SUMMARY:

• Around 8 ½ years of IT experience in Business Intelligence Using SAP Business Objects, Crystal Reports, Web Intelligence, INFOVIEW / Launch Pad, Business Views, Universe Designer, Information Design Tool, Xcelsius / Dashboards, Access and Tableau.
• Experience on Reports by using Business Objects XIR3.1 / 4.0 / 4.1 and Tableau 10.1.3.
• Strong knowledge of Data Modeling Concepts, snow flake schemas, multi star schemas, extended star schemas.
• Experience in creating Universes with measures and dimensions objects, join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Experience in interaction with the Business Analysts, identifying the needs & the requirements of the system and involving in requirement study of the system.
• Expertise in building/enhancing/migrating Business Objects universes and using various data providers.
• Proficiency in SQL language utilized for development of reports and universes.
• Worked on multiple database systems including Oracle, Teradata, MS SQL Server, IBM DB2.
• Experienced in customer interactions for requirement gathering, working closely with clients and gathering business level information to be utilized to create universes, reports for ad - hoc and canned reporting usage.
• Experienced in training Power users, Business Users and developers for SAP Business Objects.
• Strong knowledge of ETL processes and dataflow.
• Good knowledge of Data warehousing tools IBM Infosphere DataStage 8.5 (Designer, Director, Manager and Administration) and SSIS.
• Worked closely in creating test cases, performing UAT and testing reports and universes to ensure quality delivery.
• Managed Projects and Production Support, 24/7 on L2, L3, L4 levels.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• An intelligent and responsible software developer, fast learner, good technical abilities and skills developed by a strong work ethic and self-learning.
• Good analytical and documentation skills with ability to communicate at all levels.

TECHNICAL SKILLS:

BI Tools: Business Objects R3.0 / R3.1 / R4.0/ R4.1, Web Intelligence/ InfoView / Launch Pad, CMC, Webi, Designer / UDT, Information Design Tool, Import Wizard, Query As A Web Service (QAAWS), Crystal Reports 2008 / 10 / 11 / 13, Xcelsius 2008, Live Office, Dashboards 4, Tableau Desktop 10.1.3, Tableau Server 10.1.3.

ETL Tools: DataStage 8.5, Designer, Director, Information Server Manager, SQL Server Integration Services (SSIS)

RDBMS: Oracle 11g/10g/9i/8i, Db2, TeraData, SQL Server 2000 / 2005 / 2008 / 2008 R2 / 2012 / 2014, DB2, MySQL, Postgres.

O/S: Windows Server 2000/2003/2012 R2, Windows 7, Server/XP Professional, UNIX

Languages: SQL, C, C ++, PL/SQL

Tools: Remedy, Hp Service Manager, HP Application Lifecycle Management, Clear Case, Clear Quest, AQT, WinSCP FTP Client, Microsoft Visual Studio 2005 / 2008 / 2013, JIRA, Sharepoint, Slack, Version One, Eclipse.

PROFESSIONAL EXPERIENCE:

Confidential, VA

Sr. Data Engineer / Analyst

Responsibilities:

• Managed production support team to ensure maximum environment uptime for all the Business Objects servers across the organization.
• Managed Business Objects user securities for universes, reports, folders, applications, connections, users and groups by setting up application based groups.
• Lead the Customer Engagement initiative to engage with customers of Business Intelligence Platforms to perform empathy interviews to understand their needs and to help with the cloud move project by providing endless support.
• Lead the decommission effort of Business Objects platform by collecting audit and inventory metrics using multiple macros, SDKs and audit reports which was utilized by folder guardians and content owners for decision making on content removal.
• Reduced Business Objects user and content footprint by 70% by creating effective audit and inventory reporting which proved pivotal in content reduction.
• Provided guidance to developers for Business Objects and Tableau for connecting reports and workbooks to cloud data sources.
• Lead the cloud move project for Tableau on premises to AWS which included reduction of Tableau on premises user and content footprint. Created audit workbooks for site admins and content owners which helped with removing inactive users and unused content.
• Utilized Interworks for creating Tableau metadata reporting for impact analysis by fetching interworks extracts, loading in MySQL database and creating workbooks on top of the data.
• Managed Tableau Analytical and Production servers and provided support to end users as well as site admins by creating sites, adding groups and creating schedules.
• Managed Tableau Desktop and Interworks licenses across Confidential by approving, transferring and reclaiming the licenses. Worked with Tableau representative to reconcile activations of master keys.
• Managed Tableau Server Seats/Licenses on Analytical and Production servers by tracking seats purchased by different LOBs/Sites along with the number of users on the server.
• Efficiently managed Slack channels for Tableau and Business Objects support by providing timely support on licensing, development and access issues.
• Worked as an integral part of the team and followed Agile practices to ensure timely project delivery.

