Professional summary

• Focused and seasoned professional with extensive expertise in managing data warehouse and database, business intelligence reporting, and business application development under large corporate environments honed through more than 10 years of accomplishment-laden career.
• Visionary leader, empowered with impeccable work ethic, as well as notable business and technical acumen
• Analytical problem solver, well-versed in formulating strategic solutions to provide dramatic improvements in business efficiency and productivity
• Enthusiastic team-player, adept at managing group dynamics, as well as in leading and motivating high-caliber teams of professionals to deliver record-setting results
• Articulate communicator with a naturally personable attitude to establish positive work relations with diverse individuals and professionals of all levels
• Familiar with data warehousing concepts like Star Schema, Facts , Dimensions, ETL/ELT
• Worked on design and development of Data warehouses including data modeling, data model design, dataflow, ETL and BI Reporting
• Worked on development of Custom ETL Code in Oracle and SQL Server using ETL tools like SSIS, TSQL, ODI and Informatica
• Created complex TSQL, SQL and PL/SQL queries for MSSQL Server, DB2 and Oracle RDBMS
• Worked on Database monitoring using Enterprise Manager, performance tuning to ensure faster execution of ETL processes and user queries, database re-organization, table partitioning. Performance Tuning of reports and ETL processes
• Worked on Reporting tools like Microsoft SSRS, ProClarity, Business Objects, OBIEE, BI Answers and Noetix Views
• Knowledgeable in Oracle Financials eBiz Suite R12 and tables structures within AP,GL AR, Purchasing modules
• Experienced in Microsoft BI stack SSAS, SSRS and SSIS
• Experienced in Oracle BI Stack OBIEE, OBIA
• Experienced in customization of Noetix Analytics ODS and DataMart
• Worked on Noetix Views administration and reporting
• Knowledge and experience with Hyperion Essbase cubes
• Worked on Informatica on Demand interfaces to Sales Force.Com
• Involved in Installation and configuration of Noetix Analytics Data warehouse
• Involved in Installation, configuration, administration and report design of Hyperion EPMA 11.1.1.2
• Performed Database Administration of SQL Server databases
• Performed Database Migrations from SQL Server 2000 to SQL Server 2008
• Managed very large scale databases including tables with over 4 billion rows, fragmented indexes and partitioned tables
• Data Quality management to ensure clean and reliable data
• Familiar with technologies like VB, ASP, Perl, Python, Java, JavaScript, VBScript, HTML, DHTML, XML, XSL to implement applications in Client Server, Web-based and Multi-Tier platforms
• Worked on Mercury QC for developing and executing Test Procedures, Test Cases, Test Scripts, Test Plans, performing Functional Testing, Stress Testing and UAT
• Familiar with Big Data Technologies like Hadoop.

Technical Skills:

Professional Experience:

Confidential Senior Business Intelligence Consultant

Working as a consultant to actively help in definition and implementation of the BI roadmap and strategy technology and process . Lead solution design on medium to large Business Intelligence/Data Warehousing projects with varying degrees of complexity using latest version of OBIEE.

Responsibilities:

• Collaborate and lead the gathering and development of business requirements for Business Intelligence projects, working with managers, business analyst and users.
• Lead effort to translate requirements into design specifications and data model.
• Define and develop data warehouse system solutions, ensuring alignment with technical strategies and priorities, as well as the target benefits expected.
• Lead the development, configuration, and administration of OBIEE dashboards, repository, catalog objects, and reports.
• Experience configuring Interactive Dashboards with drill-down and drill through capabilities using global and local Filters, OBIEE Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters using Presentation Services

Environment: Oracle 11G, OBIEE 11.1.1.7, OBIA

Confidential

Senior Business Intelligence Developer

Description:

Confidential is a professional services company, providing food services, facilities management, and uniform and career apparel rental to businesses. Take charge in establishing an enterprise data warehouse 'The ONE EDW' as well as administering data analysis, sources, mapping, and profiling. Provide support in recording technical specifications and business requirements while identifying business drivers related to customer requests across all BI platforms. Present unique architecture designs to deliver practical front-end reports. Create innovative reporting tools tied to different data systems and manage data to develop the most optimal method of reporting.

Responsibilities:

• Generated comprehensive accounts receivable metric reporting in support of business objectives by consolidating all accounts receivable data to Oracle R12
• Render expert oversight to junior staff members in installing and configuring intricate extract, transform, and load ETL processes in PL/SQL and Informatica for new ABS BI. Execute Oracle BI architecture for OBIEE 11g dashboards in support of MC workflows for the ABS accounting system
• Restructured the National Account Datamart to incorporate OBIEE reporting system that provided Aramark's national account customers with updated information
• Utilized OBIA and ODI to detail data warehouse architecture and design a centralized data warehouse, One EDW

