EXPERIENCE SUMMARY

• Over TEN years of professional IT experience in different industries like BFS (BANKING and FINANCIAL SERVICES), TELECOM, RETAIL, INSURANCE and HEALTH CARE. Strong working experience throughout all stages of Analysis, Designing, Development and Testing.
• Over Six years of experience in Data modeling wif emphasis on data analysis, Business analysis, Relational / dimensional modeling.
• Can TEMPeffectively use modeling tools like Erwin and Embarcadero (ER/Studio)
• Worked and extracted data from various database sources like Oracle, MS SQL, DB2 and Flat files.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document wif detailed description of logical entities and physical tables.
• Possess strong Documentation skill and noledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Extensive Experience working wif business users/SMEs as well as senior management.
• Strong understanding of teh principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Strong Knowledge of SDLC.
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements.
• Conducted logical data analysis and data modeling JAD sessions, documented data - related standards.
• Designed teh data marts using teh Ralph Kimball’s and Inmon dimensional data mart modeling techniques.
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Created logical data model from teh conceptual model and its conversion into teh physical database design using Erwin.
• Good in Normalization (1NF, 2NF, 3NF) / Denormalization techniques for TEMPeffective and optimum performance in OLTP and OLAP environments.
• Efficient in data mart design and creation of cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Efficient in process modeling using Erwin in both forward and reverse engineering cases.
• Self starter and capable to work both as part of teh team as well as independently to achieve quality goals.

TECHNICAL SKILLS

Analysis/Design Tools: Erwin r7.3, Erwin r9, UML, MS-Visio, Embarcadero (ER/Studio)

Model Validator Tools: Data Base Examiner (DBE)

Operating Systems: OS-390, MVS, Windows 95/98/NT/2000/XP, MS-DOS

Languages: COBOL, Delta-COBOL, PASCAL, C, C++, Visual Basic, HTMLDAS, DBS, EZYTRIVE

Databases: SQL Server 2000/05/08/12, Oracle 7i, 8i, 9i, 10g, 11g, DB2 MS-Access, VSAM, DB2, DATACOM, Sybase.:

OLTP: CICS

Rule Engine: PEGA

IDE (facility): TSO/ISPF, IEBGENER Utility Files, ROSCOE

Defect Tracking: HP QC (HP Application Lifecycle Management 11.0), REMEDYMercury TEST DIRECTOR, PR-TOOL, JIRA

Tools: SPUFI, QMF, FILE-AID, ROSCOE, DATA MOVER, TRACE MASTERINSYNC, SDF-II, HIPERSTATION, ELIXIR, DBS (IMS-DB)DAS (IMS-DC), REXX, TOAD, Razor SQL.

Reporting Tools: Crystal Reports 11, OBIEE 10.3.4.1, BO XIR3.1, Cognos, and Microsoft

Reporting Services.:

Testing Tools: XPEDITOR, INTERTEST

Change Control: ENDEVOR, INFOMAN, VSS, SVN (Sub-Version)

PROFESSIONAL EXPERIENCE

Confidential, NJ

Data Modeler

Responsibilities:

• Identified different SOR’s and teh related entities and attributes.
• Worked closely wif business users, dealers and third party vendors to understand teh process and teh requirements.
• Created different subject areas and created different entities as per teh business needs
• Identified suitable classification words for teh data coming from different sources.
• Identified teh attributes to maintain in Semantic layer and provided instructions to Semantic team on how to populate data into those attributes.
• Participated in DRB review meetings and updated model as per their review comments
• Analyzed source system copybooks and identified necessary attributes and their data types.
• Applied ICDW naming standards for teh entities and attributes we created in integration layer.
• Analyzed teh staging tables and their attribute properties to understand teh data being populated from and identified suitable data types for teh target attributes.
• Delivered model on time for mapping team and PDM team to proceed wif.
• Working closely wif and guide teh ETL development team
• Creating appropriate meta data& documentation