Environment: Business Object 4.1 SP 6, Launch Pad, Web Intelligence, Universe Design Tool, Information Design Tool, Dashboards 4, Query As A Web Service (QAAWS), Tableau Server 10.1.3, Tableau Desktop 10.1.3, Interworks, Postgres, Slack, MySQL, MS SQL Server 2012, Teradata 15, MS-Office 2016, Version One, JIRA Ticketing System, HPSM, Windows 7.

Confidential, VA

Sr. Business Intelligence Consultant

Responsibilities:

• Worked as a production support consultant to ensure maximum environment uptime for all the Business Objects servers across the organization.
• Responsible for administering Business Objects Development, Test and Production environments.
• Managed and Monitored Business Objects servers in Central Management Console and Central Configuration Manager across all the environments.
• Managed Business Objects user securities for universes, reports, folders, applications, connections, users and groups by setting up application based groups. Restricted confidential information using folder, universe and report level securities.
• Responsible for migration of reports, universes and dashboards across all the environments. Worked on a project to synchronize business objects Development, Test and Production environments.
• Automated Universe Documentation process by utilizing Business Objects Auditing data, universe metadata and VB macros for Data Governance project.
• Developed, maintained and enhanced user friendly Business Objects reports, dashboards and adhoc universes for Business Users. Utilized hyperlinking and drilldown features to standardize the reports.
• Worked with database administrators and ETL developers to test the performance impact for Business Objects reports after ETL level security implementation.
• Worked with database administrators and ETL developers to define database requirements and load procedures for successful Business Objects reporting.
• Analyzed database tables and created views to utilize the best possible design approach for universes to enhance performance and reduce CPU and spool space usage on databases.
• Acted as an integral part of the data warehousing project and provided requirements for the reporting database for Business Objects Universes.
• Provided training to enable Business users to utilize Business Objects Adhoc Universes to fulfill their Adhoc reporting needs.

Environment: Business Object 4.1 SP 6, Launch Pad, Web Intelligence, Universe Design Tool, Information Design Tool, Dashboards 4, Query As A Web Service (QAAWS), MS SQL Server 2014, SSIS, MS-Office 2016, Visual Studio 2013, JIRA Ticketing System, Windows Server 2012 R2.

Confidential, VA

Sr. Business Intelligence Developer / SME

Responsibilities:

• Redefined the entire process for Bank Defects and Enhancements for Business Intelligence.
• Successfully managed and co-ordinate onsite and Offshore teams.
• Developed a new and enhanced customer complaint process for reporting defects and enhancements.
• Responsible for managing Business Objects XI 3.1 / R4.0 Development and QA servers.
• Administrated Business Objects servers, users, access, reports and universes.
• Worked on implementation of Quality Assurance procedures for Pre Production testing.
• Worked with different Database systems for Operational and Analytical reporting (Teradata 13/14/15, Oracle 10g/11g, DB2, SQL Server 2008).
• Worked on data masking techniques for security of Non Public Information.
• Deployed new folder based security structure for the environment.
• Provided oversight for all Production activities.
• Created reports using formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in complex Crystal reports for different Business groups (Mortgage, Finance, Card, Loans).
• Migrated and maintained Business Objects reports during Data warehouse up gradation from Fork lifted data model to 3nF.
• Created various types of WEBI reports (Standard reports, Cross Tab, Mail tab, use of Filters, Conditions, Calculations)
• Defined and lead Development team for new projects.
• Created linked and unlinked Sub Reports to create applicants experience/Qualifications reports and reports to Troubleshoot performance issues.
• Worked on Proof of Concept for Mobile Based Web Intelligence and Xcelcius Reports using live data for higher management.
• Created report templates for the standardization of reports.
• Promoted repository objects (Universes, Reports, folders) from one environment to another.
• Worked with database administrators and modelers to define database requirements and load procedures for successful Business Objects reporting.
• Developed, maintained and enhanced several complex Universes, Dashboards and linked reports for several divisions across the organization.
• Analyzed the data models in order to utilize the best possible design approach for universes to enhance performance and reduce CPU and spool space usage on databases.
• Designed universes from scratch for multiple banking divisions including but not limited to Risk Data Warehouse, Counterparty Credit Risk Management, Special Assets Management and Anti Money Laundering.
• Created user friendly landing pages for multiple dashboards using nested prompt and input control functionality.

