SUMMARY

• Ten years of professional IT experience in systems analysis, design, development, data warehouse/data mart design, RDBMS and implementation of client server applications.
• Nine years of technical hands - on experience in development of Data warehousing solutions using Informatica Power Center 9.x/ 8.x/7.x /6.x /5.x, Informatica MDM 9.5, Cloud Integration services, OBIEE, IDD, IDE/IDQ Power center, DT Studio, Power Exchange Navigator 8.1.1, salesforce.com, SAP,QTP, Confidential Quality center, and Power Mart 7.1.1 /6.2 / 5. x.
• Experience in creating and configuring rules in IDD (Informatica Data Director) for the match and merge process data .
• Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2 (Reports, Designer, Web Intelligence, Info view, and Supervisor).
• Expertise in Project Management skills like estimating, scope management, time management, change management, communication management, quality management, testing plans, training plans, team management, onsite/offshore coordination by conducting status calls after hours and working with team.
• Good knowledge on Teradata Manager,TDWM,PMON,DBQL,SQL Assistant,BTEQ.
• Worked closely with business users to enable business process using SFDC.
• Experience working across various SFDC implementations covering Sales Cloud, Service Cloud, Chatter and app exchange applications.
• Extensive experience in data loader, data Integration using Informatica and SFDC.
• Experience in using SalesForce.com to identify issues and gaps in sales efforts and develop solutions to close the gaps and solve issues. Proficiency in SFDC Administrative tasks like creating Profiles, Roles, Users, Page Layouts, Email Services, Approvals, Workflows, Validation rules, Reports, Dashboards, Tasks and actions.
• Experience in creating in creating Workflow rules and defined related tasks, time, triggered tasks, email alerts etc.
• Worked with Informatica MDM approach to address unique MDM business requirements.
• Developed full SDLC project plans to implement ETL solution and identify resource requirements.
• Expertise in managing Teradata project implementation.
• Five years of experience in administration tasks on ETL Tool, including testing, upgrading, configuration, client installations, deployments, backups, repository management, performance monitoring and improvements, patching, setting up ODBC connectivity to connect to other databases.
• Very good business knowledge in financial, retail, insurance, legal business and healthcare industries.
• Power user/administrator for Salesforce.com in creating Objects, workflow rules, managing Users, creating Page layouts.
• Experience with Relational and Dimensional data modeling using Erwin, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas.
• Have in depth Knowledge and understanding of CRM business processes like Forecasting, Campaign Management, Lead Management, Order Management, Account Management, and Case Management.
• Awareness of the implementation and performance issues relating to load management and error handling function for ETL.
• Very good database experience using Oracle 10g/9i/8i/7, Teradata, BTEQ, Sybase, Hyperion, DB2/UDB, MS SQL Server 2000/7.0/6.5 , SQL, SQL*Plus & PL/SQL. Stored Procedures, Triggers, Cursors, Indexes, Views, Functions and Packages.
• Designed Custom Formula fields Dependencies, Validation Rules, Work Flows and Approval Processes for automated alerts, field updates and Email generation according to application requirements.
• Experience in Release management activities in SIT, QA and production.
• Strong Working Experience of Power Center Administration, Designer, Informatica Repository Administrator console, Repository Manager and Workflow Manager.
• Exposure to quality processes involving ISO audits, CMM, Defects prevention, Metrics collection, Interpretation, Change request management and Version Control Management.
• In-depth understanding of data warehousing, Kimball methodologies, including dimensional modeling, star schema design and implementation using Informatica as an ETL toolset.
• Experience in working with 5010, 277 HIPPA code changes.
• Experience in Installation and configuration of Informatica server with SQL server, oracle and able to handle the Informatica administrator tasks like Creating repository and backup, Configuring DSN, creating Connection Strings, copying & moving mappings, workflows and creating folders etc.
• Created projects in DT Studio and used different types of services like parser, mapper, and serializes to transform xml files into database.
• Expertize in reducing overall development by providing Erwin model of existing database structure to the development team.
• Extensively worked in data Extraction, Transformation and loading from source to target system using Bteq, FastLoad, MultiLoad, FastExport as well as Writing complex queries for loading and extraction data using Teradata development utilities.
• Experience in Data profiling & Data Mappings, Data validation, Match and Merge rules,writing and customizing user exits using Informatica MDM tool.
• Good experience in extracting data from Oracle, XML,Flatfile,DB2, Netezza, SQL Server, Teradata, MQSeries, Sybase, SQL Programming in Brokerage, Investment Management, Claims, Salesforce, SAP R/3 and Siebel Sources and Targets.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
• Experience with defect Management and Change Management process tools like TeamTracker and PVCS Tracker.
• Created test cases and test plans and create regression suite to run the test cases in Confidential quality center. Experienced with unit testing, system testing, and UAT and Deployment activities

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 5.x/6.x/7.x/8.x/9.x, IDE/IDQ, Informatica MDM 9.5, Power Exchange, Informatica B2B,SAP,MDM, CDC and DTS.

