SUMMARY

• Combining proven leadership ability and advanced expertise in all phases of the software development life cycle SDLC to achieve ambitious project objectives
• Highly analytical problem solver with an exemplary record in data analysis and reporting to support large-scale technology projects for banking and finance operations. Extensive knowledge of data warehousing processes and Agile principles with outstanding client relations skills and a solid background in coordinating with multiple teams. Dynamic and detail-oriented professional with superb communication abilities.

Highlights of Expertise:

Technical Proficiencies:

Business Intelligence Business Objects 4.1/4.0/3.1 SP3/XIR2, Web Intelligence 4.1/4.0/3.1 SP5/3.0, XIR2, crystal reports XIR2/ XIR1/ 13/11/10/9/8.5,XCelsius,BEx,Analyzer,ETL Informatica ,OC

,Remedy, Perforce

Dimensional Data Modeling Dimensional data modeling Star join schema modeling, snowflake modeling, FACT and dimensions tables, physical and logical data modeling, ERWIN 4.5/4.0/3.5/3.2, Oracle Designer, Visio and Sybase Power Designer.

Databases Oracle 11g/10g/9i/8i/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2008/2005/2000/7.0/6.0, WCSA, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access

Programming C,C ,SQL, PL/SQL, SQL plus, Transact SQL, ANSI SQL,

Environment Sun Solaris 2.6/2.7, Win 98, Win NT, Win 2000/2003 Server, Win XP. Windows 7, and MS-Dos

Professional Experience

Confidential

Senior SAP Business Objects consultant,

• Lead the complex Business Objects report development effort by taking a primary responsibility of gathering requirements from users.
• Performed release management role on a major maintenance release.
• Conducted working sessions with development team to analyze, design, develop, and test complicated business logic.
• Worked as a developer, analyst, facilitator, and coordinator on multiple projects.
• Developed flexible role-based security enabled reports to cater wider audience in the organization and thereby promoting user self-service model.
• Performed detailed gap analysis by working with data modelers, database developers, and ETL developers to define the scope and effort required to implement the complex business requirement on time and on budget.
• Performed detailed data analysis to come up with logical and physical data model to conceptualize business requirements into technical requirements.
• Performed data analysis to build data mart for trading subject area.
• Produced Tableau reports for Trading Business Group to enable them to perform analytics on historical transactions.
• Worked with backend developers to identify necessary facts and dimensions not only to meet business requirements but also to conform to data warehousing best practices.
• Used complicated Business Objects solutions on reporting side as well as on the Universe side to implement/deliver on complex business requirements.
• Worked with business systems analyst, various business users groups, and IT team members to scope and implement extensive new functionalities and enhancements to existing the Business Objects Reports.

Environment: SAP Business Objects 4.1/3.1, SAP, Oracle11g/10g Windows 2007, PL/SQL, Toad 11.5

Confidential

SAP Business objects consultant,

• Involved in different phases of Software Development Life Cycle SDLC like requirements gathering, preparation of technical specification documents, designing and developing reports, unit testing and UAT.
• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Aggregator, Expression, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations
• Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.
• Implemented analytics across the organization and used tabs on company performance via flexible management dashboards and scorecards and implemented index awareness.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe
• Enabled dynamic report linking by passing Variables prompts between reports
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Created Master/Detail, Cross tab, Chart templates reports using Crystal Reports.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Extensive experience in creating reports with Charts bar chart, Pie chart etc , Cross-tabs and Sub reports.
• Resolved performance issues by writing stored procedures and command objects in Crystal reports.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using xcelsius 2008.
• Used Xcelsius for presenting dashboards to End users.

Environment: SAP Business Objects 4.0X, SAP, Oracle11g/10g Windows 2008, SQL Server 2008, PL/SQL, SQL Loader, Toad 11.5

Confidential

SAP Business Objects Consultant,

• Worked on various reporting platforms including Microsoft Excel, SQL/JSP reports, Web Intelligence and Crystal Reports.
• Participated in requirements gathering, analysis and design based on user requirements.
• Developed efficient and well-formatted reports which conform to client requirements and delivered within estimated timelines with high quality using Waterfall software development methodology.
• Created Design Documents, Unit Test Plans and performed unit testing
• Acted as a coordinator between Development team and testing team to facilitate discussion about issues.
• Coordinated with testing team to track defects and releases in HP Quality Center.
• Provided Level 3 support for all deliverables.
• Worked with BO Administrator to migrate and version control development.
• Created and managed web intelligence schedules.
• Provided training to Business Users to enable quick data analysis and data extracts.
• Created templates for standardizing corporate documents.
• Created relational database structures. Tables, views, primary keys, foreign keys, and indexes.

Environment: SAP BO Data Services 3.x Data Integrator Business Objects XiR3.1, Oracle11g/10g Windows 2000, SQL Server 2000, PL/SQL, SQL Loader, Crystal Reports Xi