Environment: Informatica 9.1, Oracle 11G/R12, OBIEE 11.1.1.7, Noetix Analytics and Views, Oracle BI Analytics, SQL SERVER 2000, 2008, TSQL, Informatica 9.1, Proclarity, SalesForce.com, Hyperion EPMA 11.1.1.2 , Essbase cubes, SSIS, SSRS, SSAS, Business Objects XI, Proclarity, MS Visual Studio

Confidential

ETL Developer

Description:

Developed ETL methodologies for data integration, including transfer of information from heterogeneous data sources onto a consolidated query interface. Incorporated a resilient and scalable data and ETL architecture to optimize the data warehouse and provide support to both business users and business intelligence applications. Provided guidance and direction on all technical operations related to system development to deliver an efficient system in line with business requirements. Worked with offshore vendors and teams for code development and production support. Maintained consistently high customer interaction through proactive communications.

Responsibilities:

• Played a contributing role in the development of the supply chain score card project to closely observe the efficiency of the Aramark supply chain performance
• Used OBIEE and Informatica to develop the key performance indicator KPI reporting system to assess progress toward strategic Aramark goals against more than 75 metrics
• Devised a one-way integration system between SFDC.com and a staging database through SQL Server/Informatica on Demand for data synchronization
• Held accountability in installing, configuring, and administering the Hyperion Reporting System. Assumed responsibility in transferring objects to Hyperion PROD through the LCM tool, as well as in designing Visual Basic and MaxL script to regularly backup Hyperion Objects
• Formulated comprehensive Informatica mappings, Transact-Structured Query Language T-SQL , and Procedural Language/Structured Query Language PL/SQL queries for data validation and quality assurance testing operations
• Closely observed, upgraded, and supported testing, production, and development of interfaces between Oracle and NoetixViews, Noetix Generator for OBIEE, and BI Answers and Noetix Search

Environment: Informatica 9.1, Oracle 11G/R12, OBIEE 11.1.1.7, Noetix Analytics and Views, Oracle BI Analytics, SQL SERVER 2000, 2008, TSQL, Informatica 9.1, Proclarity, SalesForce.com, Hyperion EPMA 11.1.1.2 , Essbase cubes, SSIS, SSRS, SSAS, Business Objects XI, Proclarity, MS Visual Studio

Confidential

Data Warehouse Administrator

Description:

Assumed an administrative role for the Confidential enhanced data warehouse, including management of data models, dataflow, ETL, and BI reporting. Defined development and deployment processes, mentored team of developers in implementation of development standards and best practices. Drove projects using different platforms including: specification of design, architecture for nationwide company needs.

Responsibilities:

• Maintained active involvement in the installation and deployment of Noetix analytics data warehousing system, as well as in the customization to meet Aramark's business needs
• Incorporated real-time processing, back-end integration, and comprehensive reporting capacities with Oracle database and legacy COBOL applications
• Leveraged industry expertise in upgrading the legacy data warehouse and the analysis services cube to Microsoft SQL Server 2008
• Employed MDX and Microsoft SQL Server 2008 to develop and design SQL Server Analysis Services SSAS cubes for supply chain users
• Established an invoice entry, storage, and analysis system for the client's Central Billing Department to collect, correct, and incorporate corporate account receivable records
• Constructed an ETL framework for the accounts receivable aging reporting system by consolidating legacy system and Oracle

Environment: Informatica 9.1, Oracle 11G/R12, OBIEE 11.1.1.7, Noetix Analytics and Views, Oracle BI Analytics, SQL SERVER 2000, 2008, TSQL, Informatica 9.1, Proclarity, SalesForce.com, Hyperion EPMA 11.1.1.2 , Essbase cubes, SSIS, SSRS, SSAS, Business Objects XI, Proclarity, MS Visual Studio

Confidential

Informatica Developer Consultant

Description:

This project involved design and development of new Data Marts like Claims Loss, Predictive Model and Quote Activity for Commercial line of insurance business. Contributed to the design and construction of ETL interfaces using Informatica 7.3/8.1 and reports using Business Objects XI.

Responsibilities:

• Developed and led various initiatives, including organization of high and low level design and mapping documents for mappings, workflows, and sessions.
• Thoroughly examined system specifications and outlined source data needed to be transferred to the data warehouse. Built data flow diagrams to outline data and business process models clarified business requirements to define and develop the data model.
• Gained comprehensive knowledge of the business line by building positive work relations with the business unit.
• Devised business requirement specifications, system life cycle methodology, and high-level project plans.
• Interfaced with system developers to efficiently respond and resolve issues on business requirement documents
• Served as the primary point of contact between operations, the business line, and technical areas across the project
• Made impactful contributions to user acceptance testing as well as to the development and evaluation of project schedules and functional specifications
• Composed DB2 SQL scripts to execute unit, assembly, and system testing on testing, production, and development platforms
• Provided guidance and direction to technical and regulatory teams through application development sessions to resolve systems development issues.