Salesforce Technologies: Apex Triggers, Apex Classes, SOQL, SOSL, Visual Pro, Pages, Apex Web Services, Eclipse IDE, Plug-in, Workflow & Approvals, Dashboards, Reports, Analytic, Snapshots, Custom Objects.

Querying tools & Modeling: SQL Plus, TOAD, CVS, Teradata SQL Assistant, QueryMan Erwin, Metastorm Provision

Languages: Shell Scripting, PL/SQL,SAS, SQL, SQL*Plus, C, Apex, Visualforce, Force.com IDE, Force.com Migration Tool, Web Services/SOA & Metadata APIs, Apex Data Loader, C++, Java, J2EE, XML, HTML, Python, JDBC, JMS, Apex, SAP & TIBCO

Databases: Oracle 11g/10g/9i/8i/8.0/7.0, Sybase, MS Access, DB2, JMS, UDB, Teradata, Netezza, SQL Server 2005

Client/Server GUI: FrontPage 97/98/2000, Visual Basic 5.0/6.0,Oracle Retail, Salesforce

Load Utilities: Multi Load, Fast Load, Fast Export, BTEQ, Tpump, Teradata Parallel Transporter, SQL Loader

Reporting tools: Business Objects, OBIEE

Operating Systems: DOS, UNIX, Linux, Windows

Scripting: JavaScript 1.2/2.0, PERL,UNIX Scripting

PROFESSIONAL EXPERIENCE

SFDC/ETL Integration Lead Developer

Confidential, Palo Alto, CA

Responsibilities:

• Involved in analyzing, defining, and documenting data requirements by interacting with the client and Salesforce team for the Salesforce objects.
• Have performed various testing activities like Unit Testing, Integration- System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal. Other activities include archiving the test logs and publishing the User Acceptance test logs.
• Knowledge of single sign-on process that allows network users to access all Contact salesforce.com to enable delegated authentication.
• Worked on CRM business processes like Forecasting, Campaign Management, Lead Management, Order Management, Case Management, and Account Management.
• Worked on the Business Requirement documentation by identifying the business rules, basic business process flow and sub-flow for the concerned business activity flow steps.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Developed Validation Rules for the Custom Objects and Workflow rules and Approvals for some fields.
• Customized standard sales force objects like Accounts, Contacts, case management and solutions.
• Used Sales Force Automation (SFA) for Sales Lead Management, Territory and Opportunity Management, Account and Contact Management and Approvals and Workflow.
• Worked with various salesforce.com objects like Accounts, Contacts, Leads, Opportunities, Reports, and Dashboards.
• Involved in identifying the DM changes and worked with SFDC to work for the solutions.
• Implemented pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation rules and formula fields to the custom objects.
• Development of objects, triggers, validation rules, workflow rules, Visual force Pages, Apex classes.
• Created automations of emails to Opportunity owners based on business requirements.
• Implemented Functional and Technical Design Documents to present to client for the Informatica process for the Salesforce extracts.
• Involved in Configuration, proxy server setup while working on Upgrade projects.
• Controlled the data access across the Application using Field-level security and Organization-wide Defaults, creating Profiles, Queues, Setting up Role Hierarchy, Company profile and writing the Sharing Rules as per the Requirements.
• Created and edited custom objects and custom fields in Salesforce and checked the field level Securities.
• Extracted data from Teradata sources to load into Salesforce.com.
• Involved in Integrating with Teradata sources to create, update and delete Salesforce Objects upon Business requirement.
• Worked on Offshore Onshore model, held meetings on a daily basis for coordination and planning.
• Installation and configuration of Informatica server and Client, Managing all three environments across the application groups.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Create users, Create groups, Assign roles, Create folders, Assign permissions and set up UNIX folders.
• Trouble shooting production issues and involved in 24X7 production support activities.
• Created Use cases upon Salesforce Objects and implemented those in Informatica coding to extract the data.
• Enabled Bulk data load for loading into the Sales force and checked the jobs in sales force Administration setup.
• Implemented pick lists, dependent pick lists, lookups, master detail relationships, validation Rules and formula fields to the custom objects.
• Identifying and removing Bottlenecks to improve the performance of Mappings, Sessions and Workflows using partitioning, fixing bottlenecks at source and target level.
• Created processes for lead and opportunity management.
• Data validation was done using GUI TOOLS and on Salesforce.com.
• Involved in pre-deployment activities and was part of regressing and UAT.
• Written Unit Test cases and performed Unit testing and Regression testing

Environment: Saleforce.com, Informatica Power Center 9.5.1, Informatica Cloud data loader for SFDC, SAP,Apex, Oracle, Teradata, Oracle, Unix, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls Pages, Data Loader, HTML, Java Script, Eclipse, Windows XP.

SFDC Integration developer/Solution Architect

Confidential, IA

Responsibilities:

• Involved in analyzing, defining, and documenting data requirements by interacting with the client and Salesforce team for the Salesforce objects.
• Worked on the Business Requirement documentation by identifying the business rules, basic business process flow and sub-flow for the concerned business activity flow steps.
• Worked on Account & Contact Management, Opportunity Management, Contract Management, Product Management, Price Books, Asset Management, Territory Management, Security, Roles & Hierarchy.
• Implemented pick lists, dependent pick lists, lookups, master detail relationships, validation Rules and formula fields to the custom objects.
• Developed Validation Rules for the Custom Objects and Workflow rules and Approvals for some fields.
• Extremely used Informatica cloud MDM to work with single view of Customer data within Salesforce.com
• Developed functional and technical specification documents, mappings and exception handler for ETL processes.
• Performed Informatica administration duties including creating users, user groups, and folders, database connections, promoting Informatica folders, mappings, sessions and workflows from development to production.
• Involved in Users creation, deployment groups, Connections and code migration .
• Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Sandbox data loading, Eclipse IDE Plug-in.
• Involed in extracting and loading of SAP BW data using Informatica
• Created Formula fields and Hyperlink Formula fields.
• Created Security settings for Roles and Profiles and managed Security Sharing Settings.
• Customized standard sales force objects like products, price books, case management and solutions.
• Development of objects, triggers, validation rules, workflow rules, Visual force Pages, Apex classes.
• Involved in Release management activities in SIT, QA and Production
• Worked with MDM process for matching, consolidating, cleansing the records and to maintain the data which is not changed for long time.
• Used Informatica Cloud MDM de-duplicates, cleanses, and consolidates data from back-office systems and builds hierarchies in your instance of Salesforce.
• Involved in writing SFDC Test plans and test strategy documents as per the project requirements
• Responsible for writing BTEQ queries to extract data from Teradata tables.
• Worked with ET, UV, WT Tables, error handling and performance tuning in Teradata queries and utilities.
• Created and configured Relational, MLoad, Fast Export connections based on the requirement.
• Worked with various salesforce.com objects like Accounts, Contacts, Leads, Opportunities, Reports, and Dashboards.
• Implemented Functional and Technical Design Documents to present to client for the Informatica process for the Teradata extracts.
• Expanded the use of Domains within Erwin by developing templates that are used by modelers when new models are to be created.
• Reduced overall development by providing Erwin model of existing database structure to the development team.
• Created Teradata connections according to the requirement to extract data from Teradata source.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Involved in Integrating with Teradata sources to create, update and delete Salesforce Objects upon Business requirement.
• Worked on Offshore Onshore model, held meetings on a daily basis for coordination and planning.
• Implemented the Master-Detail, Look-up, Many-to-many and Hierarchical relationships and Automate the business Process using Workflow rules, Approval Process, Auto-Response Rules and Escalation Rules.
• Created Use cases upon Salesforce Objects and implemented those in Informatica coding to extract the data.
• Enabled Bulk data load for loading into the Sales force and checked the jobs in sales force Administration setup.
• Identifying and removing Bottlenecks to improve the performance of Mappings, Sessions and Workflows using partitioning, fixing bottlenecks at source and target level.
• Have generated few complex business reports/graphs using IDQ, which was being used for understanding, acting and reporting.
• Created an Erwin Naming Standards file from the Repository to ensure adherence to corporate standards by all development teams.
• Involved in pre-deployment activities and was part of regressing and UAT.
• Written Unit Test cases and performed Unit testing and Regression testing

