SUMMARY:

• Over 5+ years of extensive Experience in Data analysis and Reporting in Finance and Telecom sectors. SAS experience includes detailed knowledge of Finance and Telecom data. Experience includes detailed knowledge of Auditing Data, Developing Data, and Performing Data Validation using SAS.
• Experience in all phases of Software Development Life Cycle (SDLC) including Requirements, Analysis Design, Development, Implement, Validation, and Testing. Expert in defining BI Standards, Best Practices, Code Review, DW standards and production support.
• Proficient understanding of finance and Telecom data and assessment of data quality, selection of appropriate models and statistical tests and presentation of results.
• Thorough knowledge in all phases of data analysis, including definition and analysis of questions with respect to data and resources.
• Worked with data governance team for creating and maintaining consistency and integrity of data.
• Experience in SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in Windows environments.
• Created complex and reusable MACROS and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
• Tested and debugged existing macros.
• Strong experience with databases like Oracle, Teradata, MS SQL Server, DB2 and MS Access.
• Expertise in using various SAS report - generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
• Retrieved Data from massive and complex Data sets using statistical techniques and conducted Data integration.
• Translated Data from multiple sources into useful information and business drivers utilized by senior management for strategic decision-making.
• Designed and automate reporting solutions using SAS/MACROS and Tableau Server.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

TECHNICAL SKILLS:

Tools: Base SAS, SAS EG, Tableau, QlikView, MS- Office, Visio, MS Project, SSIS, SSMS.

Database: MS-Access, Oracle, Teradata, SQL server, DB2.

Other Technologies: Visio, Microsoft Office (Word, Excel, PowerPoint, Outlook).

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Analyst

Responsibilities:

• Provided information to both internal and external auditors to ensure their accurate understanding and analysis of the retail portfolio.
• Worked closely with Product Credit Risk Teams, provided in-depth insight and analysis to evaluate portfolio to maintain acceptable overall risk levels.
• Identified risks and analyzed portfolio based on debt to income, loan to value, credit scores and a variety of other credit variables.
• Responsible for the overall execution, administration and ongoing development of the Model Risk Management program.
• Applied expert analytical knowledge to utilized advanced analytics to assess future risk and/or new risks, opportunities, and effectiveness.
• Developed SAS Scripts using SAS Macros for Data Segmentation.
• Analyzed historic credit performance of portfolios and developed visual reports that summarize these results, identify trends, explain variances, and provide recommendations for minimizing risk.
• Developed Early warning signals and risk models for Personal, Auto and Business Loan Products in SAS.
• Prepared high level & qualitative analysis to observe patterns and relationships in data and produce reports using with SAS and Tableau visualization.
• Developed new or modified existing SAS programs to load data from the source and create study specific datasets.
• Designed and developed ETL processes for data integration projects to build data marts.
• Developed production of reports, tables, graphs and listing using SAS/BASE, SAS/STAT, SAS/GRAPH, PROC SQL, SAS Macro, Tableau, SQL and Excel.
• Developed Tableau visualizations and dashboards using Tableau Desktop.

Confidential

Business Analyst

Responsibilities:

• Delivered End-to-End solution designs with detailed technical specifications as per TOI standards.
• Gathered detailed business requirements and use cases, and translate technical specifications into product requirements.
• Collaborated with business analysts, developers, and technical support teams to define project requirements.
• Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
• Responsible for creating document As-Is/To-Be process flows and gap analysis of business process.
• Arranged formal walkthroughs with chief architect and client to explain the proposed high-level solution, impacts on components & platforms.
• Planned and executed User Acceptance Testing (UAT) to ensure solution delivered meets business needs.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently using Tableau.
• Generated context filters and data source filters while handling huge volume of data using Tableau, SQL and SAS.

Confidential

Jr. Data Analyst

Responsibilities:

• Analyzed data using SQL and MS Excel to identify and monitor pattern in the transnational history data.
• Identified trends and opportunities to improve policies, processes and procedures that estimated in 30% revenue growth.
• Responsible for analyzing marketing/merchandising data to look for patterns, topics and improvement opportunities.
• Manipulating and transforming various datasets into the data required for analysis.