SUMMARY:

• 4+ years of IT experience with expertise in Data Warehouse Process involved in Analysis, Design, Development of various business applications, different platforms using Informatica Power center 9.6.1 with Oracle 11g, SQL Server, Sybase, DB2, XML/XSDs and Mainframes VSAM files
• 10+ years of IT experience in QA with Automation and Manual testing on various domains
• Expertise in optimizing the session performance by eliminating performance bottlenecks by optimizing target, source, mapping, transformations, session, grid deployment and optimize the system
• Expertise in tuning the throughput of source and targets not only relational source and targets but also flat files and XMLs
• Expertise in tuning session performance by increasing the partitions, and dynamic partition as well
• Expertise in analyzing the thread statistics such as run time, idle time, busy time and thred work time
• Extensive experience in fine tuning the session by using pushdown optimization, increasing DTM buffer memory and error tracing
• Extensively involved in real - time processing by using Flush Latency and Source-Based commit and staging file
• Expertise in Database Design, Entity-Relationship Modeling, Dimensional data modeling, Star schema modeling, Snowflake modeling with Raplh Kimball methodologies, Data Normalization. Experience in working with SQL Developer and TOAD
• Experienced in integrating various data sources like Oracle, SQL Server, Sybase, DB2, Fixed Width delimited Flat Files & XML Files and Mainframe Datasets
• Experience in scheduling informatica jobs using external job schedulers like AutoSys
• Good understanding of Project Life Cycle and gathering requirements for ETL Development
• Extensive experience in ETL process consists of data transformations, sourcing, mapping, conversion and loading. Familiar with ETL Tool Informatica having fair knowledge on transformations, extensive experience in creation of ETL mappings
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions
• Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders
• Experienced in interacting with Business users in analyzing the Business process requirements and transforming them into documents, designing, and rolling out the deliverables
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups
• Experience on Software Development and Implementation with Agile and Waterfall models
• Closely working with Product owners, managing and handling grooming sessions, sprint planning meetings, daily stand-ups and sprint reviews
• Hands on experience in preparation of Test Plans, Test Strategies, Test Case Design and Test Execution estimations and Testing experience on different GUI’s
• Expertise in Defect Management and extract Test Metrics and SQA Activities
• Expertise in testing Web, Desktop, SAP, PeopleSoft, Oracle Apps,SalesForce and Other ERP applications
• Designed automation frameworks and Automation suites for various projects for various applications using QTP/UFT Automation tool
• Experience in Test Management on HP ALM and JIRA
• Experience in maintaining Automation suites and manual test execution process through version control systems
• Hands on experience on various domains - Insurance, Retail, Logistics, Health Care and Capital Markets
• Hands on experience on handling multiple testing projects including onsite-offshore testing models
• Worked at various onsite client locations on long term assignments with direct interactions with Clients and Business Partners
• Experienced in interacting with Business users in analyzing the Business process requirements and transforming them into documents, designing, and rolling out the deliverable
• Experienced in coordinating cross-functional teams, project management and presenting technical ideas to diverse groups and Quality Management
• Good Analytical, Strong Interpersonal and Excellent communication skills.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines

TECHNICAL SKILLS:

Data warehousing tools: Informatica power center 9.6.1

Databases: Sybase, Db2 UDB, SQL Server 2012, Oracle 11g and Mainframe Files

Scheduling Tools: AutoSys, DAC 11, UC4

Programming: sql, pl/sql and vb scripting

Tools: /Utilities: Toad, SQL Developer, MS Visio

Operating Systems: Windows XP, Unix systems

Functional Testing Tools: QTP / UFT, Ruby and Selenium

Defect Tracking Tools: Quality Center / ALM, JIRA Defect Tool, Bugzilla

Testing: Automation, Manual, Black Box, Modular, System, UAT,Product, Integration, Regression Testing, Test Plan Creation,Test Strategy Creation, Test Cases Design, Design AutomationFrameworks, Design Automation Scripts, Design Automation,Suites, Defect Management and extract QA Matrix

Mobile Platforms: iPods, Android and POS Systems

Other Tools: SVN

Technologies: Net, Java J2EE, SAP, Power Builder, SAP, Oracle Apps, PeopleSoft and BAAN

Domain: HealthCare, Insurance, Retail, Logistics and Capital Markets

PROFESSIONAL EXPERIENCE:

Confidential,Columbus, OH

ETL Developer

• Involved in requirements study and understanding the functionalities
• Integrated heterogeneous data sources like SQL Servers and Oracle databases and delimited/fixed width flat files
• Fine tuning the session performance to be able to handle the large amount of data
• Have been developing complex mapping to access data from Oracle, SQL Server and flat files and distributing them among various targets such as relational and CSV files to send them to the upstream 3rd Party vendor
• Extensively worked with XML targets and tuned them. Solved various performance issues while working with XML targets
• Extensive experience in writing the XSD files for XML targets
• Extensive experience working with session partitions types such as Pass-Through, Key range, Hash-Auto keys and dynamic partitioning
• Identifying the bottlenecks and tuning them accordingly
• Have been leading a team and extensively involved in gathering requirements and make them understandable to the team
• Extensively involved in validating the mappings/objects developed by the team

Environment: Informatica PowerCenter 9.6.1, Sequential files, XML/XSD files, Unix Systems, Windows 10

Confidential,Chicago, IL

UAT Test Lead

• Understand business requirements and identify UAT Testing scope
• Project Planning, Resource allocation and ensuring Utilization
• Design test cases and review Test Cases which are designed by the offshore and onshore testing teams
• Ensure the delivery on schedule and within budget
• Define Methodology & Processes and pursue the implementation
• Risk Management, Issue Management, Communication & Problem Escalation
• Work with different teams to resolve the testing blockers
• Signoff the UAT testing and give a go ahead for the deployments
• Review and publish UAT results to the stake holders
• Maintain financial reports, WSR, time cards and monthly scorecards

Confidential,Green Bay, WI

ETL Developer and Test Manager

• Involved in requirements study and understanding the functionalities
• Used heterogeneous data sources like flat files and Oracle
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, RouterFilter, Rank, Sequence Generator, and Update Strategy
• Created and Monitored Informatica sessions.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica
• Sessions, Batches and the Target Data
• Checked and tuned the performance of Informatica Mappings
• Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center