SUMMARY:

• Complete proficiency in BusinessObjects Enterprise and related reporting solutions; migration/ upgrade strategy for BO and BODS environment; ability to quickly troubleshoot and resolve technical problems; design, code, test, and document reporting and BI solutions.
• Proficient in SSIS/ SSRS/ SSAS.
• Willing to adapt to changes in job requirements, learning and applying new skills as needed to ensure the company's success; strict attention to detail; superior organization skills; ability to multi - task; ability to explain technical solutions to non-technical people; ability to work in a fast-paced, stressful environment; commitment to lifelong learning.
• Experience in universe designing and updates, developing and generating ad-hoc, dashboard Reports, Business views, List of values along with User Acceptance Test and Data Accuracy Test. Prepare charts, graphs, data migration, data validation, QA, and project management.
• Proficient in SQL, reporting and BI tools, data warehouse concepts, enterprise application systems, processes, and communications skills.
• Provide Business Intelligence support.
• Working experience in development projects in ETL, Modeling and Reporting.
• Enthusiastic, quick learning, project-oriented, team player with strong analytical and problem solving skills.
• Solid communication, interpersonal skills, leadership qualities, ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

Tools: Business Objects XI 3.0 / 3.1 / 4.0 / 4.1 / 4.2 , Designer / Universe Design Tool (UDT), IDT, Supervisor, Desktop Intelligence, Web Intelligence, Web Intelligence Rich Client, BI launch Pad, Broadcast Agent, Central Management Console (CMC), Central Configuration Manager (CCM), Performance Management, Live Office, Dashboard, Import Wizard, Crystal Reports, MS Office, SAP ERP, SAP BW, SSAS, SSRS, and SSIS.

Database: Oracle 10g/11g, Teradata, SQL Server 2008/2012/2014/2016 , MS Access 2008, DB2

ETL: Informatica, SAP Business Warehouse (BW), SSIS

Programming Languages: SQL, PL/SQL, ABAP, C, Python, Perl, Ruby, PHP, Visual Basic, C#, Java

Web Designing: HTML/DHTML

Operating Systems: Windows, Linux, Macintosh

Big Data: Cloudera Developer for Apache Hadoop with Pig, Hive, Impala, HBase, Sqoop, Flume, and Oozie

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater, VA

SAP Business Objects Developer

Responsibilities:

• Understanding and documenting the functional and technical requirements
• Design, build, test and deploy SAP and Microsoft BI technical solutions.
• Implementation of SAP Business Intelligence analytics solutions
• Maintain and correct applications to keep them performing in accordance with technical and functional specifications
• Created ODBC connections on all the clusters for respective environments and created documentation.
• Created LDAP groups to provide access to specific folders on the BO servers.
• Customized and redesigned complex key reports with related sub reports, charts and graphics.
• Developed and maintained Key management reports like Key performance reports and Key indicator Reports.
• Tested migrated databases with Mockup reports.
• Lead Code review sessions to finalize the releases from Dev to upper environments.
• Created reports using MS Access.
• Designed and developed reports using SQL Server Reporting Services (SSRS) and Power BI.
• Validated Data using the MS SQL server management.
• Presented report mockups to the business users and documented feedback for changed and implemented through the business analysts.
• Presented the solutions specifications based on the requirements to the Architecture review Board and to business stake holders.
• Created Test cases and performed various testes for the Reports.
• Conducted the transfer of knowledge sessions, coaching and mentoring less experienced users.

Environment: Business Objects XI3.1, 4.1, 4.2 Central Management Console, Life Cycle Manager, Upgrade Management Tool, Report Conversion Tool, BI Launch Pad,, Designer, Desktop Intelligence, Info View, Web Intelligence, Windows 2010, Unix, MS SQL Server 2014/2016, Oracle 11G, Teradata, SharePoint.

Confidential, Rancho Cordova, CA

SAP Business Objects Developer

Responsibilities:

• Created Universes for report generation using UDT and IDT module in Business Objects.
• Designed and built new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created ODBC connections on all the clusters for respective environments and created documentation.
• Created LDAP groups to provide access to specific folders on the BO servers.
• Customized and designed complex key reports with related sub reports, charts and graphics.
• Developed and maintained Key management reports like Key performance reports and Key indicator Reports.
• Tested migrated databases with Mockup reports.
• Involved with the Data modelers to finalize the migrations in the Development Environment.
• Setup version control, Revision control suites (CICD) Clear case and SVN to migrate reports to various environments.
• Validated Data using the MS SQL server management studio and Teradata on different environments.
• Presented report mockups to the business users and documented feedback for changed and implemented through the business analysts.
• Presented the solution specifications based on the requirements to the Architecture review Board and to business stakeholders.
• Provided data to QA team, to create Test cases for the Reports.
• Conducted the transfer of knowledge sessions, coaching and mentoring less experienced users

Environment: Business Objects XI3.1, 4.2 Central Management Console, Life Cycle Manager, Upgrade Management Tool, Report Conversion Tool, BI Launch Pad, Designer, Desktop Intelligence, Info View, Web Intelligence, Windows 2010, MS SQL Server 2016, Teradata, SharePoint.

Confidential, San Antonio, TX

SAP Business Objects Developer

Responsibilities:

• Created Universes for report generation using UDT and IDT module in Business Objects.
• Designed and built new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Migrated AS - IS migration of Crystal reports to Webi using filtering, Prompting, and Drill up drill down features.
• Converted SQR reports to Crystal Reports as a part of re-platform as required by the new IT standards.
• Configured BO environment and performed post migration modifications to reports universe as needed fixing migration bugs. worked as a BO Lead in a team of 4 BO developers.
• Created reports using MS Access.
• Designed and developed reports using SQL Server Reporting Services (SSRS).
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Created Solutions specifications documents based on the Requirements; used IBM Doors 9.0 and SharePoint to publish the documents.
• Created ODBC connections on all the clusters for respective environments and created documentation.
• Created LDAP groups to provide access to specific folders on the BO servers.
• Customized and redesigned complex key reports with related sub reports, charts and graphics.
• Designed and implemented summarized Universe for easier and faster Reporting.
• Developed and maintained Key management reports like Key performance reports and Key indicator Reports.
• Involved with their Data requirements planning sessions to migrate database from Sybase to MS SQL server 2014/2016.
• Tested migrated databases with Mockup reports.
• Lead Code review sessions to finalize the releases from Dev to upper environments.
• Involved with the Data modelers to finalize the migrations in the Development Environment.
• Setup version control, Revision control suites (CICD) Clear case and SVN to migrate reports to various environments.
• Scheduled reports using Autosys as per the unique requirements from the client, and later scheduled them using the scheduler.
• Involved with the Java Developers to integrate ticketing system Remedy with the BO.
• Validated Data using the MS SQL server management studio and Sybase central on different environments.
• Presented report mockups to the business users and documented feedback for changed and implemented through the business analysts.
• Presented the solutions specifications based on the requirements to the Architecture review Board and to business stakeholders.
• Provided data to QA team, to create Test cases for the Reports.
• Conducted the transfer of knowledge sessions, coaching and mentoring less experienced users.

Environment: Business Objects XI3.1, 4.1, 4.2 Central Management Console, Life Cycle Manager, Upgrade Management Tool, Report Conversion Tool, BI Launch Pad,, Designer, Desktop Intelligence, Info View, Web Intelligence, Crystal Reports 2011/2016, Crystal Xcelsius 2008, Live Office, Windows 2010, XP, Win8.1, Unix, MS SQL Server 2014/2016, Sybase,Oracle 11G, ClearCase, Autosys, Remedy, IBM Doors 9.0.

Confidential, Middlebury, CT

SAP BO/BI Developer

