PROFESSIONAL SUMMARY:

• 8 years of working experience in software design, development, testing, coordination and project management.
• Specialist in building and executing various ETL methodologies using the widely used tools such as MS SSIS, Informatica and SAP BODS.
• Strong experience in design, building and loading transactional and relational databases and Data warehouses.
• Very good understanding of dimensional modeling and implementation of dimensional modeling.
• Strong development experience in ETL using Informatica Power Center.
• Long working experience with multiple databases such as Oracle 9i/10g/11g, MS SQL Server2005/2008, DB2 and Sybase.
• Expert in PL/SQL programming using advanced coding methods, creation and tuning of database components in Oracle Relational Database Management System (RDBMS).
• Expertise in Client - Server application development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD,Rapid SQL and SQL*LOADER.
• Long experience in Enterprise Data Warehouse ( EDW) development .
• Experience in creating reusable transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Strong experience in Data warehouse concepts and got working experience with ETL tools such as SSIS and Data Stage as well.
• Strong ETL experience using Business Objects Data Integrator XI (BODI) /Data-services xi3.2, 4.0(BODS).
• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Experienced professional in various reporting methodologies involving SAP Crystal Reports - XIR4 and SSRS.
• Expert in creation of complex reports using SAP Business Objects - XIR2/XIR4 involving multiple business logics, algorithms, graphs, sub reports using data from different databases such Oracle, DB2 .
• Experienced professional in using Crystal Reports API and generation of reports in HTML viewer and Crystal viewer.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experience in Object oriented analysis, design/development methodologies.
• Expert in creation of Core Java applications and integrate them in UNIX shell scripts.
• Expert in creating UNIX shell scripts involving complex logic, FTPs, usage of awk,sed, transforming data files, reporting and file transfer process for business implementation.
• Experienced resource in creation of perl scripts for creating and transforming files for data loading.
• Very flexible in working with tools like Eclipse, Rapid SQL, SAP Crystal Designer, Toad, SQL Server MS, BIDS, Control-M, Power builder.
• Strong knowledge of batch jobs scheduling using Control-M /crontab and utilize them for ETL and reporting process.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Strong business knowledge in banking and financial sector, especially in Securities Lending
• Experience in working with US users as business analyst for Securities Lending project
• Excellent communication, interpersonal, analytic skills and strong ability to perform as part of a team.
• Long experience in working directly with US and UK clients.
• Long experience in project cost estimation and resource management.

TECHNICAL SKILLS:

Database Development: Oracle PL/SQL, MS SQL, TSQL

ETL Tools: Informatica Power Center, SAP BODS/Data Integrator, MS SSIS

Reporting Tools: SAP Crystal Reports - Business Objects Developer Suite /BO XIR2/XIR4, SSRS

Application servers: Oracle WebLogic

Databases: Oracle DB (12c, 11g, 10g, 9i), MS SQL Server, Sybase, MS Access

Tools: Toad, Eclipse, SAP Crystal Designer, Rapid SQL,SSMS

Control: M, Crontab, Automic ( UC4 )

Version control tools: PVCS, TFS

PROFESSIONAL EXPERIENCE:

ETL/BI Senior Developer

Confidential, Chicago, IL

Responsibilities:

• Worked as a program designer, analyst and senior ETL/BI developer for the BPC team .
• Worked in multiple projects for the team in design, creation and loading of new database models in SQL Server and Oracle 11g for two key applications for the client.
• Worked in database migration projects involving the design of new Database models and merging data from various legacy applications to the new environment.
• Designed and implemented the dimensional model and Informatica 9.1 ETL for the TFIM ( Transaction Fees and Invoice Management ) project in Oracle 11g.
• Developed dimensional model for the TFIM reporting and created OLTP model for the legacy application enhancements.
• Developed many workflows using mapplets, Reusable Transformations, Source and Target definitions and many mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica Power Center.
• Worked on the normalization and de-normalization of data models to optimize the performance of reconciliation and reporting logics.
• Worked in multiple projects and designed and developed the Automic (UC4) workflows and schedules and automated the SQL, Unix, file transfer and Windows jobs through it.
• Moved the SQL scheduled jobs to batch processing scheduled through UC4 .
• Created Unix shell scripts as part of the process automation and scheduled the jobs through UC4.
• Worked on the enhancement projects for the reconciliation tool - NewClear for the client, analyzed and fixed the existing production issues.
• Worked on the development requests for the Allocation - Reporting - Reconciliation applications.
• Involved in database design and modelling for the client analytical project and implemented in SQL server 2008.
• Created project specification, design and testing documentations and worked in database and process enhancement projects.
• Created database objects - Tables, Procedures, Functions, DB links, Triggers in SQL server and Oracle data bases as part of the new project enhancements.
• Designed, created and deployed ETL models in SAP BODS.
• Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from the legacy systems and load the data into target database. Writing SQL Statements in DI scripts to modify data. Created initial and delta loads.
• Worked on Business Objects Data-Integrator, and used functions like lookup, date, conversions, etc in mappings.
• Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implemented in Data Integrator jobs.
• Coordinated with the application teams, vendor teams and support teams to fix the existing application issues and to enhance the functionalities.
• Worked directly with key clients on requirement gathering and testing.
• Within the short period, learned the application systems and worked in multiple enhancements and automation projects.

Technologies: SQL, TSQL, Oracle PL/SQL, Shell scripting, Perl scriptingEnvironments: Informatica 9.1,SQL Server 2008, SAP BODS, SSIS, SSRS, Oracle 11g, UNIX, MS Access.

Senior Associate Projects

Confidential - Chicago, IL

Responsibilities:

• Worked as a program designer, analyst, developer and project coordinator and worked on multiple technologies.
• Developed new reporting application components and data base components.
• Designed and implemented ETL techniques using multiple tools for different projects.
• Created various data models for transactional and reporting databases and also created ER Diagrams.
• Worked on ER Studio, ERWin for the creation of data models.
• Part of reporting technical team for last three years from Chicago location for the client who is one of the top global banks in investment banking and asset management sector.
• Executed projects in multiple technologies involving Oracle PL/SQL, TSQL, Java, UNIX shell scripting, Perl scripting and worked on ETL and reporting tools - SSIS, Informatica PowerCenter, Business Objects XIR4 and SSRS .
• Implemented ETL logic for new application using UNIX jobs, SQL Loader, Java programs and Oracle stored procedures for Equilend projects.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.
• Worked on ETL projects in MS SSIS and involved in designing, creating packages and scheduling the job to implement the ETL in MS SQL Server.
• Worked on creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Enhanced existing workflows for various project requirements and fixed production issues in Informatica PowerCenter.
• Created ETL logics for various project requirements involving simple and complex workflows using Informatica PowerCenter tool.
• Developed and enhanced the Java application for the risk reporting team of the client.
• Wroe Unix Shell scripts to process the files to transform it to the required format so that it can be loaded to the Oracle tables.
• Created automated process using UNIX shell scripts and perl scripts to get the requests and send the confirmation files to the client servers by pgp encrypted FTP and SFTP.
• Implemented client reports using the scheduled UNIX jobs coded in shell scripts and PL/SQL stored procedures.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Worked as the project lead, analyst, designer and developer for multiple client reporting projects for the securities lending business for the client.
• Using the expertise knowledge in various client specific tools ensured the quality and timely delivery of projects for the client.
• Coordinated the project tasks with offshore team, and implemented more than 8 development projects and many other enhancement projects as part of Oracle/Java/Unix/ETL team.
• Worked with the client partners in requirement gathering and converted the business requirements to technical requirements.
• Designed, developed and implemented reports for the securities lending clients based on the user and business requirements .
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Worked on architecture upgrade projects such as JavaArch11 upgrade, BO XIR4 upgrade, Oracle 11g migration, UNIX server upgrade projects.
• Worked also as a business analyst role utilizing the deep business knowledge in the securities lending systems to create business requirements documents after the analysis, studies and discussion on the user requests and business problems.

Environment: s: Oracle 9i/10g/11g, UNIX, DB2, WebLogic, SQL Server, MS Access,SQL Server 2008/2005,SQL Integration Services(SSIS),ERWin, ER Studio, Business Intelligence Development Studio, Informatica PowerCenter 8.6.1.

ETL Project lead

Confidential, Chicago, IL

Responsibilities:

• Worked as an analyst, developer and project coordinator for the ETL project for banking client.
• Involved in the design and development of new data warehouse components - Oracle 10g, ETL using Informatica PowerCenter and developing Oracle PL/SQL procedures/functions for reporting for the Investors Work Station project and PFS - IS projects.
• Developed and supported the Extraction, Transformation and Load process (ETL) for Oracle data warehouse from DB2 database using Informatica PowerCenter.
• Developed mappings, sessions and work flows in Informatica Power Center.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Involved in Performance tuning of complex queries.
• Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Created and modified many Shell Scripts such as Job Archival scripts, Email notification Scripts, Record Mis-match/Match Scripts.
• Developed shell scripts for Daily and weekly Loads and scheduled them using Control-M.
• Worked with business analysts to get the business requirement details and convert to the technical requirements.
• Coordinated with the upstream teams to get the data details and set up the data transmission and load.
• Responsible to create technical specification documents, disaster recovery documentations and process documents for the project.
• Involved in supporting the projects after the production release and fixing the issues, coordinating with multiple teams, conducting meetings with business analysts and management, reviewing the documentation, codes and test results and was responsible to maintain the quality standards.

Environment: Oracle 11g,SQL Server 2008, UNIX

ETL Project lead

Confidential

Responsibilities:

• Worked as the project coordinator for the new reporting project enhancements for the banking client.
• Coordinated a team of 4 members to design and develop the database components such as Tables, PL/SQL procedures, Triggers, Functions, views etc.
• Implemented in project successfully which had a very aggressive time line
• Created database models for the new reporting system using ERWin and implemented the ETL through Informatica.
• Implemented new client reporting tools and ETL logic using Informatica PowerCenter, PL/SQL, Core Java, Crystal Reports and UNIX shell scripting.
• Trained new resources at offshore location in Oracle, Unix and Crystal reports.
• Analyzed the business requirements and created the detailed technical requirements documents based for that.
• Coordinated directly with the client team and business analysts to gather the details required for the technical development.
• Handled the role of project coordinator from offshore location for the client.
• Debugged and fixed the issues in existing application components.

Environment: Oracle 10g, UNIX Toad, Rapid SQL

ETL Project lead

Confidential

Responsibilities:

• Designed and implemented three short term development \enhancement projects working from the near shore location in Mexico.
• Conducted interviews and recruited new Oracle/Unix resources to work from near shore location.
• Trained the recruited resources in Oracle, UNIX and Crystal reports technologies and allocated then to support the application from near shore location in Mexico.
• Oversaw major new enhancements to existing software systems.
• Developed a new migrate tool in UNIX and implemented in client's application for the client server migrations and staging.
• Developed new reports templates and Oracle stored procedures for the client reporting project.
• Enhanced and fixed bugs in the data flows and ETL process for the securities lending application for the client using SQL Loader, UNIX shell scripts and Oracle PL/SQL procedures.
• Enhanced Java application user interface so that the new functionality can be supported for the Global Securities Lending application.

Environment: Oracle 10g, UNIX, WebLogic Toad, Rapid SQL

Java Developer

Confidential

Responsibilities:

• Involved in Design, Development, and Testing and Support phases of Software Development Life Cycle (SDLC).
• Worked for the Securities lending project for the client, in various new and enhancement projects to enable the data flow and storage in multiple systems.
• Joining as a programmer analyst trainee got trained in Advanced Java, Data Warehousing and Unix shell scripting.
• Allocated to development projects and involved in Requirements gathering, Requirement analysis, defining scope, Design analysis, impact analysis, Integration and deployment.
• Designed and developed various modules of the application with J2EE design architecture for Java application enhancement project and worked on EJB model with JDBC, JSP,HTML,CSS,JavaScript, MQ API.
• Designed and developed DAO layer using JDBC to access the database.
• Designed and developed transactional and analytical data structures.
• Used XSLT for transforming the XML content into HTML and PDF.
• Debugged and modified software components.
• Worked on ETL projects in MS SSIS and involved in designing, creating packages and scheduling the job to implement the ETL in MS SQL Server.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Worked on creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005.
• Worked for various upgrade projects from start to end - like Oracle data base upgrade, Unix server upgrades, DB2 client upgrade, Business objects upgrade.
• Provided extensive pre-delivery support using Bug Fixing and Code Reviews
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from disparate systems using Data stage Designer.
• Designed and developed parallel jobs to extract data, clean, transform, and to load the target tables using the Data stage Designer
• Production support tasks including handling the user requests and bug fixes for the applications built in Java, Oracle and UNIX.
• Implemented ETL logic for new application using UNIX jobs, SQL Loader, Java programs and Oracle stored procedures.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Environment: Oracle 10g, UNIX, Linux, WebLogic,SQL Server 2005.