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 / 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 / R, 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 / 2013, JIRA, Sharepoint, Slack, Version One, Eclipse.

PROFESSIONAL EXPERIENCE:

Confidential - Credit Suisse, NC

Sr. Business Intelligence Developer / Lead

Responsibilities:

• Lead Business Objects, Crystal Reports and Tableau development projects for multiple applications under Margining Services IT team.
• Acted as an SME for Business Objects development and security queries.
• Developed and enhanced multiple Business Objects reports, universes and dashboards on margining and collateral data, which was widely used by the Business for daily trade processes. Developed several user-friendly universes to fulfill adhoc-reporting needs of the Business.
• Handled Business Objects administration activities in Development, QA and UAT environments by managing users, groups, folders and connections. Applied row level securities and data masking techniques to restrict confidential data based on user groups.
• Utilized dynamic emailing lists and personalization of data in Business Objects to send client interest statements across multiple departments.
• Enhanced performance of multiple WEBI and Crystal reports by analyzing joins, formulas, sqls and DB indexes.
• Created several Crystal reports, which were integrated with customer facing external applications. Fulfilled complex business requirements for dynamic report headers, customized report exports and time zone enhancements.
• Lead Business Objects XI 3.1 decommissioning project for multiple applications by performing content, scheduling and data validations against Business Objects 4.1. Worked directly with business users and production administrators to ensure maximum reporting uptime.
• Developed user friendly visualizations and dashboards in Tableau using wide range of tables and chart types, like scattered plots, dual axis, cross tab and box and whiskers plots.
• Created multiple mappings in Informatica PowerCenter Designer to load and transform data from multiple source files and databases to data warehouse tables. Developed and configured workflows and sessions in PowerCenter Workflow manager to connect these mapping together.
• Worked directly with analysts from Business teams to gather, analyze and document requirements for Business Objects, Crystal Reports and Tableau development projects.
• Efficiently followed Agile principles to ensure timely project delivery by tracking and updating JIRA stories with detailed acceptance criteria and design documentations.

Environment: Business Object 4.1 SP 7, Business Objects XI 3.1, Launch Pad, Web Intelligence, Info View, Universe Design Tool, Information Design Tool, Dashboards 4, Xcelsius 2008, Query As A Web Service (QAAWS), Crystal Reports, Tableau Desktop 10.1.12, Tableau Server 10.1.12, Tableau Reader, Oracle PL/SQL Developer 12, Informatica 10.1.1, PowerCenter Designer, PowerCenter Workflow Manager, MS-Office 2010, JIRA, ServiceNow, Tortoise SVN, Windows 7 Enterprise, Windows Server 2008 R2 Enterprise.

Confidential, VA

Sr. Business Intelligence 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 Capital One 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

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, Teradata 13/14/15, Oracle 10g / 11g, MS-Office 2016, HPSM and HP Application Lifecycle Management, VersionOne, Windows 7.

Confidential - Vantiv, 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, Remedy, Oracle 11.1, SQL Server 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 database 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.