Tools: Used: Business Objects XI 3.0, 3.1, 4.0, 4.1, BO Designer, Desktop Intelligence, Web Intelligence, InfoView, Crystal Reports, Xcelsius Dashboards, Oracle, SQL Server 2005/2008, Query as a Web Service (QaaWS), scripts, views, indexes, stored procedures.

Responsibilities:

• Experience in Development Support Solutions for Business Objects BOXIR2 / XI 3.0 / 3.1 / 4.0 / 4.1 , Designer / Universe Design Tool (UDT), IDT, Supervisor, Desktop Intelligence, Web Intelligence, Web Intelligence Rich Client, Info View, Broadcast Agent, Central Management Console (CMC), Central Configuration Manager (CCM), Performance Management, Live Office, Dashboard, Import Wizard, Crystal Reports.
• Designed, developed and updated universes using best practice methodology, and generated complex ad - hoc reports with drill-down functionality, dashboard reports, Crystal Reports, business views, list of values along with user acceptance test and data accuracy test
• Design, build and deploy Crystal, and WEBI Reporting applications.
• Design and deliver end-user and materials; provide technical support as necessary.
• Provide Business Intelligence support.
• Experience in building SQL queries, creating sub-queries, minus/union, inline queries and performance tuning of SQL (DB2 and Oracle).
• Knowledge of BO XI architecture and new features. Working with all BusinessObjects tools, including: CMC, CCM, UDT, IDT, Universe Designer, WEBI, Deski, Dashboards, and Crystal Reports.
• Ability in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like combined queries in Oracle, MS SQL, and DB2 database platform.
• Knowledge of relational database, star-schema structures and building semantic layers.
• Ability to analyze, design and create end-to-end Business Objects Data Integrator (BODS) mapping documents.
• Knowledge of data modeling diagraming and techniques such as ER diagrams and related tools.
• Ability to test ETL applications and perform ETL troubleshooting
• Facilitated JAD sessions with management, users, subject matter experts (SME) and other stakeholders to define the project and to reduce the time frame required to complete deliverables.
• Prepared and presented Business Requirement Document (BRD), System Requirement Specification (SRS), Functional Requirement Document (FRD), Test Scripts, and Production Checkout.
• Responsible for requirement gathering, business process flow, business process modeling and business analysis with document and records management.
• Used Business Objects tools, MS Office tools, SAP Hyperion, SAP BW, SQL programming, RDBMS and data warehouse concepts, as well as having financial and accounting knowledge, effectively prepared analytical and reporting needs.
• Used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experienced in interacting with business users to analyze the business process and requirements. Transforming requirements into screens, designing database, documenting and rolling out deliverables.
• Participated in project planning sessions with project managers and team members to analyze business requirements and outline the proposed solution.
• Handle a variety of projects, including the compiling of data to allow enterprise to easily aggregate, manipulate and display data as actionable information.
• Work directly with the client user community to define and document data requirements for data integration and business intelligence applications.
• Determine and document data mapping rules for movement of medium to high complexity data between applications.
• Adhere to and promote the use of data administration standards.
• Support data selection, extraction, and cleansing for corporate applications, including data warehouse and data marts.
• Create and sustain processes, tools, and on-going support structures and processes.
• Extract and analyze data from specific applications, systems and/or databases to create reports and provide recommendations based on the analysis of the data.
• Investigate and resolve data issues across platforms and applications, including discrepancies of definition, format and function.
• Create and populates meta-data into repositories.
• Create data models, including robust data definitions, which may be entity-relationship-attribute models, star, or dimensional models.
• Create data flow diagrams and process models and integrates models across functional areas and platforms.
• Working closely with DBAs to transition logical models to physical implementation.
• Responsible for employing data mining techniques to achieve data synchronization, redundancy elimination, source identification, data reconciliation, and problem root cause analysis.
• Responsible for quality control and auditing of databases, resolving data problems, and analyzing system changes for quality assurance.