Environment: Informatica Power Center 9.x,Informatica MDM9.5, Informatica Cloud data loader for SFDC, Apex, MDM, BTEQ,IDQ V9.1,Saleforce.com, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, SAP BW, Email Services, Sandbox data loading, Eclipse IDE Plug-in UNIX.

SFDC Developer/ Admin

Confidential, Longwood, FL

Responsibilities:

• Understood the Business point of view to analyze the data and implement coding.
• Involved in migration of objects in all phases (DEV, INT and PRD) of project and trained developers to maintain system when in production.
• Worked in SFDC Administrative tasks like creating Profiles, Roles, Users, Page Layouts, Email Services, Approvals Process, Workflows, Validation rules
• Unit testing and UAT Phase which required writing of test classes for each apex classes with 90%-100% coverage., Reports, Dashboards.
• Trouble shooting production issues and involved in 24X7 production support activities.
• Worked with various salesforce.com objects like Accounts, Contacts, Leads, Opportunities, Reports, and Dashboards.
• Involved in Data cleansing before extracting from source systems and loaded into Target systems.
• Have worked on preparing the impact analysis document and high-level design for the requirements.
• Have worked on preparing test strategy documents and test scripts and code reviews.
• Developed functional and technical specification documents, mappings and exception handler for historical conversion, go forward ETL processes and outbound interfaces.
• Used Informatica MDM business model approach to address unique MDM business requirements.
• Wrote test cases, migrations process documents and test plans as per the project requirements.
• Involved in DQ Architecture and Master data management according to the project requirements.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Participated in the training sessions provided by the Salesforce team and support end users.
• Worked with error handling and performance tuning in Teradata queries and utilities.
• Responsible for writing BTEQ queries to extract data from Teradata tables.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Worked with joiners and complex SQL Queries to extract the data from source systems according to the requirement.
• Created an Erwin Naming Standards file from the Repository to ensure adherence to corporate standards by all development teams.
• Performed Informatica code migrations, test, debug, document to maintain programs and deployed.
• Documenting business requirement, test plans, test scripts, implementation plans.
• Extracted data from Oracle database and loaded into Teradata targets.
• Interaction with Offshore Team every day for ongoing work, based on the Tickets/issues and to follow up with them for its progress.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Participated in project planning sessions with project managers, team members to analyze business requirements and outline the proposed solution.
• Built in mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values. Extremely worked with unstructured and Java transformation to extract XML files.
• Created variables, macros to Manage Jobs running Schedule and passing Parameters to different jobs.
• Analysis and fixing the defects found in unit and system testing Provided support and quality validation thru test cases for all stages of implementation
• Performance tuning of the components like Parameter files, Variables and Dynamic Cache.

Environment: Salesforce.com,Informatica 9.1, BTEQ,Teradata,HL7, Informatica MDM9.5,Business Objects, Apex, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Sandbox data loading, Eclipse IDE Plug-in Visualforce,IDQ V9.1,SQL Server, IDD, MDM, PL/SQL, Erwin, Confidential QC and Perl.

Sr. Project Admin/ Sr Solution Engineer

Confidential, KY

Responsibilities:

