SUMMARY

• Over 8 years of IT experience in Development, Migration, Business analysis, Database design, Build and Support enterprise Business Intelligence solutions using BI tools SAP Business Objects, Platfora, and Tableau.
• Propose and design database models, perform data analysis, data quality checks on Enterprise database platforms - DB2, SQL server, Hadoop.
• Expertise in Installation, Configuration, SSO and troubleshooting Crystal Reports, Business Objects and Migration from Business Objects XI R2 to R3.1/ 4.0.
• Published and scheduled Crystal Reports, WebI and DeskI documents with document merging using BO 3.1.
• Experience in Designing/Developing Complex Universes using Star, Extended Star and Snow Flake Schemas and in developing canned and ad-hoc reports using Business Objects and WebI tools
• Experience in developing and publishing reports, presentations on site and sales metrics for business partners and C level audience.
• Expert in writing large/complex SQL queries using functions, nested queries, views, stored procedures.
• Thorough understanding of Data warehousing concepts and Experience in Designing/Developing Complex Universes using Star, Extended Star and Snow Flake Schemas.
• Working experience with SAP BI 4.0 tools- Universe Design Tool, Information Design Tool, and BI Launch Pad, Web Intelligence.
• Proficient in developing Crystal Reports which includes Standard, Cross-tab, Summary, Sub Reports and Charts using Parameters, Complex Functions and Shared Variables
• Possess extensive Tableau Experience in Enterprise Environment with Tableau versions 8.0, 8.1, 8.2.
• Lead experience designing / developing reports and visualizations in Platfora. Used waterfall, trend charts, and rollup functions to visualize retail business metrics.
• Expertise in Business Objects administration tasks including installation, configuration, migration and deployment.
• Strong experience in design, implementation of Business Objects security model and maintenance of associated content and application.
• Proficient in carrying out Administrative tasks using BOBJ tools like Infoview, CMC, CCM, SIA, Query builder, Import Wizard, Life cycle manager and Business View Manager
• Excellent ability in writing specifications and gathering requirements to develop Viz-boards/ Dashboards/ Crystal reports as per the needs of the client and maintain documentation for future reference.
• Hands on project management experience involving estimating, scheduling, planning and monitoring resources.
• Strong Knowledge of Infrastructure Processes - Incident, Change and Asset Management.
• Hands on experience in creating dashboards/visualizations using Xcelsius 2008, Live office & QAAWS.
• Experience working with a variety of databases such as DB2, Netezza, Oracle, SQL Server, MySQL and MS Access and proficient in creation of Tables, Views, Indexes, Stored Procedures, Functions, Triggers and Packages using SQL, PL/SQL and T-SQL.

TECHNICAL SKILLS

LANGUAGES: C, C++, JAVA, SQL

DATABASE: SQL Server, Teradata, Netezza, DB2, PL/SQL, Oracle, Hadoop, MySql

TOOLS: Business objects XIR2, Business objects XI3.1, Business objects 4.0, Business objects 4.1, Informatica Powercenter 8.6, Informatica Powercenter 9, Adobe Site catalyst, Adobe Discover, SAP BO Data Services 3.1, BO Data Services 4.1, Tableau, Platfora

OPERATING SYSTEMS: Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, Hoffman Estates, IL

Sr. BO / BI Developer

Responsibilities:

• Managed Servers, Groups & Connections using Central Management Console (CMC) and Central Management server (CMS).
• Involved in migration of existing Crystal Reports, Users, profiles, documents and Groups from BO XI R2 to BO 3.1/4.0.
• Published and scheduled Crystal Reports, WebI and DeskI documents with document merging using BO 3.1.
• Created Universes and developed the WebI reports and dashboards using IDT (Information design tool).
• Build and support online, customer, web analytics reporting to Sears and its business partners Kmart, Mygofer, Craftsman, Kenmore, Diehard, LandsEnd and marketplace.
• Responsible for ad-hoc report requirements gathering, creation and developing Technical specification document to review with stakeholders/business analysts and merchants.
• Created ad-hoc reports in Tableau by connecting to various data sources like DB2, Teradata, Cloudera Hadoop/ Flat files etc.
• Designed Tableau visualizations with quick filters, query/report level Parameters connecting to DB2/ Hadoop databases and published workbooks by creating user filters on Tableau Server.
• Developedad-hoc/ canned tableau reports with Trend Lines, Scattered plot charts. Used Quick filters, calculated fields, set parameters for Tableau dashboardsefficiently using Tableau Desktop 8.1 and 8.2.
• Performed gap analysis to identify the attributes/metrics that needs to be transitioned to new database from DB2.
• Analyzed existing BI reports that are to be migrated and developed in Platfora/ Tableau.
• Involved in transitioning the online reporting environment from SAP BI suite to Platfora/ Tableau.
• Created data sources, datasets, Lenses on HDFS locations to meet business-reporting needs.
• Liaison with other departments to retrieve store sales for member vs non-member analysis from Teradata to promote shopyourway rewards.
• Worked with Platfora support team and Hadoop developers to automate the daily Lens refresh in Platfora using UNIX scripting by identifying the underlying load dependencies from Green-box mart.
• Resolve sears production incidents related to desktop/mobile orders.
• Closely monitored and worked with DBA’s to address any issues related to daily/month end data loads with respect to daily feeds received from Adobe warehouse.
• Develop and refine framework for measurement of customer facing leading/ lagging metrics within Sears online businesses using KANA database.
• Understand complex source data models and create reporting data model structures that meet reporting needs and optimize performance
• Created Audit reports to identify BI tool usage.
• Provided recommendations on resolving issues by researching the data integrity and quality.
• Created quality metrics at the source and integration levels, used to monitor data attributes
• Identify key performance metrics, build dashboards, present key insights and ensure data drives actions to improve the business in Integrated Retail (IR).
• Translate data- based insights into actionable business recommendations.
• Develop reporting based on Ad-Hoc requests from various business partners.
• Establish strong collaborative working relationships with internal constituents including information technology, contact centers, store operations, logistics and loss prevention.

Confidential, Schaumburg, IL

Business Objects Developer

Responsibilities:

• Primarily responsible for Planning, installation, configuration of the BOE 3.1 environment components. Configuration includes clustering, Single-sign on and service parameters tuning under the direction of BOE architect.
• Administered Servers, Server Groups, Universes and Connections using Central Management Console (CMC) and Central Management Server (CMS).
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Worked extensively with Integration and System testing teams to ensure all Interfaces were ready to be deployed on Production servers before go-live.
• Converted universes from unv to unx format using Information Design Tool. Mentored team members on issues during conversion and possible resolution.
• Design and develop WEBI reports in BO 4.0 to evaluate new feature and functionality to support the future upgrade.
• Developed universes using derived tables and also used aggregate awareness functions in it to improve the performance.
• Supported multiple universes by modifying existing contexts and alias tables. Modified existing Linked universes before migrating to SAP BI 4.0 SP4.
• Wrote SQL queries/ views and used them as a data source in designing crystal reports.
• Involved in troubleshooting broken reports and fine- tuned complex reports to improve performance.
• Provided on call support and timely assistance for clients with database related issues including data transforming and data loading.
• Migrated Objects between environments using tools like publishing wizard & Import wizard for migration of reports, universes with BIAR files
• Carried out administrative tasks like Scheduling / Re-Scheduling reports using Schedule manager and managing instances using Instance Manager.
• Collaborated with offshore resources on deliverables, timelines.

Confidential

Crystal Report Developer

Responsibilities:

• Designed numerous Crystal Reports including cross tab reports, drill-down reports, summary reports and parameterized reports from tables, views and stored procedures according to the business requirements.
• Used SQL, T-SQL to develop Views, Stored Procedures and Functions which in turn were used to create reports.
• Modified existing database objects to accommodate newly identified attributes as per the KPIs.
• Created Data Connections, Data Foundations, Business Elements and Business Views using Business View Manager.
• Used Business View Manager to create list of values (LOVs) for generating cascading dynamic prompts.
• Developed various complex crystal reports including Drill-down reports, Conditional reports, Cross-tabs reports, Parameterized reports, Summary reports, Charts and Sub reports using Business Views, dynamic prompts, command objects, running totals, stored procedures and views.
• Published Crystal reports to Business Objects Enterprise using Publishing Wizard.
• Created dashboards with Crystal Xcelsius using gauges, alerts, sliders, selectors and charts to present complex data in an easy to visualize format.
• Resolved Fan Traps, Chasm Traps and loops by setting cardinalities manually, using context and alias.
• Created canned/ad-hoc reports using Desktop Intelligence (DeskI) and Web Intelligence (WebI) Reports from multiple data providers through Infoview.
• Converted existing DeskI reports to WebI reports using Report Conversion Tool.
• Developed detailed documentation for report users describing how to schedule, run and view Crystal reports using Infoview.
• Involved in performance testing of all the reports, which helped in analyzing and improving report response time before moving into production.
• Created complex Business Objects WebI reports using features like Sections, Slice/Dice, Breaks, Alerts, Prompts, filters, drill down reports by using Multiple Data Providers.
• Developed detailed documentation to guide users on how to use the new features that are available in Crystal Reports 10.0