SUMMARY:

• Over fourteen years of Experience working as a Data Analyst/Data Modeling with emphasis on Data Mapping, Data Validation, Requirement Gathering in Data Warehousing Environment.
• Proficient in Analyzing source system by examining teh content, structure and internal relationships of legacy data sources like flat files, Excel, Oracle, Sybase, SQL Server, XML and DB2 databases.
• Extensive experience analyzing and documenting business requirements and system functional specifications including use cases
• Strong Knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema and ODS architecture for modeling a Data Warehouse by using tools like Erwin, Power Designer, E - R Studio, AbInitio, Designer 2000 and Microsoft Visio.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments
• Experience working with Agile data modeling methodologies
• Experience working with conceptual, logical and physical data modeling considering meta data standards.
• Experienced in designing star schema (identification of facts and dimensions), Snowflake schema for modeling a Data Warehouse.
• Experience with Data warehouse applications using Oracle, MS SQL Server on windows and UNIX platforms.
• Knowledge of Ralph Kimball and Bill Inmon’s approaches to Data Warehousing.Experience in data transformation, data mapping from source to target database schemas and data cleansing procedures using Informatica Power Center and SSIS.
• Familiarity with Microstrategy, Crystal Reports, Cognos and SSRS - Query, Reporting, Analysis and Enterprise Information Management .
• Experience in Teradata RDBMS using FastLoad, FastExport, MultiLoad, TPump, Teradata SQL Assistance and BTEQ Teradata utilities.
• Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and teh team members apprised of goals, project status, and resolving issues.
• Worked in various verticals such as Banking, Health Care, Pharmaceutical, Financial, Retail, Beverages and Educational.
• Good at SQL and PL/SQL.
• Well versed with Data profiling, Data Migration and Data Conversions.

TECHNICAL SKILLS:

Database systems: Oracle 11g/10g/9i/8i/7.x, SQL Server (2005/2000/7.0 ), DB2, AWS Redshift, AWS Postgres, TERADATAv2r5, MS access, Azure, Sybase MySQL.

Data modeling tools: Erwin, Power designer, oracle Designer, ER / Studio, Rational Rose, MS Visio, Embarcadero.

BI/ Reporting tools: Micro Strategy 9, Crystal Reports, Cognos and SSRS.

ETL Tools: Informatica 8.1/7.1.3/7.1.1/6. x/5.x and SSIS.

Programming Languages: C, C++, Java, Unix shell, Visual Basic, COBOL.

Operating Systems: Windows (NT/XP/2003), Linux and Unix.

Other tools: MS Office (Word, Excel, Power Point), MS Project.

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield, IL

Data Architect

Responsibilities:

• Worked in all aspects of data modeling from SAM, CDM, LDM, PDM and deploying teh DDL into different database environment.
• Working with teh Business Analyst and DBA, conducting team meetings and JAD sessions for technical requirements gathering, business analysis, testing and project coordination
• Analyze and evaluate existing system for assessing how it supported functions from teh Use Case diagrams and UML diagrams.
• Implemented end to end AWS ecosystem from Ingestion teh data to moving to other region of teh ecosystem. Teh final solution being teh reporting layer.
• Developed Logical data model using Erwin 9.2 and created physical data models using forward engineering.
• Implemented member and claim domains in snowflake database.
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create graphical representation (E-R diagram) using Erwin 9.2.
• Implemented Policy domain on AWS Redshift database using CA Erwin.
• Worked with ACCORD reference architecture to model members and non-members for an individual component.
• Used BTEQ for SQL queries, and TPump for loading data from source into Teradata tables
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks
• Participate in updating teh dimensional model, and identify teh Facts and Dimensions
• Employed process and data analysis to model a Customer Information Business System.
• Produced functional decomposition diagrams and defined logical data model.
• Coordinated with ETL team for analysis and reporting needs.
• Developed data migration strategies and impact analysis for database
• Design, plan and program data conversion procedures from old to new databases
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality
• Model a database to store customer demographic and other data.
• Design complex reports like aging analysis, invoices generation, profit/loss, balance sheet etc.
• Involved in design and development of standard and ad-hoc reporting using SQL
• Design and developments of teh changes and enhancements. Teh existing submission and refining programs were enhanced to in corporate teh new calculations.
• Involved in overall data mart testing and different team review meetings.

Environment: CA Erwin, SQL Server 2008, AWS Redshift, AWS RDS, AWS ElastiCache, Python, Teradata 16, Apache HIVE, Spark, Scala, Mongo, Oracle 11g, Matillion, Azure Synapse, Micro Strategy, SQL Developer, Windows XP, MS Visio, MS Access and MS Excel.

Confidential, New York, NY

Data Architect

Responsibilities:

