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 with emphasis on data analysis, Business analysis, Relational / dimensional modeling.
• Can effectively 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 with detailed description of logical entities and physical tables.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Extensive Experience working with business users/SMEs as well as senior management.
• Strong understanding of the 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 the data marts using the 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 the conceptual model and its conversion into the physical database design using Erwin.
• Good in Normalization (1NF, 2NF, 3NF) / Denormalization techniques for effective 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 the 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, HTML, XML DAS, 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, Jersey City, NJ

Data Modeler

Responsibilities:

• Identified different SOR's and the related entities and attributes.
• Worked closely with business users, dealers and third party vendors to understand the process and the requirements.
• Created different subject areas and created different entities as per the business needs
• Identified suitable classification words for the data coming from different sources.
• Identified the 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 the entities and attributes we created in integration layer.
• Analyzed the staging tables and their attribute properties to understand the data being populated from and identified suitable data types for the target attributes.
• Delivered model on time for mapping team and PDM team to proceed with.
• Working closely with and guide the 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, Princeton, NJ

Data Modeler

Responsibilities:

• Working directly with external clients in establishment of standardized interface format capable of transferring all regulatory required data into a central data warehouse that could be used to satisfy all regulatory reporting needs (annual statements, data calls).
• Under general direction, working closely with users, business analysts and team members to understand business requirements and the design of technical specification.
• Designed the strategic interface format in which all source systems will provide the source data
• Design and model the reporting data warehouse considering current and future reporting requirement
• Working closely with and guide the 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, Boston, MA

Data Modeler

Responsibilities:

• Working on interviewing business users to gather requirements and documenting the 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 the Table/Column names.
• Created alter scripts to support changes in the database.
• Created Indexes to improve the performance.
• Created constraints and table spaces.
• Automated use of data naming standards by creating Erwin Macros.
• Created Master Abbreviations file.
• Documented formal standards and conventions.
• Delivered and published the models on time.
• Resolved the revolving issues by conducting and participating in JAD sessions with the users, architects, and developers.
• Conducted design discussions and meetings to come out with the appropriate data model.
• Extensively used Agile methodology as the Organization Standard to implement the 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

Responsibilities:

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

Data Analyst / Modeler

Responsibilities:

• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Participated in KAP sessions to gain knowledge on the applications assigned with the help of Confidential SME's.
• Played a major role in gathering documents and preparing SMTD document on the knowledge gained from SME's.
• Involved in Training sessions to provide all the business knowledge to the team members.
• Resolved the revolving issues by conducting and participating in different meetings with the 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 with the business and documented all that information.
• Succeeded in getting approvals from the Business Owners for those applications which were allocated to me.
• Gained in-depth knowledge on Accruals and Amortization process of the income department and created different subject areas and tables.
• Created the conceptual model for the data warehouse with emphasis on insurance (life and health), mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered.
• Analyzed large number of COBOL copybooks from multiple mainframe sources (16) to understand existing constraints, relationships and business rules from the legacy data.
• Worked on rationalizing the requirements across multiple product lines
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Created the logical model for the EDW with approximately 147 entities and 3668 attributes using ER Studio. The 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 the ease of understanding and comprehension.
• Reviewed the model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Worked with ETL to create source to target mappings (S2T).
• Had brain storming sessions with application developers and DBAs to discuss about various denormalization, partitioning and indexing schemes for physical model
• Worked on Requirements Traceability Matrix to trace the 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 with client and off shore team to make sure that the deliverables are on time.

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

Confidential, Woodland Hills, CA

Data Analyst / Modeler

Responsibilities:

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

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 knowledge on Deutsch Language in a very short span of time.
• Gathered 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 the Business requirements from Deutsch Language to English
• Logged each defect in each phase and reported the issues using PR-TOOL.
• Thoroughly analyzed Delta-COBOL programs and created the specs.

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

Confidential

Data Modeler/Mainframe Programmer

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 with ERWIN tool to create Models.
• Played significant role in Performance Tuning methodologies using DB2.
• Effectively implemented performance tuning methods and brought the system thoughput from 4 hours 20 minutes to 4 minutes 49 seconds.
• Provided necessary knowledge to the 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 knowledge on BANKING Domain.
• Performed significant role in Developing CICS programs with scrolling logic.
• Developed Backend programs to send the necessary information to the approver to take decisions.
• Tested many Online Screen programs and Data in the Databases (CICS and DB2)
• Played an important role as a Team Lead to make sure the high Quality of the 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 the documents using JCLs.
• Performed significant role in Developing CICS programs.
• Created different screens using Macros (BMS)
• Created many control cards and copybooks as per the requirements

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