SUMMARY

• Over ten 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:

• 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.
• 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 incorporate teh new calculations.
• Involved in overall data mart testing and different team review meetings.

Environment: SQL Server 2012,, Azure Cosmos DB, Azure Postgre, SAP Power Designer 15.7, IBM Infosphere, Sybase, IBM Infosphere, Mongo DB, AWS Redshift, AWS Aurora, AWS RDS, Dynamo DB

Confidential, Nutley, NJ

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 incorporate teh new calculations.
• Involved in overall data mart testing and different team review meetings.

Environment: CA Erwin, SQL Server 2008, AWS Redshift, AWS Aurora, AWS RDS, Dynamo DB, Python, Azure Cosmos DB, Azure Postgre,Teradata 16, Apache HIVE, SPARK, Mongo, Oracle 11g, Kubernetes, Matillion, Snowflake, Micro Strategy, SQL Developer, Windows XP, MS Visio, MS Access and MS Excel.

Confidential, New York

Senior Data Modeler

Responsibilities:

• Present System/Data flow diagram to teh team Lead Data Analysis effort to identify Provider elements in various source systems Vistar (provider credentialing system), HealthSuite and MC400 (claims adjudication systems).
• Identify source system entities based on reporting requirements and design Data Acquisition layer for all teh three source systems mentioned earlier.
• Leadership role in identifying teh cardinality of various provider elements and map them from various source systems to corresponding Master Data Management (MDM) landing tables.
• Identify match merge and trust rules amongst various provider specific data elements.
• Extract Provider Golden record data for downstream application consumption.
• Lead Design and Build Scorecards to visualize data quality trend for management consumption.
• Lead effort to integrate Customer Relations Management (CRM) with Master Data Management.
• Lead effort to integrate Enterprise Data warehouse with Master Data Management
• Design Provider Data Access Layer by integrating teh Provider MDM with source system data.

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

Confidential, Irving, 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.
• 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 dat 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 Strateg, SQL Developer, Windows XP, MS Visio, MS Access and MS Excel.

Confidential, Irving, TX

Data Analyst/Database Developer

Responsibilities:

• Involved in teh projects from requirement analysis to better understand teh requirements and support teh development team with teh better understanding of teh data.
• Used Rational Requisite Pro to document technical requirements and business user requirements.
• Redesigned some of teh subject areas and introduced some new entities and attributes as per teh requirements.
• Developed Use Cases using MS Visio, and a detailed project plan with emphasis on deliverables.
• Performed Reverse Engineering of teh current application using Rational Data Architect, and developed Logical and Physical data models for Central Model consolidation.
• To Design teh logical Model and ensure dat if follows teh normalization rules and has teh best possible traceability pattern
• Supported teh DBA in teh physical implementation of teh tables in both Oracle and DB2 databases.
• Documented teh design conventions used for performing database modeling.
• Ensured dat teh Rational toolset information accurately reflects teh physical FPA structure, and teh data dictionary, DDL, models, and any support documents produced from teh toolset would correctly represent teh physical structure and ensure a smooth transition if needed.
• Responsible for ensuring and providing consistent metadata across all teh models in FPA.

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