• Working with teh Business Analyst and DBA, conducting team meetings and JAD sessions for technical requirements gathering, business analysis, testing and project coordination
• Analyze and evaluate existing system for assessing how it supported functions from teh Use Case diagrams and UML diagrams
• Developed Logical data model using Erwin 9.2 and created physical data models using forward engineering
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create graphical representation (E-R diagram) using Erwin 9.2
• Used BTEQ for SQL queries, and TPump for loading data from source into Teradata tables
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks
• Participate in updating teh dimensional model, and identify teh Facts and Dimensions
• Employed process and data analysis to model a Customer Information Business System.
• Produced functional decomposition diagrams and defined logical data model.
• Coordinated with ETL team for analysis and reporting needs.
• Developed data migration strategies and impact analysis for database
• Design, plan and program data conversion procedures from old to new databases
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality
• Model a database to store customer demographic and other data.
• Design complex reports like aging analysis, invoices generation, profit/loss, balance sheet etc.
• Involved in design and development of standard and ad-hoc reporting using SQL
• Design and developments of teh changes and enhancements. Teh existing submission and refining programs were enhanced to in corporate teh new calculations.
• Involved in overall data mart testing and different team review meetings.
• Working with teh Business Analyst and DBA, conducting team meetings and JAD sessions for technical requirements gathering, business analysis, testing and project coordination
• Analyze and evaluate existing system for assessing how it supported functions from teh Use Case diagrams and UML diagrams
• Developed Logical data model using Erwin 9.2 and created physical data models using forward engineering
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create graphical representation (E-R diagram) using Erwin 9.2
• Used BTEQ for SQL queries, and TPump for loading data from source into teradata tables
• Used teradata utilities such as Fast Export, MLOAD for handling various tasks
• Participate in updating teh dimensional model, and identify teh Facts and Dimensions
• Employed process and data analysis to model a Customer Information Business System.
• Migrated on premise Teradata DW into AWS Redshift database.
• Produced functional decomposition diagrams and defined logical data model.
• Coordinated with ETL team for analysis and reporting needs.
• Implemented subject area for customer within Snowflake.
• Developed data migration strategies and impact analysis for database
• Design, plan and program data conversion procedures from old to new databases
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality
• Model a database to store customer demographic and other data.
• Design complex reports like aging analysis, invoices generation, profit/loss, balance sheet etc.
• Involved in design and development of standard and ad-hoc reporting using SQL
• Design and developments of teh changes and enhancements. Teh existing submission and refining programs were enhanced to in corporate teh new calculations.

Environment: Teradata 16, Oracle 11g, SQL Server 2012, DB2 SQL, Unix, MS Azure, Azure Cosmos DB, Azure Databricks, Azure Deltalake, SAP Business Objects, IBM Cognos, Erwin 9.2, SAP Power Designer, IBM InfoSphere

Confidential, New Jersey

