SUMMARY:

• Highly motivated IT professional with overall 9.5 years of experience in IT industry with 6 years experience in ETL (Informatica, SSIS) and Salesforce administration and development.
• Strong ETL Knowledge of Data Integration, Master Data Management, Data Profiling, Data quality processes.
• Proficiency in utilizing ETL tool Informatica Power Center 9.x for developing the Data warehouse loads with work experience focused in Data Acquisition and Data Integration.
• Extensive Experience in designing and developing complex mappings applying various transformations and mapplets. Extensive experience in developing the Workflows, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Knowledge in OLAP Function, Materialized views and Hierarchical query.
• Worked on Oracle Views, Joins, queries, sub queries, correlated sub queries.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts. Development of Stored Procedures with Toad
• Knowledge in teradata database, teradata utilities like FASTLOAD, MULTILOAD, BTEQ, FAST EXPORT, TPUMP scripts.
• Knowledge in UNIX shells scripting and file management in various UNIX environments.
• Possess expertise in implementation of SCD type1, SCD Type2, SCD type3.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Expertise in Salesforce-Informatica Integration. Experience in Sales Force CRM Configuration, Customization, Testing of applications. Extensive experience using Sales force Administration (SFA), Custom Objects, Custom Tabs, custom fields, role based Page Layouts, Custom Reports, and Report Folders, Report extractions to various formats, design of Visual Force Pages, Dashboards and various other components as per the client and application requirements,
• Strong Knowledge of SFDC standard Objects and familiarity with designing Custom Objects and Force.com platform
• Experience in administration, configuration, development, Implementation, and Support of sales force CRM, and SalesForce applications based on Apex Language and leveraging Force.com Platform
• Strong Implementation and Integration experience using Custom objects, Triggers, workflows/ workflow rules, approvals, S-Controls, Visual Force Pages, and Apex classes. Proficient in using meta-data migration tools like Eclipse IDE and SalesForce Apex Data Loader
• Possess strong expertise in developing COBOL/DB2 Applications, COBOL/DB2 Stored Procedures on DB2 for z/OS and Native SQL Stored Procedures on DB2 for AIX.
• Experience in Banking and Insurance & Annuities domain.
• Practical understanding of all phases of SDLC with proven experience in successfully executing assignments of requirements gathering, estimation, design, development, testing and deployment of software systems.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies. Excellent problem solving, communication, analytical, interpersonal skills.

TECHNICAL SKILLS:

• Informatica Power Center 9.1, SSIS
• DB2 for z/OS, DB2 for AIX, Oracle 11g
• Salesforce.com, Informatica Cloud, Data Loader, Apex, Force.com Eclipse IDE Plug-in,, Force.com Explorer, Developer Console, Force.com Data Loader, Apex Explorer, SOQL, SOSL, S-Controls, SOAP API, REST API, Metadata API.
• TOAD,SPUFI,QMF, WinSCP, Putty
• SQL*Developer, SQL * Plus, PL/SQL
• JobTrac, COBOL,SQL,VSAM,JCL, Changeman, TWS
• IBM z/OS, IBM AIX, UNIX, Windows
• Quality Center
• Domain - Insurance, Banking

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica/ Salesforce.com Admin/Developer

Responsibilities:

• Requirements gathering and Analysis of new requirements and application integration requests from upstream applications.
• Involved in design of new and complex high quality performant solutions to clients in response to varying business requirements.
• Engage with customer to understand their use case requirements and propose the development strategy.
• Collaborated with cross-functional application teams to come up with design options in the Integration area
• Designing of Salesforce data model creating custom objects, defining relationships as per application requirements.
• Coordinated with Offshore development team for timely delivery, quality and implementation activities.
• Supported team in resolving SQL Reporting services and T-SQL related issues
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Actively worked on many production issues in the capacity of SME for downstream applications.
• Extensively worked on test data preparation, test case execution and bug reporting using Quality Center.
• Experienced in integration of Confidential with external applications by using SOAP API.

Environment: Informatica Power center 8.5, Informatica Power center 9.1, Informatica Power exchange, Confidential, Force.com IDE, Visual Force, Apex Data loader, S-Controls, SOSL, SOQL, IBM DB2 AIX.

Confidential

Onsite Tech Lead

Environment: Informatica PowerCenter, Informatica PowerExchange, DB2, Stored Procedure, Mainframe, Windows NT, AIX, Shell Script, Confidential, Crystal reports, DB2 Stored Procedures, XML

• Actively participated in the POC phase with the Config team to understand the structure of the new Database.

• Analysis of the impacted Stored procedures and identify the design changes as per new structure.
• Coordinate with the cross commit team to make them aware of the impact.
• Participate in different phases testing - Unit test, SIT, Production parallel, UAT.
• Coordinate with team to migrate the defect/fixes in SIT, UAT and retrofit them across all regions.
• Involved in the Performance testing of Crystal reports, interact with the middleware team and resolve various issues.
• Performance testing of the modified modules from different angles of performance - size, run time, timeout issues.
• Interact with the DBA to capture the NMON and Optim reports.
• Analysis of NMON report, Optim reports (Top SQL and Executive reports) to analyze the pain areas.

Confidential

Onsite Tech lead.

Environment: MS Visual Studio 2005 SSIS, Sql Server 2008, Stored Procedure, Mainframe, AIX, Shell Script, Confidential, SSIS, Task Factory.

Responsibilities:

• Provide on call Support to the Production support team during batch cycle.

