Senior Data Analyst Resume
Richmond, VA
SUMMARY:
- Around 7 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:
Business Skills: Business Process Analysis, Requirement Gathering, and Use Case Modeling, SDLC
Methodologies: Agile, SCRUM and Waterfall
Tools: Selenium, JIRA, Tableau, Informatica, Power BI, MS Office: Word, Access, Advanced Excel, PowerPoint, MS Project, Microsoft Visio
Data Modeling: Erwin, Microsoft Visio, Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables
Databases and RDBMS: Oracle, SQL Server, Teradata, MS Access, Mongo DB
Programming skills: Asp.NET, Java, C#, PL/SQL, HTML, Python
Operating Systems: Windows, Mac, UNIX, Linux
PROFESSIONAL EXPERIENCE:
Senior Data Analyst
Confidential, Richmond, VA
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
Data Management Analyst
Confidential, Evanston, IL
Responsibilities:
- Extensively involved in Performance Tuning for ETL process at source, target, Informatica Mappings, Sessions and at database level for optimum performance.
- Designed & created OLAP Cubes with Star schema using SSAS.
- Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
- Worked on creating DDL, DML scripts for the data models.
- Primary focus was administration and support of warehouse management and order fulfillment applications written in Progress RDBMS.
- Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
- Create various Data Mapping Repository documents as part of Metadata services.
- Providing subject matter expertise to Compliance on expected data behaviors, trends and patterns, as well as the meaning of data fields and values.
- Developed Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like Erwin7.x
- To ensure data warehouse and data mart designs efficiently support BI and end user.
- Created and maintained all data mapping, Meta Data, resolved all Data Quality Issues.
- Performed requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), & documentation for end users.
- Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL).
- Created dimensional logical model with various facts, dimensions with attributes combination using ER studio.
- Responsible for data design, metadata and assisting with the data integration layer's repository creation.
- Developed slowly changing dimension scheme - type 1 and type 3 for most of the dimensions.
- Designed the business requirement collection approach based on the project scope and SDLC methodology.
- Reviewed the Business Requirement Document and Business Process Flow Diagram.
- Creating logical and physical data models using best practices to ensure high data quality and reduced redundancy.
- Review of Various documents including Business Requirement Document (BRD) and Functional System Design (FSD).
- Created UML diagrams including context, Business Rules Flow, and Class Diagrams.
Environment: Informatica, Tableau, Microsoft Office, Oracle, SSRS, SQL Server, MS Excel, Teradata, SCD, Agile
Data Analyst
Confidential, Virginia Beach, VA
Responsibilities:
- Worked with the analysis teams and management teams and supported them by providing variables based on their requirements.
- Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages, Functions and Triggers using SQL Server.
- Analyzed existing logical data model and made the necessary changes to make it compatible with business requirements.
- Requirements, Analysis and Design - Involved in data analysis, preparation of mapping documents, procuring signoffs on ETL design.
- Develop robust ETL designs (functional and technical) for the ETL solution.
- Assist with task identification and effort estimates for ETL development per Agile Development methodology.
- Lead and mentor the team in Offshore in design, develop and deliver the ETL tasks.
- Identified the entities and relationship between the entities to develop Conceptual Model using Erwin 7.x/8.x.
- Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
- Developed live reports in a drill down mode to facilitate usability and enhance user interaction.
- Query Data from Hadoop/Hive & MySQL data sources to build visualization in Tableau.
- Facilitated the automation process for the Delinquency Report -This report was required to run monthly.
- Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Involved in creating Tree Map, Heat maps and background maps.
- Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.
- Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
- Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
- Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
- Created reports using analysis output and exported them to the web to enable the customers to have access through Internet.
Environment: Microsoft SQL Server 2012, SSRS, SSIS, RDBMS, MYSQL, Tableau
Data Analyst
Confidential
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
Data Analyst
Confidential
Responsibilities:
- Normalized tables, established joins, and created indexes wherever necessary utilizing profiler and execution plans.
- Hands-on experience in analyzing the data and writing Custom MySQL queries for better performance, joining the tables and selecting the required data to run the reports.
- Restricted data for Users using row level security and use filters.
- Utilized technology such as MySQL and Excel PowerPivot to query test data and customize end-user requests.
- Wrote custom procedures and triggers to improve performance and maintain referential integrity.
- Optimized queries with modifications in SQL code removed unnecessary columns and eliminated data discrepancies.
- Utilized dimensional data modeling techniques and storyboarding ETL processes.
- Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures using Informatica Power Center.
- Performed Unit Testing and tuned the Informatica mappings for better performance.
- Re-engineer existing Informatica ETL process to improve performance and maintainability.
- Exceeded expectations by collaborating with a testing team in creating and executing the test cases for a giant pharmaceutical company.
- Organized and delegated tasks effectively while working with multiple customers at the same time.
- Demonstrated leadership by guiding newcomers with the best practices of the company.
Environment: Informatica, Oracle 10g, UNIX, SSIS, SSAS, SSRS