Environment: Business Object XI R3.1 / R4.0 / R4.1, Launch Pad, INFOVIEW, Web Intelligence, Designer, Universe Design Tool, Dashboards 4, Query As A Web Service (QAAWS), Crystal Reports 2011 / 2013, Teradata 13/14/15, Oracle 10g / 11g, MS-Office 2016, HPSM and HP Application Lifecycle Management, VersionOne, Windows 7.

Confidential, OH

Sr. Business Intelligence Consultant

Responsibilities:

• Worked as a production support consultant to ensure maximum environment uptime.
• Acted efficiently and proactively to resolve tickets and incidents within allotted SLA.
• Coordinated with multiple onsite and offshore teams to ensure timely and error free delivery for multiple projects.
• Addressed daily production support issues in Business Objects, SSIS and DataStage.
• Performed code migration activities between various DataStage environments using Designer, Information Server Manager and UNIX scripts.
• Administered DataStage environments ensuring maximum availability.
• Pro-actively approached Business Users to understand and document business functional and technical requirements.
• Created various types of WEBI reports (Standard reports, Cross Tab, Mail tab, use of Filters, Conditions,Calculations)
• Monitored and supported countless ETL Jobs, for perfect end to end data-flow on SSIS and DataStage.
• Created complex validation reports and queries to ensure proper ETL load.
• Developed QAAWS based off universes and reports to use in dashboards.
• Created Live Office connections for dashboards.
• Supported various dashboards by performing specific validations and checks to ensure proper portrayal to end users.
• Managed Business Objects user securities for universes, reports, folders, applications, connections, users and groups by setting up application based groups. Restricted confidential information using folder, universe and report level securities.
• Implemented multiple data masking techniques utilizing Business Objects for sensitive Non Public Information.
• Setting up user accounts, groups and access levels in CMC for internal users and external customers.
• Responsible for migration of reports, dashboards, universes, QAAWS, access levels and user groups between different environments throughout the organization using LCM and Import Wizard.
• Handled efficiently administration activities on all Business Objects environments.
• Monitored and maintained Business Objects servers to ensure maximum performance.
• Responsible for 24/7 production support of Business Objects.
• Worked as an integral part of multiple teams, including but not limited to Networking, Data Warehouse, Server Management, Database, Web Servers, Testing, Implementation etc., providing the best of my abilities and capabilities to perform given activities and to provide further support for better functionality of the client systems.

Environment: Business Objects XI R3.1, Web Intelligence, INFOVIEW, IBM Infosphere DataStage 8.5, SSIS, UNIX, Clear Case, Clear Quest, MS-Excel, MS-Project, MS-Access, MS-Visual Studio 2005 / 2008, Remedy, Oracle 11.1, SQL Server 2005 / 2008 R2 and DB2

Confidential, PA

Crystal Report/Business Object Developer

Responsibilities:

• Created Complex reports with SQL views in Crystal Report.
• Understood SQL views and accordingly generated reports.
• Wrote SQL queries in Teradata SQL Assistant to extract the data from database.
• Extensively used Toad to understand the data.
• Defined Business Objects and database structure based on the functional specifications and user requirements, and utilized Business Objects Designer to create and maintain the universes, linking Universes. Setting up aggregate awareness in a universe.
• Connected Oracle data base to generate the reports.
• Created prompts, calculations, conditions, measure objects on reporter.
• Used special fields like Dates and Query prompts, Page numbers in the reports.
• Worked as a BA to documented user’s requirement into functional specification.
• Provided support and maintenance to users, universe and Reports.
• Ensured that deadlines are met and manage the activities and deliverables.
• Developed, tested and deployed Business Objects report and Universes.
• Involved in performance tuning of universes by creating alternate views and indexes.
• Performed presentation to managers and decision makers about different ways and options available for them to Improve their Business (Dashboards, Drill Down Reports, Jump off reports)
• Responsible for 24/7 production support of Business Objects.
• Created a UI using Xcelsius to call jump off reports using opendoc and sent prompt parameters to the reports.
• Involved in the migration of the existing legacy reporting system to Business Objects by building new Universe and reports for it.
• Involved in the data warehousing project and provided them with requirements for the reporting database for Business Objects Universe.

Environment: Business Objects XI R3.1, Crystal Reports 2008, Web Intelligence, INFOVIEW, MS-Excel, Oracle 9i, Teradata 12 and DB2.

Confidential, MD

Report Developer

Responsibilities:

• Defined Business Objects and database structure based on the functional specifications and user requirements, and utilized BO Designer to create and maintain the universes, linking Universes. Setting up aggregate awareness in a universe.
• Worked with NPI and NON-NPI Data.
• Created Reuters performance reports and send them across the globe.
• Created universes based on Oracle and SQL Server2005 Databases.
• Created joins, cardinalities, resolved loops and checked Integrity.
• Created aliases and contexts. Created Reports using Desktop Intelligence and Web Intelligence.
• Created Reports in cross tab, master/detail, drill down, created variables format reports for better presentation.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerts.
• Created DESKI reports with multi data provider with linked dimensions to use them in the same report block.
• Created complex reports with multiple folded breaks and on variables concatenating multiple dimension objects to fulfill formatting requirement of a report.
• Created reports with hidden columns and macro’s.
• Created reports on store procedures and local data providers.
• Web Intelligence with Info view, scheduling reports.
• Created Canned Reports for end user and document step by step all the work.
• Created Ad-hoc according to manager requirements.
• Performed presentation to managers and decision makers about different ways and options available for them to Improve their Business (Dashboards, Drill Down Reports, Jump off reports)

Environment: Business Object XI R3.1, Crystal Reports XI, INFOVIEW, Web Intelligence, MS- Excel, MS- Word, SQL Server 2005.

Confidential, Houston, TX

Crystal Report/Business Object Developer

Responsibilities:

• Created Complex reports with SQL views in Crystal Report.
• Understood SQL views and accordingly generated reports.
• Wrote SQL queries in PL/SQL Developer to extract the data from database.
• Defined Business Objects and database structure based on the functional specifications and user requirements, and utilized Business Objects Designer to create and maintain the universes, linking Universes. Setting up aggregate awareness in a universe.
• Connected Oracle data base to generate the reports.
• Created prompts, calculations, conditions, measure objects on reporter.
• Used special fields like Dates and Query prompts, Page numbers in the reports.
• Worked as a BA to documented users requirement into functional specification.
• Provided support and maintenance to users, universe and Reports.
• Ensured that deadlines are met and manage the activities and deliverables.
• Developed, tested and deployed Business Objects report and Universes.
• Involved in performance tuning of universes by creating alternate views and indexes.
• Administrated Business Objects servers, users, access, reports and universes.
• Performed presentation to managers and decision makers about different ways and options available for them to Improve their Business (Dashboards, Drill Down Reports, Jump off reports)
• Worked with database administrators to define database requirements and load procedures to successful Business Objects reporting.
• Responsible for 24/7 production support of Business Objects.
• Created a UI using Xcelsius to call jump off reports using opendoc and sent prompt parameters to the reports.

Environment: Business Objects XI R3.1, Crystal Reports XI, Web Intelligence, INFOVIEW, MS-Excel, Oracle 9i, and DB2.