SUMMARY

• 13+ years of total IT experience of which 12+ years of relevant experience in ETL process using the tool Power Center Informatica.
• Good experience in building Data Warehouse using Power Center Informatica ETL tool and Oracle, Sql server and DB2 databases.
• Good experience in building Informatica MDM jobs to get appropriate Customer and product information from different source systems.
• Involved in high - level design, translate business requirements into technical and functional documents, and develop ETL jobs to fulfill business requirements.
• Good experience in Data Warehousing, SQL and Business Intelligence concepts and excellent ability to translate business requirements into IT solutions using BI tools like Informatica.
• Good experience in Informatica 10.X, 9.X, 8.X and 7.X can design ETL processes and develop mappings and workflows.
• Design and develop Informatica complex mappings and workflows, which follows SCD type 1 and SCD type 2 logic for maintaining history and current versions of source data loaded into dimensions and fact tables.
• Designed workflows and involved in optimizing Informatica performance by tuning source, target, mappings and sessions for the required performance.
• Expertise in Master Data Management concepts, methodologies and ability to apply this knowledge in building MDM solutions for the business analysis.
• Conduct analysis that identifies the current state of business processes and/or system inadequacies and propose future state of high efficient stable system.
• Provide accurate functional and technical solutions on business requirements.
• Deliver recommendations for process and system improvements that assist the business in achieving its goals and objectives, leveraging best practices and professional experience.
• Work with team members to proactively identify, communicate and resolve issues and risks that impede the execution and/or success of the project.
• Engages in pre-deployment UAT with a view to anticipate post deployment data issues and refine data research and report processes with the senior data and systems analysts.
• Worked in production support environment and have good experience in handling medium and critical incidents
• Good experience in UNIX and Shell scripting.
• Good experience in using Oracle PL/SQL, MS Sql server and DB2 databases.
• Able to multi-task by working on multiple assignments and/or projects.
• Collaborate with business stakeholders, team members and project managers to ensure timely delivery of project deliverables.
• Received numerous appreciations from customer and management

TECHNICAL SKILLS

• Design and developing technical and functional specificationsPower Center Informatica ETL Tool and MDMUnit testing and Integration Testing
• Oracle SQL, PL/SQL, MS SQL server, DB2, Teradata, Unix and Shell scripting
• Business Intelligence
• Oracle reports, Excel reports and Power point presentations
• Data Management
• Oracle, Sql server
• Informatica ETL Tool, Develop ETL process and build EDW (Enterprise Data Warehouse), Write complex queries to generate reports
• Informatica, Oracle, Sql server and Unix
• Insurance, Reinsurance, Logistics and Supply Chain Management

PROFESSIONAL EXPERIENCE

Confidential

Software Developer

Responsibilities:

• Involve in gathering business requirements and develop Informatica ETL jobs to feed the data from EBX to Oracle Finance MDM schema tables and make available to SAP HANA ATLAS systems.
• Use Informatica MDM to get valid data of Business Partners and Used Banks from different source systems. Apply valid business rules to get gold records when the data undergone match and merge process in Informatica MDM.
• Use java transformations in ETL jobs to connect EBX application through PCE, pull the financial data through xsd transformations, and distribute into various group of Finance MDM schema tables created in Oracle database.
• Design and develop EBX Integration layer in Power Center Informatica ETL tool, which pulls MDM views data from Oracle database, and load EBX application using web service consumer transformation
• Develop MFE UC4 jobs, which runs on daily basis and triggers EBX IL workflows followed by EBX DL workflows end to end.
• Design and develop bi temporality in Group MDM objects of EBX, which maintains the history of business partners, BP addresses, used banks and Line of Business.
• Implement SCD type 2 logic for expiring old record with current date and inserting active record with infinite date in Group MDM objects using Power Center ETL jobs.
• Identify data processing problems while fetching data from EBX and fix the issues related to technical problems.
• Unit testing ETL process and follow the test strategy to fulfil the designed requirement and perform integration testing and share the results with the client and take the approvals for deploying the build into production environment
• Improve performance of Cost Transparency application, which passes MDM data between Oracle and EBX schema tables by maintaining efficient system in all environments.
• Use complex sql queries to generate moderate reports between Group MDM and Finance MDM data elements and identify growth of the business based on the statistics generated in drill down process.
• Develop Oracle procedures and functions and align them in different packages and execute based on the requirements of EBX application
• Monitor the complete data flow when a change request triggered by a business user and see the approval status in different phases of change.
• Prepare user interface documents, which elaborates data flow in different environments, and make comfortable to new and existing users to use EBX application that has Group MDM and Finance MDM data.

Confidential

Software Developer

Responsibilities:

• Perform Major/Minor Enhancements OIMRE & PONTE applications related to Brazil Finance.
• Understand, prioritize business team's needs and designs work product enhancements
• Provide monthly close figures to Swiss Re Brazil business team for Swiss Re Brazil SUSEP filing
• Enhancement and supporting Informatica MDM jobs to maintain the Customer and Product Information related to BRF application
• Work with ITG vendor for any new releases to the OIMRe, OIMx (Ponte) software
• Design work product for Business needs, creates and assigns the solution designed to the Global Finance IT team for development
• Regularly interact with the business for requirements gathering and analysis of application gaps
• Work with the business team and IT team to prepare functional specification during the project requirements stage.
• Assist the Global Finance IT team to prepare technical design document and submits document for client approval.
• Follow up with Global Finance IT team to implement the work product designed.
• Participate in Unit Testing, Integration Testing and assist the business teams in UAT
• Get sign-off approvals from the stakeholders for production deployment related to ETL process.
• Get sign-off approvals from the business, IT and SQA teams for DSD and TDD
• Monitor and maintain databases, performs SQL query optimization, performance tuning, analysis of data quality
• Perform root cause analysis of the issues and provides a permanent solution.
• Work with the business to propose solutions for the overall stability of the OIMRe & Ponte applications.
• Prepare reconciliation reports from RIC and provide them for quarterly reconciliation
• Direct the business team to right parties in order to resolve the reconciliation differences and finance application issues
• Interact and coordinate with the offshore team for any production issue that may arise.
• Provide functional leadership and mentor his team members on Swiss Re applications.
• Review work products from offshore.

Confidential

Software Developer

Responsibilities:

• To analyze Regulatory reporting to CNSF (Comisión Nacional de Seguros y Fianzas) which include legal reporting, financial reporting and intermediaries/vendor details reporting and develop Informatica Power center mappings and workflows to load RR Oracle tables.
• Understanding Moody's Risk Integrity application that has the ability to generate all required reports related to P&C and C&S companies and develop ETL feed for each report
• Understanding source applications like Manhattan Next (direct), Manhattan Classic (assumed), Oracle GL, LFD (financial application) and data contained in it and design a data flow for each report.
• Interaction with the client and the business users in Legal, Finance departments to get sign off for design.
• Preparing Technical and Low / High level design documents.
• Preparing estimates.
• Assisting Development team and testers in understanding requirements. Ensuring information from all sources are available for Development team to build the application and interfaces.
• Conducting System Testing and assisting users during User Acceptance Testing.
• Following up on all regulatory changes published by CNSF. Understanding changes proposed and impact on current mappings.
• Assisting Business users with review of reports generated from Risk Integrity tool.
• Reconciling Source data from Manhattan Staging, LFD and Oracle GL with reports generated from Risk Integrity tool.
• Analyzing impact of Specification changes proposed by Risk Integrity Product Team on existing mapping and planning for testing involved due to proposed changes.

Confidential

Computer Programmer

Responsibilities:

• NACA is a complex system and getting sensitive financial information from different banks and need to maintain security of data while feeding into Oracle database and archiving image and data files, which will be taken care on priority basis every business day.
• Identify data issues faced in terms wrong check image tied up with different data element and resolve the incident on priority basis by connecting right image with right data.
• Adjust the schedule of Batch Tracker jobs which fetches Lockbox files and feed NACA in different sets of tables called la batch header and la batch detail
• Missing JE20s and JE30s which are classified as credit and debit amounts of vendor checks and wires handled on priority basis and get missing data loaded into the system within expected time
• Improve system performance by running the jobs in off hours and make available data to end users during working hours the day.
• Develop Informatica mappings and workflows to create a new feed for Bank Fees automation transactions which comes from Robotics (GIGI) and feed into NACA
• Query NACA Oracle database for identifying any data quality issues and report to the upstream data feed delegates to fix the quality issues raised while generating complex reports.
• Recommended software applications like Oracle Apps and SR Oracle has proposed to migrate this front-end system and attending meetings with stakeholders to get sign off and initiate define phase for the same
• Analyze user requirement and business solutions to migrate existing NACA application to new Oracle Apps environment
• Prepare user interface and system analysis documents and upload to share point and notify end users to use those version control documents for their business need
• Monitoring Power center Informatica ETL jobs and Java code which executes in Linux environment on daily basis and make sure all the jobs execute without any issues

Confidential

Project Lead

Responsibilities:

• Developing and enhancing Enterprise Data Warehouse using ETL tool Informatica 8x/9x.
• Replicating source data from DB2 to IBM Netezza/Oracle using Informatica Power Exchange.
• Migrating/conversion from Oracle warehouse builder code to Informatica code.
• Responsible for understanding the existing system and the new project requirements and implement a solution after doing a proper gap analysis.
• Responsible for preparing Design documents based on existing OWB code and implement the same functionality to achieve using Informatica ETL toll.
• Review the mappings developed by team members and guide them to meet the requirements.
• Responsible for developing, enhancing and maintaining Informatica mappings

Confidential

Project Lead

Responsibilities:

• Working as a project lead and involved in end-to-end delivery of different requirements coming in different stages.
• Analyzing the requirements received from the client and regular interaction with the client and the team.
• Involved in creation of technical design documents and creation of folder structure as per Barclays standards
• Development of Informatica mappings and workflows, unit testing plan/document and unit test execution steps as per the requirement.
• Creation of concurrent workflows for different countries.
• Provide guidance in SIT testing to SIT tester and creation of UNIT test cases.
• Support for OAT and Production for 2 months.
• Creation of support document and involved in hand over of application to support team.

Confidential

Project Lead

Responsibilities:

• Worked as project lead and involved in end-to-end delivery of different requirements coming in different stages.
• Analyzing the requirements received from the client and regular interaction with the client and the team.
• Involved in creation of technical design documents and creation of folder structure as per Barclays standards
• Development of Informatica mappings and workflows, unit testing plan/document and unit test execution steps as per the requirement.
• Creation of concurrent workflows for different countries.
• Provide guidance in SIT testing to SIT tester and creation of UNIT test cases.
• Support for OAT and Production for 2 months.
• Creation of support document and involved in hand over of application to support team.