SUMMARY

• Skilled I.T. professional with 9+ years expertise in Data Modeling, Dimensional and Relational Modeling, Data Analysis and design, Data Management, Data Warehousing, Metadata, Data Transformation and Master data (reference data) managementand Business intelligence tools.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Dimensional Data Modeling, Building Star/Snowflake schemas, OLAP tools.
• Dimensional Data Modeling and Relational Data modeling using ER/Studio, Erwin, Infosphere Data Architect, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling.
• Experienced in Normalization/DE normalization techniques for optimum performance in OLTP and OLAP environments.
• Highly proficient inData Modelingretaining concepts ofRDBMS,Logical andPhysical Data Modelinguntil3NormalForm (3NF)with Complete knowledge of Data warehouse methodologies (RalphKimball, BillInman),ODS,EDWandMetadatarepository.
• Expert in theData Analysis,Design,Development,ImplementationandTestingusingData Conversions, Extraction, Transformation and Loading (ETL) andSQL Server,ORACLEand other relational and non - relational databases. ExpertisewithTOAD 9x/8x, SQL server management studiofor Database interactions and manipulations.
• Experience in the Oracle development tool set (Including PL/SQL, SQL*Plus, SQL Loader).
• Experience in creating data definition and metadata repositories.Participated in physical implementation (partitioning, cluster, indexing, etc.)
• PerformedData cleansingandData profiling for detecting and correcting inaccurate data from the databases andto track data quality and to assess the risk involved in integrating data for new applications.
• Excellent understanding and working experience of industry standard methodologies likeSystem Development Life Cycle (SDLC), as per(RUP), AGILEandWaterfall Methodologies.
• Worked with various RDBMS like Oracle 11g, SQL 2008, and DB2.
• Proficient in creating Conceptual, Logical and Physical Data models as per the client project requirements.
• Hand on ETL tools like Informatica and Data Stage; Created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input.
• Worked with ETL Team to load sequential files (flat files, text files, CSV files) in data stage
• Worked on Implementing the Slowly Changing Dimension in Data stage.
• Successfully managed technical teams and gained broad expertise in mission and requirement’s analysis and process modeling (JAD) structured development methodologies.
• Excellent analytical skills and problem solving techniques as a data modeler.
• Experience with gathering business requirement and requirements analysis.
• Extensive experience in analyzing and documenting business requirements and working with business analysts.
• Proficient in developing varies levels of documentation: Context Diagram, Process Diagram, Decomposition Diagram, Data Flow Diagram, Data Exchange Diagram, Data Mapping Matrixes, and other
• Involved in creating Enterprise data dictionary and data standards to ensure data quality and consistency.
• Expertise in ER Studio Upgrades to the latest versions and involved in all the testing, implementation, administration tasks, keeping control of all the models, backups, check in check out, facilitate users to ER Studio related issues and provide the solutions, extensively involved in resolving all the issues and providing solutions to the users.

TECHNICAL SKILLS

Data Modeling: ER Studio 16.0.3, ER Studio 11.0,ER/Studio 9.0.1/7.6.1/7.5.1/7.0 , Erwin 7x/6x/5x, ESP.

ETL Tools: Informatics - Power Center 8x/7x/6x/5x, SQL Server Integration Services, Data Stage 7.5.1.

Programming Skills: SQL, PL/SQL,JCL,Transact SQL,Shell Scripting, C++, Java

Operating Systems: Win 95/NT/98/2000/XP, LINUX, HP-UX, MS-DOS

Other Tools: Toad 7.4/7.3,TSO,Microsoft Office, Microsoft Visio, Microsoft Excel, Tortoise SVN .

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr. Data Modeler/Analyst

Responsibilities:

• Working to support the ESP (Enterprise Servicing Platform) Product which is the client’s in-house product that incorporates multiple functionalities like Data Consumption, Normalization, Data Control, Monitoring and Data management, used by Confidential as a repository for storing data from its multiple lines of business.
• Working in ESP core team for enhancement and project support which is aimed to design, develop and implement data sourcing solutions for its LOBs based on each business / application requirement.
• Working to fulfil the client reporting requirements and made product also available the data for reporting needs for each business and application.
• Conducted JAD Sessions with business analyst and application teams to analyze requirements for data storage for new applications within ESP.
• Leverage the ESP functionality to creating the Meta Models to support the business requirements.
• Helping in tuning the marts and improving query performance by analyzing the ESP Queries
• Front End and backend support to outside clients and internal teams by analyzing the end to end flow from UI Categories, Feeds, marts, extracts, and analyzing the Unix logs, process, real time tagging, chaining etc. to provide the solution.
• Support existing data load processes and batches and also support business users with queries and clarifications.
• Design, develop and unit Test ESP Objects, data load process into the objects and reporting queries for new LOB/Applications.
• Data Hub Inbound-Data from source system would be received by ESP in this layer. Here the data could be received in Batch and Real time through different data channels (SFTP,
• MQ etc.) and of different file formats (Delimited, Excel, XML, JSON etc.) and core support Loading data received from source system into ESP data store (a.k.a Data Category) using the feed mapping rules defined and stored in ESP feed repository.
• Excellent understanding and working experience in AGILEMethodologies.
• Designed various marts (Spot Mart, Merge Mart, Sql Mart, Transpose Mart, snapshot Mart etc.) based on the business needs and made the data available historically and point in time (Data Category and Data Mart) based on the ASOF and ASAT details requested by the end user/data consumption layer (ESP Extracts, Interactive Views, IRD Reports, ODBC etc.).

