SUMMARY:

• Over 8+ years of IT experience in the analysis, design, development, testing and implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Worked on EDI transactions, HIPAA standard transaction codes including EDI 837, 835, and performed analysis and testing of such transaction.
• Experience in testing Business Report developed in Business Objects XIR2.
• Experience in Education, Financial, Banking and Insurance industries.
• Extensive testing ETL experience using Informatica 8.x/7.x/6.x/5.x (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Experience with includes OTC derivatives, structured products, cash derivatives, Mortgage-backed securities including TBA's, FX derivatives, FX swaps, Equity options, Interest Rate derivatives, Inflation Swaps.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in HP Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology.
• Proficient experience in different Databases like Oracle, SQL Server, and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Application Data warehousing experience in Banking, Finance and Insurance.
• Performed Unit, Integration and System Testing.
• Expert knowledge in UNIX shells scripting (Korn shell/Bourne shell).
• Good analytical and problem solving skills.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
• Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

• SQL Server 2000/2005/ 2008
• MS Access, Oracle 9i, 10g, PL/SQL
• Windows (XP/2000/NT/98/95)
• UNIX (Solaris2.8, Linux7.2/8.0)
• T - SQL, HTML, C#, ASP.Net, PL/SQL
• SAP Business Objects Business Intelligence 4.1 SP05
• XIR2, Cognos 8.0
• EDI
• Quality Center v10 / Application Lifecycle Management v12
• Quick Test Pro
• SSIS, Data Stage 8.x/7.x
• Informatica Power Center8.x/7.x/6.x

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

• Analyze and understand the requirement. Create a design document for overall projects. Review the design document with user before coordinating with stakeholder. .
• Extensively used Agile Methodology in the process of the project management based on SDLC.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Work with business analysts to analyze and debug data issues. Use Excel and functions for data validation and cleansing.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Gathered and documented Business Requirements, created Functional specifications and translated them into Software Requirement Specifications.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Prepared test Data sets and performed data testing using the SQL query. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Designed and developed project document templates based on SDLC methodology
• Analyze and understand the monthly process of Stryker forecast. Provide the expert judgment, rather than numerical analysis and create a plan for customer service and supply planning team.
• Use the reginal forecast data beside customer and improve the accuracy of the future demand and sales team.
• Result of better forecast is to improve less orders manually, Quantify into dollars, improve the time and back orders quantity.
• Utilized Oracle ERP system to maintain, run the logic and consume the forecast data as per orders by the quantity.
• Convert complex business functions into technical specifications and involved in testing with Oracle ERP technical data integrity.
• Involve in ERP monthly reporting and compare against forecast.
• Experience with process mapping is required and Experience documenting complex processes and presenting them in a clear and understand.
• Ability to understand, evaluate and recommend changes to business processes is required and Demonstrated strong communication and relationship skills
• Demonstrated ability to partner with business representatives at all levels to identify needs, define and document requirements, and drive solutions
• Demonstrated ability to develop detailed project requests or charters which include project objectives, success criteria, and requirements
• Experience in identifying opportunities for process optimization, process redesign, or development of new process/policies
• Demonstrated ability maintain clear communication channels with IT and business stakeholders
• Demonstrated ability to explain complex technical concepts to a non-technical audience
• MS Project, MS SharePoint MS Access, SAS Enterprise, MS SQL, Oracle 11g, Prime Excel, MS Power Point, MS Project, Agile Data Warehouse, Data Models, BI, Oracle ERP, Application life cycle management.

Confidential

Business Data Analyst

• Design Planned Create Reviewed and Analyzed the Manual Test cases Written in Application Lifecycle Management (ALM)
• Involved in Functional Testing, Regression Testing, UAT testing of Wideorbit end to end Radio, Network, BOB (Business of books) reports.
• Worked in an agile environment.
• Create a business SAP business object report using the all necessary parameter.
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the SQL/ORACLE database.
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, and Summary Reports, Portal built on Oracle.
• Used Application Lifecycle Management (ALM) for defect tracking.
• Interact with QA Analyst, Developers to clarify the Issues related to Test Data, Test cases Design, Flow, Features and Functionality of application.
• Checking and modifying basic functionality of Manual test cases.
• Record and writes Test scripts in different environment and Add-Ins using QTP 9.1/8.2
• Create and modify functions for different functionality and add in Function library, Load this function library in each test.
• Execute and run the test, View and Analyze the Test result in QTP and Quality center.
• Change test status in Manual as well as Automation folder when status change for any test.
• Handle unexpected events that occur during the Test Run.
• Attends review, Project status meetings, Walkthrough and Inspections.

Confidential

Lead/Business Analyst

• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Define requirements, test plans, and deployment plans in support of Insurance back office business units.
• Work closely with MGA/TPA 3rd party business partners on policy/claim requirements for integration & warehouse
• Experience in data integration and data quality projects.
• Requirements gathering and, development of specifications for data integration projects and reconciliation metrics.
• Work directly with IT Warehouse, IT Development, Data Quality, Statistical Reporting, Claims, Finance and UW teams to document data, reporting, reconciliation requirements, manage analysis, and develop/review specifications for enterprise data integration projects.
• Provide project management across data integration projects.
• Work with developers to ensure requirement specifications are understood and appropriate project management and documentary artifacts and procedures are followed.
• Work with Data Quality/Data Governance Team to ensure DQ/DG guidelines are maintained/developed to support various Data Integration projects/initiatives with relevant analytics, reporting, data reconciliation methodology.
• SQL skills to query SQL databases and experience in reporting and data validation / reconciliation
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Conducted impact assessments for tactical shifts to trading and order flow process or client activity and vendor functionality changes including cost, efficiency, compliance metrics of trading flows; responsible for UAT, integration and regression testing.
• Involved in Offshore Regression testing for Base Applications like Web impressions and EOS (Enterprise online Activity).
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Worked on complex data analysis using AML management tools (Prime) and other systems to detect patterns and trends consistent with money laundering activity
• Utilized detailed knowledge of the Bank Secrecy Act, USA Patriot Act, and the Office of Foreign Assets Control (OFAC) laws and regulations.
• Prepared clear and concise reports (SARs) that detailed the unusual activity detected in the account review Assisted in interviewing, training and evaluation of employees within the Risk Management department
• Mentored and coached junior AML Testers and Fraud analysts Preparing Production implementation plan & scripts.
• Involved in gathering and analyzing the user requirements in coordination with Business.
• Identified the Facts, Dimensions, and grain of the Dimensional mode and referential joins.
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment.
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Tested ad hoc and canned reports for Business objects.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• Used Quality Center for defect tracking.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Worked in an agile technology.
• Tested ad hoc and canned reports for Business objects.
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Performed performance tuning by optimizing Target, Source, Mapping and Session.
• Involved in migration of mappings / workflows from Development to Testing and to production.
• Written test scripts to compare OLTP VS OLAP for ETL testing.

Confidential

Sr ETL Tester

• Created and implemented test cases for EDI files generated for various transactions as 837/835.
• Involved in EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Developed and executed various manual testing scenarios, test cases, test scripts and exceptionally documented the process to perform functional testing of the application
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Tested Informatica Mapping. Performed data validations against Data Warehouse.
• As a ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Managed test cases and created RTM (Requirement Traceability Matrix) in Quality Center and tracked defects using Rational Clear Quest.
• Used the ETL processes of Informatica tool to load data from MS SQL Server and Oracle, into the target Oracle database.
• Worked in an Agile technology with Scrum
• Wrote UNIX shells scripts (Korn Shell) to generate data, extracts test data, and load data to Oracle database using SQL*Loader
• Worked in Agile Methodology.
• Used Autosys for scheduling the Jobs and setting up the Jobs for execution.
• Involved in SIT (System Integration testing) including negative testing, positive testing, integration testing, regression testing and Black box testing.
• Extensively worked with PL/SQL, SQL in Oracle database.
• Extensively used PVCS for Version Control System and for Code Promotion.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle 10g.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, conditions, breaks, sorting, Functions, Alerts, Cascading Prompts and User Defined Objects.
• Initiated the bi-weekly QA-Stat-Meet to discuss the intricacies involved in the application(s) being tested.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Reported bugs and tracked defects using Quality Center 10
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Prepared test plans/test schedules with inputs from Project manager and development team
• Responsible for reporting and escalating data issues arising from project or daily support.
• Developed/revised training documentation and procedure manuals.
• Managed and executed the test process, using Agile Methodology
• Created and executed SQL queries in ORACLE and MS SQL server. Responsible for running and analyzing quality check reports to ensure system is functioning properly
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Confidential

ETL QA Tester

• Imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Attending Client calls for Business understanding and Clarifications.
• Created test case scenarios, executed test cases and maintained defects in Quality Center and ETL graphs from Source to Target
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers and clean-up process.
• Tuned SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using Quality Center 8.2.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in testing of Universe from different data sources like Oracle/SQL Server.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Tested several data migration application for security, data protection and data corruption during transfer
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Involved in creating source target mappings based on the Technical Design requirements.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules
• Worked on test data and completed unit testing to check all business rules and requirements are met.

Confidential

QA Tester

• Participated in all phases of STLC including Requirement Analysis; Test Plan, Test case development, Test execution and Test Environment Setup and Test Cycle Closure.
• Understanding High Level ETL Requirement specifications to test LLD for type-I, SCD Type-II and Type III mappings and done rigorous testing for various test cases.
• Involved in testing of complex ETL mappings and stored procedures in an optimized manner.
• Developed detailed Test Plan including strategies for testing
• Extensively used PL/SQL, TOAD programming in backend and front-end functions, procedures, packages to implement business rules.
• Performed Integration testing on various modules in the upstream and downstream applications.
• Tested stored procedures, functions and packages in PL/SQL
• Data was extracted from various sources like SQL Server, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database and testing was performed between the same.
• Performed rigorous testing of workflows and Worklets using Workflow Manager which loads the data into the Target Database
• Involved in testing the Slowly Changing Dimensions as per the requirements.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Wrote UNIX Shell Scripts for Informatica jobs and Autosys scripts for scheduling the jobs (work flows)
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Scheduling the jobs using Power Center Job Scheduler, and using pmcmd command.