SUMMARY

• 8 years of IT experience with 7 years in Business Objects/Informatica/ Data Warehouse developer that includes the experience in the Client/Server and Data warehouse applications using Oracle, Sybase, MS SQL server on Windows and UNIX platforms.
• Proficient in Business Objects XIR2/XIR3/XI3.1/4.0 Suite, Designer, Business Objects (Reporting), Web Intelligence, Crystal Reports, Xcelsius/Dashboard.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse using ETL tools, Informatica PowerCenter, PowerMart, OLTP, OLAP.
• Experience in Oracle/MS SQL Server/ Teradata Environments
• Data Modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling, ERWIN 4.0/3.x and Oracle Designer.
• Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Experience in creation and customization of ETL extracts and load process using Informatica
• Expertise in Universe designing, developing and generating complex, Ad hoc, dashboard Reports, Business views
• List of values along with User Acceptance Test and data accuracy Test.
• Proven abilities in creating complex reports by linking data from multiple Universes
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Extensively used Crystal Reports functionalities such as Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Excellent communication and strong interpersonal skills with ability to interact with end - users, managers and technical personnel.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts
• Highly skilled in developing Test Plans, Creating and Executing Test Cases.
• Passionate about learning, analyzing, and implementing.

TECHNICAL SKILLS

Business Intelligence & OLAP Tools: SAP BUSINESS OBJECTS XIR2/XIR3/XIR3.1/4.0 Suite, IBM Cognos, Designer, CMC, Import Wizard, Administrative Tool, Power Designer, Web Intelligence, Voyager, Desktop intelligence, Dashboard Manager, Performance Manager, Crystal Xcelsius 4.5/Dashboard and Live Office XIR2

ETL Tools: BOXir2 Data Integrator Informatica PowerCenter 7.1/6.2/6.1, PowerMart 6.2/5.1.1/5.0 , OLTP, OLAP, Designer, Workflow Manager, and Workflow Monitor, Power Connect, and Power Analyzer, DTS, PL/SQL

Databases: Oracle 9i/10g/11g, My SQL Server 2008, Sybase, MS Access

Data Modeling Tools: Star-Schema Modeling, Snowflakes Schema Modeling, FACT and Dimension Tables, MS Visio 2005, ERWIN 4.1, Oracle Designer 2000.

Web Development: HTML, HTMLB, Java Script, Servlets, JDBC, RMI, JSP, XML, BSP, EJP, JNDI, Net Weaver Developer Studio, Web Dynpro.

Languages: SQL, PL/SQL, Java, C, C++, C#, ASP.NET

Operating Systems: MS DOS, Windows Server, Windows XP, Windows Vista, Windows 7, Snow Leopard, Ubuntu, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

Sr. SAP BOBI/Crystal Reports Developer

Responsibilities:

• Interact with users to gather, analyze and record requirements/specifications.
• Interact with Business Users to analyze the dimensions and facts to design the data Ware house for the reporting.
• Working parallel with Database Admins, ETL Developers and Architecture team members to slice and dice the data.
• Row level security is implemented in the supervisor to restrict the data to the respective divisions.
• Involved in resolving table-linking problems like Chasm Traps and Fan Traps using Alias and Context.
• Create an interactive enhanced report that is very friendly to understand the complex data.
• Using BOXi 4.0 which is the latest version of Business Objects integrated with Crystal Reports
• Create the complex WEBI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Tested and deployed universes and documents across testing/production repositories
• Designed Star schema to provide better Drill down, Slice and Dice functionality in the reports. lCreating interactive charts that looks like a dashboard and help users to predict the upcoming numbers in the business
• Working with small team and very friendly environment and always room for new opportunities to learn
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) to overcome the problems with database when integrating with BO
• Customized the list of values (LOVs), which helps the end users to select the values
• Involved in testing reconciliation reports between the OLTP systems and data warehouse reports.
• Interacting with higher level management which requires excellent communication skills and strong learning, analyzing and implementing process.
• Bug fixing and enhancing existing reports
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed Hierarchies to support drill down reports.
• Created interactive reports which replaces dashboard functionality
• Designer Level and Reporting Level
• Converting Crystal Reports to Webi reports

Environment: Business Objects 4.0 Suite, Crystal Reports, Designer, Information Design Tool, Web Intelligence, CMS, CMC, CCM, Oracle 11g/10g, PL/SQL, TOAD, My SQL Server 2008, Windows 7, Windows NT Server, UNIX, PVCS

Confidential, Birmingham AL

SAP Business Objects Consultant

Responsibilities:

• Created functional requirement specifications through end-user meetings and analysis of Business requirement documents.
• Worked with team on customizing the out-of-box product to get look and feel of the application and abilities of SAP Business Objects BI4.0/Xi3.1 like exporting, previewing, printing and emailing the reports.
• Involved in creating the ‘Master Reports Suite’ which included enhancements to existing ad hoc reports
• Documented the steps of installing and configuring the SAP Business Objects BI4.0/Xi3.1 for the networking department to build the servers when we have releases.
• Responsible to support the issues with reports on the SAP Business Objects BI4.0/Xi3.1 environments (Development, QA and Production)
• Responsible to Sign-off on the SAP Business Objects BI4.0/Xi3.1 and Ad-Hoc application after the release
• Developed Crystal critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount
• Skilled in Management of performance tuning activities to improve system performance
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks
• Crystal Xcelsius is used to create a dashboard to view the state of different trade metrics Confidential a given point of time.
• Responsible to see that every developer has the reports checked in into ‘Version Management’ before the code freeze date.
• Trained developers on steps involved in migration
• Developed the confirmation letter reports which get mailed to participants

Environment: Business Objects 4.0 Suite/Xir 3.1/Xi3, Central Management Console, Designer, IDT/UDT, Info View, Web Intelligence, Crystal Reports, Crystal Xcelsius/Dashboard Reports, Informatica PowerCenter 7.1/6.2/6.1, PowerMart 6.2/5.1.1/5.0 , Application foundation, ORACLE 10g RDBMS, PL/SQL, My SQL Server, SQL Developer, Windows 7 and Windows Server

Confidential, Melville NY

SAP Business Objects Developer

Responsibilities:

• Created functional requirement specifications through end-user meetings and analysis of Business requirement documents.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Developed critical reports using drill up drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Customized the list of values (LOVs), which helps the end users to select the values
• Worked with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and populate Data Warehouse.
• Involved in testing reconciliation reports between the OLTP systems and data warehouse reports.
• Developed universe user documentation guide for the end users reference
• Provided training for end users for generating their own report including complicated report.

Environment: Business Objects XI R3.1/XI R3.0, Designer, CMC, Desktop Intelligence, Web Intelligence, Live Office, BCA, Crystal Xcelsius, Oracle 9g, PL/SQL, TOAD, Windows NT Server, UNIX, Informatica Power Center 7.1.2, Autosys, BO Java SDK, J2ee (JDK 1.4, JSP 2.0, Servlets), Web sphere 5.0, WSAD, CVS

Confidential, Atlanta GA

System & Process Analyst

Responsibilities:

• Service Oriented Architecture (SOA) business process modeling system
• Designed, crafted, and executed workflow structure on daily basis
• Manage C-Store Office (Back Office Application)
• Lead small projects
• Frequent travelling and visiting clients