SUMMARY:

• 10 Years of experience in data warehousing with ETL and Reporting tools like Informatica 9.1/8.6/ 6.2, Business Objects Data Services, SAP BO 4.0 / XI R3 / XI R2, SAP BI/ BW.
• SAP/Business Objects suite of products like Designing BOBJ Architecture, Web Intelligence, Universe Design, Crystal Reports, Xcelsius, Live Office, Dashboards, Data Integrator/ Data Services for major clients likeBest Buy, Verizon, SIRVA.
• Expertise in Universe(s) designing from scratch, developing and generating complex, Ad hoc, Reports, List of values, Input Control, graphs, along with User Acceptance Test and data accuracy test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, derived tables and input controls
• Knowledge in SAP HANA and MSBI
• Experience in working Agile and Waterfall methodology projects.
• Expertise over preparing requirement document, High level and low level design documents, report specifications, test plans, database designs, deployment documents.
• Expertise in designing, developing and coding with Teradata 13.1, SQL Server 2000/2005.
• Experience in performance tuning, identify and resolve performance issues from reporting side.
• Good Knowledge ofData Warehouse Concepts and Data Modeling approaches like Start Schema modeling, Snowflake Schema modeling, Fact,LookupandDimensionstables .
• Strong Knowledge Software Development Life Cycleexperience including Scoping, requirements gathering, modeling, analysis/design, development, testing, migrations and support.
• Having very good experience in & Supporting end - user reporting needs using Business Objects.
• Active team player and as an individual withExcellent Communication,Interpersonal skills, self-motivated fast learner, good leadership skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

BI/OLAP: SAP Business Objects 4.0/XI3.1/XIR2/6.x, CMC, Designer, InfoView, Web Intelligence, Desktop Intelligence XI, Full client, Xcelsius 4.5, LiveOffice, Dashboards, Crystal Reports 9/ XI, BI, BW, Microstrategy

ETL: Informatica 9.1 /8.1/ 7.2, Business Objects Data Integrator 11.5 / Data Services

Data Modeling: Power Designer, Visio

Database: Teradata 13.1, MS SQL Server 2000, Oracle 9i

Operating Systems: Windows 7/XP/2000/98/95

Web Expertise: ASP 3.1, Java Script, VB Script, HTML

Languages: SQL, PL/SQL

Others: Maestro scheduler, CVS, VSS

PROFESSIONAL EXPERIENCE:

Confidential - Richfield, MN

Technology Architect

Responsibilities:

• Analysis on the metrics to be displayed on the dashboard to indicate the KPIs
• Responsible for working on medium to high architectural impact projects, creating Conceptual Architecture and High Level Design documentation and recommending Best Practices.
• Created logical, physical and dimensional data models using Power Designer
• Worked with ETL design and developing architecture for Data Marts.
• Discussing with business users on designing the dashboard GUI.
• Preparing the requirement specification, interface agreement document, mapping document, design documents, test plans, supporting documents
• Createdcomplex webi reportswithmultiple queries, using complex functions, merging dimensions at report level, drill down, drill up, complex filters etc
• Worked onvalidatingthecanned crystal reportswith the end user andcustomizedsome of canned reportsandcreated new reportsas a part of new user requests
• Worked on architecture and planning of Business Objects,
• Worked with Database design team to articulate the reporting needs using the DB tools and objects.
• Worked on proactive approach to develop the test scripts. Troubleshooting of the reports for the performance and better design by adding functions, parameters with subset of data.
• Worked on bug fixes, guiding the team for the proactive approach and recommendations.
• Coordinating with on shore team and off shore team in getting on time delivery

Environment: SAP BO 4.0, Business Objects XI R3, Informatica 9.1, Teradata 13, UNIX, Maestro

Confidential

Technology Architect

Responsibilities:

• Preparing the requirement specification, interface agreement document, mapping document, design documents, test plans, supporting documents
• Responsible for architecture, design and implementation of an application for Business.
• Defined the data integration standards and designed the data integration process from multiple sources using the standards.
• Extensive data analysis across multiple sources for creating the enterprise data models
• Responsible for modeling the first phase of warehouse.
• Designing and developing new universe from scratch.
• Developed new complex web intelligence reports, with multiple tab reports. Each tab reports will display different level of data. Input control was created on the graphs, such that user can change the data as per their requirement.
• Working with customers on validating the reports during UAT and post production phase.
• junior level developers in creating reports and universe using BO XI R3
• end users in using the reports and creating ad hoc reports.
• Leading a team of 7 people and coordinating between onshore-off shore teams.
• Post production support.
• Knowledge transfer on the project details to the support team after the PDAP phase.

Environment: SAP Business Objects 4.0, Informatica 9.1, Teradata 13.1, Teradata Utilities, Message Queue Tool, UNIX, Maestro

Confidential

Technical Lead

Responsibilities:

• Preparing the requirement specification, interface agreement document, mapping document, design documents, estimation plans, test plans, supporting related documents.
• Updating existing Universe and enabling ad hoc report generation
• Creating new complex reports in web-I and helped the team in overcoming all technical challenges.
• Updated informatica mappings, created and modified BTEQ, FLOAD scripts
• 5 fresher’s in Business Object XI R3 and internal tools, which was used for documentation, version control, ticketing system, migration request system.
• Coordinating with off shore team and on site lead to drive the project for successful completion
• Proved the capability to manage a team of 20 people which involved multiple iterations going in parallel.
• Production support

Environment: Business Objects XI R2 / R3, Informatica 9.1, Teradata 13.1, Teradata Utilities, UNIX, Maestro

Technical Lead

Responsibilities:

• Interacting with the clients to understand the requirements
• Participating in design discussion.
• Creation of data dictionary and Mapping documents, unit test cases and unit testing.
• Developing mappings using BODI (Business Objects Data Integrator/ Data Services).
• Modifying reports, using Infoview and Web Intelligence
• Unit testing, System testing and acceptance testing.
• Production Implementation and Support

Environment: Business Objects Data Integrator (BODI) 11.5, Business Objects XI R2, MS SQL Server 2005, Windows XP

Confidential

Technical Lead

Responsibilities:

• Understanding the requirements
• Creation of data dictionary and Mapping documents.
• Participating in preparing function document
• Developing mappings using BODI (Business Objects Data Integrator).
• Creating Unit Test Cases and Unit Testing
• Production support

Environment: Business Objects Data Integrator (BODI) 11.5, MS SQL Server 2005, Windows XP

Senior Developer

Responsibilities:

• Running the operations for dailies, weekly, monthly jobs.
• Generating reports using Micro strategy
• Monitoring the Scheduler.
• Timely escalation of issues.

Environment: Informatica 7.1, Oracle 9i, UNIX, Microstrategy

ETL and Report Developer

Responsibilities:

• Involved in extracting the data from different data sources like Oracle and Flat files.
• Developed mappings/sessions using Informatica power center for data loading.
• Created various Transformations like Joiner, Aggregator, Expression, Filter, and Update Strategy.

Environment: Informatica 6.1, MS SQL Server 2000, Crystal Reports 9, Windows NT

Confidential

Developer

Responsibilities:

• Developing user interface
• Unit and integration testing of the Web pages.
• Generating of reports using Crystal Reports

Environment: ASP 3.1, Seagate Crystal Reports 9, HTML Java Script, VB Script, MS SQL Server 2000