• Understood the Business point of view to implement coding using Informatica power center designer extremely.
• Involved in migration of objects in all phases (DEV, INT and PRD) of project and trained developers to maintain system when in production.
• Eliminated errors in Erwin models through the implementation of Model Mart (a companion tool to Erwin that controls the versioning of models).
• Involved in migration projects to migrate data from data warehouses on DB2 and migrated those to Teradata.
• Involved in in performance tuning of BTEQ scripts for target data Warehouse for FastLoad, MultiLoad.
• Created security groups, IDs for new users and grant access according to the security ticket requests.
• Use SalesForce.com to identify issues and gaps in sales efforts and develop solutions to close the gaps and solve issues.
• Support outside sales staff.
• Create, backup, restore and DR for Informatica Repositories.
• Add and update ODBC and TNS entries.
• Responsible for the code migration and E ETL Administration responsibilities for the enterprise Data using Informatica tool.
• Involved in Production Support activities including monitoring loads, resolving exceptions and correcting data problems.
• Created and configured Teradata and Oracle connections in Informatica workflow Manager.
• Worked with BTEQ scripts to extract data from Teradata tables.
• Created and Integrated with Fast Export and Load Utilities.
• Participated in cleansing the data before extracting into the source systems.
• Applied Oracle performance tuning tips on database tables.
• Participated in IM and production support tickets to complete according to the request.
• Experience in Grids, nodes, Repository services and Integration services.
• Ensures proper configuration of the Power Center Domain components.
• Involved in writing shell scripts and added these shell scripts in Cron Job, as scheduled daily, weekly, monthly
• Extensively created mapping/mapplets, reusable transformations using transformations like Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy etc.
• Possess experience in architecture level by providing optimization for data validation solutions.
• Performance tuning has been done to increase the throughput for both mapping and session level and SQL Queries Optimization as well.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Solved various Production issues and worked along with the Informatica Global support to troubleshoot those failures.
• Creating Folders and manages user and user group access to objects in the repository
• Experience in using metadata for the integration processes, enterprise applications and mainframe systems into a central catalog.

Environment: Informatica Power Center 9.1,DT Studio, Erwin, Confidential Service center, IDQ 9.1,BTEQ,SAP HANA, DB2,OBIEE, Salesforce.com, IBM Tivoli, Oracle, SQL*Plus, PL/SQL, .NET, Teradata, UNIX.

Sr. ETL Developer

Confidential, Baltimore, MD

Responsibilities:

• Understood the Business point of view to implement coding using Informatica power center designer extremely.
• Used Erwin extensively for logical and physical Data modeling and to create ERD diagrams.
• Helped in resolving production issues and identified root causes to prevent Production Issues from reoccurring
• Worked with 5010,277 impacted code changes and loaded into Oracle database.
• Created the ETL specs according to the business logic.
• Identifying and removing Bottlenecks to improve the performance of Mappings, Sessions and Workflows using partitioning, fixing bottlenecks at source and target level.
• Involved in writing scripts for loading data to target data Warehouse for Bteq, FastLoad, MultiLoad.
• Involved in using DT Studio tool to extract data from large xml files into Oracle databases.
• Created unstructured transformation to call Data transformation service from Power Center Session.
• Created UNIX Shell Scripts to Manage Jobs running Schedule and passing Parameters to different jobs.
• Worked with BTEQ scripts to extract data from Teradata tables.
• Created Junit frame works to test B2B project.
• Reduced overall development by providing Erwin model of existing database structure to the development team.
• Automated the jobs thru scheduling using UC4, which runs every day by maintaining the data validations.
• Possess experience in architecture level by providing optimization for data validation solutions.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.
• Performance tuning has been done to increase the throughput for both mapping and session level and SQL Queries Optimization as well.
• Experience in using metadata for the integration processes, enterprise applications and mainframe systems into a central catalog.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.

Environment: Informatica Power Center 8.6.1, Informatica B2B DT, TeamTracker, JMS, Oracle PowerExchange, IDQ,Cognos, MQC, MQJ Explorer, JCL,SAS,HIPPA, BTEQ, Eclipse, FACETS, Oracle 10g, Erwin, PL/SQL, Toad, CDC and UNIX.

Sr. ETL Developer/Production Support Lead

Confidential, Eagan, MN

Responsibilities:

• Experience in System design and development required for business process.
• Created Functional specifications according to the requirement.
• Participated in project planning sessions with project managers, team members to analyze business requirements and outline the proposed solution.
• Created projects in DT Studio and used different types of services like parser, mapper, and serializes to transform xml files into database.
• Support outside sales staff.
• Used Database trigger for making history of insertion, updating, deletion.
• Extracted data from multiple source systems to load into Data warehouse.
• Extremely worked with unstructured and Java transformation to extract XML files.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources Worked with external loads to load the data into Teradata.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Trouble shooting production issues and involved in 24X7 production support activities.
• Used IDE data quality component to build new structures from existing data and databases.
• Configured PowerExchange Sessions to work with CDC objects.