• Provide SME support to the production support team during production issues.
• Guide the offshore team to achieve quality deliverables of the repeatable tasks.
• Interact with the Business team to understand the problem areas and gather the requirements.
• Involve in release activities of the monthly BAU release.
• Designed SSIS Packages to transfer data from flat files to SQL Server
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Loading operational data from Oracle, SQL Server 2000, Flat files, Excel Worksheets into various data marts.
• Developed number of complex Informatica mappings, Mapplets and reusable transformations for the product line profitability systems to facilitate daily, monthly loading of data
• Designed, and developed ApexClasses,ControllerClasses,extensions and ApexTriggers for various functional needs in the application.
• Packaged and Deployed customizations from Sandbox to other environments using Force.com IDES.

Confidential

ETL Sr Developer/SalesForce Admin/Developer

Responsibilities:

• Created Visualforce Pages, Controllers, Apex Classes & Triggers, custom components, custom settings, custom labels & sidebar components.

• Use of Salesforce emailing APIs to automate email service.
• Created new User Accounts and assigned Profiles as per their role in role hierarchy.
• Create user security model using Organization Wide Defaults, Sharing rules and defined validation rules, approval process, workflow rules, profiles & permission sets.
• Created Data Validation rules and Formulas as per business requirement.
• Worked with various Confidential Standard objects like Accounts, Contacts, Leads, Cases, Campaigns, Reports, and Dashboards.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Migration of data between multiple heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Deployment Salesforce changes across multiple environments and implementation of change management process using Force.com IDE.
• Mentor development team during the project and help them follow Salesforce best practices.
• Actively involved in different phases of project life cycles.
• Code promotion to Integration and UAT environment.
• Involved in conducting reviews for the codes after development

Environment: SSIS, MS Visual Studio 2005 SSIS, Sql Server 2008, Oracle 9i, Unix, Shell Script, TOAD, IBM DB2 AIX, Confidential, Force.com IDE, Visual Force, Apex Data loader, Quality Center, Service Now, Teradata.

Confidential

Informatica/Sql Developer

Responsibilities:

• Involved in analysis and design, documentation and development and testing

• Member of warehouse design team, assisted in creating fact and dimension tables based on specifications provided by Managers.
• Creating Workflow Rules & Approval process, Email Alerts, and components to suit to the needs of the application.
• Developed number of complex Informatica mappings, Mapplets and reusable transformations for the product line profitability systems to facilitate daily, monthly loading of data
• Used Informatica Power Center for extracting source data and loading into target tables.
• Creating Workflow Rules & Approval process, Email Alerts, and components to suit to the needs of the application.
• Involved in writing component test cases and Involved in functional testing and integration testing.
• Creating public Groups, Roles, Queues, Permission sets, Public Groups etc.
• Customized different page layouts and assigned them for different profile users.
• Developed Apex triggers as per the functional requirement.
• Created scripts (BTEQ, FastLoad, and MultiLoad) and written queries to move the data from source to destination. Worked in data Extraction, Transformation and Loading from source to target system using BTEQ, FastLoad and MultiLoad.
• Created appropriate indexes depend on the table situation and requirement.
• Extensively used ETL to load data from Oracle and Flat files to Data Warehouse.
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups & Proven ability to implement technology based solutions for business problems.

Environment: Informatica Power center 8.5, Informatica Power exchange, DB2 Stored procedures, Shell Script, HP Quality Center, Confidential, Informatica Cloud,Data Loader, Apex, Force.com IDE, Force.com Explorer, Developer Console, Force.com Data Loader, Apex Explorer, Teradata

Confidential

ETL Consultant

Environment: DB2, Informatica 8.6, Windows NT, Unix, Shell Script, Mainframe, Teradata

Responsibilities:

• Created scripts (BTEQ, FastLoad, and MultiLoad) and written queries to move the data from source to destination.

• Worked in data Extraction, Transformation and Loading from source to target system using BTEQ, FastLoad and MultiLoad.
• Created appropriate indexes depend on the table situation and requirement.
• Did data reconciliation in various source systems and in Teradata.
• Involved in loading of data into Teradata from legacy systems and flat files using BTEQ, FAST Load scripts.
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics.
• Extensively used ETL to load data from Oracle and Flat files to Data Warehouse.
• Extensively used Informatica client tools-Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager, Facets application.
• Created Informatica mappings using Source Qualifier, Expression, Lookup (connected and unconnected), Aggregate, Update Strategy, Joiner, Normalizer and Filter transformations.
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups & Proven ability to implement technology based solutions for business problems.

Confidential

Cobol Application Developer

Responsibilities:

• Analyzed user requirements.

• Converting Business requirements to System Requirements.
• Conducting Requirement Reviews and Design reviews with the clients.
• Worked upon various design models to ensure the minimal loss of information during Data Conversion and Data Archiving.
• Developed new applications using COBOL, PL/I, JCL and DB2 to facilitate the portability.
• Did extensive system and integration testing and supported Full Volume data test runs.
• System/Intergration testing with the Upstream Applications like Salesforce.
• Identified the modules where changes were required, Coding and Unit Testing.
• Did documentation and technical enhancements for maintaining the existing application
• Prepared Unit Test Plans and User Acceptance Test Plans
• Followed Change Management procedures to be both efficient and effective in completing the Implementation.

Environment: IBM - Z/OS, TSO/ISPF, COBOL, JCL, Embedded SQL programming, OPC, DB2, IMS DB, QMF, SPUFI, Informatica Power center, Informatica Power exchange, DB2 Stored procedures, Teradata.