SUMMARY

• Around 8 years of technical experience in Data analysis and Data Modeling, business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed timelines.
• Performed role of Data Analyst in implementation teams for Transforming Business Requirements into Software Requirement Specification (SRS) using MS Office Suite, JIRA, MS Project, and various tools.
• Experienced in all phases of Software Development Life Cycle (SDLC). (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Proficient in Requirements management life cycle, including Requirements gathering, Requirements elicitation, documentation, validation, and tracking.
• Well versed in system analysis, Entity Relations ER/Dimensional modeling, Database Design and implementing RDBMS specific features.
• Sound Proficiency in analyzing and Creating Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams, Sequence diagrams and AS - IS, TO-BE using MS Visio.
• Experienced Data Modeler with strong conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, creating data mapping documents, writing functional specifications, queries.
• Experience in Dimensional Data Modeling, Star/Snowflake schema, FACT & Dimension tables.
• Experienced in identifying entities, attributes, metrics, and relationships; also, assigning keys and optimizing the model.
• Extensive experience with Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Extensive knowledge on producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Experience in utilizing Tableau visual analytics and generating reports using Tableau visualizations like bars, lines, pies, scatter plots, heat maps, bubbles etc. according to the end user requirements.
• Good experience with Oracle, MS SQL Server, MS Access.
• Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for Physical models using Erwin tool.
• Excellent verbal and written communication skills with the ability to interact professionally with stakeholders at all levels of the organization, including the ability to exercise good judgment and nature of communications to senior management, stakeholders, and team members.
• Possess a disciplined, professional, and quality centered approach with strong analytical and problem-solving skills.

TECHNICAL SKILLS

Languages: R, Python, SQL

IDE: Eclipse, Visual Studio, R Studio

Project Tools: JIRA, ALM/QC, Squids, ClearQuest, Planview

ETL Tools: Microsoft SSIS and Informatica 7.1.3

Microsoft Suite: MS-Word, MS Excel, MS-Power Point, MS Visio, MS Outlook, MS Access

Databases & Tools: Oracle, Teradata, Tableau, SAS, Hadoop

Web Technologies: Html, Java script, Angular JS, Node JS, Ajax

Cloud Technologies: MS Azure, AWS, Hadoop, Bigdata

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Senior Data Analyst

Responsibilities:

• Experience in all phases of the Data warehouse life cycle involving Analysis, Design, Development and Testing as a part of Data Quality Design framework. Development of Extraction and Loading using Informatica.
• Prepared SQL & PL/SQL Queries to validate the data in both source and target databases.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed process for capturing and maintaining metadata from all data repository components.
• Perform pharmacy claims data extraction and analysis to produce reports evaluating the potential financial impact associated with implementation of medical policy claim edits.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Designed entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Worked extensively on Data Profiling, Data cleansing, Data Mapping and Data Quality.
• Collaborated with data architects for data modeling management and control visions by conducting data model reviews with project team members.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Worked with upper management to identify and brainstorm solutions for bottlenecks and errors of ongoing reports.
• Extracted data from various database sources like Oracle, SQL Server using Informatica to load the data into a single data warehouse repository.
• Utilized corporation developed Agile SDLC methodology used Jira and Microsoft office software to perform required job functions.
• Extensively used Erwin for Data modeling. Created Staging and Target Models for the Enterprise Data Warehouse.
• Designed Logical and Physical modeling, Dimensional modeling using Erwin in data warehouse.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also, used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Created and optimized RDBMS objects (tables, materialized views, synonyms, indexes, triggers, procedures, functions) and Discoverer reports.
• Development of dashboard in Tableau for data visualization to expedite the data analysis process and report automation.
• Reviewed and created conceptual model for Enterprise Data Warehouse with business users/clients.
• Played important role in Agile team which includes participating in job sprints on Scrum based projects with onsite and offshore team members.

Environment: Agile, Erwin, PL/SQL, RDMS, SDLC, MS office, Enterprise data warehouse, Jira, data mapping, data cleansing

Confidential, New York, NY

Data Analyst

Responsibilities:

• Created System Sequence Diagram to depict the interaction or flow of transactions between the entities.
• Managed deployment of complex software releases with dependencies among different implementations and engagement of multiple release managers.
• Worked with the UX team to update/create mockups of the pages.
• Worked with Analytics Team to engage Data Analytics in the project.
• Developed workflow diagrams, activity diagrams, sequence diagrams and Use cases by covering all the business needs using MS Visio
• Worked with engineering and external partners to generate, capture, and ingest source data, also, worked with data engineering to build ETLs that transform the data into manageable nuggets.
• Built reports and performing analyses to draw insights; and worked with different parts of the organization to implement changes based on those insights.
• Analyze and determine risks in the portfolio decisions, forecasting potential losses.
• Wrote sophisticated and optimized SQL queries to extract large data and built complex models.
• Defined and created procedures to install Tableau desktop in silent mode.
• Generate DDL's and make the same available to the DBA for execution.
• Empowered productivity improvements and data sharing throughout a major banking enterprise by using Erwin for effective model management.
• Utilized Agile/Scrum and PMI methodologies to monitor steer and develop project objectives.
• Analyzed large transactional data, history data and stream data for the knowledge of business development and problem solving.
• Gathered requirements through meetings, surveys and got them approved by the product manager.
• Predict future trends from the current developments in the market and recommend management accordingly to plan the strategies.
• Facilitated User Acceptance Testing with business stakeholders to ensure all requirements have been met.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Facilitated meetings with business users, data architects, data modelers, business analysts, QA and multiple delivery teams to define the data quality and profiling requirements.
• Used SDLC (System Development Life Cycle) methodologies like agile methodology.

Environment: Oracle, MYSQL, SSIS, SSAS, Informatica, Erwin, Windows, UNIX, Excel, Agile

Confidential, Phoenix, AZ

Data Analyst

Responsibilities:

• Involved in Business and data analysis during requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined data requirements and elements used in XML transactions.
• Reviewed and recommended database modifications
• Analyzed and rectified data in source systems and Financial Data Warehouse databases.
• Generated and reviewed reports to analyze data using different excel formats
• Documented requirements for numerous adhoc reporting efforts
• Troubleshooting, resolving and escalating data related issues and validating data to improvedata quality.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: PL/SQL, Informatica Power Center (Power Center Designer, workflow manager, workflow monitor), SQL *Loader, Cognos, Oracle, SQL Server, Erwin, Windows, TOAD.

Confidential, San Jose, CA

Data Analyst

Responsibilities:

• Worked on performing quantitative analysis for credit portfolios, data quality control and data profiling.
• Developed interactive dashboards and storyboards inTableauto explore credit portfolios data and report insight to the manager.
• Performed exploratory data analysis and identified data patterns that can translate into business rules.
• DeployedMS SQL Serverplatform to store transform and query data for data analyzing and reporting.
• WroteT- SQLqueries involving multiple joins, subqueries, and common table expression to perform data aggregation for reporting.
• Performed statistical analysis such as T-test, F-test, ANOVA, MANOVA, Confidence interval calculation and Distribution identification usingR, and generated reports usingR Markdown.
• UsedETLtoolSSISto extract data from both external and internal sources including CSV JSON excel and load data into database.
• Collected data from various sources usingPythonand loaded data into Pandas Data frame to detect outliers and imputing missing values.
• UsedMS Excelto get summary statistics of datasets, andVBAto automate data transforming.

Environment: MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL