SUMMARY

• 8+years of IT experience in the field of Data/Business analysis, ETL Development, Data Modelling, and Data Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Data governance and Metadata Management, Master Data Management and Configuration Management.
• Over 3 years of experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Embarcadero.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge in Business Intelligence tools like Business Objects, Cognos, SAS, Tableau and OBIEE
• Experience with Teradata as the target for the data marts, worked with BTEQ, Fast Load and MultiLoad.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Multi-table queries, Source to Target mappings, SQL Joins.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project's exposure to the forces of change
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Extracted data from the Data mart and reconciled with online data and several different Custom Calculated Values using VBA in MS excel and extensively used Vlookups, filters, and pivot tables.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Worked on different platforms such as Windows 95/windows/98/NT and UNIX, Tableau, Sun Solaris, AIX, HP.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Experience in creating functional/technical specifications, data design documents based on the requirements.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Databases: Oracle 11g/10g, SQL Server 2000/2005, MS Access

Database Tools: SQL*PLUS, SQL*Loader, SQL Developer, TOAD 9.5

Data Modelling Tools: OBIEE, Crystal Reports 8.0/9.0/10

Reporting Tools: ERWIN, ER Studio, MS Visio 2003

ETL Tools: Informatica Power Center 8.x, 7.1.x

Languages: Pro*C, JAVA, COBOL, SQL, PL/SQL, T-SQL, UNIX Shell Scripting,PERL

Testing Tools: WinRunner, LoadRunner, QTP, Rational Clear Quest

Version Control: Sub Version, PVCS, CVS, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr. Data Analyst

Responsibilities:

• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the trumping rules applied by Master Data Repository.
• Define the list codes and code conversions between the source systems and MDR.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Liaising with end-users and 3rd party suppliers. Analyzing raw data, drawing conclusions & developing recommendations Writing SQL scripts to manipulate data for data loads and extracts.
• Applied Master Data Management standards in data conversion, mapping and migration.
• Developing data analytical databases from complex financial source data. Performing daily system checks.
• Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.
• Worked on creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data
• Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements.
• Involved in defining the source to target data mappings, business rules, and business and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, 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.
• Developed Qlikview Dashboards using different Chart, List, Input Field, Table Box, etc.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Document data quality and traceability documents for each source interface.
• Modified existing reports using QlikView.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Involved in Data warehouse and Data mart design.
• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll and Benefits modules
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and, assisting in the development of current and target state data architectures.

Environment: Oracle 11gr2, MS SQL Developer, Microsoft Office Suite 2010, MS Visio, DB2, Erwin, Windows 7, JIRA, PeopleSoft HCM, PeopleTools, HR, Payroll, Benefits, QlikView.

Confidential, Madison, WI

Sr. Data Analyst

Responsibilities:

• Reviewed requirements together with QA Manager, ETL leads to enhancing thedatawarehouse for the originations systems and servicing systems.
• Design discussions and meetings with thedataarchitects to come out with the appropriate design for thedatawarehouse.
• Identified, organized, and documented the changing requirements of the project.
• Extensively involved in the Physical/logical modeling and development of ReportingDataWarehousing System.
• Documented requirements in Power Designer V16 /V15, Erwin and created Requirements Traceability Matrices (RTMs).
• Created fully fledged Source to Target Mapping documents (S2T), documented business and transformation rules.
• Worked on differentdataformats such as Flat files, SQL files, Databases, XML schema, CSV files.
• Attended JAD sessions withDataArchitects to build up subject area specific models.
• Working with otherDataanalystsand Infoanalystsfor each subject area.
• Conducted internal and final DFD reviews with the ETL team (EIS),DataQuality, Metadata Management team,dataarchitects, and business and applicationdatastewards.
• Developed on overall project plan and implementation schedule through consultations with project team, management, employees and external consultants.
• Delivered advanced and complex-reporting solutions such as Dashboards and Standardized Reporting using QlikView
• Involved in project cycle plan for thedatawarehouse, sourcedataanalysis,dataextraction process, transformation and ETL loading strategy designing.
• Maintaining the Requirements Traceability Matrix (RTM) across the deliverables of a project
• Supported QA/ETL teams in ensuring proper implementation of the requirements and developed and executed test plans and test scripts for testing and UAT (User Acceptance Testing).

Environment: Power designer V16/ V15, Erwin, Teradata V14, Teradata SQL Assistant,Oracle10g, SQL Server 2005/2008, Mainframes, TOAD, XML, ClearQuest, QlikView.

Confidential, Reston, VA

Data Analyst/ Business Analyst

Responsibilities:

• Documenting gathered Business Requirements from Business users, Stake Holders and SME's.
• Training and mentoring team to ensure tasks are completed on time.
• Organized internal meetings with team members to ensure to meet the requirements.
• Extensively worked on Source to Target mapping for business need and documentation purpose.
• Wrote Test Scripts for various System Change Requests (SCR)
• Worked on writing and prioritizing User Stories, Test Scripts and Test Scenarios.
• Participating in MappingDataelements from existing proprietary EncounterDatarecord Layout
• Participated in validating and production implementation of various projects.
• As part ofDataMasking /DataPrivacy performing the Reverse engineering on theDataModel to identifying the Schemas based on requirements.
• Gathering the business requirements from the respective application team (DataArchitect's / Application Owner's).
• Reviewed requirements together with QA Manager, ETL leads to enhancing thedatawarehouse for the originations systems and servicing systems.
• Updating the existingdatamodels in all environments.
• Analyzing the Consistency across the DB's also Referential Integrity across the tables.

Environment: Agile, Oracle 10g, PL/SQL, SQL* Loader, TOAD 9.5, DB2, Crystal reports 9.1, Perl, Teradata, SQL Server 2005, SSIS, MSVisual Studio

Confidential, Moline, IL

Data Analyst

Responsibilities:

• Involved in interacting with the end-user (client) to gather business requirements.
• Participated in analyzing and modeling the requirements for the logical and physical design of the database using star schema and normalization techniques.
• Involved in Data Mining, Profiling and Data Modelling.
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Built re-usable mapplets using Informatica Designer.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Developed and modified mappings for Extraction, Staging, Slowly Changing Dimensions of Type1, Type2, Type3, Facts and Summary tables duly incorporating the changes to address the performance issues as stated in the Re-architecture specifications.
• Developed mappings for Slowly Changing Dimensions of Type1, Type2, Facts and Summary tables using all kinds of transformations.
• Worked on Informatica Power Center 7.1.1 - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Written PL/SQL Stored Procedures and Functions for Stored Procedure Transformation in Informatica.
• Define and represent Entities, Attributes and Joins between the entities.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Written UNIX shell scripts to automate loading files into database using crontab.
• Developing batch files to automate or schedule tasks.
• Support for the development, pre-production and the production databases.

Environment: Agile, Oracle 9i (SQL, PL/SQL), SQL*Loader, Oracle Forms, TOAD, HTML/DHTML, PRO*C, JavaScript, Windows NT/2000, Crystal Reports, Informatica Power Center 7.1.3, Erwin 4.0, UNIX.