SUMMARY:

• Process oriented data analyst with 5+ years of experience. Experienced in interpreting and analyzing data to drive growth for a pharmaceutical and Telecom companies.
• Over 5+ years of experience as a Sr. Data Modeler/Data Analyst with high proficiency in requirement gathering and data modeling.
• Excellent Knowledge of Ralph Kimball and Bill Inmon approaches to Data Warehousing.
• Experience in working on Distributed storage for analysis and processing of large data sets using Apache Hadoop.
• Experience in Designing and implementing data structures and commonly used data business intelligence tools for data analysis.
• Experienced in ETL using Informatica and Pentaho.
• Experience working with Agile and Waterfall data modeling methodologies.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, BTEQ and MDM.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL, PL/SQL.
• Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing. Worked on those functions using Informatica and Pentaho.
• Expertise on Relational Data modeling (3NF) and Dimensional data modeling.
• Hands on experience in Normalization and Denormalization techniques for optimum performance in relational and dimensional database environments.
• Good understanding and hands on experience in setting up and maintaining NoSQL Databases like Cassandra, MongoDB, and HBase.
• Sound knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Extensive knowledge of Big data, Hadoop, MapReduce, Hive, NoSQL Databases and other emerging technologies.
• Very good experience and knowledge on Amazon Web Services: AWS Redshift, AWS S3 and AWS EMR.
• Proficient in data mart design using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Proficient in Software Development Life Cycle (SDLC), Project Management methodologies, and Microsoft SQL Server database management.
• Experience in data analysis, data migration and data modeling activities.
• Hands on experience with modeling using Erwin in both forward and reverse engineering processes.
• Strong experience in using MS Excel and MS Access to dump the data and analyze based on business needs.
• Experience designing security at both the schema level and the accessibility level in conjunction with the DBAs
• Extensive experience on usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Informatica.
• Efficient in implementing Normalization to 3NF/ De-normalization techniques for optimum performance in relational and dimensional database environment
• Solid understanding of Data Governance, Meta Data, Data Management and control; Adept in Data warehouse and Data mart architecture.
• Strong background in data processing, data analysis with hands on experience in MS Excel, MS Access, Unix and Windows Servers.

EXPERIENCE:

Sr. Data Modeler / Data Analyst

Confidential, Seattle, WA

• As a Sr. Data Modeler / Data Analyst I was responsible for all data related aspects of a project.
• Massively involved in Sr. Data Modeler / Data Analyst role to review business requirement and compose source to target data mapping documents.
• Analyzed business requirements, system requirements, and data mapping specification requirements.
• Extensively used Agile methodology as the Organization Standard to implement the data Models.
• Presented the data scenarios via, ER/Studio logical models and excel mockups to visualize the data better.
• Performed end to end ETL including the mapping and transformations in the transformation layer using Informatica.
• Designed and Developed logical & physical data models and Meta Data to support the requirements.
• Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle.
• Involved in extensive Data validation using SQL queries and back-end testing
• Generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures.
• Used SQL for Querying the database in Unix environment.
• Worked on AWS Redshift and RDS for implementing models and data on RDS and Redshift
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using E/R Studio.
• Documented data dictionaries and business requirements for key workflows and process points.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using E/R Studio.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models.
• Worked on Normalization and Denormalization techniques for both OLTP and OLAP systems.
• Designed ER diagrams and mapping the data into database objects.
• Monitored the Data quality and integrity of data was maintained to ensure effective functioning of department.
• Worked with MDM systems team with respect to technical aspects and generating reports.
• Assisted in the oversight for compliance to the Enterprise Data Standards, data governance and data quality.
• Developed complex T-Sql code such as Stored Procedures, functions, triggers, Indexes, and views for the business application.
• Designed and developed cubes using SQL Server Analysis Services (SSAS) using Microsoft Visual Studio.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages all environments.
• Developed reports for users in different departments in the organization using SQL Server Reporting Services (SSRS)
• Used ER/Studio for reverse engineering to connect to existing database and ODS.
• Created graphical representation in the form of Entity Relationships and elicit more information.

Environment: Agile, ER/Studio v17, Oracle 12c, Unix, AWS, Amazon Redshift, OLTP, OLAP, NoSQL, MDM, T-Sql, SSAS, Microsoft Visual Studio 2016, SSIS, SSRS, Informatica

Sr. Data Analyst

Confidential

• Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
• Involved in story-driven Agile development methodology and actively participated in daily scrum meetings.
• Used methodology as the Organization Standard to implement the data Models.
• Designing the architecture of the data warehouse after understanding and analyzing the legacy databases.
• Analyze data and provide insights and interpretation of trends for decision makers.
• Generated various dashboards as per the requirements, which were used by management to make key business decisions
• Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using ER/Studio.
• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Collected requirements from business users and analyzed based on the requirements.
• Involved in extensive Data validation by writing several complex SQL queries.
• Involved in back-end testing and worked with data quality issues.
• Involved in developing the data warehouse for the database using the Ralph Kimball's Dimensional Data Mart modeling methodology.
• Worked on Data modeling, Advanced SQL with Columnar Databases using AWS
• Migrated reference data from existing product into Informatica MDM hub.
• Worked with Hadoop eco-system covering HDFS, HBase, Yarn and MapReduce.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct Data Analysis.
• Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries.
• Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose.
• Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
• Developed various QlikView Data Models by extracting and using the data from various sources files Excel, Flat Files and Big data.
• Generated multiple ad-hoc Python tools and scripts to facilitate map generation and data manipulation.

Environment: ER/Studio, Microsoft SQL Server, MySQL, SAS, Amazon Redshift, MDM, HDFS, HBase, Yarn, MapReduce, OLTP, OLAP, Metadata, MS Excel, QlikView, Crystal Reports

Data Analyst

Confidential

• Worked with Data Analyst for requirements gathering, business analysis and project coordination.
• Work with the Data Analysis team to gathering the Data Profiling information
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Performed Data Analysis and Data validation by writing SQL queries using SQL assistant.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Gathered business requirements through interviews, surveys with users and Business analysts.
• Worked on Data Mining and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Developed SQL Queries to fetch complex data from different tables in databases using joins, database links.
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
• Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.
• Performed Data analysis of existing database to understand the data flow and business rules applied to Different databases using SQL.
• Performed data analysis and data profiling using complex SQL on various sources systems and answered complex business questions by providing data to business users.
• Performed the detail data analysis, Identify the key facts and dimensions necessary to support the business requirements.
• Generated Data dictionary reports for publishing on the internal site and giving access to different users.
• Used MS Visio and Rational Rose to represent system under development in a graphical form by defining use case diagrams, activity and workflow diagrams.
• Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Worked in data management performing data analysis, gap analysis, and data mapping.
• Established a business analysis methodology around the RUP (Rational Unified Process)
• Developed stored procedures in SQL Server to standardize DML transactions such as insert, update and delete from the database.
• Created SSIS package to load data from Flat files, Excel and Access to SQL server using connection manager.
• Develop all the required stored procedures, user defined functions and triggers using T-SQL and SQL.
• Produced report using SQL Server Reporting Services (SSRS) and creating various types of reports.
• Generated multiple ad-hoc Python tools and scripts to facilitate map generation and data manipulation.

Environment: SQL, SQL server, PL/SQL, MS Visio, Rational Rose, SSIS, T-SQL, SSRS