Objective

• Seasoned Data Warehouse, ETL and SAP Business Object consultant with 16 years of experience, seeking a position leveraging extensive technical experience in the areas of Business Intelligence, Data Analysis, Data/Dimension Modeling, Database Design and Developement, ETL Development, SAP Business Objects and Application Developement.
• Area of Expertise
• Strong Business Intelligence experience
• Relational Dimensional Modeling
• ETL design and process development using SSIS and Data Services
• Oracle PL/SQL and MS-SQL Development
• Data Warehouse Design and Development
• Strong experience on SAP Business Objects BOBJ reporting tools, Sap Xcelcius/ Dashboards/ Explorer/ Webi/ Universe/ CMC /Live Office/Crystal
• Strong experience with SSAS/SSRS/SSIS
• Professional expereince summary
• Extensive experience in architecting, managing and successfully delivering enterprise Data Warehouses, Data Marts and Business Intelligence systems. Have successfully developed and implemented Data warehouses and Business Intelligence systems as full-fledged production systems.
• Extensive experience in designing and developing the architecture of all data warehousing components including source system change data capture, data integration, data staging, aggregation, data quality, data warehouse refresh strategy and information and analytics delivery.
• Extensive experience in designing and developing ETL architecture t integrate data from multiple data sources int a centralized data warehouse.
• Extensive experience with relational database design and data modeling techniques 3rd Normal, Star/Snowflake schemas utilizing conceptual, logical and physical models.
• Extensive experience on ETL development and have worked on SSIS and SAP Data Services tools.
• Experienced with implementating large scale migrations, data conversions and database upgrade projects including ETL modules across heterogeneous database platforms.
• Experienced with working on windows, web and SOA based web integration leveraging Microsoft.Net and SQL-Server/Oracle database technologies.
• Hands on experience on Business Intelligence reporting tools, Sap Xcelcius/ Dashboards/ Explorer/ Webi/ Universe/ CMC /Live Office/Crystal, Oracle PL/SQL, MS Sql-Server.

Technical Experience

Professional experience

Confidential

Managing Consultant /Data Architect /ETL Developer

• Led teams t customize/develop critical new modules t n-tier web enabled smart client net enterprise application and browser based e Business ASP.net/.net application. Used Microsoft .net technology, .net remoting, ADO.net, Crystal Reports and SQL-Server/Oracle databases.
• Initialized, planned, managed and tracked all the technical implementation activities including resource plans, cost plans, budgeting, recruiting, software customization, new development and data conversion.
• Led design, implementation and development of BizTalk real time integration t multiple systems t TIMSS and visa-versa.
• Led design, implementation and development of SOA based SS Single Sign On projects using .Net web-services.
• Developed Complex application for ETL Extract Transform Load int Data Warehouse and Transactional databases.
• Developed designed BI Universe, Webi reports, dashboards and analytics using SAP BI 4.0.
• Performed data analysis and implemented the Acquire flagship enterprise product TIMSS for multiple clients and provided consulting services t numerous clients for data migration projects, and assessed the following:
• Data migration platform architecture.
• Data integrity assurance plan.
• Data movement approach.
• Data quality and cleansing approach.
• Verification and validation.
• Roll-back plan.
• Developed a new plan that significantly reduced the risk and assured timely, accurate conversion.
• Worked on the following clients
• SPE Society of Petroleum Engineers.
• Toastmasters International.
• AA American Association of Ophthamology.
• AWWA American Water Works Association.
• SEMI Semi Conductors Golbal Association.
• AACN American Assciation of Crtical-Care Nurses
• Mercer Advisors
• MGMA Medical Group Management Association.
• TCG Theatre Communications Group
• AHA American Humane Assocation
• NAMM National Association of Music Merchants
• WSBA Washington State Bar Asociation
• WGA Western Growers Association
• CDA California Dental Assocation
• ILTA International Legal Technology Assocation.
• Used Erwin t create dimensional model using Kimball star schema method for data warehouse layer t abstract and encapsulate the physical implementation of the Finance, Membership, CRM and Order Management Data Warehouse in order t provide a business-centric, well-designed view of the data warehouse for all consumers, whether for scheduled or ad-hoc reporting.
• Performed financial data analysis, designed and developed Financial batch process such as Aging , Invoicing, Customer Analysis , Interface t AR-AP ERP 's like Lawson, Oracle Financials.
• Extensively used ETL Transformation like Script Object, SQL Object, Table Compare, Case , Key Generator , Lookup, etc. and all transformation properties.
• Worked on migrating application from Oracle t Sql server.
• Established the project development environment using Team Foundation Server and Visual Source Safe t effectively share objects and code.
• Worked on SAP B .Net SDK t integrate SAP B within the .Net Application.
• Conducted Oracle 10g Instance and database performance tuning, including the use of Perform tracing, explain plans and SQL query tuning, index tuning and diagnostics.

Environment

SAP Business Objects BI Tools, Xcelcius, DTS, ETL- SAP Data Services, SSIS, Crystal reports, Dashboards, Microsoft Visio, Oracle, SQL Server, VBA, XML, HTML, .Net

Confidential

Senior Consultant

• Worked as onsite Lead Consultant at Telekom South Africa SA as a senior consultant for the Y2K project.
• Led a team of developers on the customization of the telecom billing system used by South African National telecom company and made it capatible t the Y2K format.
• Won the Best Implementation award from SA Telekom.
• Worked on Pr C, Oracle 8i and Oracle reports
• Impletmented Automated Testing for the first time at SA Telekom.
• Sucessfully implemented the Y2K project with very minimal issues.

Environment

Oracle, SQL Server, Pr C, Oracle Reports, HTML

Confidential

• Key role in database designing and report designing.
• Designed and developed hundred of screens and extensively using Oracle Forms VB6 SQL Server Oracle Foxpro.
• Worked on of warehousing project for a unit of BHEL India BHEL has a total revenues of over 910M
• Worked closely with the end users and management t understand the reporting needs/requirements which helped us create/design customizations which were key t their successful business operation.
• Extensively worked on Oracle and all its components.

Environment

Oracle, SQL Server, Foxpro, Cobol, VB6, Pr C, Oracle Reports