Environment: ERwin r7.3.10, Informatica, Teradata SQL Assistant, Quest Toad for oracle 10.6.1, SVN WinSCP 4.3.5, VISIO, SharePoint.

Confidential, NJ

Data Modeler

Roles and Responsibilities:

• Working directly wif external clients in establishment of standardizedinterface format capable of transferring all regulatory required data into a central data warehouse dat could be used to satisfy all regulatory reporting needs (annual statements, data calls).
• Under general direction, working closely wif users, business analysts and team members to understand business requirements and teh design of technical specification.
• Designed teh strategic interface format in which all source systems will provide teh source data
• Design and model teh reporting data warehouse considering current and future reporting requirement
• Working closely wif and guide teh ETL development team
• Creating appropriate meta data& documentation

Environment: ERwin r9.0, Data Stage, MS-Office, SQL Server 2008/2012, Toad, VISIO, SharePoint, Oracle 11g, Cognos.

Confidential, MA

Data Modeler

Responsibilities:

• Working on interviewing business users to gather requirements and documenting teh requirements.
• Discovering entities, attributes, relationships and business rules from functional experts.
• Using Erwin R9.0, Creating Logical and Physical data models.
• Translating logical data models into physical database designs.
• Working logical model in 3NF.
• Designing and building relational databases.
• Performing data mapping and documenting ETL transformations.
• Performing Data Analysis and Data Profiling.
• Working on Naming standards to automate teh Table/Column names.
• Created alter scripts to support changes in teh database.
• Created Indexes to improve teh performance.
• Created constraints and tablespaces.
• Automated use of data naming standards by creating Erwin Macros.
• Created Master Abbreviations file.
• Documented formal standards and conventions.
• Delivered and published teh models on time.
• Resolved teh revolving issues by conducting and participating in JAD sessions wif teh users, architects, and developers.
• Conducted design discussions and meetings to come out wif teh appropriate data model.
• Extensively used Agile methodology as teh Organization Standard to implement teh data Models.

Environment: ERwin r8.0 and Erwin r9.0, Subversion (SVN), Data Base Examiner (DBE), MS-Office, SQL Server 2008/2012, SQL Server Management Studio, VISIO, SharePoint, JIRA.

Confidential, Boston, MA

Data Modeler

Roles and Responsibilities:

• Participated in requirement gathering session wif business users and sponsors to understand and document teh business requirements as well as teh goals of teh project.
• Created teh conceptual model for teh EDW (Enterprise Data Warehouse) and get it reviewed by business users.
• Analyzed teh source systems to understand teh source data and table structure along wif deeper understanding of business rules and data integration checks.
• Identified various facts and dimensions from teh source system and business requirements to be used for teh data warehouse.
• Created different subject areas as per teh Business specifications.
• Created teh dimensional logical model wif approximately 59 facts, 40 dimensions wif 2842 attributes using ER Studio.
• Implemented teh Slowly changing dimension scheme (Type II) for most of teh dimensions.
• Prepared naming standard document and applied teh naming standards to fields in teh physical Model.
• Validated model for errors and corrected model.
• Reviewed teh logical model wif Business users as well as wif my team members
• Reviewed teh physical model wif DBA’s
• Clarified teh queries from teh QA team (testing team) and helped them in understanding teh business requirements.
• Created teh DDL scripts using Embarcadero ER/Studio and source to target mappings (S2T- for ETL) to bring teh data from source systems to teh warehouse.
• Documented all our model changes regularly and published to entire team to provide them better understanding of teh changes.
• Produced Data Dictionary.
• Worked on HP Quality Center to track teh defect logged against teh logical and physical model.
• Worked wif teh test team to provide insights into teh data scenarios and test cases.
• Worked on data profiling and data validation to ensure teh accuracy of teh data between teh warehouse and source systems.
• Uploaded teh model artifacts regularly into SharePoint.

