SUMMARY

• Tech - Savvy and driven IT professional with total 9 Years of experience in the field of Business Intelligence and Data warehousing.
• Technical expertise on BI Tools like Business Objects Enterprise, Crystal Reports, Xcelsius, Tableau 8.0 Professional, Composite, Micro strategy and QA/Testing
• Over 4 years of experience in Business Analysis/Data analysis
• Expertise on designing the Universes; Highly skilled in building reports using Web Intelligence, Desktop Intelligence, and Crystal Reports; Hands on with customizing applications using BOE Java SDK
• Worked on Business Objects Administration
• Designed Dashboards and Scorecards using Crystal Reports, Xcelsius 4.5, 2008,Tableau 8.0; Hands on Business Objects Live Office and QAAWS for automation of the Dashboard refresh.
• Well versed in Oracle 11G, Microsoft SQL Server SQL, Transact SQL and PL/SQL scripts
• Working knowledge of UNIX shell scripting
• Strong experience in Object Oriented Programming and Methodologies

TECHNICAL SKILLS

Reporting tools: Business Objects XI R1/R2, XI 3.1, BO 4.0, Crystal Reports, Micro strategy

Dashboard Tools: Xcelsius 4.5, 2008, Performance Manager 6.5, and XI, SSRS (SQL Server Reporting Services), Tableau 8.0

OLAP tools: MS SQL Server Analysis Services (SSAS), Voyager, Crystal Reports

ETL tools: Informatica Power center7, 8, SSIS 2005, Data Integrator XI, Composite

Databases: Oracle 8i, 9i, 10G, 11G, MS SQL Server 2000, 2005, Teradata V2r5, V2r6, DB2

Operating Systems: Windows server 2003, 2008, UNIX, Linux

Others: MS Excel, MS Access Microsoft Suite, HTML, JSP, XML, .Net, and Erwin

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NYC

Responsibilities:

• Business Analyst for Enterprise DW and SMA Trade Capture. This project receives the daily trades or data feeds from several different sources.
• Define the scope of Agile Sprint cycle. Conduct Sprint Planning, brainstorm, retrospections, daily scrums. Keep track of progress on user stories, story points.
• Written SQL/T-SQL scripts using MS SQL Server 20008/2012.
• Created Stored Procedures, Triggers in DB as per requirement specifications
• Hands-on with Tableau 9 dashboards, familiar with concepts like Data blending
• Build Hive/Impala connectivity in Business Objects IDT
• Design Logical and Physical data models using star schema
• Experience with Enterprise scheduler tool - Active Batch jobs
• Experience creating Excel Macros to automate data cleaning procedures
• Created Vlookup and Hlookups in Excel

Confidential, Newtown Square, PA

Analytical Owner

Responsibilities:

• Analytical owner for long-term solution with SAP HANA/BW as backend, Business Objects Information Explorer as presentation layer and Smart Business Executive Edition as Self-service Planning tool
• Built visualizations using SAP Business objects Design Studio 1.6 on SAP HANA Views
• Performance optimization and mobile deployments
• Written SQL/T-SQL scripts using MS SQL Server 20008/2012
• Created Stored Procedures, Triggers in DB as per requirement specifications
• 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

Reporting Analyst

Responsibilities:

• Analyze/Understand the business objectives and reporting requirements; Analyze source data, build data warehouse for reporting purpose
• Power user for Business Objects Reports
• Implemented performance optimization for reports running slow by creating stored procedures, views, Indices etc.
• Create DB views to support the existing reporting requirements
• Gathered requirements to customize application using BOE SDK; Integration with application portal
• Managed project timeline and resources, maintained Project plans and submitted weekly Status reports to senior management.
• Responsible for coordinating final requirement and SDLC documentation sign-off, code delivery and defect management
• Understanding of Capital Markets
• Assist End Users in creating ad-hoc reports using both Web Intelligence and Full client versions

Confidential, New York, New York

Business Intelligence Analyst

Responsibilities:

• Lead Business Analyst for building T24 Reports, these ensure compliance with FRB’s Regulation U.
• Analyzed data across T24 Data files, Data Warehouse to exemplify the business logic.
• Key stakeholders include PB Lending, Loan Maintenance Team, Credit Risk Management, Bank Regulatory Compliance, IB Collateral Monitoring Unit and Solution Partners
• Stakeholder Analysis, Elicitation/Requirement Gathering for Reporting and Analytics within Private Banking IT
• Wrote Use cases for Proof of Concept of building dashboards using Tableau 8.0, Micro strategy
• Wrote Use cases for Proof of Concept of Composite tool which is used to integrate multiple data layers and expose views built as web service used into Mobile platforms like Tablets
• Using SAP Mobile Platform/BO Explorer - Displayed Web Intelligence Reports / MBOs onto iPad
• Wrote System Requirements Specification documents, Change Requests, technical documentation; Implemented performance optimization for reports running slow by creating stored procedures, views, Indices etc.
• Power user for Business Objects Reports; Scheduled reports, automated to send the reports MS outlook inbox
• Work with cross-functional teams, key stakeholders, end users to gather requirements and work with development team to translate/implement the project deliverables on time
• Involve in UAT, IT and Production Support
• Assist End Users in creating ad-hoc reports using both WebI and Full client versions

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