SUMMARY

• 6 years of Database Analyst of experience on source to target mapping, gathering business requirements from business/user, creating source to target mapping document, creating process flows, and DFD. Working with ETL team for data extraction, DQ team for validation.
• Worked on various Domains like Banking, Financial, Parma and Telecommunications.
• Excellent understanding of Data warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, CDC, Normalization/De-Normalization, Dimension & Fact tables.
• Strong working experience in the Data Analysis, Data Quality and Validation of an ETL Applications using Backend/Database Testing.
• Worked with heterogeneous relational databases such as Teradata Oracle, MS Access and SQL Server
• Experience in working third party tools like WinSQL and TOAD.
• Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
• Experience in Data Profiling, Data cleansing, and Data mapping.
• Involved in preparation of Test Cases based on High level requirements and make an ensure detailed/system level process wrote Test Scripts
• Involved in preparation of Test data to test the functionality of ETL Sources Mappings and Targets.
• Have hands on experience in testing the ETL (Informatica) mappings and BO reports.
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases.
• Experience in maintaining support documents, Test Plans, QA Sign off Documents and Maintaining Weekly Status Reports.
• Experienced in handling concurrent projects and providing expected results in the given timeline.
• Excellent communication, documentation and presentation skills.

TECHNICAL SKILLS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, Logical Data Physical Modeling, Erwin r7.2/3/4, Sybase Power Designer.

Databases: Oracle 11g, 10i 9i/8i, SQL Server 2008/20052000 , DB2, TeraData 12, MS Access 2007.

BI: Business objects

ETL: Abinitio, Informatica Power Center 8.X/7.x/6.2

Tools: WinSQL, TOAD, Autosys, Teradata SQL Assistant, Remedy, ClearQuest, Quality Center

Environment: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3,Sun Solaris7, WinNT4.0

PROFESSIONAL EXPERIENCE

Confidential, Chicago, ILL

Data analyst/Database Tester

Responsibilities:

• Involved in requirement gatherings with Business team.
• Involved in discussions to gather source information for different source system.
• Created Source to Target Mapping documents, documented business and transformation rules and participated in working sessions and ensured full business participation throughout the process.
• Created DFD (Data Functional Design) artifacts that incorporated the process flow visios, S-T Mapping document and all the specifications for proper ETL implementation.
• Involved in creating the test strategy.
• Prepared Test plan, test case according to the Source to target mapping document
• Tested the FSDs and ETL mapping which were developed to load from different source systems in the Teradata Staging /Target areas.
• Validated the data between the Soure to Staging and Staging to Target using the Source to target mapping document as reference.
• Performing own Data profiling on source to compare with list of valid values while mapping source to target and writing exception cases if necessary.
• Helped the Infrastructure team in loading the XML’s generated by the Informatica into the ALGO Limit management system.
• Tested the data using the Logs generated after loading the data in to LMT.
• Worked on GAP analysis for missing requirements.
• Involved in Functional Testing of the LMT project.
• Tested the BO reports generate by the BO team using ACR (ALGO) as a source.
• Prepared Traceability Matrix with requirements versus test cases.
• Conducted internal and final DFD reviews with the ETL team (EIS), Data Quality and Metadata Management team, data architects, and business and application data stewards.
• Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre this involved Bug life cycle.
• Supported various leading vendor solutions for financial Risk based management solutions such as Algorithmic LMS and Moody’s Fermat RWA applications

Environment: Erwin, Teradata, Oracle, Abinitio, Abinitio EMEM Data Profiler, Informatica Power Center 8.6, Business Objects XI R3.1, Teradata SQL Assistant, Oracle, Toad, Windows XP, Share Point, Quality Center, MS Access, MS Excel, SharePoint Portal.

Confidential, Maine

Data analyst

Responsibilities:

• Worked closely with the Project Manager in creating the process swim lane and also estimates for completion of the technical artifacts needed for development.
• Attended JAD working sessions with Data Architects to build up subject area specific models.
• Extensively tested the ETL mappings which were developed to load data from Oracle and SQL Server sources into the Oracle Staging/Target Area
• Verified and validated data model 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.
• Worked in the implementation of loan and risk management system applications.
• Worked closely in conjunction with business (SME’s) and application data stewards to get business responses and source-to-target mapping clarifications.
• Provided pseudo code for DQ and ETL developers.
• UsedSQLto verify the data from theOracleand MS SQL Server databases.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Tested mappings and SQL queries in transformations such asExpression transformation, Filtertransformation, Lookup transformation, Joiner transformation, XML transformation, Aggregator transformation, and Update strategy transformation.
• Extensively usedInformatica Debuggerto validate maps and to gain troubleshooting information about data and error conditions.
• Interacted with client user personnel to ensure continuing adherence to requirements and user standards.
• 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 inSystem testing,integration testingand coordinated UAT with users.

Environment: Informatica Power Center 8.6/8.1.1, Workflow Designer, Power center Designer, Repository Manager, COGNOS Power play 6.6, XML,SQL server 2008, DB2, Oracle 9i, SQL,PL/SQL, SQL Loader, UNIX Shell Scripting, Windows NT/2000/XP, Visio, Erwin 3.5.

Confidential, Thousand Oaks, CA

Data Analyst/ETL Tester

Responsibilities:

• Reviewing the business requirements and working with business and requirements team for gaps found during the review.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Identified and tracked the slowly 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 various 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, data mapping for different sources.
• Writing the test scenarios based on business requirements and Business use cases
• Developed a detailed Test Plan & Test strategy based on Business requirements specifications writing and execution of Test cases.
• 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.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions.
• 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 Backend using SQL Queries to validate the data in the database.
• Responsible for creating test data for testing environment.

Environment: Test Director, Informatica 8.1/7.1.4, SQL, PL/SQL, UNIX Shell Scripting, Autosys, MS SQL Server 2005, TOAD, XML, XSLT, XSD

Confidential, Atlanta GA

Data Analyst

Responsibilities:

• Followed Rational Unified Process (RUP) methodology for creating artifacts.
• Conducted Interviews, brainstorming and Question and Answer sessions to identify requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Facilitated (JAD) Joint Application Development sessions to resolve issues relating to difference between business requirements and technical design.
• Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non Functional Requirements.
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using Visio.
• Created and maintained Data Dictionary and pursued to reach consensus.
• Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.
• Provided primary liaison between business/operations/vendors and development
• Created data models and data flow diagrams for the to-be process.
• Researched upstream data sources and ensured its owners attested all source data sources.
• Created report specifications containing mapping to source data sources.
• Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Created and executed SQL queries (using Rapid SQL and MS Access) and scripts to validate data movement and generate expected results for UAT.
• Conducted UAT to verify whether all the Requirements were catered to by the application.
• Used Rational Test Manager for Test Case Management and Rational ClearQuest for defect tracking and resolution.
• Worked with the developers on resolving the reported bugs and various technical issues.
• Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

Environment: Oracle 10g, SQL, Rapid SQL, OLTP, TOAD, MS Access, MVS, Requisite Pro, Clear Quest, UNIX and Windows.