SUMMARY

• Over 9+ years of working experience in Data Modeling, Data Analysis including planning, analysis, design, development, testing, implementation.
• Extensive working experience on Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration management.
• Extensive 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 Big Data Hadoop Ecosystem in ingestion, storage, querying, processing and analysis of big data.
• Solid Excellent experience in creating cloud based solutions and architecture using Amazon Web services and Microsoft Azure.
• Experience in conducting Joint Application Development (JAD) sessions wif SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Excellent proficiency in Software Development Life cycle (SDLC), Agile/Scrum and waterfall methodologies.
• Good experience in working wif 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 teh business techniques.
• Warehouse projects.
• 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 wif data modeling, data governance.
• Efficient in all phases of teh development lifecycle, coherent wif 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 has done normalizations up to 3NF.
• Experience in data analysis to track data quality and for detecting/correcting inaccurate data from teh 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 wif 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 wif 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 teh Enterprise Data Warehouse.
• Experience wif DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.

TECHNICAL SKILLS

Data Modeling Tools: Erwin 9.7/9.6, ER Studio v17, and Power Designer.

Programming Languages: SQL, PL/SQL, HTML 5, XML and VBA.

Reporting Tools: SSRS, Power BI, Tableau, SSAS, MS-Excel, SAS BI Platform.

Cloud Platforms: AWS, EC2, EC3, Redshift & MS Azure

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

Databases: Oracle 12c/11g, Teradata R15/R14, MS SQL Server 2016/2014, DB2.

Operating System: Windows, Unix, Sun Solaris

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

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

PROFESSIONAL EXPERIENCE

Confidential - Dublin, OH

Sr. Data Modeler

Responsibilities:

• As a Data Modeler understand teh high-level design choices and teh defined technical standards for software coding, tools and platforms and ensure adherence to teh same.
• Used Agile Methodology of Data Warehouse development using Kanbanize.
• Analyze business requirements and build logical data models that describe all teh data and relationships between teh data
• Migrated SQL Server Database to Microsoft Azure SQL Database.
• Provided suggestion to implement multitasking for existing Hive Architecture in Hadoop also suggested UI customization in Hadoop.
• Integrated data from multiples sources including HDFS to Hive Data warehouse.
• Involved in Planning, Defining and Designing database using ER/Studio on business requirement and provided documentation.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snow Flake Schemas.
• Translate business and data requirements into logical data models in support of Enterprise Data Models, Operational Data Structures and Analytical systems.
• Partner wif DBAs to transform logical data models into physical database designs while optimizing teh performance and maintainability of teh physical database
• Work wif Data Management to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure teh accuracy, validity, and reusability of metadata.
• Developed Full life cycle of Data Lake, Data Warehouse wif Big data technologies like Spark and Hadoop.
• Applied all phases of teh Software Development Life Cycle, which include requirements definition, analysis, review of design and development, and integration and test of solution into teh operational environment
• Worked on Azure Power BI Embedded to integrate teh reports to application.
• Createddataschema and architecture ofdatawarehouse for standardizeddatastorage and access
• Used data profiling automation to uncover teh characteristics of teh data and teh relationships between data sources before any data-driven.
• Used Azure reporting services to upload and download reports
• Developed test scripts for testing sourced data and their validation and transformation when persisting in data stores that are physical representations of teh data models
• Designed and documented Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Completed enhancement for MDM (Masterdatamanagement) and suggested teh implementation for hybrid MDM (MasterDataManagement)
• Designed processes and jobs to source data from Mainframe sources to HDFS staging zone.
• Lead database level tuning and optimization in support of application development teams on an ad-hoc basis.

Environment: ER Studio 9.0, Hive, Hadoop, MDM, MS Azure, HDFS, PL/SQL, Sql Server, Azure SQL DB, UNIX

Confidential - Boston, MA

Sr. Data Modeler

Responsibilities:

• Working as Sr. Data Modeler wif client to develop huge data warehouse wif teh help of AWS cloud and data modeling technique.
• Generated Data Models using Erwin and developed relational database system.
• Extensively used agile methodology as teh Organization Standard to implement teh data Models.
• Worked in an environment of Amazon Web Services (AWS) provisioning and used AWS services.
• Created semantically rich logical data models (non-relational/NoSQL) that define teh Business data requirements.
• Converted conceptual models into logical models wif detailed descriptions of entities and dimensions for Enterprise Data Warehouse.
• Involved in creating Pipelines and Datasets to load teh data onto Data Warehouse.
• Coordinate wif Data Architects to Design Big Data, Hadoop projects and provide for a designer that is an idea-driven.
• Created database objects in AWS Redshift. Followed AWS best practices to convert data types from oracle to Redshift.
• Worked on NoSQL Databases as Cassandra
• Identified data organized into logical groupings and domains, independent of any application or system.
• Developed data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema.
• Created S3 buckets in teh AWS environment to store files, sometimes which are required to serve static content for a web application.
• Developed Model aggregation layers and specific star schemas as subject areas wifin a logical and physical model.
• Identified Facts &Dimensions Tables and established teh Grain of Fact for Dimensional Models.
• Configured Inbound/Outbound in AWS Security groups according to teh requirements.
• Established measures to chart progress related to teh completeness and quality of metadata for enterprise information.
• Developed teh data dictionary for various projects for teh standard data definitions related data analytics.
• Managed storage in AWS using Elastic Block Storage, S3, created Volumes and configured Snapshots.
• Generate teh DDL of teh target data model and attached it to teh Jira to be deployed in different Environments.
• Conducted data modeling for JAD sessions and communicated data related standards.
• Investigate Data Quality Issues and provide recommendation & solution to address them.
• Optimized and updated UML Models (Visio) and Relational Data Models for various applications.
• Validated teh data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Prepared reports to summarize teh daily data quality status and work activities.
• Performed ad-hoc analyses, as needed, wif teh ability to comprehend analysis as needed.

