SUMMARY

• Strong technical expertise in SAP Business Objects 4.2(Web Intelligence, IDT & UDT), Crystal Reports Enterprise, Tableau 8.1/9.1 and OBIEE 11.1 Publishers and Answers.
• Experience in Qliksense 3.1, Enterprise Scale Reporting SolutionsusingSAP BW 7.4 - BEX Query Designer and Analyzer
• Very good noledge on IBM Cognos BI (8/10), Microsoft BI - SSIS and SSRS
• Comprehensive functional noledge inSales & Distribution,MM(Purchasing & Inventory Management) and general business process of SAP ECC.
• Very good noledge on ETL, SAP HANA Modelling, SAP BW -DSO’s, InfoCubes and MultiProviders.
• Good understanding of Master data and Transactional data load to BW Providers.
• Excellent functional noledge in Oracle EBS, IT GRC SOX Controls and Corporate Reporting functionality
• Thorough noledge of Software Development Life Cycle (SDLC) including Agile and Waterfall methodologies. Experience working in Scrum Projects.
• Competent as a Technical Lead with Analysis, development and implementation of reports/ dashboards and expert in analyzing current and future business processes
• Skillful in process oriented business requirements gathering - functional and non-functional requirements by means of conducting meetings and interviews
• Expertise as Project Lead in collaborating with multiple teams to ensure defect free delivery, project tracking
• Implemented Six Sigma concepts in projects to ensure high quality deliverables
• Combine patience, determination, and persistence to troubleshoot client issues
• Motivated and focused team player with stronganalytical andproblemsolvingskills withexcellent interpersonalandcommunication skills.

TECHNICAL SKILLS

• BI Reporting and ETL Tools
• Data Visualization & Dashboards
• SAP and Oracle
• SAP BUSINESS INTELLIGENCE 4.2 - Business Objects
• UDT, IDT and Web Intelligence (All prior versions of SAP BI/BO R3.1, R2)
• Crystal Report 2008/2011 & Business View Manager
• Basic Administration on Business Objects user autantication, authorization, server maintenance.
• IBM Cognos BI 8/10-Framework Manager, Report Studio, Query Studio, Cognos Connections, Analysis Studio,
• Microsoft BI - SSIS Designer & SSRS Report Designer on Visual Studio
• Info Burst Enterprise scheduler
• Tableau 8.1 / 9.1
• QlikSense 3.1
• OBIEE 11.1 - BI Publishers & BI Answers
• SAP BW 7.4 - BEX Reporting ( Query Designer and Analyzer)
• SAP BI - Explorer( Information Space)
• SAP HANA Modelling using Eclipse ( Only theoretical noledge)
• Databases
• Oracle SQL & PL/SQL, Microsoft SQL Server 2005 ( SQL Developer, Toad and AQUA tools)
• Project and Quality Management
• Scrum execution
• Six Sigma Green belt certification training
• HP ALM, Service Now and Remedy for Project Management

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

Decision Support Analyst

Responsibilities:

• Interacted with business users/management and identified Business requirements, analyzed reports in Sales & Distribution, Manufacturing and Inventory application areas.
• Understand the non-SAP systems and reporting usage to deliver data in multiple phases
• Engage in discussions and meetings to gather reporting requirements based on new SAP data source
• Build complex web intelligence reports on top the Bex queries, combined with universe data sources.
• Built complex P&L, Profitability and Sales distribution reports using variables and formulae used for sales assessment and promotions.
• Generated the Pricing reports from Oracle EDW, used Infoburst Enterprise scheduler to burst and distribute reports to various users.
• Enhanced business critical logistics reports to be used by DCs on WMS system using Crystal reports’ features like form based and pixel perfect formatted reports.
• Perform extensive data validation and end to end testing from ECC data on customer Master, Material Master, Sales Order, Material movement and Inventory data.
• Work with SAP BW team to understand the underlying ADSO’s, composite providers on top of which Bex Queries were built.
• Used SAP ECC and BW for data testing.
• Used QlikSense to build interactive, dashboards for internal project use for data discovery on project and quality tracking tools like HP ALM
• Designed and developed Qlik Sense dashboards on Sales data to be used by Field Reps and Sales Directors.
• Assist trainings for end users

Environment: SAP Business Objects 4.2/4.1, SAP BW 7.4, Info Burst EnterpriseCrystal Reports 2013, Oracle 12, Qliksense 3.1

Confidential, New York City, NY

Report Analyst

Responsibilities:

• As a report developer responsibilities include working closely with PMO and IT department of Langone to understand the business requirements for Business Objects Reports
• Convert the business requests to technical specifications, create and maintain design artifacts for design
• Derive at the appropriate design following best practices of Langone MCIT by means of understanding existing EDW and Reporting infrastructure
• Create artifacts and work with Business Analysts and other stakeholders for approvals
• Work with data modelers and ETL team to understand the data model and load logic that will facilitate the development of reports for complex logic, work on enhancements ETL load logic based on requirements
• Completely understand the Front Range HEAT system and suggest better reporting views
• Design and develop Universe from BO 4.1 IDT that supports ad-hoc and on demand reports. The universe features like calculated columns, IDT level filtering, hiding columns were used.
• Multiple Views of the same universe was created for various purposes of reporting.
• Design and build Business objects reports with drilling and hyper linking features, cascading prompts, List of Values, graphs/charts etc.
• Design and build Dashboards using Tableau 9.1 based on the HEAT system data
• Used Tableau features like Filters, Parameters, Groups and Sets.
• Build interactive dashboards that halp the top management use the data for data quality and infrastructural decision making
• Create derived tables and View for complex business functionalities.
• Work on building security tables for distribution
• Perform Unit testing and peer reviews, assist business analyst in Integration testing and QA.
• Train various teams of NYU IT department on Business Objects usage.

