SUMMARY

• Over Twelve years of experience primarily in Business Intelligence and Data Warehousing Development and Production Support.
• Expertise in multiple enterprise reporting tools including Tableau, OBIEE, BO, Jasper and Crystal
• Proficient in Oracle 10g/9i/8i, PL/SQL Developer, MySQL, Perl, Sun Solaris and HP UNIX, Korn Shell Scripting.
• Strong Experience in data warehouse Building, OLAP and OLTP systems, Maintenance and Support which uses ORACLE 8i/9i/10g Databases, MySQL, SQL, PL/SQL, SQL* Loader, Shell Scripts, Business Objects, Oracle Express Language in windows NT and Unix environment.
• Strong Knowledge of Data Warehousing concepts, RDBMS and Dimensional modeling primarily Star & snowflake schemas using ERWIN, Fact and Dimension Tables, De - normalization, Normalization, Logical & Physical Data Modeling.
• Expertise in Tuning of Procedures, Packages, SQL
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors, Dynamic SQL, Oracle Analytical Functions, Exception Handling, Materialized views and views for processing data, enforcing referential integrity and needed business rules.
• Designing, Coding, Testing and implementation of High Availability Distributed System.
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects.
• Involved in Data modeling, E/R diagrams, normalization and de-normalization as per business requirements.
• Experience in Data Migration, SQL Loader.
• Experience with Crystal Reports, iReports, TLM, Business Objects, Jasper Server and Jasper ETL, Autosys, AscentialDataStage 7.5.1, Informatica Powercentre 8.6
• Strong experience in financial industry.
• Excellent analytical and problem solving skills and can work independently.
• Excellent Communication and responsible team player.
• Quick learner with ability to master new concepts and applications.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/2003, Solaris 10, HP-UX 10/11, AIX, Linux

Programming languages: C, C++, VC++,C#, Java, PL/SQL programming, RDJ 8.3.2, Axway Accounting Integrator

Web Technologies: HTML, JSP

Script Languages: JavaScript, Shell scripting, Perl

Tools: Toad, OEM, PL/SQL Oracle Developer/2000, Oracle Forms/Reports 6i/9i/10g, Tableau, Crystal Reports, Cognos, Jasper Server 3.1,3.7,4.0.2,4.5, iReport, WebFocus, Autosys, TLM, Citrix, Reflections for Unix, Business Objects, Datastage, Informatica Powercentre 8.6/9.5

Database: Oracle 11g/10G/9i/8i/8, MS Access 2000, MySQL

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. PL/SQL ETL Tableau Developer/Lead

Responsibilities:

• Analyze the functional & technical requirements and of the project.
• Discuss with business users, BA's and UI Architects to finalize requirements and scope of the project.
• Design the Database and ETL framework for the new enhanced UI for SCT tool
• Design and provide Database service call contracts to Java/UI team
• Provide development, CUT, and SIT estimates to project services team
• Create functional and technical documents.
• Lead team of 8 offshore (CTS Pune) ETL developers.
• Assign work to offshore and have nightly hand-shake calls.
• Create new tables, views, materialized views, Packages, Stored Procedures and functions per the requirements.
• Create new Informatica Mappings as required. Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank, Union, Normalizer, and Update Strategy & Sequence Generator.
• Perform code review and make changes/improvements as required
• Optimize the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance
• Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested.
• Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams like DBAs, Unix Admins, Informatica Admins etc.
• Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data as per mappings
• Designed and developed intuitive Tableau Dashboards against SCT to bring visibility on Trade events process and performance.
• Built Tableau visualizations by connecting to various Data Sources Relational Databases(Oracle, SQL Server)
• Built reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Designed and deployed interactive reports with Drill Downs, Drop down menu option, Parameters and Linked reports using Tableau.
• Created variety of visualizations and dashboards, reference lines, sets, groups, trend analysis and forecasting according to business requirement specifications.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Experience withActive Directory Integration within Tableau Environment for automated user provisioning.
• Generated Tableau reports with Trend lines, forecasting, groups and sets, top N rank reports.
• Performed Tableau Admin related activities like Tableau Server installation, backup, upgrades and performance tuning
• Created users, groups, security roles and SSL authentications.
• Performance tuning of DB and Tableau Server, data sources, workbooks, extracts etc.
• Extensively used TabAdmin and TabCmd
• Performance tuning, Trouble shooting and support of existing system.
• Modify BO universe as required, schedule several BO reports for high profile stake holders.
• Work and coordinated migration of Oracle 10g to 11g.