Environment: Erwin 9.7, NoSQL, Sqoop, Cassandra 3.11, AWS, Hadoop 3.0, SQL, Pl/SQL

Confidential - St. Louis, MO

Sr. Data Modeler/Data Analyst

Responsibilities:

• As a Data Modeler/Analyst role to review business requirement and compose source to target data mapping documents.
• Participated in design discussions and assured functional specifications are delivered in all phases of SDLC in an Agile Environment.
• Researched and developed hosting solutions using MS Azure for service solution.
• Worked on Performance Tuning of teh database which includes indexes, optimizing SQL Statements.
• Coordinated wif teh Business Analyst and prepared Logical and Physical Data models as per teh requirements involving multiple subject areas, domains and naming standards.
• Built Data Warehouse in Azure platform using Azure data bricks and data factory.
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Developed data Mart for teh base data in Star Schema, Snowflake Schema involved in developing teh data warehouse for teh database.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models
• Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
• Created and maintained data model standards, including master data management (MDM).
• Worked in importing and cleansing of data from flat files, SQL Server wif high volume data.
• Explored NoSQL options for current back using Azure Cosmos DB (SQL API).
• Created PL/SQL procedures in order to aid business functionalities like bidding and allocation of inventory to teh shippers.
• Created dimensional model for teh reporting system by identifying required facts and dimensions using Erwin.
• Worked wif project management, business teams and departments to assess and refine requirements to design BI solutions using MS Azure.
• Created DDL scripts using Erwin and source to target mappings to bring teh data from source to teh warehouse.
• Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
• Created Project Plan documents, Software Requirement Documents, Environment Configuration and UML diagrams.
• Worked on Data load using Azure Data factory using external table approach.
• Developed teh stored Procedures, SQL Joins, SQL queries for data retrieval, accessed for analysis and exported teh data into CSV, Excel files.
• Created data flow, process documents and ad-hoc reports to derive requirements for existing system enhancements.

Environment: MS Azure, Azure Data factory, Agile, 3NF, T-SQL, MDM, SQL, PL/SQL, Erwin 9.7, MS Visio 2019, ad-hoc, SSRS, SQL Server 2016, Azure Databricks.

Confidential - Greensboro, NC

Sr. Data Analyst

Responsibilities:

• As a Data Analyst analyzed data quality issues against source system and prepared a data quality document confirming all teh source data quality.
• Understand teh data visualization requirements from teh Business Users.
• Developed data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema.
• Coordinated wif teh Business Analyst and prepared Logical and Physical Data-models as per teh requirements involving multiple subject areas, domains and naming standards.
• Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.
• Performed in team responsible for teh analysis of business requirements and design implementation of teh business solution.
• Developed and implemented data cleansing, data security, data profiling and data monitoring processes.
• Extensively used Data Analysis for OLTP and OLAP systems.
• Used SAS Import/Export Wizard plus SAS programming techniques to extract data from excel.
• Written complex T- SQL, SQL queries using joins, sub queries and correlated sub queries
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Developed and presented Business Intelligence reports and product demos to teh team using SSRS (SQL Server Reporting Services).
• Used Informatica features to implement Type I & II changes in slowly changing dimension tables.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Identified source databases and created teh dimensional tables and checked for data quality using complex SQL queries.
• Involved in data mining, transformation and loading from teh source systems to teh target system.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Worked on Data Verifications and Validations to evaluate teh data generated according to teh requirements is appropriate and consistent.
• Developed UNIX Shell scripts to automate various periodically repetitive database processes.
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.

Environment: SQL, PL/SQL, OLAP, OLTP, BI, SAS, T- SQL, SSIS, SSRS, Informatica, Tableau and UNIX.

Confidential 

Data Analyst

Responsibilities:

• Designed and implemented business intelligence to support sales and operations functions to increase customer satisfaction.
• Involved in data analysis, data discrepancy reduction in teh source and target schemas.
• Developed complex PL/SQL procedures and packages using views and SQL joins.
• Developed of reports using different SSIS Functionalities like sort prompts and cascading parameters, Multi Value Parameters.
• Conducted detailed analysis of teh data issue, mapping data from source to target, design and data cleansing on teh Data Warehouse
• Involved in identifying teh Data requirements and creating Data Dictionary for teh functionalities
• Analyzed and build proof of concepts to convert SAS reports into tableau or use SAS dataset in Tableau.
• Created or modifying teh T-SQL queries as per teh business requirements.
• Developed and optimized stored procedures for use as a data window source for complex reporting purpose.
• Performed teh batch processing of data, designed teh SQL scripts, control files, batch file for data loading.
• Coordinated wif data stewards / data owners to discuss teh source data quality issues and resolving teh issues based on teh findings.
• Worked wif data investigation, discovery and mapping tools to scan every single data record from many sources.
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked on SQL Server concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Worked on different data formats such as Flat files, SQL files, Databases, XML schema, CSV files
• Involved in designing Parameterized Reports for generating ad-hoc reports as per teh business requirements

Environment: SAS, Tableau 8.1, Ad-hoc, SQL, T-SQL, Flat Files, SSIS Vs 2013, SSRS, SSAS, SML, Business Intelligence.