Anindya Chandra

 ANINDYA CHANDRA Apt G002, Nkere Residency, 3rd Main, Puttenahalli Lake Road, J.P.Nagar 7th Phase, Bangalore - 560078 Mobile# -; Email:- Objective Seeking a challenging career where my acquired skills can be exemplified to the best of my abilities for the development of the organization. Areas Of Exposure BI & Data Analytics Accenture from Dec 2014 to till date (Senior Analyst) Work with Implementation and Deployment team, including clients to capture and understand client needs & requirements Creating estimation templates for the client for designing their scorecard and metrics, KPI dashboard. Preparation of of monthly reports/ad-hoc request for the clients. Extracting and cleansing data from SQL server management studio using SQL queries as per reporting needs. Develop Qlikview dashboards/metric reports and conduct data analysis to measure effectiveness of data quality program. Performing UAT on the new Qlikview reports in QA environment. Data modeling and analysis in Qlikview environment. SQL query optimization in Qlikview scripting for better performance. Maintaining data as per compliance to statutory and Internal Audit requirement. Adhere to SLAs, contractual agreements and legal compliance. Weekly and monthly reporting on process key metrics vs. goals to internal and external stakeholders. Managing and helping team members in their daily work. Genpact India Private LTD from Aug 2010 to Dec 2014 (Senior Associate) GE HQ Risk Resolve and escalate data quality issues, research and implement solutions to correct problems at the source where possible. Establishes processes to continuously monitor data quality. Ensures processes are in place to proactively detect, correct, and prevent invalid data values. Defines and implements Data Governance Management tools. Implement and lead data cleansing activities to meet CCAR guidelines. Co-ordinate with regional risk teams across the globe ensuring accuracy and coverage of risk exposure on day to day basis. Assesses data repositories for compliance with data governance policies and standards. Works with all areas of the organization to ensure data quality and integrity Normalization, Validation, and data governance of risk data. Preparing and developing Spotfire reports for Business needs. GE Sales And Marketing Worked with all GE platforms (Teradata Database) to analyze their deployment and added them to the Rules. Set/implement deployment rules for newer markets. Created SAS dashboards which explain the Rule and Data gaps and updates on a daily basis. Analyze SFDC Deployment rules for all GE platforms and add them to the Deployment rules engine which helps in automatically deploy the sales reps for new accounts. Analyzing the rule gaps, data defects and business defects in SFDC and maintaining the database for minimal defects. Tracking coverage on existing & new Tier 1 & 2 accounts. Alerting businesses to drive data clean up and to improve coverage by generating monthly reports Creating reports using RDBMS concepts (Teradata-SQL) with the help of SFDC data as per client requirements. Spotfire dashboards are created to continuously track and resolve the deployment issues. Working and analyzing the Single requests from different platforms to maintain the SFDC databases. Ensures that quality methods and procedures are executed. Verifies data integrity and compliance by performing data cleansing, data audit and/or data validation. Worked on the administration part of Spotfire to give access to the client users on their reporting needs. CPG Retail Analytics (Symphony IRI) Work involves the creation and maintenance of the Symphony IRI Client’s Database in the hierarchical model as per the suggested spec logic. Work involves the creation and maintenance of the Top-line reports as per client requirement. Use strong analytical skills to deliver adhoc reports and presentation to support the SPOCs to enable them to respond to their client. Utilize raw data to develop and report on trends of products as per Client requirement. Extensive Market research, secondary research and primary research and data drilling on the Client’s/Competitor’s Brands as per the requirement of the Client. Contribute to strategic team initiatives involving process improvements, new methodology development, and quality control. Dedicated to quality, responsiveness with a focus on processes and efficiency. Team handling (approx 6 members) and mentoring the associate consultants. Ensuring all the feedbacks and the learning from the COE and client is documented and applied to the categories to improve accuracy and quality. Responsible for maintaining and creating SOP’s (Standard Operating Procedure) of each process within the team through coding and quality delivery performance. Responsible for fulfilling Ad-hoc requests made by home team and Clients. Doing primary research of client specific products, to get more information from the field team to place the product in the database and preparing questioners for it. Delivering the Top-line and Ad-hoc reports based on Client requests on Product, Geography, Measures and Time periods. Doing Quality check for the team and provide guidance to the associate consultants. Ocwen Financial Solutions from April 2008 to July 2010, (Associate) Portfolio Management(US Mortgage Loans Foreclosure) Effectively worked on different cross-skilled platforms of Default Servicing Mortgage and Freddie Mac investor reporting. Working as a part of a Team which is enhancing the business applications and process manuals Highly customized and efficient reports were created for foreclosure function by using Microsoft Excel for Freddie Mac Was responsible for accomplishing the team’s performance and sustaining quality Successfully trained a team of 10 personnel in “Filtering” project which was designed to minimize the timeline delay caused to the foreclosure process on Freddie Mac loans Handled a Team of 10 members and was an acting TL for them and helping them in process improvement. Foreclosed the defaulted loans with in Freddie Mac time line Provided Resolutions on the Foreclosure issues to the internal customers, paralegals and the attorneys through email and over phone Filtered 3rd party delays on the foreclosed loans Analyzed the delayed foreclosures and preparing the Defective Analysis which was helpful for the investors to investigate the delays. Tools Worked on: Spotfire/Qlikview, GUTX (Mainframe-IBM 3270), Oracle Analyzer, Minitab, Base SAS ,Teradata(SQL), Salesforce, VBA (Basic Concepts), Dataflux (Basic), BO, Cognos. Lean Trained and Certified on job (Genpact) Educational Qualification HS : ST’ MICHEAL”S, DURGAPUR, 58%, ICSE, 2003(SCIENCE) HSLC : DON BOSCO, BANDEL, 69%, ICSE, 2001 (SCIENCE) Degree : B.Sc, Administrative Management College,59% Bangalore University, 2007 Pursuing PGDBM (2nd Sem) from Symbiosis Centre of Distance Learning, specialization in Business Analysis. PERSONAL STRENGTHS I have a reputation of keeping a cool head with a good presence of mind during tensed situation, hard working and determination of getting results of the work done and good communication skill as well. Personal Details Father’s Name : Mr. Amiya Kumar Chandra Mother’s Name : Mrs. Annapurna Chandra Date of Birth / Sex : 30TH DECEMBER 1985/ Male Interests & Activities : Gaming, Football, Music, Cricket. Languages Known : English, Hindi, Bengali, Assamese Place: Bangalore Anindya Chandra