●Around 6 years of Data Analyst experience in: requirements gathering, analysis, ETL design, development, testing and reporting of data warehousing systems.
●Extensive experience in writing complex SQL queries, PL/SQL, stored procedures, packages, view, synonyms.
●Considerable experience in working with various data sources like Oracle and Flat Files.
●Built, maintained and managed the infrastructure in Snowflake cloud data warehousing.
●Created solutions in Snowflake cloud data warehousing.
●Skilled in Performance Tuning at database and Informatica side like source, target, mapping, transformation and session to make them more efficient in session performance.
●Experienced in cloud implementation using Amazon web services (AWS) components like S3 storage and Elastic map reducing.
●Accomplished in delivering critical solutions on various levels of project planning and execution, quality assurance and system/business analysis.
●Supported Business continuity program by capturing metrics and reporting status using SharePoint dashboard.
●Visualized data using Tableau to present information needs for projects.
●Experienced in publishing and sharing workbooks, data sources with user filter to Tableau server.
●Experienced in using SQL for Tableau and in writing parametrized queries for generating tabular reports, formatting report layout, and expressions.
●Excellent communication and interpersonal skills, self-starter and team player.
●Presented data-based improvement and operational strategies to the executive team.
SQL, Python, Spark.
BI Reporting Tools
Tableau, Power BI, SharePoint, SSRS, SSIS
Oracle, MySQL, MS SQL Server
Big Data Technologies
Hadoop, Hive, Pig
Amazon Web Services, MS Excel, Visio, System requirement specification (SRS), Unified modeling language (UML), Business requirement document (BRD), Functional requirement document (FRD)
Client: Prudential Insurance, Roseland, NJ Feb.2018– Mar.2019
Role: Data Analyst
The project is an annuities product of insurance policyholders. The reporting annuities is done with a legacy data warehouse that is inefficient and error-prone. The vision of the project is to migrate the annuities product to a data lake architecture for improved accuracy of reporting and to better utilize resources.
Communicated with business users, data architects and developers to identify needs, define project scope and detailed functional and non-functional requirements.
Prepared Data Mapping documents, Use Cases, Requirements Traceability Matrix and worked with the User experience team
Created requirement documentation, reviewed with user representatives, recommended priorities, gave presentations and walkthroughs and obtained user signoff.
Driven daily stand up meetings offshore, iteration planning meetings and requirement gathering meetings.
Extracted data from different public data repositories and from different databases and creating datasets for statistical analysis.
Identified Multiple Dimensions and Fact tables. Used advanced data modeling concepts of degenerated dimension, sub-dimension, Fact-less fact table, Aggregate fact tables in the multidimensional model.
Hands-on development in creating and modifying worksheets and data visualization dashboards.
Designed & developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
Created and modified Interactive Dashboards and Created guided navigation links within Interactive Dashboards.
Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle 12g and MS Excel.
Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
Environment: MS SQL, MS Excel, Oracle 12g, Shell Scripting, Tableau, and Informatica 10.1.1
Client: Sprint, Overland Park, KS Nov.2016 – Jan.2018
Role: Data Analyst
●Preformed ad-hoc requests for clients using Excel and customized SQL queries to extract information.
●Strong knowledge of SQL, stored procedures, data analysis and data validation.
●Proficient in designing and implementing SQL queries for reporting/ data validation using Oracle, SQL server and DB2.
●Experienced in Snowflake database management – created databases, schemas, roles, tables, and views.
●Interacted with the clients and stakeholders to understand business questions and needs.
●Attended business calls to gather and analyze project requirements.
●Produced detailed design documents/technical specifications for business management approval.
●Worked with business management associates to fix data issues.
●Developed storytelling dashboards in Tableau desktop and published them on to Tableau server.
●Prepared Dashboards using calculations and parameters in Tableau.
●Created report schedules on Tableau server.
●Produced data extracts during system testing and received business management approval.
Environment: Informatica Power Center, Oracle, Hive, Snowflake, and Tableau
Client: CSC, India May.2012 – Aug.2015
Role: Business Data Analyst
●Act as a liaison among key stakeholders to elicit, analyze, communicate and validate a requirement for change to business processes.
●Created business requirement document (BRD) and Functional requirement document (FRD)
●Successfully adapted data models and procedures to account for changing requirements from the client.
●Analyzed business processes and business requirements into functional specifications for the development team.
●Advised clients on resource requirements, scope, budgets, and timing.
●Created SQL queries and reports to support inventory control and improve sales profitability.
●Engaged in reporting project updates, managing project resources, conflict resolution and maintaining project deadlines.
●Maintained project documents such as the risk management plan, action item list, project benefits list, updates, and review with the project manager at regular time intervals.
M.S in Engineering management
Trine University, Angola, IN
B.S in Computer Science
Dr. MGR University, Chennai, India