SUMMARY:

• Around 10 years of IT experience in ETL/DW Architecture Solutions. Enterprise Data Warehouse Architecture, Collaborate with Client Architects, ETL and BI teams.
• Core Developer in Informatica Power Center with Linux/Unix platform. Design, supervise, plan, and coordinate highly complex project in heterogeneous source/targets.
• Subject matter expert (SME) on Data Warehouse, data analytics, data modeling, data quality, data governance assessments.Specialized in Insurance and Telecom/Telecommunication domains.
• 6+ years of Project Lead/delivery experience in CRM SFDC (Salesforce.com) Projects. Integration Architect and POC for the SFDC (cloud) integration.
• Experience in all the phases of Software Development Life cycle (SDLC) Requirements gathering, Design, Coding/Implementation, validation/Testing and Maintenance/support

TECHNICAL SKILLS:

ETL Tools: Infromatica PowerCenter 9.6/8.6.

Informatica Power Exchange: Informatica Power Exchange SalesForce (SFDC), MSMQ,PeopleSoft, Hadoop, Netezza.

Databases: Oracle 9i/10g, Teradata 12.0 and SQL Server 2005.

Scripting Language: Linux and Unix Shell Scripting.

Cloud application/tools: Salesforce.com (SFDC), Marketing cloud,Informatica Cloud,CMR Demand tool, People Import.

Office Tools: MS Word, Excel, PowerPoint and Visio

Others: Agile(Scrum), DevOps,Cognos Planning

Tools: SQL Developer, PL/SQL Developer, TOAD, Putty

Data Analytics: Oracle 9i/10g, Teradata and SQL Server 2005

File Transfer utilities: FTP, SFTP

PROFESSIONAL EXPERIENCE:

Architect/Technical Lead/Application Specialist/Senior Developer

Confidential

• ETL/DW Architect, involved in DW/ETL design for the Marsh Integration project.
• Currently working as an Technical/Project lead, my role involves coordinate with Client team, IT leads, vendors and offshore team (India)/near shore (Argentina/Philippines) to deliver monthly release.
• POC on the RFP on the data warehousing model and application integration.
• Design and develop ETL Infromatica jobs for new and existing integration.Expert in Informatica mappings development for heterogeneous source/targets like Salesfoce.com, Message queue, PeopleSoft, XML, Oracle, Teradata, SQL server, Marketing Cloud, flat files,
• Familiar with data warehouse solution, multidimensional model, logical and physical models design, data types, staging process and its benefits. Different data warehouse design approaches (top - down, bottom-up) and schemas (Star, Snow Flakes, etc)
• Application/Integration lead role with Release, Incident/problem, disaster and delivery management.Played multiple key roles including Application/Integration Lead, Support lead, SLA management and release management. Responsible for data validation, data cleansing, data transformation, data modeling.
• Have performed all phases of testing including unit testing, regression testing, integration testing, Performance and user acceptance testing.
• Performs perfective, preventive and corrective maintenance activities on ETL code, SFDC integration and support process/Job monitoring.
• Reviews of System Test scripts, Release Notes and Functional/Design documents to ensure the quality of application. Coordinate with third party vendors (SDL, Marketing cloudBridge-FTP servers) and internal vendor team like Admins, DBA’s, network, databasesstorage, security and operation systems.
• RCA (Root Cause Analysis), adhere to SLA/ audit, performance tuning, enhance for optimization of the mappings, sessions and workflows. Support activity involving escalation/POC, on call support for severity ( SEV1/SEV2 ) tickets/High priority issues. Trouble shooting complex issues.
• Worked on high demand environment and proven my skills in resolving the issue on timely manner.
• Management competencies include Team Management (Global teams), resource utilization, Client business/Client IT coordination, strong oral/written communication skills, presentation skills, work independently yet remain a strong team player (offshore, near shore). Coach/mentor/train the resources.

Software Engineer/Senior Developer

Confidential

• My role involves in understanding of the requirement and developing the ETL code, I have developed 200+ mapping and workflow jobs .Performed extensive validation of the code for quality and accuracy.
• I have involved 2 modules of the project (Wireline and wireless team) and was able to understand and update the changes on the existing codes.
• I was also involve d in perfective, preventive and corrective activities and implemented the new concept of data loading.
• I have created Macro to perform the operation of converting the file to Informatica compatible Files. Also performed the Code Validation and validated 60 percent of the Wireline Feeds which was developed.
• Requirements gathering, Design, Coding/Implementation, validation/Testing and Maintenance/support f the ETL code.
• Performed testing including unit testing, regression testing, integration testing, Performance and user acceptance testing to ensure the quality deliverability’s.
• Preparation of test plan and test case for Informatica mappings. Created Job Aid/trackers for the loading the wireless and wireline feed, which help to understand the various aspects of the process and loads involved in each feed.
• Coach/Mentor the new joiners to the project work/process.
• Had a short term project where I was responsible of the migration of the code
• Migration involved Informatica ETL Code from Informatica8.6 to Informatica 9 version
• Data migration from SQL Server 2005 to Teradata 12.0.

Associate Software Engineer

Confidential

• Project involved two modules of the Application (EDW and NSE) and I was responsible of handling application monitoring of production Informatica job.
• Worked on defect, failure recovery, data validation/analysis and support tickets to ensure the resolution fall well under the SLA’s.
• Maintenance of the jobs, performing RCA and business notification on failure.
• Worked on shell scripting automation for file handling/validation.
• Worked on enhancement of the existing ETL job to meet the new changes to the jobs.
• Worked on Dashboards, Weekly tracker, issue tracker and status decks.
• Project involved 24/7 support and worked on various shifts to support the project.