NAGARAJ BIJJALA

Email: adb58p@r.postjobfree.com

Ph: 646-***-****

Mulesoft / Data Warehousing/ETL / Informatica / Business Intelligence / OLAP / Oracle / Sybase / SQL Server DTS / SQL / PL-SQL / Data Modeling / UNIX / Shell Scripting

SUMMARY:

4+ years of experience in design and development of API’s using mulesoft.

11+ 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.

Education:

Masters of Science, Rochester Institute of Technology, Rochester, NY, USA. (2003 – 2005)

Bachelor of Engineering in Instrumentation, VRSEC, Nagarjuna University, India.

Perficient, Jul’19 – current

Lead Mulesoft Consultant

Projects & Responsibilities

Designing and developing API’s in API-Led architecture and documenting through RAML.

Helping team in understanding MuleSoft and guiding and reviewing the code.

Working with cross functional teams to capture the requirements and creating the mapping documents.

Developed API’s integrating Legacy and Database systems and move data to Salesforce Health cloud.

Worked with Texas Health Resource to understand their complex data (Patient, Leads, Assessments, Encounters etc) and delivered what is required to build Sales force application for them.

Environment: mule 4, Anypoint Studio, Anypoint API manager, Postman, RAML, Cloud hub, Teradata.

Bank of America- Alpharetta, GA, Feb’16 – Jul’19

Mulesoft API Designer/DEVELOPER

Projects & Responsibilities

• 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.

• Worked on POC for integrating different system like SAP, Salesforce, oracle Eloqua, NetSuite and other cloud connectors.

• Worked on migration project, migrated existing API’s on version 3.x to 4.x

Environment: mule 4, Anypoint Studio, Anypoint API manager, Postman, RAML, CICD, Github, xml, java, Oracle, SQL Server, SpringBoot, Spring REST services, JPA

Bank of America- Alpharetta, GA, Aug’10 – Jan’16

ETL DEVELOPER

Projects & 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 Bank of America 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.

Bank of America

Software Guidance & Assistance- Jersey City Aug’09 – Jul’10

Lead ETL

Projects & Responsibilities

CSDR (Compliance Solution Data Repository) is the single source of data repository for all ML and BAC compliance requirements. Data received from various domain feeds gets loaded into CSDR. Multiple downstream systems consume the data of CSDR for various business requirements like Trade Surveillance, Reporting etc.

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.

ADORESOFT CORPORATION, CA Aug’05 – Aug’09

ETL/Informatica Team Lead

Client: J.P.Morgan Chase

Projects & Responsibilities

MIS Unification is a long-term strategic program established to enhance the efficiency, quality, and accuracy of financial management reporting. The program has defined multiple projects enabling the ability to achieve the strategic end-state. Asset flows capture changes in client account asset balances stemming from activities initiated by the client or client advisor as part of managing the client’s portfolio. It is a key performance metric for JPMorgan Private Bank The goal of this project is to track Flows so that management can assess banker and product area performance on a weekly, monthly, or annual basis. Transactions are utilized as the basis for Flow reporting and serve as the best measure to create an approximation of Flows within Private Banking.

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.

Thot Solution, Hyderabad, AP, India June’01- Aug’03

Oracle Programmer

Responsibilities:

Actively participated in the requirement analysis, database design and modeling.

Participated in the implementation of a payroll system using SQL, Oracle forms & triggers on UNIX platform.

Also involved in performing development tasks such as writing extensive PL/SQL programs units like triggers and forms.

Involved in database administration. Design, development and implementation.

Responsible for development of forms and interfacing the data selection from the database.

Assisted in the Development of several reports including tabular, master detail reports.

Environment: Oracle 7.3, SQL, PL/SQL, TOAD, Oracle Developer 6i, WinNT4.0.

Contact this candidate