Environment: ESP, Oracle11G, UNIX, XML, Autosys Jobs, Flat Files, Squirrel SQL Client 3.3.0.

Confidential, Newark, NJ .

Sr. Data Modeler

Responsibilities:

• Data Modeler/Analyst in HDH team and responsible for conceptual, Logical and physical modeling.
• Responsible for maintaining all the physical model across all the applications in different environment. (Oracle, Teradata, Db2)
• Studied in-house requirements for the Data warehouse to be developed.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Developed aConceptual modeland got it run through business and IT folks.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Maintained warehouse metadata, naming standards for future application development.
• Designed Data models to typically implement Attribution, Members, Group/Subgroup and claims and PI Finance.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 andSQL Serverdatabase systems.
• Generated DDL’s and created the tables and views in the corresponding architectural layers.
• Extensively made use ofCompressor, Table Spaces,Indexes, Sequences, Materialized Views, Procedures and Packages in Data Models.
• Developed Source to Target Matrix with ETL transformation logicfor ETL team
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting and data mining solutions.
• Worked On Multiple Key Projects for supporting HDH, IDS and semantic layer.
• Managed the meta-data for the Subject Area models for the Data Warehouse environment. Highly involved in maintaining the Data Dictionaries for all the models across enterprise.
• Worked Extensively with DBA and Reporting team for Improving the Report Performance with the Use of appropriate indexes and Partitioning.
• Worked on Data Modeling Standardization Process across enterprise and created multiple documents related to the Data Modeling. Extensively worked for cleaning up the repository and come up with the cleaner versions of the repository models.
• Primarily responsible for ER Studio tool upgrade to all the higher versions in past 2 years, involved in end to end process to upgrade and handling all the administrative work and facilitating users to all the problems and features to the tools, educating them about repository, Team server and other features and make them use appropriately.
• Maintaining the naming standard files across the enterprise and defining all the new abbreviations as industry standard.
• Highly involved in creating the documents (Mapping Documents, Any New process guidelines, Installation documents etc.)
• Extensively used the SVN and help Developers creating Tags as per the releases in all the layers, DEV, SIT, UAT, PROD and keeping consistency across the environments.

Environment: SQL Server 2008, SQL Server 2012, Teradata 14.0, ERStudio 16.0.3,11, 9.0,9.0.1 Oracle 11, XML, Flat Files, SSIS, SSRS, SSAS, Cognos.

Confidential

Data Modeler

Responsibilities:

• Data Modeler/Analyst in Data Architecture Team and responsible for Conceptual, Logical and Physical model for Supply Chain Project.
• Working on Multiple projects for supply Chain Project (Pallet Trend, Carrier, Vendor, DOM and Purchase Order.
• Doing extensive data Profiling, Data Analysis and Data Modeling.
• Analyze the OLTP Source Systems and Operational Data Store and research the tables/entities required for the project. Designing the measures, dimensions and facts matrix document for the ease while designing.
• Analyzed the specifications and identified the source data from disparate data sources likeOracle, MS SQL Server,DB2(AS400),flat files, COBOL filesandidentified data that needs to be moved to data warehouse.
• Building the Foundation layer in third normal form and bringing all subject areas of Supply chain using ERWIN in Teradata Database.
• Building Reporting layer on top of foundation layer for Quantisense, netezza, microstartegy etc. in Kognitio.
• Gathered Business requirements by organizing and managing meetings with business stake
• Organized and managed meetings with Technical Assistants (TA’s), Data Stewards, and Subject Matter Experts (SME’s) for the requirements gathering.
• Developed Source to Target mappings for ETL support.
• Conductedfrequentmeetingswiththe ETL coding and development team from Cognizantto co-ordinate the process and to efficiently organize and distribute the workflow among the team.
• Developed and maintained the data dictionaries, Naming Conventions, Standards, and Class Words Standards Document.
• Validate the models with the production data and developed the STT (Source to Target) mapping matrix, an expert solution to design and develop the mappings for the loading of data, to the ETL developers.
• Collaborated with DBAs to ensure that any business issues, rules or concepts are reflected on the physical database design.
• Analyzed the forecasting of data for future application growth and worked and worked with DBA’s to come up with the necessary space.
• Data from the Mainframes/Legacy systems were analyzed and profiled to be made sure of the integrity before they were brought into the oracle system.

Environment: ERWIN 9.0, Informatica Power Center 8.6/8.5.6, Oracle 11g, COBOL, Teradata14.01, Teradata SQL Assistant, Kognitio Console, MS SQL Server, DB2, Flat files, SQL/PL SQL, Amdocs, UNIX Shell Script, TOAD 9.7.2.

Confidential, Newark, NJ

Data Modeler/Analyst

Responsibilities:

• Data Modeler/Analyst in Data Strategy and Management team and responsible for conceptual, Logical and physical models for Member Enrollment/Groups/Billing
• Involved ingathering complete requirements byorganizing and managing meetings with Business Analysts (BA’s), Technical Assistants (TA’s), Data Stewards, and Subject Matter Experts (SME’s)on a regular basis.
• Analyze the OLTP Source Systemsand Operational Data Store and research the tables/entities required for the project.
• Analyzed the specifications and identified the source data from disparate data sources likeOracle, MS SQL Server,DB2,flat files, COBOL filesandAmdocsensemble billing system that needs to be moved to data warehouse.
• Create the data results through techniques and tools such as basicSQL queries, data mining, and multidimensional analysis.
• Analysis offunctional and non-functionalcategorized data elements for dataprofiling and mapping from source to target data environment.Developed working documents to support findings and assign specific tasks.
• Worked as Administrator for ER Studio Tool.
• Core Support for the DAL (Data Access Layer) and the IDS (Integrated Data Store) teams.
• Worked on Canonical Data Model (XSD and XML) for the outbound teams who were consuming Data from Data Access Layer.
• Working on multiple projects with different business units on logical data and Physical data models for Enrollment/Groups/Billing and ensured the feasibility of the logical and physical design models.
• Gather the various reporting requirement from the business analysts, participated in JAD sessions involving the discussion of various reporting needs.
• Extensively working on Analysis from source perspective, working with web services/portal teams, downstream teams to leverage the data into various models which is coming from all these different applications.
• Involve in Affinity analysis to identify the gaps between the data coming from different applications and existing model and sources.
• Maintaining mapping documents, LOV documents and all other related Critical documents from the Affinity analysis.
• Model updates based on the gaps and clarification from the business.
• Conducting discussions and meetings with the Business I.T SME'S to validate the models with the business knowledge and Use Cases.
• Modeling the future state of the business in the relational form.
• Conducting Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Worked with the implementation team to let them understand the relationship and flow of data from the model so that they can load the data and get their reporting and mapping done also to ensure a smooth transition from the design to the implementation phase.
• Created and MaintainedEnterprise Data Dictionaryfor reusable objects like domains, attachments, defaults, reference values, data types and reusable procedural logic.
• Worked on specifications given by theData governance teamand Data quality team that required managing the master data from all the business units and ensuring data quality across the enterprise.
• Worked on STM, LOV mapping and also involved in overlay sessions from the various teams dealing with different sources to enhance the scope of the model.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to in corporate the new calculations.

Environment: SQL Server 2008, ERStudio 9.0, SQL, Oracle 11, XML, Flat Files, SSIS, SSRS, SSAS, Cognos.

Confidential, Minneapolis, MN

Data Modeler/Analyst

Responsibilities:

• Involved in facilitating work sessions and gathering requirements from business users.
• Developed, documented and maintained logical and physicaldata models for development projects.
• Designed Data models to typically implement fixed income portfolios, Credit card Accounts and general banking
• Identified the facts and dimensions and designed star schema model for generating reports.
• Maintained warehouse metadata, naming standards for future application development.
• Used Advance Data Modelling Concepts like Multi valued dimensions, Conform Dimensions and facts, Bus Matrix Architecture, Family of stars to handle various complex situations.
• Extensively made use of Triggers, Table Spaces, Pre/Post SQL, Sequences, Materialized Views, Procedures and Packages in Data Models.
• Implemented dimension model (logical and physical data modeling) in the existing architecture using IBM Infosphere Architect tool. Identified the existing dimensional objects and created new dimensional objects.
• Worked with the BI teams to share the dimensional models via Infosphere Architect tool.
• Developed Source to Target Matrix with ETL transformation logic for ETL team.

Environment: IDA7.5, Oracle 10g, SQL SERVER 2008, Flat Files, TOAD, Informatica Power Center 8.6

Confidential

Data Analyst

Responsibilities:

• Created SQL tables and developed queries using SQL, SQL*PLUS and PL/SQL
• Involved in testing the database for queries that were generated,
• Used oracle designer for generating forms and reports
• Created, and modified complex Oracle Forms, and scripts
• Worked closely with business decision makers and end users
• Involved in analysis, design and study of entire system, and handle the performance issues
• Assisted in analysis and recommendations on which Reporting tool to use
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Performing application development tasks as necessary, following development standards
• Evaluated new development tools, and methodologies and recommended solutions
• Identifying the impact of development requests on other application functionality

Environment: Oracle, SQL Server 2005, UNIX, Erwin 4.0, Crystal Reports