• Worked on various Domains like Banking, Health Insurance, Pharmaceutical and Telecommunications.
• Worked with heterogeneous relational databases such as Oracle, SQL Server, and MS Access.
• Experience in the Data Analysis, Data Modeling, Data Mining, Data Mapping, Data Quality.
• Experience creating Business Requirements Document BRD , Functional Specifications Document FSD , Nonfunctional Requirements Document and Use Case Specifications.
• Experience in Requirement Analysis, JAD sessions, Business and Systems reviews and working sessions to understand the requirements and system design.
• Experience in implementing advanced ETL methodologies using Informatica Power Center 9.x/8.x/7.x
• Experience in performing Data Profiling using Informatica Developer and Informatica Analyst.
• Experience on writing, testing and implementation of SQL triggers, stored procedures, and functions using PL/SQL in Oracle 11g/10g/9i.
• Experience on writing, testing and implementing of SQL queries using advanced Analytical Functions.
• Experience in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience on building Reports and OLAP Cubes.
• Experience on managing data held in RDBMS by writing, testing and implementing SQL queries.
• Knowledge of DDL, DML, DCL, and DQ in RDBMS.
• Knowledge of complete Software Development Life Cycle SDLC , Software Testing Life Cycle STLC and Bug Life Cycle BLC .
• Have hands on experience in testing the ETL Informatica mappings and reports.
• Experience in handling various kind of files Flat file, XML, Database, Excel and more .
• Experienced in handling concurrent projects and providing expected results in the given timeline.
• Excellent communication, documentation and presentation skills.
• Very good team player and self-starter with ability to work independently.

Confidential

Responsibilities:

• Worked with business users to document current and future work flow processes and to identify, define and document process improvement options and alternatives, as directed by business needs.
• Articulated and presented business analysis results clearly and concisely to the technical team.
• Designed and developed Use Cases, Report Specifications and Business Process Modeling.
• Participated in testing, acceptance testing and implementation of information systems, modules and subsystems.
• Prepared data mapping and worked with business users to define and document business rules.
• Identified required information fields and developed data dictionary.
• Coordinated with business partners to gather as well as ensure all regulatory reporting needs are addressed through the documentation of high quality reports to be used by business for operational and executive level decision making.
• Planned and delivered requirements, communications and implementation specifics supporting Financial Regulatory Reporting.

Environment: Oracle 11g, SQL, PL/SQL, Cognos, MS Excel, MS Visio.

Confidential

Responsibilities:

• Worked in a team with Project Manager and other members in creating data model for different aspects.
• Produced functional decomposition and logical models into an enterprise data model.
• Designed conceptual and logical data models of Data Warehouse and tables for ETL Process.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Employed process and data analysis to model a Customer Information Business System.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams for ETL.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Developed and maintained sales reporting using MS Excel queries, SQL in Teradata, and MS Access.
• Produced functional decomposition diagrams and defined logical data model.
• Logical data model was developed using ER diagrams
• Created SQL tables with referential integrity and developed queries using SQL
• Wrote specifications for Web pages based on Use case analysis
• Conducted team meetings and JAD sessions
• Helped DBA in creating the physical database design and QA team in their testing
• Implemented the reporting sub system via Crystal Reports

Environment: Oracle 11g, Oracle Designer, Teradata, Windows NT, SQL, SQL developer, Teradata, MS Excel, Erwin, Informatica.

Confidential

Responsibilities:

• Worked in a team with Project Manager and other team members on client's site to identify the appropriate source of data for the Data Capture process.
• Understood the importance of HIPAA privacy rule in health industry and practice it on daily work.
• Designed and developed the schemas using Erwin for the captured data.
• Extensively used VLOOKUP, COUNTIF, COUNTIFS functions and created Pivot Tables in Microsoft Excel to analyze the data.
• Performed manual Data Validation using Data Quality matrix on Excel and writing SQL Queries.
• Performed cross check on Data Validation using Informatica Data Profiling.
• Performed Data Scoring of the validated data based on business rule of BCBS and submitted the report to the project manager.
• Involved on Data Transformation to meet organization requirement using Informatica PowerCenter.
• Performed data load using utility Oracle Pump import in Oracle 11g database.
• Maintained the trigger, function and stored procedure using PL/SQL.

