SUMMARY

• Above 8+ years of IT experience in data analysis.
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes and canonical model.
• Efficient Data Lake implementation over Azure.
• Solid hands on experience with administration of data model repository, documentation in metadata portals in such as Erwin, ER Studio and Power Designer tools.
• Strong working Experience with Agile, Scrum, Kanban and Waterfall methodologies.
• Capture, validate and publish metadata in accordance with enterprise data governance policies and MDM taxonomies.
• Responsible for data governance rules and standards to maintain the consistency of the business element names in the different data layers.
• Extensive experience in development of T - SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Proficient in Normalization/De-normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) tools.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data warehousing environments.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
• Conduct data analysis, mapping transformation, data modeling and data-warehouse concepts.
• Experience in designing Logical, Physical &Conceptual data models for to build the Data Warehouse.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Solid Excellent experience in creating cloud-based solutions and architecture using Amazon Web services (Amazon EC2, Amazon S3, Amazon RDS) and Microsoft Azure.
• Excellent knowledge on creating reports on SAP Business Objects, Web reports for multiple data providers.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, BTEQ, and MDM
• Experience in designing Star schema, Snowflake schema for Data Warehouse, ODS architecture.
• Hands on experience in SQL queries and optimizing the queries in Oracle, SQL Server, DB2, and Netezza.
• Experience in working with RDBMS like Oracle, Microsoft SQL Server and Teradata.
• Experience in data analysis to track data quality and for detecting/correcting inaccurate data from the databases.
• Good Knowledge on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for implementing the business techniques.

TECHNICAL SKILLS

Cloud Management: Amazon Web Services(AWS), Amazon Redshift

Data Modeling Tools: ER/Studio V17, Erwin 9.7, Power Sybase Designer 16.6.

OLAP Tools: Tableau, SAP BO, SSAS, Business Objects, and Crystal Reports 9

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED

Databases: Oracle 12c, Teradata R15, MS SQL Server 2017, DB2.

Testing and defect tracking Tools: HP/Mercury, Quality Center, Win Runner, MS Visio 2016 & Visual Source Safe

Operating System: Windows 10/8, Unix, Sun Solaris

ETL/Data warehouse Tools: Informatica 10.1, SAP Business Objects XIR3.1/XIR2, Talend, Tableau

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model.

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

Sr. Data Analyst

Responsibilities:

• Massively involved in Data Analyst role to review business requirement and compose source to target data mapping documents.
• Analyzed and lead the business requirements, system requirements, and data mapping specification requirements.
• Extensively used Agile methodology as the Organization Standard to implement the data Models.
• Migrated data from Snowflake DB to Redshift.
• Used Snowflake (SaaS) for data warehousing.
• Involved in upgradation and migration from Cognos 8.4 to Cognos 10.2.
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Documented data dictionaries and business requirements for key workflows and process points.
• Created multiple STTM documents, conducting business and technical reviews and lobbying stakeholders for sign-off.
• Source-to-Target-Mapping STTM of source system data to be leveraged within the EDW.
• Presented the data scenarios via, ER/Studio logical models and excel mockups to visualize the data better.
• Created Source to Target Mapping STTM that has all the cleansing, standardization, transformations, and loading rules.
• 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 the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using E/R Studio.
• Created augmented Data Lakes using Snowflake DB.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models.
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Monitored the Data quality and integrity of data was maintained to ensure effective functioning of department.
• Used Python to convert Hive/SQL queries into RDD transformations in Apache Spark.
• 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.
• Involved in Deployment of reports (Import/Export) in Cognos connection and in Unit Testing of the code.
• Responsibilities include supporting end user reporting requirements by developing Reporting solutions on the Cognos.
• Use SQL and Cognos tools on a routine basis in achieving the above tasks.
• Extensively involved in testing Ad-Hoc, recurring reports, and Cognos deliverables.
• Performed source-to-target mapping STTM of report data.
• Used ER/Studio for reverse engineering to connect to existing database and ODS.

Confidential - Phoenix, AZ

Sr. Data Analyst

Responsibilities:

• As a Data Analyst Gathered and translated business requirements into detailed production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Worked in an agile team using Scrum methodology and participated in backlog prioritization with product owner and Scrum master.
• Implemented Snowflake schema to ensure no redundancy in the database
• Insured that the data model, STTM and Interface registry meets the Enterprise Data Governance compliance.
• Create and maintain data model standards, including master data management (MDM).
• Implemented Normalization Techniques and build the tables as per the requirements given by the business users.
• Created Azure Data Factory for Data movement from various sources to Azure SQL Data Warehouse.
• Worked Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon approaches.
• Updated Source to Target Mapping (STTM) documents with legacy systems ingredient attribute, Transformation Logic and enumeration values to implement it in APPs.
• Developed and presented Business Intelligence reports and product demos to the team using Power BI. Used windows Azure SQL reporting services to create reports with tables, charts and maps.
• Worked with MDM systems team with respect to technical aspects and generating reports.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed Data Migration and Clean sing rules for the Integration Architecture (OLTP, ODS, DW).
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
• Delivered dimensional data models using Erwin to bring in the Employee and Facilities domain data into the oracle data warehouse.
• Developed Data Mapping, Data Governance, transformation and Cleansing rules for the Master Data Management Architecture involving OLTP and ODS.
• Performed detailed data analysis to analyze the duration of claim processes and created the cubes with Star Schemas using facts and dimensions.
• Performed Data Analysis and Data Profiling using complex SQL queries.
• Part of JAD sessions for defining business requirements and translating them into technical specifications.
• Responsible for designing a Data dictionary& Business Glossary.
• Created DDL scripts using Erwin and source to target mappings to bring the data from source to the warehouse.
• Used Power BI, Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Worked with business team and ETL to create source to target mapping (STTM).
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Created stored procedures and functions using Dynamic SQL and T- SQL.
• Working closely with the Data Stewards to ensure correct and related data is captured in the data warehouse as part of Data Quality check.
• Designed and developed business intelligence dashboards, analytical reports and data visualizations using power BI.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Used Azure reporting services to upload and download reports

Confidential - Boston, MA

Data Analyst

Responsibilities:

• As Data Analyst performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Developed logical and physical data models for central model consolidation.
• Worked with DBAs to create a best fit physical data model from the logical data model.
• Conducted data modeling JAD sessions and communicated data-related standards.
• Migrated historical data into AWS cloud and set up automated process in cloud for incoming clickstream aggregation.
• Implemented Redshift based data warehousing solution.
• Worked on modeling and designing database for data warehouse workload and created the objects in Redshift.
• Used Star/Snowflake schemas in the data warehouse architecture.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Developed process methodology for the Reverse Engineering phase of the project.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Utilized Erwin's reverse engineering and target database schema conversion process.
• Automated Glue ETL jobs using S3 events and AWS Lambda functions.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Involved in extensive data analysis on querying and Writing in SQL and Toad.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and SQL Server.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges
• Involved in Data profiling in order to detect and correct inaccurate data and maintain the data quality.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Worked closely with the ETL SQL Server Integration Services (SSIS) Developers to explain the Data Transformation.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Created simple and complex mapping using DataStage to load Dimensions and Fact tables as per Star schema techniques.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.
• Connected to AWS Redshift through Tableau to analyze the data for ad-hoc requirements as well as canned reports.
• Generated ad-hoc reports using Tableau.

Confidential - Rockville, MD

Data Analyst

Responsibilities:

• Worked as a Data Analysts to understand Business logic and User Requirements.
• Understand the data visualization requirements from the Business Users.
• Writing SQL queries to extract data from the Sales data marts as per the requirements.
• Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Designed and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Explored traffic data from Google Analytics, connecting them with transaction data, and presenting as well as writing report for every campaign, providing suggestions for future promotions.
• Extracted data using SQL queries and transferred it to Microsoft Excel and Python for further analysis.
• Data Cleaning, merging and exporting the dataset was done in Tableau Prep.
• Data processing and cleaning techniques carried out to reduce text noise, reduce dimensionality in order to improve the analysis.
• Used Pentaho BI tool to represent data in Google Maps.
• Created numerous reports using report lab and python packages. Installed numerous Python modules.
• Designed and implemented basic PL/SQL queries for testing and report/data validation.
• Developed the stored Procedures, SQL Joins, SQL queries for data retrieval, accessed for analysis.
• Used forward engineering approach for designing and creating databases for OLAP model.
• Used SQL Server Integrations Services (SSIS) for extraction, transformation, and loading data into target system from multiple sources
• Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQL Joins and other statements for reporting.
• Conducted data mining and data modeling in coordination with finance manager.
• Created Project Plan documents, Software Requirement Documents, Environment Configuration and UML diagrams.
• Wrote Python scripts to parse XML documents and load thedatain database.
• Gathered requirements and performed data mapping to understand the key information by creating tables
• Performed Gap Analysis on existing data models and helped in controlling the gaps identified.
• Involved in the creation, maintenance ofDataWarehouse and repositories containing Metadata.