Senior Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Worked with DBAs to recreate a best fit physical data model from teh logical data model.
• Performed Data modeling using Power designer, maintaining teh database schema.
• Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Mapped teh source and target databases by studying teh specifications and analyzing teh required transforms and documented teh Purpose of mapping so as to facilitate teh personnel to understand teh process and in corporate teh changes as and when necessary.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using teh forward engineering ERWIN tool.
• Involved in reverse engineering of teh application using Erwin.
• Used Erwin to transform data requirements into data models.
• Redefined many attributes and relationships in teh reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Widely used Normalization methods and has done different normalizations (3NF).
• Good experience in data analysis querying and writing in SQL and TOAD.
• Developed teh unit test scenarios for teh mappings being changed
• Analyzed teh performance of teh jobs during teh project. Utilized standard techniques for enhancing teh performance.
• Gather all teh Sales analysis report prototypes from teh business analysts belonging to different Business units; Participated in JAD sessions involving teh discussion of various reporting needs.
• Reverse Engineering teh reports and identified teh Data Elements (in teh source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with teh appropriate Data Mart at teh lowest level of grain for each of teh Dimensions involved.
• Designed a STAR schemas for teh detailed data marts and Plan data marts involving shared dimensions (Conformed)
• Worked on teh Snow-flaking teh Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.

Environment: SAP Power Designer, Erwin 9.2, Ab Initio, Teradata, Oracle 11g, IBM Infosphere Suite, HDFS, Hortonworks

Confidential, Austin, TX

Data Modeler

Responsibilities:

• Experience in complete life cycle of DW/BI/ETL implementations including defining Vision, Strategy, Architecture, Design, development, Testing, Governance, Troubleshooting, Administration, and Production Support.
• Experience in defining data architecture for data warehouses, ODS and business applications.
• Created Enterprise Conceptual Data Model to halp better understand teh different data domains.
• Experience in building conceptual (ERDs), logical and physical data models from ground up. Adept in Star-Schema modeling and Dimensional modeling.
• Strong analytic and SQL skills to analyze source systems and define integration/Data requirements.
• Experience in business analysis and requirement gathering.
• Experience in working with industry leading ETL and BI tools and establishing governance standards and best practices for DW/BI environments.
• Experience in Prototyping solutions for design and architecture validation, creating technical specifications, preparing testing strategy, and creating deployment plans
• Adept in implementing Service Oriented Architecture, Master Data Management, Metadata management, Data profiling, and Data Quality Improvement initiatives.
• Expertise in SAP suite of products including SAP Data Services, Information Steward, Business Objects, Lumira.
• Designed teh datamart and developed teh complete ETL process to load data into teh tables and achieve teh end goal of building reports in Business Objects.
• Designed and Created teh Universes for different datamarts.
• Involved in data mapping efforts for teh down streams. Performed teh cross system mappings between teh existing system and teh system under development. Also wrote teh logic to map data field requirements for teh down streams when there was no one to one correspondence between teh data elements.
• Implemented Data Integration using nightly ETL Processes. Identified teh Source, teh staging tables, teh target databases, teh SLAs and based on teh requirement set upnightly ETL feeds.
• Involved in teh full life cycle of Business Objects reporting Application.
• Acted as teh liaison between teh business and teh IT team. Ensured that teh business requirements were clearly and unambiguously communicated to teh IT team.
• Reviewing and assessing existing data processing methods and techniques.
• Analyzed data sources for content quality, key consistency, and suitability for integration with teh overall warehouse.
• Revising existing systems and procedures to correct deficiencies and maintain more TEMPeffective data handling, conversion, input/output requirements, and storage.
• Designing documentation deliverables including: process models, process decomposition diagrams, network architecture diagrams, data models, data flow diagrams, entity-relationship diagrams.
• Involved in extensive analysis to design teh Universes and assigned them to respective domains.

Environment: CA Erwin, SQL Server 2008, Micro Strategy, SQL Developer, Postgres, Windows XP, MS Visio, MS Access and MS Excel.

Confidential, Nutley, NJ

Data Modeler

Responsibilities:

• Experience in complete life cycle of DW/BI/ETL implementations including defining Vision, Strategy, Architecture, Design, development, Testing, Governance, Troubleshooting, Administration, and Production Support.
• Experience in defining data architecture for data warehouses, ODS and business applications.
• Experience in building conceptual (ERDs), logical and physical data models from ground up. Adept in Star-Schema modeling and Dimensional modeling.
• Strong analytic and SQL skills to analyze source systems and define integration/Data requirements.
• Experience in business analysis and requirement gathering.
• Experience in working with industry leading ETL and BI tools and establishing governance standards and best practices for DW/BI environments.
• Experience in Prototyping solutions for design and architecture validation, creating technical specifications, preparing testing strategy, and creating deployment plans
• Adept in implementing Service Oriented Architecture, Master Data Management, Metadata management, Data profiling, and Data Quality Improvement initiatives.
• Expertise in SAP suite of products including SAP Data Services, Information Steward, Business Objects, Lumira.
• Designed teh datamart and developed teh complete ETL process to load data into teh tables and achieve teh end goal of building reports in Business Objects.
• Designed and Created teh Universes for different datamarts.
• Involved in data mapping efforts for teh down streams. Performed teh cross system mappings between teh existing system and teh system under development. Also wrote teh logic to map data field requirements for teh down streams when there was no one to one correspondence between teh data elements.
• Implemented Data Integration using nightly ETL Processes. Identified teh Source, teh staging tables, teh target databases, teh SLAs and based on teh requirement set up nightly ETL feeds.
• Involved in teh full life cycle of Business Objects reporting Application.
• Acted as teh liaison between teh business and teh IT team. Ensured that teh business requirements were clearly and unambiguously communicated to teh IT team.
• Reviewing and assessing existing data processing methods and techniques.
• Analyzed data sources for content quality, key consistency, and suitability for integration with teh overall warehouse.
• Revising existing systems and procedures to correct deficiencies and maintain more TEMPeffective data handling, conversion, input/output requirements, and storage.
• Designing documentation deliverables including: process models, process decomposition diagrams, network architecture diagrams, data models, data flow diagrams, entity-relationship diagrams.
• Involved in extensive analysis to design teh Universes and assigned them to respective domains.

Environment: Oracle 9i, SQL, PL/SQL, MS Office, Rational Data Architect, Windows Server 2003, UNIX-Solaris, IBM Rational Requisite Pro, Rational Clear Quest, SQL Developer, TOAD, CA Erwin, SAP Business Objects, Microstrategy