Environment: Informatica Power Center 8.6.1,IDE/IDQ Powercenter, PVCS Tracker,.Net, Informatica DT Studio,, PowerExchange, TFS, MQJExplorer, DB2, DT Studio, Autosys, Oracle10g, SQL*Plus, XML, JMS, Junit, PL/SQL, Toad, CDC, UNIX & Eclipse.

Sr. Salesforce.Com Developer

Confidential, Buffalo, NY

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Participating in the review of the detail design and construction for the above projects.
• Worked with sales, purchases and Account transaction data.
• Developed SQL queries to create tables and views to work with multiple relational tables
• Created and configure Salesforce.com and Siebel Sources and Target Definitions.
• Worked with powercenter Change Data Capture (CDC).
• Experience in using metadata for the integration processes, enterprise applications and mainframe systems into a central catalog.
• Helped in resolving production issues and identified root causes to prevent Production Issues from reoccurring Loaded the data into Oracle, DB2, and Teradata Tables using the business logic.
• Created Mapping specifications and testing specifications according to the requirement.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode. Performed unit testing and tuned for better performance.
• Used complex lookups to update salesforce sources into EDW.
• Implementation of error handling, audit logging/messaging.
• Extensively for error identification by creating breakpoints and monitoring the debug monitor.

Environment: Informatica Power Center 8.6, JMS, SalesForce.com, TFS, Oracle Teradata, CDC, Business Objects, IBM Mainframe, Data Profiling, Apex, Oracle10g, Sybase, SOAP, SQL*Plus, PL/SQL, Erwin 4.0, UNIX & UC4.

ETL Specialist/DW Consultant

Confidential, Cincinnati, OH

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Created ETL mappings using Informatica that transfer data from Oracle source system to the Datamart.
• Highly used SQL*Plus basic commands without interacting with the database.
• Used PowerConnect to integrate with SAP R/3 Sources and Targets.
• Implementation of error handling, audit logging/messaging.
• Created Web Service Consumer Transformations to integrate with PowerCenter with Web Services.
• Used SOAP protocol to transmit data between Integration service and other sources.
• Enhanced metadata exploration with customized views.
• Used SQL queries for database testing to retrieve and verify data accuracy.
• Designed ER-Diagrams according to the requirements by connecting to the database server.
• Involved in parsing of XML documents to fetch the data from xml through PL/SQL and store in oracle tables.
• Used Database trigger for making history of insertion, updating, deletion.
• Involved in Data Cleansing and data conversion programs.
• Created error log table to capture the error messages, session load time.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Wrote PL/SQL stored procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Involved in processing of Policy, Claims data in dev.
• Involved in troubleshooting the loading failure cases, including database problems.

Environment: Informatica 8.5,Cognos 8.2, Oracle 10g,JMS,SAPR/3,Data Profiling, SQL Server, IBM Mainframe, Firstlogic, SSIS, PL/SQL, JMS, Web Services, PowerConnect, SQL*Plus, Erwin 4.0, UNIX, UC4, PUTTY, CVS & XML.

ETL Consultant

Confidential, Boston, MA

Responsibilities:

• Worked with Business Analysts to gather the requirements.
• Used See Confidential Integrator tool to fix the CSV files and to generate 54x messages and dump into oracle database.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Worked with brokerage trades, and loans related sources.
• Used SQL*Plus to trap the errors and to explain SQL statements.
• Have performed various testing activities like Unit Testing, Integration- System Testing, Regression Testing, User Acceptance Testing and ensured that the code is ideal. Other activities include archiving the test logs and publishing the User Acceptance test logs to the respective and stake holders.
• Deployed projects from one environment to other environment.
• Used SQL queries for database testing to retrieve and verify data accuracy.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Created post-session and pre-session shell scripts and mail-notifications.
• Extracted data from COBOL files using copy books.
• Created Database triggers and pl/SQL scripts to manage the data.
• Involved in Unit testing of the mappings.
• Wrote JMS programs to read the data from queues.
• Develop test scripts/applications as-needed to facilitate data quality assurances and software testing
• Creating Relational Connections, Migrating the Mappings from Dev to Test and Test to Production.

Environment: Informatica 7.1.3, Oracle 9i, VSAM, SQL*Plus, PL/SQL,, Toad 7.0, UNIX 5.0.5, See Confidential & Windows XP.