We provide IT Staff Augmentation Services!

Sr Etl Bi Architect Resume Profile

NY

SUMMARY

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

SKILL SET:

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

WORK EXPERIENCE

Confidential

Sr ETL BI Architect/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.
  • Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data as per mappings
  • Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams like DBAs, Unix Admins, Informatica Admins etc.
  • Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested.
  • Optimize the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance
  • Perform code review and make changes/improvements as required
  • 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.
  • Create new tables, views, materialized views, Packages, Stored Procedures and functions per the requirements.
  • 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 with Active Directory Integration within Tableau Environment for automated user provisioning.
  • Generated Tableau reports with Trend lines, forecasting, groups and sets, top N rank reports.
  • 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

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

Architect

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

Sr.Oracle PL/SQL

  • 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.
  • Design and Development of pre-session, post-session and batch execution routines to run Informatica sessions using Informatica Server manager.
  • Extensively worked on end-to-end OBIEE design and architecture, including repository, reports and Dashboards development.
  • Developed Mapplets to implement business rules using complex logic.
  • Extensively worked with various Passive transformations like Expression, Lookup connected and unconnected , Sequence Generator, Mapplet Input and Mapplet Output transformations.
  • Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
  • Used Rapid SQL SQL Developer to access DB, write packages, procedures functions.
  • Wrote complex shell scripts using AWK, SED.
  • Used PUTTY Reflections to connect to UNIX machines.
  • 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.
  • Created Test scripts and involved in Unit, Integration and System testing.
  • 24/7 on call support and resolve P1 issues immediately.
  • Created semantic layers, dashboards, reports, etc using OBIEE
  • Customization and configuration of OBIEE using Answers, Dashboards, Administration Tool RPD
  • Implement Change control and release management, plan the change and co-ordinate with various teams on ITSM processes.
  • Used Debugger to check the errors in mapping.
  • 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

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

Confidential

Sr.Oracle PL/SQL, Jasper BI Developer

Responsibilities:

  • Work with Fund Managers Investment advisors to get the requirements.
  • Proposed changes to the existing Database Architecture as per requirements and Involved in redesign of database.
  • Used ERWIN for Logical and physical Data Modeling and reading the schema designs.
  • Translated the business requirements into technical requirements, conduct meetings for approvals and document solutions.
  • Migration from Oracle 10g to MySQL 5.0.27.
  • Designed ETL process for the datamarts from scratch.
  • Designed Fact dimension tables, Indexes and handled slowly changing dimensions.
  • Manage and mentor 2 junior developers, assign tasks and review day-to-day tasks.
  • Created new Tables, Indexes, and Sequences where needed.
  • Wrote complex PL/SQL Procedures with Cursors, Ref Cursors and Complex Functions to do various financial calculations and to calculate Rate of Return for monthly, quarterly, yearly, calendar year returns trailing year returns both Annualized Compounded.
  • Modified existing and designed new user interfaces using Oracle 10g Forms.
  • Created new mappings, modified existing mappings using Informatica Power center 8.1
  • Used various active and passive transformations, connected and unconnected look ups, mapplets, workflows, and sessions.
  • Created mappings to get the data from XML and flat files, from multiple sources into Target.
  • Developed 100's of financial reports according to the specifications of different Fund Managers and Investment Advisors.
  • Created Sun Solaris UNIX Shell scripts for automating the execution process.
  • Working on assigned tickets and resolve day-to-day issues in the OLTP and production systems.
  • Follow and implement several ITSM processes like Change Management, Release Management, Configuration Management, Service Level Agreements, Problem and Incident Management tailored to client specific.
  • Developed SQL loader scripts to load data in the custom tables.
  • Scheduled jobs using Autosys
  • Created batch jobs for the data cleansing and generation of summarized reports.
  • Developed Cash reconciliations and Securities reconciliations, reports using third party tool TLM
  • Developed XML Schemas to create OLAP Cubes for analysis of complex data in different dimensions using Jasper Analysis.
  • Design, develop and deploy user friendly and rich looking Financial and Billing reports using Oracle PL/SQL, Analytic Functions, SQL, iReport and deployed onto Jasper Server.
  • Designed and developed Adhoc reports, Asset Allocation, Portfolio Summary and Portfolio Activity, Transactional summary and detailed, Calendar Year and Trailing year returns performance reports, KPI's, Complex reports with many sub reports and evaluation conditions using Crystal Reports, Jasper Server and iReport
  • Experience on BEA Tuxedo.
  • Created database triggers for data security Consistency.
  • 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.
  • Created Materialized views normal views where business requirements needed.
  • Tune the SQL queries and complex procedures to improve performance decrease response time utilizing TkProf, Explain Plan and Hints.
  • Coordinated with the team of java developers to accomplish complex financial calculations.
  • 24/7 oncall production support.

