SUMMARY

• Around 8 years of working experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration management.
• Good understanding of Software Development Life cycle (SDLC) including planning, analysis, design, development, testing, implementation.
• Good Knowledge and working experience on AWS tools like Amazon S3, and Amazon Red Shift.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Power Designer.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Excellent proficiency in Agile/Scrum and waterfall methodologies.
• Good experience in working with different reporting tool environments like SQL Server Reporting Services (SSRS), and Business Objects.
• 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.
• Experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Good experience in Technical consulting and end - to-end delivery with data modeling, data governance.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Data Profiling, Data Mapping, Performance Tuning and System Testing.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Experience in generating DDL (Data Definition Language) Scripts and creating Indexing strategies.
• Proficient in Normalization/De-normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
• Experience in data analysis to track data quality and for detecting/correcting inaccurate data from the databases.
• Excellent knowledge on creating reports on SAP Business Objects, for multiple data providers.
• Conduct data analysis, mapping transformation, data modeling and data-warehouse concepts.
• Capture, validate and publish metadata in accordance with enterprise data governance policies and MDM taxonomies.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data
• Good understanding of Ralph Kimball (Dimensional) & Bill Inman (Relational) model Methodologies.
• Experience with Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Having good working experience in Data Vault which is used in maintain Historical Data in the Enterprise Data Warehouse.
• Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

Data Modeler/Data Analyst

Responsibilities:

• As a Data Modeler/Data Analyst to generate Data Models using Erwin and subsequent deployment to Enterprise Data Warehouse.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Participated in design discussions and assured functional specifications are delivered in all phases of SDLC in an Agile Environment.
• Worked with Business users during requirements gathering and prepared Conceptual, Logical and Physical Data Models.
• Worked on Data load using Azure Data factory using external table approach.
• Created various Physical Data Models based on discussions with DBAs and ETL developers.
• Used Normalization (1NF, 2NF & 3NF) and De-normalization techniques for effective performance in OLTP and OLAP systems.
• Worked on Data load using Azure Data factory using external table approach.
• Worked on Master data Management (MDM) Hub and interacted with multiple stakeholders.
• Designed the data marts in dimensional data modeling using star schemas and snowflake schemas.
• Maintained and implemented Data Models for Enterprise Data Warehouse using Erwin.
• Developed the data warehouse model (Kimball's) with multiple data marts with conformed dimensions for the proposed central model of the Project.
• Used windows Azure SQL reporting services to create reports with tables, charts and maps.
• Developed rule sets for data cleansing and actively participated in data cleansing and anomaly resolution of the legacy application.
• Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs.
• Worked on Data Mining and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Developed Data mapping, Transformation and Cleansing rules for the Data Management involving OLTP and OLAP.
• Worked with project management, business teams and departments to assess and refine requirements to design/develop BI solutions using MS Azure.
• Configured Hadoop Ecosystems to read data transaction from HDFS and Hive.
• Created data flow, process documents and ad-hoc reports to derive requirements for existing system enhancements.
• Performed Data Manipulation using MS Excel Pivot Sheets and produced various charts for creating the mock reports.

Environment: Erwin 9.7, Agile, MS Azure, OLTP, OLAP, MDM, T-SQL, SSIS, SSRS, Hadoop 3.2, HDFS, Hive 3.1, MS Excel 2019

Confidential Rochester MN

Data Analyst

Responsibilities:

• Gathered user requirements, analyzed, and designed software solution based on the requirements.
• Designed and developed real time recommendation engine to rank sales leads for upsell opportunities
• Transformed raw data into MySQL with custom-made ETL application to prepare unruly data for machine learning
• Automated ETL processes across millions of rows of data, which reduced manual workload by 20% monthly
• Leveraged Survey Monkey responses to develop sentiment analysis model that helped improve sales and marketing strategies
• Developed views, functions, procedures, and packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Loading data from flat files into to database tables using SQL* loader.
• Collaborated with the infrastructure, network, database, application, and BA teams to ensure data quality and availability.
• Designed, documented operational problems by following standards and procedures using JIRA.
• Analyzed and processed complex data sets using advanced querying, visualization, and analytics tools.
• Identified, measured, and recommended improvement strategies for KPIs across all business areas.
• Partnered with 3 cross-functional teams: UI/UX, product testing and marketing to drive product discovery, development, and delivery of new mobile applications
• Created database objects like tables, views, procedures, triggers, functions to provide definition, structure and to maintain data efficiently.
• Designed and implemented data profiling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.
• Created data stories, reports and visualizations using Tableau
• Created ad-hoc, weekly and monthly reports in compliance with the client requirement with Excel.

Confidential Washington, PA

Data Modeler/Data Analyst

Responsibilities:

• Worked as a Data Modeler to generate Data Models using Erwin and developed relational database system.
• Worked on Software Development Life Cycle (SDLC) with good working knowledge of testing, agile methodology, disciplines, tasks, resources and scheduling.
• Conducted Design reviews with the business analysts and the developers to create a proof of concept for the reports.
• Worked on Amazon Redshift and AWS and architecting a solution to load data, create data models.
• Analyzed the data which is using the maximum number of resources and made changes in the back-end code using PL/SQL stored procedures and triggers
• Performed thorough data analysis for the purpose of overhauling the database using SQL Server.
• Designed different type of Star schemas for detailed data marts and plan data marts in the OLAP environment.
• Extracted Mega Data from Redshift AWS, and Elastic Search engine using SQL Queries to create reports.
• Created and maintained data model standards, including master data management (MDM)
• Created SSIS package for daily email subscriptions to alert Tableau subscription failure using the. PostgreSQL database.
• Connected to AWS Redshift through Tableau to extract live data for real time analysis.
• Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and Dimension tables using Erwin.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
• Identified and documented data sources and transformation rules required to populate and maintain data Warehouse content.
• Worked on Metadata exchange among various proprietary systems using XML.
• Developed Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
• Performed detailed data analysis to analyze the duration of claim processes and created the cubes with Star Schemas using facts and dimensions through SQL Server Analysis Services (SSAS).
• Worked on normalization techniques, normalized the data into 3rd Normal Form (3NF).
• Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
• Performed data analysis and data profiling using complex SQL on various sources systems.
• Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
• Monitored the Data quality and integrity of data was maintained to ensure effective functioning of department.

Environment: Erwin 9.6, agile, AWS, PL/SQL, OLAP, MDM, SSIS, OLTP, XML, SSAS, 3NF, SSRS

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Worked as a Sr. Data Analyst/Modeler to generate Data Models using Power Designer and developed relational database system
• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Developed long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap.
• Worked in generating and documenting Metadata while designing OLAP systems environment.
• Designed logical and physical data models using data provisioning and consumption techniques.
• Involved in data mapping document from source to target and the data quality assessments for the source data.
• Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Designed both 3NF data models for OLTP systems and dimensional data models using star and snow flake Schemas.
• Designed and Developed Oracle, and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Conducted JAD Sessions with the SME, stakeholders and other management teams in the finalization of the User Requirement Documentation.
• Involved in Data profiling and performed Data Analysis based on the requirements, which helped in catching many Sourcing Issues upfront.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created ER diagrams using Power Designer modeling tool for the relational and dimensional data modeling.
• Created SQL tables with referential integrity and developed queries using SQL, and PL/SQL.
• Involved in Normalization / De-normalization, Normal Form and database design methodology.
• Conducted user interviews, gathering requirements, analyzing the requirements using Rational Rose, Requisite pro RUP.

Environment: Power Designer, OLAP, SSIS, SSRS, OLTP, 3NF, PL/SQL, SQL

Confidential

Data Analyst

Responsibilities:

• Performed data analysis and data profiling using complex SQL on various sources systems and answered complex business questions by providing data to business users.
• Generated Data dictionary reports for publishing on the internal site and giving access to different users.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for application.
• Worked with Data Analyst for requirements gathering, business analysis and project coordination.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Created, modified, deployed, optimized, and maintained Business Objects Universes using Designer.
• Worked with business analyst to design weekly reports using combination of Crystal Reports.
• Applied various data mining techniques Linear Regression & Logistic Regression, classification, clustering.
• Produced report using SQL Server Reporting Services (SSRS) and creating various types of reports.
• Developed all the required stored procedures, user defined functions and triggers using T-SQL and SQL
• Performed Data Analysis and Data validation by writing SQL queries using SQL assistant.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process.
• Worked on Data Mining and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.
• Developed SQL queries, Ad Hoc for Extracting data from production databases to build data structures, reports.

Environment: SQL, SSIS, XML, SSRS, T-SQL, OLTP, OLAP, PL/SQL