SUMMARY:

• Experience in design and development of API’s using mulesoft.
• 8+ years of IT experience in development and design using Business Objects and Informatica PowerCenter. Advanced knowledge in ETL and Data warehousing with OLAP technology.
• Proven track record in planning, building, and managing successful large - scale Data Warehouse and decision support systems. Comfortable in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Proficient in all phases of the Software development lifecycle, including requirements Definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformation.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Informatica Power Center Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, to SQL Server.
• Experience in integration of data sources like Oracle, SQL Server, Sybase and Flat files into the staging area and Multi-Dimensional Data Modeling (Star, Snow Flake schema).
• Explain Plan, Ref Cursors, Constraints, Triggers, Indexes- B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export / Import Utilities.
• Extensively used Query Analyzer and Enterprise Manager. Experience in development of DTS packages using SQL server. Tuned SQL, PL/SQL, analyzed tables, used Hints/TOAD.
• Possess wide range of IT industry experience with Banking / Finance, with strong analytical, problem-solving, organizational, communication, learning and team skills. Experienced with coordinating cross-functional teams.

WORK EXPERIENCE:

Confidential, Alpharetta, GA

Mulesoft API Designer/DEVELOPER

Responsibilities:

• Experience in Mule Administration, Configuration, & Tuning with Mulesoft Management Console (MMC) & Enterprise release capabilities.
• Extensively worked on Anypoint Studio, Mule Integration Platform and used it to interface application services by utilizing message routing, data transformation and service creation utilities.
• Extensive hands on experience in consuming as well as developing API's for SOAP and REST based Web services to integrate third party functional modules into the core application.
• Expertise in using MuleSoft studio in creating various flows to integrate API's, Databases and SaaS applications.
• Experience working on mule 4 and extensively worked on mule DataWeave component.
• Participated in deployment of Mule ESB applications using Cloud Hub and Strong experience using Mule ESB in integrating various third party solutions.
• Hands on experience in Mule Expression Language (MEL) to access payload data, properties and variables of Mule Message Flow.
• Extensively worked on both Enterprise and Community editions of MULE ESB. Have an experience working on MULE API manager and RAML.
• Designed and developed Mule ESB projects using various connectors like Salesforce, File, Database, JMS, SMTP, Transformers, and Data weave for integrating various applications, which are on - premises and hosted on cloud using synchronous and asynchronous Mule flows.
• Developed Mule flows to integrate Data from various sources into Database from Active MQ topics and queues and some transformations at the integration layer.
• Experience profiling and troubleshooting Java application code.
• Involved in unit testing and writing MUnit Test cases for the mule flows.
• Extensive Experience in retrieving and manipulating data from backend using Oracle, MySQL, SQL Server, IBM DB2. Strong experience in Scrum Methodologies, UML and Test Driven Methodologies.
• Experience on working with public and private cloud services (AWS and Azure) as well as proxies, load balancers and networking devices.
• Worked on POC for integrating different system like SAP, Salesforce, oracle Eloqua, NetSuite and other cloud connectors.

Environment: mule 4, Anypoint Studio, Anypoint API manager, Postman, RAML, CICD, Github, xml, java, Oracle, SQL Server

Confidential, Alpharetta, GA

ETL DEVELOPER

Responsibilities:

• Designed and Led the Development effort for CCAT which is “automated” consumer transaction/event monitoring and reporting platform leveraging Actimize® rules modules executed against consumer data for consumer compliance event surveillance monitoring. The CCAT system integrates with various disparate Consumer and Small Business Card, Card Claims, Banking Center Deposits and Payment systems to extract data necessary for the Global Compliance - Consumer Compliance Testing (CCT) Team to follow an established framework for compliance testing which is in line with applicable regulatory and industry standards.
• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, to SQL Server.
• Created complex SSIS packages using various transformations.
• SILAS (Short Interest Large Aggregation System) platform for Confidential Merrill Lynch Disclosure reporting, incorporating Short Selling, Large Shareholder Report and Reg K disclosure reporting capability.
• Equity Aggregation reporting system designed in order to generate accurate substantial position disclosure reporting, generate long position reporting thus calculating the percentage of ownership by the firm in AMRS, APR and EMEA regions.
• Demonstrated skills in interviewing business and technical leaders to gather and clarify business requirements. Authored High level design documents, Low level design documents, work break down structure. Took lead role in numerous projects and consistently exceeded customer expectations.

Environment: Informatica PowerCenter 9.5.1, Informatica PowerExchange 9.5.1 Actimize, Oracle EXADATA, DB2, Teradata, Autosys, UNIX, ERWin, SVN.

Confidential

Lead ETL

Responsibilities:

• My responsibilities are to coordinate with Business Analyst and Data Modeler and design the ETL for the new feeds.
• Prepare the ETL design document and coordinate with developers to build the ETL process.
• Perform data analysis and scheduling meetings to walkthrough ETL design documents with Onsite and offshore teams.
• Be the lead responsible person for complete Project lifecycle, from Initiation of the Project till code migration to Production and support.
• Built Microsoft SQL Server Integration Services (SSIS) packages for data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

Environment: Informatica PowerCenter 8.6 (Repository Manager, Repository Server Administration Console, Designer, Workflow Manager, Workflow Monitor), SQL Server Integration Services (SSIS), Oracle 10g, PL/SQL, Toad, OBIEE, Share point, Autosys, Windows, UNIX, UNIX Shell Scripting, CVS, SVN.

Confidential, CA

ETL/Informatica Team Lead

Responsibilities:

• Built a CRM application using which users can view background information about the client or prospect before interacting with them in order to provide a better quality of service. Users can use activity records to log such details on a regular basis for assessing the past and present banking relationships.
• Built a Profitability mart using which users can generate profit and loss reports which help higher management in making critical decisions.
• Built Revenue and Assets application, the purpose of this application is to collect all the positions of the reporting month and calculate all the revenue components like Net Interest Income, Non Interest Revenue etc.
• Worked on building CMS mart which is the collateral and exposure management system for the Private Bank (PB). It provides a holistic view of assets and liabilities for all PB clients. System functions include lending value assignment, special deal creation and maintenance, collateral optimization, availability and buying power calculation, margin call generation and management, credit portfolio reporting, transaction reporting, and regulatory reporting.
• Participated in the data mart design sessions and was one of the key members in the design group.
• Manage multiple project teams onsite, onshore and offshore.
• Lead Development teams in Data Warehouse projects.
• Develop Informatica mappings to build the respective marts.
• Developed UDT transformations which have the logic to convert multi sheet xls to xml.
• Worked with COBOL files as source files for the mappings.
• Develop DTS packages in SQL server.
• Developed ETL code using SAS Data Integration studio for Profitability project.
• Understand the existing system, process, scripts and procedures used. Perform the required modifications or write new once and apply them to the current project.
• Schedule the jobs using CA Scheduler.
• Migrate code to SIT, UAT and PROD.
• Provide Production support for the applications which are in production and also work on the on going projects.

Environment: Informatica PowerCenter 8.6/7.x (Repository Manager, Repository Server Administration Console, Designer, Workflow Manager, Workflow Monitor), Power Exchange, Informatica Data Transformation Studio, Business Objects, SQL Server 2000, Sybase server, Netezza, PL/SQL, DBArtisan, Rapid SQL, SAS Data Integration Studio, CA Scheduler, DTS, Windows, UNIX, UNIX Shell Scripting, CVS, SVN.