Environment: Oracle 11g, Informatica, Erwin, SQL Developer, SQL, PL/SQL, Oracle Data Pump, MS Excel, MS Visio.

Confidential

Responsibilities:

• Involved in discussions to gather source information for different source system with Business team.
• Created Source to Target Mapping documents, documented business and transformation rules and participated in working sessions and ensured full business participation throughout the process.
• Determined business/functional requirements and created vision, scope, use case documents and business process models.
• Conducted JAD sessions throughout SDLC to resolve open issues.
• Created triggers, functions and stored procedures in T-SQL.
• Created numerous Reports using Oracle Report Building 11g and Pivot Table in Excel by getting data from Oracle.
• Worked with QA team to design test plan and test cases for User Acceptance Testing UAT .
• Involved in developing Informatica mappings/mapplets, sessions, workflows for data loads.
• Involved in importing and exporting XML files, and using XML Transformations in Informatica.
• Prepared Test plan, test case according to the Source to target mapping document.
• Performed Data Profiling and Data Quality on source to compare with list of valid values while mapping source to target and writing exception cases if necessary.
• Performed data migration by writing scripts.

Environment: Oracle 11g, Toad, SQL Developer, SQL Loader, Erwin, OLAP Cubes, Data Mapping, Data Profiling, Metadata, Informatica Power Center 9.x, Windows XP, MS Access, MS Excel.

Confidential

Responsibilities:

• Worked closely with the Project Manager in creating the process and completion of the technical artifacts needed for development.
• Extensively used Export and Import Utilities to move database objects.
• Extensively tested the ETL mappings which were developed to load data from Oracle and SQL Server sources into the Staging and Target Area.
• Verified and validated data modeling structure and E-R modeling with all related entities and relationship with each entity based on the rules using Erwin as per the business requirements.
• Intensive use of SQL within the Teradata platform.
• Created and modified views within Teradata for Business Analysts.
• Provided pseudo code for DQ and ETL developers.
• Performed back-end testing using SQL queries and analyzed the server performance on UNIX.
• Extensively used Informatica Debugger to validate maps and to gain troubleshooting information about data and error conditions.
• Worked closely with Risk Professionals to model Credit Risk valuation.
• Involved in Data Mining using SAS.
• Involved in creating SAS codes to export and import data in and out of SAS and database.
• Exposure to data warehouse data modeling and Data Flux.
• Exposure to Master Data Management MDM to define and manage non-transactional data entities.
• Interacted with client user personnel to ensure continuing adherence to requirements and user standards.
• Involved in data mining for fulfilling customer segmentation business requests and periodic report generation.
• Involved in formal review meetings with project teams and developers to report, demonstrate, prioritize and suggest resolution of issues discovered during testing
• Tested formulas for various loan, interest calculations, and currency conversions required for reporting purposes.
• Actively participated in System testing, integration testing and coordinated UAT with users.

Environment: Oracle 10g, SQL, UNIX Shell Scripting Informatica Power Center 8.6/8.1.1, Workflow Designer, Power center Designer, Repository Manager, XML, Metadata, MDM, Windows NT/2000/XP, Visio, Erwin 3.5, SAS.

Confidential

Responsibilities:

• Reviewed the business requirements and worked with business team for gaps found during the review.
• Created and executed SQL queries to perform Data Integrity testing on database, and to validate and test data using TOAD.
• Converted various SAS Datasets into tables for reporting after performing Data Validation
• Identified and tracked the changing dimensions/mini dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Performed extensive Data Validations against Data Warehouse.
• Extensively used Informatica Designer Tool's components such as source analyzer, transformation developer, mapping designer, mapplet designer, workflow manager and workflow monitor.
• Analyzed the data for the projects and performed the data profiling and data mapping for different sources.
• Documented Test Cases corresponding to business rules and other operating conditions.
• Carried out ETL Testing using Informatica.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Extensively worked on back-end using SQL Queries to validate the data in the database.
• Responsible for creating test data for testing environment.

Environment: Oracle, Sql Server, SSIS, Informatica 8.1, SQL Plus, PL/SQL, UNIX Shell Scripting, TOAD, SAS.