Environment: Embarcadero - ER/Studio DA 9.1, Oracle 11g, VISIO, MS-Office, INFORMATICA, TOAD for Data Analysts 3.0, HP Application Lifecycle Management 11.0/ HP-QC.

Confidential, MA

Data Analyst / Modeler

Roles and Responsibilities:

• Participated in JAD session wif business users and sponsors to understand and document teh business requirements in alignment to teh financial goals of teh company.
• Participated in KAP sessions to gain noledge on teh applications assigned wif teh help of State Street SME's.
• Played a major role in gathering documents and preparing SMTD document on teh noledge gained from SME's.
• Involved in Training sessions to provide all teh business noledge to teh team members.
• Resolved teh revolving issues by conducting and participating in different meetings wif teh users, SME's of different systems and developers.
• Coordinate and record stakeholder meetings regarding planning, implementation or issue resolution.
• Involved in all applications related meetings wif teh business and documented all dat information.
• Succeeded in getting approvals from teh Business Owners for those applications which were allocated to me.
• Gained in-depth noledge on Accruals and Amortization process of teh income department and created different subject areas and tables.
• Created teh conceptual model for teh data warehouse wif emphasis on insurance (life and health), mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
• Reviewed teh conceptual EDW (Enterprise Data Warehouse) data model wif business users, App Dev and Information architects to make sure all teh requirements are fully covered.
• Analyzed large number of COBOL copybooks from multiple mainframe sources (16) to understand existing constraints, relationships and business rules from teh legacy data.
• Worked on rationalizing teh requirements across multiple product lines
• Reviewed and implemented teh naming standards for teh entities, attributes, alternate keys, and primary keys for teh logical model.
• Created teh logical model for teh EDW wif approximately 147 entities and 3668 attributes using ER Studio. Teh logical model was fully attributed till 3rd normalization and contains both current and history tables. Data model is divided in number of sub models for teh ease of understanding and comprehension.
• Reviewed teh model wif application developers, ETL Team, DBAs and testing team to provide information about teh data model and business requirements.
• Worked wif ETL to create source to target mappings (S2T).
• Had brain storming sessions wif application developers and DBAs to discuss about various denormalization, partitioning and indexing schemes for physical model
• Worked on Requirements Traceability Matrix to trace teh business requirements back to logical model.
• Generated DDL scripts.
• Created source to target mapping document.
• Worked and extracted data from various database sources like DB2, VSAM and Flat files.
• Worked wif client and off shore team to make sure dat teh deliverables are on time.

Environment: DB2, EMBARCADERO ER Studio, Oracle 11g, VISIO, MS-Office, INFORMATICA, SQL

Confidential, CA

Data Analyst / Modeler

Roles and Responsibilities:

• Participated in different phases of projects starting from Business Walk through for requirements gathering, business analysis, Design, Coding Testing and project coordination.
• Worked wif teh Business analyst for requirements gathering, business process analysis and project coordination.
• Extensively used Agile methodology as teh Organization Standard to implement teh data Models.
• Resolved teh revolving issues by conducting and participating in JAD sessions wif teh users, modelers, and developers.
• Conducted design discussions and meetings to come out wif teh appropriate data mart.
• Experience in Data Transformation and Data Mapping from source to target database schemas and also data cleansing.
• Developed teh Star Schema for teh proposed warehouse model to meet teh requirements.
• Identified teh objects and relationships between teh objects to develop a logical model using ERWin and later translated teh model into physical model.
• Defined and processed teh facts and dimensions.
• Resolved teh data type inconsistencies between teh source systems and teh target system using teh Mapping Documents.
• Created documentation, worked wif users for new module implementation.
• Involved in assigning indexes.
• Created tables, views, sequences, triggers, tablespaces, constraints and generated DDL scripts for physical implementation.
• Created domains, which supports Target Database data types.
• Created Erwin template to support teh organization standards and Database standards.
• Determined data rules and conducted Logical and Physical design reviews wif business analysts, developers and DBAs.
• Created secure views to mask teh data.
• Redefined many attributes and relationships in teh reverse engineered model and cleansed unwanted table/columns as part of data analysis responsibility.