Environment: Oracle 10g, Oracle 10g Developer Suite Forms/Reports, SQL, PL/SQL, SQL Plus, SQL Loader, Toad, MySQL 5.0.27, ITSM, Informatica Power center 8.1,Crystal Reports, Autosys ,Jasper Server 1.3.0/3.1.1, Jasper ETL, Jasper Analysis, iReport 1.3.0/3.1.1, TLM, Java, Sun Solaris, Unix Shell Scripting

Confidential

Sr.Oracle PL/SQL Developer.

Responsibilities:

  • Involved in Data Modeling using ERWIN
  • Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema.
  • Altering the database Objects to synchronize it with the new Schema created.
  • Understanding the business logic to modify existing SQL Code and Performance Tuning if it requires.
  • Used Sqlldr for loading the database tables with huge volumes of data from Old Schema.
  • Used Data Stage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into target tables.
  • Involved into updating procedures, functions, triggers and packages based on the change requests.
  • Involved in writing procedures, functions, triggers and packages for new requirements.
  • Import Export database for validation and performance testing.
  • Provided Test Data to QA team to validate front end application. Also performed unit testing.
  • Requirements Analysis, Specification and Development of Web Focus reports for internal and external users.
  • Involved to prepare user level and system level maintenance documentation.

Environment: Oracle 10g/9i, SQL, PL-SQL, SQL Plus, Toad, Stored Procedures, Functions and Triggers, HP UNIX, UNIX Shell Scripting, Web Focus, Ascential DataStage

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Participated in the full software life cycle.
  • Participation in weekly design reviews and walkthroughs with project manager and development team.
  • Worked on database design with the team.
  • Measured the performance of the shell scripts by getting the expected results.
  • Writing PL/SQL code using the technical and functional specifications
  • Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
  • Involved in writing PL/SQL Packages, Functions and Stored Procedures and Data Base Triggers.
  • Scheduled batch jobs using Autosys
  • Developed complex SQL queries to retrieve the data
  • Documented business rules, functional and technical designs, test cases, and user guides.
  • Involved in the debugging and error handling.
  • Created reports using Cognos as per requirements of various departments.
  • Monitored the database growth on daily basis. Established backup and recovery strategies. Worked on Database tuning and performance monitoring.
  • Wrote HP UNIX SHELL scripts.
  • Modified UNIX kernel parameters and associated db parameters.

Environment: Oracle 10g/9i, Oracle Enterprise Manager, HP UNIX Shell Programming, SQL, PL-SQL, SQL Plus, Toad, Stored Procedures, Functions and Triggers, Cognos, Autosys

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Understanding the business logic to modify existing SQL Code and Performance Tuning if it requires.
  • Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes
  • Involved into updating procedures, functions, triggers, and packages based on the change requests.
  • Coordinate with the front end design team to provide them with the necessary stored procedures, packages and the necessary data.
  • Involved in writing procedures, functions, triggers, and packages for new requirements.
  • Read data from flat files and uploading that data into oracle tables using SQL loader.
  • Provided Test Data to QA team to validate front end application. Also performed unit testing.
  • Involved to prepare user level and system level maintenance documentation.

Environment: Oracle 9i, PL/SQL, SQL Plus, SQL Loader, Toad.

Confidential

Oracle Database Developer

Responsibilities:

  • Involved in the performance tuning of various database queries. The queries retrieved data from different tables in multiple databases.
  • Developed Unix Korn Shell Scripts for batch processing of the Reports, which were also scheduled to run Weekly, Monthly or Bi-Monthly.
  • Worked on Poly-Loader, the set of PL SQL packages to load the SNP data into staging tables before load into the actual production databases
  • SQL Scripts were developed for creating dynamic query tables using the latest Oracle 8i features.
  • Reports were upgraded with different dynamic layouts.
  • Report Triggers were extensively used for creating dynamic tables and dynamic queries.
  • Developed PL-SQL packages for loading various data loading.
  • Developed SQL loader script for loading data from different schemas.

Environment: Oracle 8.1.7 8i , PL/SQL, PERL, UNIX, Korn Shell scripts, MS Access, Excel Spread sheet Sybase 11.9.2, SQL Plus, C , SQL Navigator and TOAD

Confidential

Oracle PL/SQL Database Developer.

Responsibilities:

  • Performed design, coding, implementation and support.
  • Wrote Stored Procedure, Package and Triggers for back end validations
  • Wrote Procedures using Oracle supplied Packages
  • Analyzing the tables
  • Validations have done in front-end and as will in backend using triggers.
  • Wrote complex SQL queries using joins and correlated sub queries
  • Code base consists of complex package logic that uses DML and writes all SQL executed to log tables for troubleshooting, and logic that processes logistical data for optimizing selecting a particular product and its features available across different companies. Measuring and reporting product list using Excel, PL/SQL scripts.
  • Designed Front-end interfaces and created reports as per the requirements using Forms/Reports 6i.
  • Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: Oracle 8i, Oracle Forms/Reports 6i, SQL Plus, PL/SQL Developer , Windows XP Pro, MS Office 2003 Excel, Word , Perl, UNIX

Hire Now