SUMMARY:

• Over 9+ years of experience as Data Architect and Data Modeler with excellent knowledge on BI, Data warehouse, and various Data Modeling methodologies.
• Experience with JAD sessions for requirements gathering and writing functional specifications, queries.
• Good experienced in Dimensional and Relational Data Modeling using Star and Snowflake Schemas, Fact and Dimension tables, Conceptual, Logical and Physical data modeling using Erwin.
• Expertise in Normalization (1NF, 2NF, 3NF and BCNF)/Denormalization techniques for effective and optimum performance in OLTP and OLAP
• Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.
• Experience with Amazon Web Services, including AWS Lambda, AWS EC2, AWS S3, Cloud Watch.
• Experience in generating DDL (Data Definition Language) Scripts and creating Indexing strategies.
• Proficient in Data Analysis, Data Validation, Data Lineage Data Cleansing, Data Verification and identifying data mismatch.
• Having good knowledge in Normalization (1NF, 2NF and 3NF) and De - Normalization techniques for optimum performance on XML data.
• Hands on experience with Agile and Waterfall data modeling methodologies.
• Good experience in Relational and Dimensional Data modeling for creating Logical and Physical.
• Experience working with data modeling tools like Erwin, Power Designer and ER Studio.
• Extensive experience in development of T-SQL, Oracle, PL/SQL Scripts, Stored Procedures and Triggers.
• Efficient in enterprise data warehouses using Kimball data warehouse and Inmon's methodologies.
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Great hands on knowledge using Microsoft office like MS Word, MS Excel and MS Power Point.
• Develop and manage SQL, Python and R code bases for data cleansing and data analysis using Git version control.
• Proficient in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export.
• Strong experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration management.
• Strong Experience in working with Excel Pivot and VBA Macros for various business scenarios.
• Extensive experience in advanced SQL Queries and PL/SQL stored procedures.

TECHNICAL SKILLS:

Data Modelling Tools: ER/Studio v17, Erwin 9.6/9.5, Sybase Power Designer.

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

Cloud Platform: AWS, EC2, EC3, AWS ELB, RDS, Redshift, MS Azure Basic

BI Tools: MS BI suit, Tableau, Tableau server, Tableau Reader, SAP Business Objects, Crystal Reports.

Programming Languages: SQL, PL/SQL, Unix shell Scripting, Perl, AWK, SED

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

Operating System: Windows, Unix, Sun Solaris, Linux, CentOS

ETL/Data warehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2 and Tableau.

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

ADDITIONAL SKILLS:

Agile, MDM, Amazon Redshift, SSIS, OLTP, SSRS, Erwin 9.7, NoSQL, Oracle 12c, OLAP, Qlikview, MS Excel 2016, T-SQL, SQL, PL/SQL, UNIX, Rational Rose, MS Visio 2008, ER/Studio v13, SQL, Metadata, DB2, 3NF

WORK EXPERIENCE:

Confidential, Marlborough, MA

Sr. Data Architect/Data Modeler

Responsibilities:

• Massively involved in Sr. Data Architecture/Data Modeler role to review business requirement and compose source to target data mapping documents.
• Worked on data profiling and analysis to create test cases for new Architecture evaluation.
• Attended JAD sessions with Data Architects to build Subject Area specific data models.
• Extensively used agile methodology as the Organization Standard to implement the data Models.
• Defined the overall BI data architecture, included ETL processes, ODS, EDW and data marts.
• Provided oversight across projects to ensure Data Models and ETL/BI designs align to standards and best practices for achieving maximum consistency, performance and efficiency of the DW/BI ecosystem.
• Worked as a SME for data integrated with Enterprise Data Warehouse.
• Provided BI technical and architectural guidance to projects and teams, ensuring that new initiatives enable effective data reporting.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Interacted with multiple users to collect business Requirements and converted them into a Business requirement document.
• Responsible for technical Data governance, enterprise wide Data modeling and Database design.
• Designed and Implemented databases, data structures, and data processes to meet business needs for Reporting and Analytics
• Worked with Reporting and Analytic team members on understanding the structures.
• Build Integrated Enterprise Data Warehouse and Dimensional models using Hadoop to support optimized reporting solutions.
• Created entity relationship diagrams and then converted them into logical and physical model.
• Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
• Reversed Engineering of different legacy systems using Erwin Data Modeler and Erwin Safyr option.
• Reviewed Data Models for enterprise data architecture principles and standards
• Performed Metadata Reviews on Data Models to improve the Master Data Management (MDM).
• Documented ER Diagrams, Logical and Physical models, business process diagrams and process flow diagrams.
• Developed and implemented data cleansing, data security, data profiling and data monitoring processes.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Extensively worked on creating the migration plan to Amazon web services (AWS).
• Extracted MegaData from Amazon Redshift, AWS, and Elastic Search engine using Sql Queries to create reports.
• Used Model Manager Option in Erwin to synchronize the data models in Model Mart approach.
• Worked with the ETL team to document the SSIS packages for data extraction to Warehouse environment for reporting purposes.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models
• Worked on Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon's Data Warehouse methodology.
• Participated in all phases of project including Requirement gathering, Architecture, Analysis, Design, Coding, Testing, Documentation and warranty period.
• Developed data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Extensively used Erwin as the main tool for modeling along with Visio
• Involved in designing and architecting data warehouses and data lakes on high performance (Teradata) and big data (Hadoop - Hive and HBase) databases.
• Loaded data into Hive Tables from Hadoop Distributed File System (HDFS) to provide Sql access on Hadoop data.
• Installed and configured Hive, Pig, and Sqoop on the Hadoop cluster.
• Deployed SSRS reports to Report Manager and created linked reports, snapshots, and subscriptions for the reports and worked on scheduling of the reports.
• Sql Server

Environment: Agile, MDM, Amazon Redshift, SSIS, OLTP, SSRS, Erwin 9.7

Confidential, Chicago, IL

Data Architect /Data Modeler

Responsibilities:

• Provided end to end data architecture for the project by identifying the sources of data, designing the target and generating data mapping between source and target.
• Design SDLC processes that ensure the consistent and effective creation, storage, presentation and control of documents and metadata to support enterprise-wide data sharing and integration efforts.
• Responsible for the data architecture design delivery, data model development, review, approval and Data warehouse implementation.
• Responsible for Big data initiatives and engagement including analysis, brain storming, POC, and architecture.
• Gathering Business requirements by running meetings with Business stakeholders and documenting functional and technical requirements.
• Used Agile Methodology of Data Warehouse developmentusing Kanbanize.
• Designed and developed architecture for data services ecosystem spanning Relational, NoSQL, and Big Data technologies.
• Developed and Implemented logical and physical data models using enterprise modeling tools Erwin.
• Monitored and measured data architecture processes and standards to ensure value is being driven and delivered as expected.
• Participate in Data Governance meeting to provide guidance and participate with Data Management organizations to define ownership, usage, security and quality for all data.
• Created data models for AWS Redshift, Hive and HBase from dimensional data models.
• Developed Master data management (MDM) strategies for storing reference data.
• Worked with Data Stewards and Business analysts to gather requirements for MDM Project.
• Coordinated the database design on the DB infrastructure objects and performance/storage related changes with DBA on Oracle platform.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using Erwin.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snow flake Schemas.
• Created Data Validation rules using SQL to validate the structure and integrity of the extracted data.
• Worked in NoSQL database on simple queries and writing Stored Procedures for Normalization and De-normalization.
• Created Data Migration and Cleansing rules for the Integration architecture (OLTP, ODS, DW).
• Handled performance requirements for databases in OLTP and OLAP models.
• Conducted meetings with business and development teams for data validation and end-to-end data mapping.
• Worked with reversed engineer Data Model from Database instance and Scripts.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams based on the requirements.
• Involved in designing and developing Data Models and DataMarts that support the Business Intelligence Data Warehouse.

Environment: Agile, NoSQL, Erwin 9.7, Amazon Redshift, MDM, Oracle 12c, OLTP, OLAP, Qlikview, MS Excel 2016

Confidential, Flores San Antonio, TX

Sr. Data Modeler

Responsibilities:

• As a Sr. Data Modeler involved in performing business area analysis and logical and physical data modeling using Erwin for data warehouse/data mart applications
• Conducted data modeling JAD sessions and communicated data related standards.
• Conducted walkthroughs with the DBA to convey the changes made to the data models.
• Optimized and updated UML Models (Visio) and Relational Data Models for various applications.
• Analyzed data reporting operations to Identified insight to reduce data quality issues and process gaps.
• Participated in performance management and tuning for stored procedures, tables and data base servers.
• Performed data analysis and profiling of source data to better understand the data sources.
• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model.
• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and ITanalysts on a scheduled basis.
• Utilized algorithms such as linear regression, logistic regression, decision tree and SVM.
• Worked with Business users during requirements gathering and prepared Conceptual, Logical and Physical Data Models.
• Performed logical data modeling, physical data modeling (including reverse engineering) using the Erwin Data modeling tool.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using Erwin.
• Developed dataMart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models.
• Applied data analysis, data mining and data engineering to present data clearly.
• Developed and implemented data cleansing, data security, data profiling and datamonitoring processes.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
• Designed OLAP system environment and maintained documentation of Metadata.
• Worked on specifications given by the Data governance team and Data quality team.
• Developed and maintained the data dictionaries, Naming Conventions, Standards, and Class Words Standards Document.
• Collaboratively worked with the Data modeling architects and other data modelers in the team to design the Enterprise Level Standard Data model.
• Worked on Data governance, data quality, data lineage establishment processes.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mappingtools to scan every single data record from many sources.
• Directing and overseeing data quality tests, including providing input to quality assurance team members.
• Recommending solutions regarding data systems, storage and lifecycle management.

Environment: OLTP, Erwin 9.4, MS Visio 2014, 3NF

Confidential, Northfield Township, IL

Data Analyst/Data Modeler

Responsibilities:

• Worked as a Data Analyst/Data Modeler to generate Data Models using ER/Studio and developed relational database system.
• Reversed Engineered the Data Models and identified the Data Elements in the source systems.
• Developed Data Migration and Cleansing rules for the Integration Architecture.
• Conducted meetings with the business team to gather necessary analytical data requirements in JAD sessions.
• Created and maintained Metadata, including table, column definitions
• Worked on Data governance, data quality, data lineage establishment processes.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ER/Studio.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Involved in Data Profiling, Data cleansing and make sure them data is accurate.
• Generated DDL (Data Definition Language) scripts using ER/Studioand supported the DBA in Physical Implementation of data Models.
• Created and maintained the data dictionaries, maintained some parameters to provide faster query performance-using SQL.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Worked with Data governance, Data quality, data lineage to design various models and processes.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Wrote PL/SQL statement, stored procedures and Triggers in DB2 for extracting as well as writing data.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Performed Data analysis for the existing Data warehouse and changed the internal schema for performance.
• Used MS Visio for business flow diagrams and defined the workflow.
• Involved in complete SSIS life cycle in creating SSISpackages, building, deploying and executing the packages all environments.

Environment: ER/Studio v13, OLAP, SQL, Metadata, OLTP, SSRS, DB2, MS Visio 2010, SSIS

Confidential

Data Analyst

Responsibilities:

• Massively involved in Data Analyst to analyze the specifications and identify the source data from disparate data sources.
• Generated and DDL (Data Definition Language) scripts using Power Designer for the creation of new objects like table, views, indexes, packages and stored procedures.
• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization.
• Conducted JAD Sessions with business analyst and application teams to analyze requirements for data storage for new application.
• Extensively used Power Designer for Data modeling. Created Staging and Target Models for the Enterprise Data Warehouse.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Generated DDL statements for the creation of new Sybase objects like table, views, indexes, packages and stored procedures.
• Performed Data Analysis and Data validation by writing SQL queries using SQL assistant.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct Data Analysis.
• Worked with the business analyst and development team to create models and to guide the development team in terms of data and process integration requirements.
• Involved in developing Data Conversion programs using SQL, PL/SQL and Unix shell scripts.
• Generated Data dictionary reports for publishing on the internal site and giving access to different users.
• Designed ER diagrams and mapping the data into database objects
• Involved in Data profiling in order to detect and correct inaccurate data and maintain the data quality.
• Used MS Visio and Rational Rose to represent system under development in a graphical form by defining use case diagrams, activity and workflow diagrams.
• Identified the business requirements by going over the business process and interacting with the business analyst and management.
• Analyzed the business requirements by dividing them into subject areas and understood the dataflow within the organization.
• Communicated with users and business analysts to gather requirements.
• Involved in business process modeling using UML through Rational Rose.

Environment: T-SQL, SQL, PL/SQL, UNIX, Rational Rose, MS Visio 2008.