Environment: SQL, ERWIN r7.3, INFORMATICA, VISIO, Oracle, MS-Excel, PowerPoint, MS-Word.

Confidential

SME

Roles and Responsibilities:

• Involved in all phases of project and actively participated in Multiple Roles.
• Have Excellent Business Knowledge on TELECOM domain and played a key role as a SME in gathering requirements for EA-Services (Connection Applications) of Telecom Business.
• Gained good noledge on Deutsch Language in a very short span of time.
• Gatheird Business information from Walk through sessions and getting translated them from German Language to English.
• Created many Test Objectives and helped testers to execute them in different phases of Testing.
• Proactively involved in translating and understanding teh Business requirements from Deutsch Language to English
• Logged each defect in each phase and reported teh issues using PR-TOOL.
• Thoroughly analyzed Delta-COBOL programs and created teh specs.

Environment: ERwin, Oracle, Delta-COBOL, DBS (IMS-DB), DAS (IMS-DC), PR-TOOL. VISIO, MS-Excel, POWERPOINT, MS-Word.

Confidential

Sr. Mainframe Programmer

Roles and Responsibilities:

• Involved in various phases of project and actively participated in Multiple Roles.
• Got in depth Business Knowledge on RETAIL and BANKING domains and played a key role as a Team Lead.
• Worked in a Warehouse environment and worked wif ERWIN tool to create Models.
• Played significant role in Performance Tuning methodologies using DB2.
• TEMPEffectively implemented performance tuning methods and brought teh system thoughput from 4 hours 20 minutes to 4 minutes 49 seconds.
• Provided necessary noledge to teh Team on Database concepts.
• Involved in business analysis, Design, Coding Testing and project coordination.
• Created many Test Objectives and executed in different phases of Testing.
• Extensively worked on Credit Business and having good noledge on BANKING Domain.
• Performed significant role in Developing CICS programs wif scrolling logic.
• Developed Backend programs to send teh necessary information to teh approver to take decisions.
• Tested many Online Screen programs and Data in teh Databases (CICS and DB2)
• Played an important role as a Team Lead to make sure teh high Quality of teh product.

Environment: MAINFRAME (CICS, COBOL, DB2, Oracle, VSAM, JCL, EXPEDITOR, INTERTEST, INSYNC, FILE-AID, DATAMOVER, RUMBA, SPUFI, QMF, ERWIN, ROSCOE, REXX, OBIEE)

Confidential

Mainframe Consultant

Responsibilities:

• Involved in various phases of project and actively participated in Business Walkthroughs.
• Performed impact analysis on system jobs and created many procedures and control cards.
• Extensively worked on SORTING techniques.
• Created many reports using EZYTRIVE.
• Printed many reports in various locations by routing teh documents using JCLs.
• Performed significant role in Developing CICS programs.
• Created different screens using Macros (BMS)
• Created many control cards and copybooks as per teh requirements

Environment: MAINFRAME (CICS, COBOL, DB2, VSAM, JCL, EXPEDITOR, INTERTEST, INSYNC, FILE-AID, EZYTRIVE)

Confidential

Application Developer

Roles and Responsibilities:

• Involved in teh entire system study, analysis and design.
• Generated report and printed teh invoices on various printers using JCL.
• Created online screens for teh agents to receive orders for different items.
• Developed teh Database Maintenance System wif various COBOL/CICS/BMS programs to receive data from user entries and stores teh values in different tables in DB2.
• Involved in UNIT testing, Application Integration testing to validate teh data and handled teh performance issues efficiently.
• Involved in documenting teh entire technical process and Supported technical teams involved wif DB2 issues and operations.
• Involved in teh maintenance of teh database.

Environment: COBOL, DB2, JCL, SPUFI, QMF, ENDEVOR, INTERTEST, EXPEDITOR.