CHRONOLOGICAL SUMMARY OF EXPERIENCE

Senior Data Analyst

Confidential

• Gathered requirements, analyzed and wrote the design documents.
• Queried the databases, wrote test validation scripts and performed the System testing.
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Responsible for defining the key identifiers for each mapping/interface.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Extensively involved in Data Extraction, Transformation and Loading ETL process from Source to target systems using Informatica Power Center 8.1
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Reverse engineered all the Source Database's using Erwin.
• Worked with internal architects in the development of current and target state data architectures
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.

Environment: Oracle 10g/11g, Erwin, Informatica PowerCenter 8.1, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, Crystal Reports, PowerPoint 2007.

Senior Data Modeler/Analyst

Confidential

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, and Power Designer Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Normalized the database to put them into the 3NF of the data warehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Defined relationships, cardinalities among entities.
• Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.

Environment: ER Studio 7.1.1, Quest Central for DB2 v 4.8, Mainframe DB2, Mercury Quality Center 9, Informatica PowerCenter 8.1

Sr. Data Modeler/ Analyst

Confidential

• Interacted with Business analysts and SMEs to gather the user requirements and participated in data modeling JAD sessions.
• Performed data analysis and profiling of source data to better understand the source systems.
• Created 3NF business area data modeling with normalized physical implementation data and information requirements analysis.
• Created E/R Diagrams, Data Flow Diagrams, grouped and created the tables, validated the data, identified lookup tables.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of the Source Data Analysis responsibilities.
• Performed legacy application data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing and data synchronization.
• Developed the data warehouse model Kimball's with multiple data marts with conformed dimensions for the proposed central model of the Project.
• Defined naming standards and extensively used Complete-Compare.
• Implemented Star Schema methodologies in modeling and designing the logical data model into Dimensional Models.
• Conducted design sessions with Business Analysts and ETL developers to come up with a design that satisfies the organization's requirements.
• Worked with Database Administrators DBAs to finalize the physical properties of the tables such as Partition key, based on volumetric.
• Member of Data model and Design Review group that oversees data model changes and system design across Enterprise Data Warehouse.

Environment: Erwin 7.3, Informatica Power Center 8.6, PL/SQL, Oracle 10g/ 9i, DB2 7.1, OBIEE, Crystal Reports 2011, SQL Server 2005/2008, XML, Visio, ClearQuest.

Data Modeler / Analyst

Confidential

• Worked with Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications.
• Extensively involved in developing logical and physical data models that fit in exactly for the current state and the future state data elements and data flows using Erwin
• Defined the key columns for the Dimension and Fact tables of both the warehouse and Data Mart
• Interacted with the end users frequently and transferred the knowledge to them
• Conducted and participated JAD sessions with the Project managers, Business Analysis Team, Finance and development teams to gather, analyze and document the Business and reporting requirements.
• Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and naming Standards.
• Conducted design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions Conformed .
• Created and maintained Logical Data Model LDM for the project.
• Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LPDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Conducted 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.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process
• Explained and guided Front end Developing team on the database architecture and built objects for effectively accessing the database.
• Maintain change log and history tables for each data model and solved the production issues by debugging the code.
• Performed data validation and Unit Testing before handing over the data for production and Quality Testing.

Environment: Oracle 10g, PL/SQL, Erwin 8, Microsoft Excel, MS Word, Power Point, TOAD, SQL developer, XML, and Microsoft Visio.

Data Modeler / Analyst

Confidential

• Interacted with users and business analysts to gather requirements.
• Engaged in business process modeling using UML through Rational Rose.
• Produced Logical /Physical Data Models.
• Created the calculations based on the reporting needs and the source data available
• Recognized source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
• Created Data Migration and Cleansing rules for the Integration Architecture OLTP, ODS, DW .
• Formed data mapping documents between Legacy and User Interface Systems.
• Worked with ETL team to produce PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Worked with testing team to performed UAT on the application.

Environment: Erwin, Informatica, DB2 UDB, SQL Server, Oracle, Toad for Oracle, Windows NT, Linux.

Data Modeler

Confidential

• Gathered and transferred business and functional requirements.
• Interacted with business users and studied available documents/application to understand the requirements.
• Worked with large sets of data to find rate flow trends and patterns, identify and fix data anomalies
• Used Erwin r7.0 for creating tables using Forward Engineering
• Designed the prototype of the Data mart and documented possible outcome from it for end-user.
• Involved in business process modeling using UML
• Developed and maintained data dictionary to create metadata reports.
• Identified facts and dimensions and designed the Star Schema.
• Designed logical/ physical model using Erwin data modeler for SQL Server database platform.
• Cleansed, extracted and analyzed business data on daily basis and prepared ad-hoc analytical reports using Excel and T-SQL
• Done SQL Server configuration database size estimation, database creation logins user's Creation, granting object level permission, estimation of indexes on tables.
• Helped ETL team in understanding the complex transformation rules and creating ETL maps.
• Developed Data Mapping, Data Governance, and Transformation and Cleansing rules.
• Involved with reporting team to generate ad-hoc reports using Crystal Reports 9.
• Worked closely with Data Quality team in the process of testing.

Environment: Erwin r7, SQL Server 2000/2005, Windows NT, MS Visio, XML, Informatica, Crystal Reports 9.

Data Modeler

Confidential

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks
• Created a logical design and physical design in Erwin.
• Maintained security and data integrity of the database
• Identified the business function activities and processes, data attributes, and table metadata, and documented detailed design specifications
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL Plus, SQL Loader and Handled Exceptions.
• Run batch jobs for loading database tables from Flat Files using SQL Loader.
• Extensively used Erwin for developing data model using star schema methodologies.
• Created Entity relationship diagrams ERD , Function relationship diagrams FRD , data flow diagrams DFD and enforced all referential integrity constraints using Erwin.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Good knowledge and experience on Global Custody operations, capital markets, securities services, vendor management operations, trade finance, trade settlements, income processing, tax, corporate actions, market claims and reconciliations, NAV generations.

Environment: Oracle 8i, SQL, PL/SQL, Erwin, SQL Loader, Perl, TOAD and UNIX.