Environment: Oracle 11.0.2, Oracle 10G, PL/SQL, Rapid SQL 7.6, PLSQL Developer, Informatica PowerCenter 8.6.1, Windows Server 2008, Tableau 7x/8x, SAP BO XI

Confidential

Big Data - Hadoop Sr.Oracle PL/SQL ETL Reporting Developer

Responsibilities:

• Analyze the functional & technical requirements of project and Study project scope
• Developed Prototypes for ACS - Administration of Child care services and Big data to present to all commissioners.
• Developed mobile app for prototype using Corona.
• Install IBM DataStage InfoSpehere 8.7 on a Windows Server for Sandy Door to Door project (Mayor's office)
• Designed ETL strategy for Sandy project.
• Created reports on Sandy extract using iReport.
• Created dashboard reports using OBIEE
• Schedule reports on Jasper Server

Environment: OBIEE 11G, Oracle 10.0.2, Oracle 11G, PL/SQL, Rapid SQL 7.6, DataStage Infosphere 8.7, Windows Server 2008, Corona, Jasper Server 4.5

Confidential

Responsibilities:

• Upgrade existing Jasper reports from version 3.1.1 to 4.5
• Convert reports from Oracle to Jasper.
• Proposed changes to the existing Database Architecture as per requirements and Involved in redesign of database.
• Modified existing ETL processes as per new requirements.
• Manage and mentor 2 junior developers on Jasper Reports 4.5, assign tasks and review day-to-day tasks.
• Create new Input Controls, Drop down lists, resource bundles on the Jasper Server.
• Create new Users, Roles and manage Jasper Server Reporisory.
• Created Book of reports which enables users to select reports runtime dynamically.
• Upgrade financial reports according to the specifications of different Fund Managers and Investment Advisors.
• Designed and developed Adhoc reports, Summary Reports, KPI's, performance reports, Complex reports with many sub reports and evaluation conditions Jasper Server and iReport 4.5
• Design, develop and deploy user friendly and rich looking Financial and Billing reports using iReport and deployed onto Jasper Server.
• Developed XML Schemas to create OLAP Cubes for analysis of complex data in different dimensions using Jasper Analysis.
• Incorporated IT services management changes into Jasper and real-time feed processing using ETL.
• Extensively performed Unit Testing & Integration Testing with different test cases.
• Used Hummingbird Exceed to connect to the UNIX server.
• Used TortoiseCVS control version for synchronizing the upgradations.
• Coordinated with the team of java developers to accomplish complex financial calculations.
• 24/7 oncall production support.
• Built Pilot project and demonstrated capabilities of Tableau Visualizations to business users.
• Conducted various discussions with Management in order finalize target visualizations.
• Generated Dashboards by joining multiple complex tables
• Designed and deployed complex visualizations involving parameters, drill downs and complex business logic.
• Performed Unit testing of visualization by comparing data in dashboards vs Data in Data Warehouse.
• Built visualizations against OLTP and OLAP(Star and Snow Flake) Schemas

Environment:, Jasper Server 4.5/3.1.1/1.3.0 , Jasper ETL, Jasper Analysis, iReport 4.5/3.1.1/1.3.0 , Tableau 6, Oracle 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Toad, MySQL 5.0.27, ITSM, Jasper ETL, Jasper Analysis, Java, Sun Solaris, Unix Shell Scripting

Confidential, NewYork

Sr.Oracle PL/SQL ETL OBIEE/Reporting Lead

Responsibilities:

• Replace the exiting local OMR system (in US) with “Calypso”, the standard implemented in the Paris head-quarters.
• Analyze the functional & technical requirements of project.
• Involved in Logical and physical modeling.
• Manage team of 3 people, create project plans, conduct meetings, perform code reviews.
• Designed and developed ETL process from scratch for this new system using Oracle, PL/SQL and Unix.
• Designed Fact and dimension tables and handled slowly changing dimensions.
• Create new Tables, Indexes, Views, Materialized Views, Table Partitions as per the requirement.
• Create SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL FILE
• Wrote complex stored procedures and packages.
• Create complex structures & functions in C.
• Create complex PRO-C scripts to connect to DB from C
• Create new Structures, Input/Output Events, and Sources in RDJ for new rules.
• Create & Modify Transformation, Change, Balancing, Aggregate & Audit rules in RDJ8.3.2 as per the requirement.
• Validate, extract and send the rules to File Manager, compile and move them to production.
• Move data between databases using Import/Export.
• Extensively used Explain Plan and TKProf utilities to fine tune and improve the performance of application.
• Extensively used hints to tune & optimize queries using DB links.
• Used DRIVING SITE, HASH, INDEX, NO USE NL, etc hints to optimize queries.
• Wrote complex shell scripts for processing of rules.
• Used $UNIVERSE scheduler to schedule ORACLE & non oracle jobs.
• Created Test scripts and involved in Unit, Integration and System testing.
• Wrote FTP scripts for transferring files between different machines, FTP checks to ensure complete file transfers, new Daily backup scripts to copy last 5 days of files to disaster recovery (DR) system.
• Used PUTTY & Reflections to connect to UNIX machines.
• Wrote complex shell scripts using AWK, SED.
• Used Rapid SQL & SQL Developer to access DB, write packages, procedures & functions.
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
• Extensively worked with various Passive transformations like Expression, Lookup (connected and unconnected), Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Developed Mapplets to implement business rules using complex logic.
• Extensively worked on end-to-end OBIEE design and architecture, including repository, reports and Dashboards development.
• Design and Development of pre-session, post-session and batch execution routines to run Informatica sessions using Informatica Server manager.
• Used Debugger to check the errors in mapping.
• Implement Change control and release management, plan the change and co-ordinate with various teams on ITSM processes.
• Customization and configuration of OBIEE using Answers, Dashboards, Administration Tool(RPD)
• Created semantic layers, dashboards, reports, etc using OBIEE
• 24/7 on call support and resolve P1 issues immediately.
• Guide/help team members in resolving technical issues.
• Assign work to other team members.
• Create adhoc reports using Business Objects XI, for Finance users.
• Provide 24/7 oncall production support, resolve P1, P2 issues immediately

Environment: Oracle 9i(9.2.0.1.0), Oracle 10.0.2, Informatica 8.6.1, OBIEE/Siebel Analytics, SQL, PL/SQL, Rapid SQL 7.6, SQL Developer, UNIX, SH, Windows NT, Reflection for UNIX, RDJ 8.3.2/9, Oracle Apps 11.5, Business Objects XI

Confidential -Plough, NJ

Sr.Oracle PL/SQL ETL Developer

Responsibilities:

• Involved in gathering business requirements.
• Analyzed the requirements and converted them into technical specifications.
• Created technical design document for the dependant down-stream systems.
• Manage and co-ordinate with offshore team in India-IBM
• Created new Tables, Indexes, Views, Materialized Views, Table Partitions as per the requirement.
• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema using SQLLDR, Export/Import.
• Created new mappings, modified existing mappings using Informatica Powercentre 8.6
• Modified existing and created new SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Extensively used PL/SQL Collections, Table Types and Record Types.
• Used Bulk Collect and For All for processing huge volumes of data.
• Extensively used UTL FILE, DBMS XMLGen for creating flat files and XML files used by the down stream systems.
• Extensively used DBMS SQL, Execute Immediate for dynamic sql.
• Extensively used Analytical functions for complex reporting purposes and hierarchial data
• Extensively worked on Cursor, RefCursor for data processing.
• Used Exception Handling to handle runtime & user defined exceptions.
• Modified existing Shell Scripts and created new Korn Shell Scripts.
• Used AWK, Sed utilities.
• Scheduled Jobs using Crontab.
• Created Test scripts and involved in Unit, Integration and System testing.
• Used Import/Export utility to move data from one DB to other.
• Used Explain Plan and TKProf utilities to fine tune and improve the performance of application and database.
• Created new and modified existing Universe items of Business Objects.
• Prepared System level and user level maintenance documentation.
• Coordinate with Off Shore team.
• Used Reflections for UNIX and Citrix to connect to the UNIX box.

Environment: Oracle 9i(9.2.0.1.0), Oracle 10g (10.2.0.3.0 ), SQL, PL/SQL, TOAD 9.7.2, PLSQL Developer, Unix, Korn Shell Scripting, Windows NT, Reflection for Unix, Citrix, Informatica Powercentre 8.6, Business Objects