Environment: MS Office Project XP , Windows NT/2000, Informatica Power Center 7.1.3 8.1, Repository Manager, Workflow Manager Workflow Monitor, TOAD for DB2, IBM DB2, SQL, Unix Shell Scripts, Business Objects XI, MS Visio

Confidential

Data warehouse Developer Consultant

Description:

• Confidential Bank is a leader in vendor financing, commercial and corporate financing, rail car and locomotive financing, construction financing, Small Business Administration loans, and asset-based and credit-secured lending in the Asia-Pacific region.
• The project involved developing an integrated Data Warehouse system, to meet the demands of detailed, targeted customer data and sales analysis. The Data Warehouse was designed with expansion in mind, as the final stage of this project was to incorporate atomic level detail data.

Responsibilities:

• Involved in the analysis and designing of the data warehouse System Requirements thereafter created Functional and Technical specs.
• Developed a common information architecture to collect and organize information from various sources external to the company.
• Involved in the conversion of data from legacy system to Oracle warehouse environment.
• Responsible for data extraction and data cleansing from databases external to the company. Responsible for data conversion and ETL from various legacy systems using Informatica.
• Implemented various transformations like Expression, Lookup, Sequence generator, and Source Qualifier, Rank, Aggregator etc.
• Created different types of dimensions using Mapping Wizard to create complex mappings.
• Designed various dimensions and developed common procedures and standards to maintain databases using locally developed tools.
• Used Server Manager to load data into Oracle database.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and implemented e-mails using server manager.
• Worked extensively to create and modify SQL, PL/SQL components like Procedure, Functions, Triggers, Packages and Cursors

Environment: Informatica 5.1 PowerMart, SQL, PL/SQL, Windows NT/2000, Exchange Server 5.5, Oracle 8.1.6

Confidential

Analyst Programmer Consultant

Description: Confidential is a leading provider of financial services Credit Cards to retailers, manufacturers, and consumers in 28 countries around the world. The business need for this project was to design and develop a re-carding system to send out new credit cards to customers.

Responsibilities:

• Analyzed the existing Credit Card Management 'CARDPAC' system COBOL/CICS .
• Participated in gathering user requirements, developing functional and non-functional requirements, and technical specifications for the new 'Re-Carding' system.
• Developed use cases/diagrams, conceptual model, behavior diagrams sequence, collaboration, state chart, Activity , using MS Visio.
• Responsible for working with the manager and other users and creating Work flow diagrams as per the data analysis.
• Responsible for the delivery of Requirements Documents RD within project timelines.
• Work with the development team to ensure that they understand the specifications.
• Developed business components and screens using VB and Oracle.
• Extensively involved in coming up with test specifications, test cases and test manuals for the application.
• Performed unit testing, functional testing, integration testing, stress testing and code inspection review to make sure the deliverables are a match with business requirements.

Environment: COBOL/CICS, VB 6.0, Oracle 7i, Windows NT, MS Visio 2000

Confidential

Analyst Programmer Consultant

Description:Confidential Client Business Services, located in Fort Myers, Florida, is the only processing center for Confidential businesses and it processes 11 million invoices a year for one of the world's largest and most diversified industrial corporations.The system consisted of two modules, Fixed Assets and Accounts Payable. The Online Reporting System and Invoice Viewing System had to be designed and developed. In addition to that, the older legacy systems and optical/Imaging Viewstar system had to be supported.

Responsibilities:

• Analyzed and documented the System specifications, Business Requirements, and detail design of the new systems for full understanding of the business and used MS Office for the requirement tracking and analyzing.
• Analyzed client requirements and prepared program specifications and workflows for Online Reporting System and Invoice Viewing system, the interfaces for Accounts Payable module developed. The reports and invoices from legacy systems and Viewstar Workflow System were accessed using these interfaces.
• Involved in development using Visual Basic. Developed user interface screens, Master detail relations and Report screens, Front-end coding and also created record groups, and menus using Visual Basic and MS SQL SERVER 6.2.
• Analyze user requirements, Coding, development and testing of new and existing COBOL/CICS programs for AP and FIXED ASSETS system
• Production support of mainframe AP and FIXED ASSETS systems.
• Troubleshoot, Manage and support optical/Imaging Viewstar system and MS SQL Server 6.2 on Windows NT

Environment: Viewstar Workflow System, COBOL/CICS, VB 5.0, MS SQLServer 6.2,