TECHNICAL SKILLS

• BI Tools include SAP BI 4.X
• Crystal Reports
• Xcelsius
• Tableau 8.0
• Micro Strategy
• Dashboards
• Composite
• Quality Control
• Quality Assurance
• Data Integrator
• Informatica Power center 8/9.6
• ETL
• Star Schema
• OLAP cubes
• Oracle 11G
• Microsoft SQL Server
• Transact SQL
• PL/SQL
• BOE Java SDK
• SAP HANA 1.0

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NYC

Responsibilities:

• Design, develop and deploy Business Objects Universe on Cloudera HDFS DB (Amazon Web services Cluster)
• Build Tableau dashboards
• Install Business Objects 4.2 SP2 version on Windows Server 2012 R2
• Setup/Configure Windows AD integration with Single Sign - on
• Build Hive/Impala connectivity in Business Objects IDT
• Used Promotion Management (CMC) to migrate Business Objects Universes/reports
• Design ETL loads and transformations using Informatica Power center 9.6
• Design Logical and Physical data models using star schema
• Experience with Enterprise scheduler tool - Active Batch jobs

Confidential, Newtown Square, PA

Analytical Owner

Responsibilities:

• Analytical owner for long-term solution with SAP HANA as backend, Business Objects Information Explorer as presentation layer and Smart Business Executive Edition as Self-service Planning tool
• Has to think analytically and arrive at creative solutions
• Gather the requirements from Business Stakeholders, engage in conversations with multiple clusters in Enterprise Analytics group
• Work closely with IT Platform team to build information models using HANA, perform reconciliation checks and business validation testing
• Create executive summary presentations for Business sponsors, track the project in SAP JIRA by defining Epics, Backlog entries.

Confidential, Mount Laurel, New Jersey

Business Objects Consultant

Responsibilities:

• Design, develop and deploy Business Objects artifacts such as universes, reports
• Define classes and objects in business-friendly terms and arrange them in a logical fashion for end users
• Resolve designer issues like loops, traps, and ambiguous queries by defining contexts and aliases
• Responsible for performance tuning
• Assist end users in creating ad-hoc reports using Desktop Intelligence, Web Intelligence and full client versions
• Upgrade BI solutions by keeping track of latest releases

Confidential, New York, New York

Business Objects Lead/Analyst

Responsibilities:

• Lead Business Analyst for building T24 Reports to ensure compliance with FRB’s Regulation U.
• Analyzed data across T24 data files, data warehouse to exemplify the business logic.
• Key stakeholders included PB Lending, Loan Maintenance Team, Credit Risk Management, Bank Regulatory Compliance, IB Collateral Monitoring Unit and Solution Partners
• Worked on client facing application Consolidated Client Reporting (CCR), Client View
• Lead Analyst for building MIS reporting web-based solution that provided various levels of data aggregation.
• This was used by financial business users, including Relationship Managers (RM), Branch Managers, Sales and Senior Management for viewing Assets under Management (AuM), Revenue earned and Net new Money (NNM). Also for allowing drill-downs for deep dive analysis
• Wrote system requirements specification documents, change requests, and technical documentation
• Designed, developed and deployed Business Objects artifacts such as universes, and reports using Business Objects XI 3.1 SP3
• Designed Universe Schema on Oracle Cubes (Oracle 11G), relational tables and views
• Customize application using BOE SDK; Integration with application portal
• Scheduled reports, built calendars using Central Management Console (CMC)
• Reported names, such as AUM by Asset Allocation by Client, Positions Report, Realized Gains or Losses Reports
• Implemented ranking, custom filters, combined queries, merged dimensions, calculation contexts, hyperlinks or open document, alerters or conditional formatting, scope of analysis, sub-queries, sections, breaks, crosstab reports, different chart types, input controls
• Defined classes, objects in business-friendly terms and arranged them in a logical fashion for end users
• Resolved designer issues such as loops, SQL traps, ambiguous queries by defining Contexts, aliases
• Responsible for performance tuning
• Installed and configured BI 4.1 on Windows Server 2008 R2
• Migrated environment from XI 3.1 to 4.1 using Upgrade Management Tool
• Configured Windows AD authentication in 4.1; Designed Folder and Application Level security in CMC
• Maintained the objects (Universes, WEBI, Crystal Reports) in DEV, QA, PROD environments using Import Wizard, LCM, Promotion Management Tool
• Worked with team in debugging problems and corrupt data by investigating on different mappings.
• Assisted global end users in creating ad-hoc reports using both WebI and full client versions
• Upgraded the BI solutions by keeping track of latest releases

Confidential, NJ

Senior Business Objects Lead/Analyst

Responsibilities:

• Understood business objectives and reporting requirements
• Analyzed data sources, data profiling, data mapping
• Created, deployed and maintained Universes using Designer XI 3.1
• Built universe on SAP Business Warehouse (SAP BW) or Business Explorer Queries
• Familiar with short-cut joins, derived tables, aggregate awareness, Objects hierarchy and types of security
• Implemented aggregate awareness, derived tables, resolved fan/chasm traps, and set up row level security
• Implemented Custom filters, Merged dimensions, Prompts, Hyperlinked reports, combined queries
• Implemented performance optimization for reports running slow by creating stored procedures, views, Indices
• Created or scheduled publications, report busting
• Created DB views to support the existing reporting requirements
• Configured Business Objects Auditing on Production/QA/Dev environments, to use pre-built audit reports
• Assisted end users in creating ad-hoc reports using both Web Intelligence and full client versions
• Experience in migration from BO XIR2 to XI 3.1
• Installation and configuration of Business Objects software, service packs, fix packs, licensing
• Upgraded BI solutions by keeping track of latest releases

Confidential, NJ

Programmer/Analyst - BI

Responsibilities:

• Collaborated with business stakeholders to assess their needs and goals to recommend solutions. Collaborated with IT team including Application and DB Developers, DBA and IT Support during all phases of the projects
• Gathered and analyzed document requirements. Designed application UI, document - using wireframes and mock-ups and assisted in building prototypes. Documented business logic, process flows, data mapping and use cases. Wrote functional and technical requirement specifications
• Collaborated with IT teams to discuss and propose Application Design and Architecture that met functional and non-functional requirements
• Performed gap analysis on legacy applications during decommissioning
• Installed and configured Crystal Reports XI, Business Objects XI R2
• Created and modified database tables using MS SQL Server 2000
• Created stored procedures, tables, views, indices
• Modified data using T-SQL
• Created CMC Repository using SIA
• Designed, developed and deployed universes, Web Intelligence reports
• Built dynamic calendar type based on user input in Universe, designed master/detail reports, reports using ranking
• Self-starter for Business Objects implementation

Confidential

Programmer/Analyst

Responsibilities:

• Designed, developed and deployed in-house applications - Testing Services Management Office - a site developed for managers. It included several features, such as recruitment drive entry, pipelines, utilization of resources
• Experience spanned across different verticals, i.e. projects included clients like Sallie Mae, United Health Group, CCC Insurance, Ameriprise
• Designed, developed and tested the reports based upon data generated by Enterprise transaction, financial and customer information systems, using Business objects 5.1 and 6.5 connected to multiple data providers such as Oracle 9i and MS SQL server2000
• Played a key role from Project startup to QA sign off
• Worked on Oracle, Unix, Putty
• Knowledge of SDLC, testing life cycle, testing methodologies and testing techniques
• Prepared and executed tests cases
• Experience in functional and regression testing
• Experience in defect management
• Worked on JUnit Tool
• Knowledge on automation testing tools like Load Runner
• Designed three different universes for finance and sales departments and worked/made changes on 17 other Universes, which already existed and was in use
• Upgraded old reports, universes to new version of BO that was BO6.5
• Creation of BCA (Broadcast agent) for scheduling and monitoring reports
• Created about 60 new reports and repaired about 200 Old reports
• Used functionality like drilldown, complex queries, slice and dice panel
• Created macros in Visual Basic to perform calculations and displayed in reports
• Used Visual Basic Application (VBA) tool to access external data
• Solid experience working in multiple environments (BO5.x & BO6.x)
• Created metrics using dashboard manager and also used Application builder to build Metric analytics and statistical analytics
• Worked on Application foundation building executive and marketing dashboards
• Worked on Crystal Reports9 and uploaded to Business Objects XI
• Involved in writing stored procedures and triggers using Transact SQL