Environment: SAP BI XI R 4.1, Tableau 9.1, Microsoft SQL Server 2008 and Oracle 12

Confidential, Jersey City, NJ

Data Analyst

Responsibilities:

• Provide data analysis and design as Data analyst and Senior Report Developer
• Assessment of AML reports that are currently in use and parallel redesign of the Business objects reports
• Working with the ETL team to establish new EDW design
• Co-ordinate with business users to come up with use cases and test strategies.
• Develop design documents for the business objects reports thus resolving the existing design flaws both from EDW and reporting perspective.

Environment: SAP BI 4.1 and 3.1 (Business Objects Web Intelligence, Universe and IDT, Microsoft SQL Server 2012

Confidential, Teaneck, NJ

BI Project Lead & Data Analyst

Responsibilities:

• Support for the finance team reports by understanding the concepts of Oracle financials General Ledger & sub-ledgers
• Completely noledge of the data that is being used for reporting in terms of Oracle Financial planning and re-conciliation
• Interact with the EBS core team to analytically resolve data issues and create new Business Objects reports and Tableau Dashboards
• Worked extensively on building new Crystal Reports and maintaining existing reports in Crystal 2008
• Worked with the BO Administrator to migrate 3 universes and 50 web intelligence reports from BO 3.1 to BO 4.1 using Upgrade Manager tool - managed users rights and schedule of reports.
• Co-ordinate between the client team and offshore support team.
• Provide expert technical leadership - assessed requirements, created design artifacts, conducted
• Technical design reviews and code reviews identified and resolved key technical issues.
• Key role in closing critical support tickets and was the primary Business Objects Administrator
• Established and sustained a high level of partnership with the Business.
• Instilled a level of confidence in technical noledge in order to suggest and deliver solutions to business opportunities.

Environment: SAP BI 4.1/3.1 (Web Intelligence& IDT), Crystal 2008, Oracle 10g, Tableau 8.1

Confidential, New York

BI Project Lead

Responsibilities:

• Build complex metadata models using Cognos Framework manager and BO Universe Designer - with drill and hierarchy features for reporting purposes.
• Reports and dashboards creation using Cognos Report Studio and WebI BO 3.1 with features likeList, Cross-tab, Chart, Drill-ThruandMaster-Detail Reports.
• Designed SSIS Packages to for extracting, cleaning, transforming and loading data into data warehouse - from flat files to SQL Server using Business Intelligence Development Studio.
• Providing Technical Specifications and review of artifacts
• Involved in the creation of database views in Oracle suiting to reporting needs
• Worked extensively on oracle stored procedures and pixel perfect Crystal reports derived from stored procedures
• Migrated few web intelligence reports and 2 universes directly from XI R2 to BO 3.1 version using Import Wizard
• System configurations, Unit testing and application performance analysis, application fixes, small enhancements and Major developments.
• Initiated training for the users to do ad-hoc reporting usingQuery Studio.
• Worked on PoC on Tableau 8.1 and Microsoft SSRS

Environment: Cognos 8/10, Microsoft SSIS - BI Development Studio, SAP BO XI R3, Crystal 2008, Oracle 10g, SQL SERVER 2005, Business Objects Data Integrator/BODS, Tableau 8.1

Confidential

Technical Lead

Responsibilities:

• Requirements gathering and estimation. Functional specifications, Technical Specifications and review Technical Specifications done by other developers.
• System configurations, Unit testing and application performance analysis. Application fixes, Small enhancements and Major developments.
• Technical leadership - assessed requirements, created design artifacts, conducted
• Technical design reviews and code reviews identified and resolved key technical issues.
• Master the application noledge to design, develop and test Business Objects universe and reports.
• Established and sustained a high level of partnership with the Business.
• Instilled a level of confidence in technical noledge in order to suggest and deliver solutions to business opportunities.
• Collaborated and mentored other team members in software engineering techniques & ensured their is clear ownership (accountability/responsibility)

Environment: Crystal 2008, Oracle 10g

Confidential, Ohio

Technical Lead

Responsibilities:

• Onsite Team Lead providing expert technical design and assistance to team
• Involved in requirements gathering for business subjects reporting needs, designed and developed reports and universe
• Understand the installation of Business Objects, analyze schedule errors caused by servers and fix them
• System study and requirement gathering for the Migration. Constant client interaction and Co-coordinating offshore team
• Designed the database views, designed and developed Business Objects universe.
• Designed and developed complex reports, scheduled reports
• Performing design reviews and system integration testing.

Environment: Business Objects XI R2/Oracle 9i