SUMMARY

• 8 years of Experience working with Business Objects 4.1,4.0, XI R3.1/R2/R1/6.5, Designer, Desktop Intelligence, Web Intelligence Rich Client, Info View, Security Design, Performance Manager, Dashboard Manager, Lifecycle Manager, Central Management Console, Crystal Reports/XI/10 - 8, Crystal Xcelsius 4.5 - 2008,
• Having good knowledge in various Queries as a Web Service, Import Wizard, Central Configuration Manager, Live Office, Oracle 11g/10g/9i, SQL Server 2012/2008/2005.
• Developed inventory reports using Crystal Reports in tandem with Microsoft SQL Server and Microsoft Access; reports have increased profitability
• Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.
• Experience creating Business Objects Infrastructure and designing the Security Model for different LOBs.
• Extensively worked on scheduling reports using Business Objects event based scheduling.
• Excellent understanding of Normalization and Demoralization of schemas designed Star schemas (OLAP) and extended star schemas (Snow flake).
• Experience doing implementation using Rapid mart.
• Experience in gathering the business requirement and building Universes, free hand SQL methods and creating complex ad-doc reports.
• Created Financial, Banking, Healthcare and Supply Chain Management dashboards using SAP Dashboards Design 4.0 for company's website.
• Used SASMacros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
• Experience in administration activities like creating and managing repositories, monitoring/granting permissions and rights to users, user groups through Central Management Server.
• Skilled in using TOAD and SQL Tools for performance maintenance of Database Applications.
• Experience in all phases of Testing (Unit Testing, Functional 4Wizard, Central Management Console, Central Management Server, Application Foundation/Performance Manager (Dashboards, KPI's), Query as a Web Service, Crystal Report and Dashboards.
• Experience in working with several data sources like Flat Files, XML, SAP ECC, Oracle, SQL server, DB2 and Teradata.
• Experience in implementing and testing of stored procedures, Views, Packages, Database triggers, cursors, functions at database level using PL/SQL.
• Extensive experience in data modeling, ETL, Working with standard and custom InfoCubes, InfoSources, Extraction Process, Transport organizer.
• Extensive experience in developing Dataflows in BODS.

TECHNICAL SKILLS

Servers: WebSphere, WebLogic, Tomcat.

Databases: Oracle 11g/10g/9i/8i, MS SQL Serve2008/2005, DB2, Teradatav2r5, Teradata13

Programming: ASP.NET, C#.NET, JAVA, SQL, PL/SQL, Python, JavaScript, HTML, XML,T-SQL

Data Modeling: ERwin, MS Visio

DW / ETL Tools: Clear Case, SVN.

Tools: /IDE: SAP BO Data Services 4.x/3.2/ DI 11.7.3/DQ 3.1XInformatica 8.1/7.1, SAPBW/BI3.5, 7.0, 7.2, ECC 6.0 R/3, Informatica Power Center 8.1/7.1. Teradata 13.10, Viewpoint, Teradata Administrator, SQL Assistant, Teradata Utilities, MicroStrategy, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data and Reporting Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, Teradata and SQL Server for design, development, testing, and production rollover of reporting and analysis project within Tableau Desktop.
• Involved in extraction, transformation and loading of data directly from different source systems (flat files/Excel/Oracle).
• Involved in creating interactive dashboard and applied Actions (filter, highlight and URL) to dashboard.
• Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.
• Created dashboards by extracting data from different sources using parameters and calculations.
• Involved in creating Tree Map, Heat maps, background maps, calculated fields, mapping and hierarchies
• Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.
• Performed Tableau type conversion functions when connected to relational data sources.
• Developed dashboard reports on the Tableau Server so that the end users having access to the server can view the data.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Environment: Tableau Desktop … Tableau server, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007 Windows 2007, Java, Teradata and Microsoft office 2007.

Confidential, Billerica, MA

Senior IT Development Analyst

Responsibilities:

• Interacted with Business Analysts, Business Users and other Key Stake Holders in gathering Business Requirements and prepared Technical design documentation for reporting system.
• Acted as a liaison between internal/external clients; gathering accurate requirements to translate into a query for report building.
• Formulated collaboration through training and mentoring among peers and other associates.
• Established relationships across functional areas, created functional operating instructions based on Business requirements.
• Created and modified Crystal Reports for various counseling and domestic violence programs using Crystal Reports 2011 and MS SQL Server 2008.
• • Worked on reports that contained up to 10 sub-reports (including drill-down sub reports). Handled both dependent and stand-alone sub reports. Developed various charts and graphs like Bar chart (side-by-side, stacked), Pie Graphs, Line graphs, Gantt Chart etc.
• Developed SASMacro programs to create Ad-hoc reports.
• Restructured SAS datasets using PROC TRANSPOSE procedure.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SAP BODS.
• Debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.
• Was responsible for resolving time critical issues in production systems in times of batch failures as part of the production support team.
• Implemented complex DI ETL including SCD 1 and 2 and source based CDC for large volume of data from SAP and non-SAP Source systems.
• Installed BOBJ 4.0 and BODS 4.0 and configured SAP and Windows AD authentication for Business objects enterprise.
• Managed enterprise wide Business Intelligence and Analytic applications. Portfolio management of Clinical and Non-Clinical BI applications.
• Participated and supported client audits for systems, validations and processes
• Design and develop a back-end structure for Executive Dashboard.
• Designed cascading prompts in the universe to filter the names based on business units and Implemented the Object level and row level securities in the Universe.
• Used Live Office connection for Dashboards using WebI Report/Universe as the source
• Implemented new security procedures at Universe for different groups by creating multiple connections to avoid spool space issues in Database.
• Created Complex Reports by using multiple data providers, merge functions, variables, sections, breaks & filters in Webi/Webi rich client and Deski.
• Wrote compliance reports and published to 3000 users across the company through bursting/publication.
• Trained Business users in creating Adhoc reports and educated how to implement the best standards when creating the reports.
• Developed security model for IMPACT reports.
• Responsible for purchasing, installation, configuration, maintenance and upgrading of UNIX systems. Analysis of data & logs and reporting of analysis results.
• Implemented various Teradata alerts using Alert facility in viewpoint. Involved in setting up alerts send out notifications as necessary.
• Extensive experience on temporal tables, columnar tables and the various other new features of teradata 14.
• Produced documentation and procedures for best practices in Teradata development and administration.
• Migration project from SQLServer, Oracle to Teradata 14
• Responsible and involved in setting up the Teradata database, users, roles and profiles
• Developed SASMacro programs to create Ad-hoc reports.
• Used SASMacros, SAS SQL to query data and to obtain results that were generally stored as delimited text.
• Restructured SAS datasets using PROC TRANSPOSE procedure.
• Developed Strategic Trend Analysis Report for multi-million dollar clients focusing on corporate clinical cost containment initiatives and drug utilization patterns
• Using SAS Enterprise Guide to create executive level reports to help drive key business decisions and result in 10 - 15% cost savings for clients.
• Responsible for developing marketing strategies as a part of a research project using predictive modeling and score cards in SAS Miner environment
• Imported raw data files in excel format in SAS and subsequently created SAS datasets and performed data cleaning and data manipulations for further analysis and reporting.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Developing Quality Indicator reports to identify key clinical metrics across various drug therapeutic classes for major clients.
• Stored data for business entities, charted criterion and had functions linking it to other MS Office products, Excel and Visio. The tool had an embedded Visio Viewer displaying an entity organization chart within MS Access.
• Created access points for users through CMC security.
• Strong and extensive experience inOBIEE Administration, Admin Tool,OBIEE Answers,OBIEE Intelligent Dashboards andOBIEE Delivers with Siebel Analytics/OBIEE stand-alone/integrated Applications (OBIEE 11G/10G and Siebel Analytics).
• Create visualizations based on customer requirements withSpotfireto include dashboards, executive briefings, and/or front end visualizations.
• Co-Managing and leading JIRA Escalation Task team of 6.
• Developed complex universes for adhoc reporting and canned reports using Web Intelligence.. Implement column and row level security within universes, based on user roles assigned externally to BusinessObjectssystem.

Environment: SAP Business Objects XI 3.1 (CMC, Designer, Webi, Web Rich client, Infoview, SAS/ACCESS, SAS/BASE, SAS/MACRO,SAS /STAT,SAS/GRAPH,SAS/SQL, Auditor, Import Wizard), SAP BI 7.0, Crystal Reports 2008, Oracle 10g, SQL, PL/SQL, Windows XP.

Confidential, Frankfort, KY

Business Objects Developer

Responsibilities:

• Created Dashboards using Xcelsius 2008.
• Worked extensively on BODS/DI 4.0 and later with BODS 4.1 with Teradata.
• Designed and Created complex BODS/ ETL Jobs for Data extraction and loading into multiple systems.
• Created complex SQL queries and stored procedures for Teradata systems.
• Performed extractions on multiple non-SAP source systems and flat files and loaded data into Teradata systems.
• Created complex interfaces for ETL on non-SAP Systems.
• Created complex DI/DS scripts for multiple jobs. upgrading the BODS 4.0 system to BODS 4.1 and migrated required objects to new environment
• Involved extensively in requirements discussion with Business users and supporting them in design specifications.
• Created Web Intelligence Ad-hoc and canned reports.
• Created Data acquisition and Interface System Design Document.
• Worked on developing and coding complex SQL scripts and stored procedures for the Teradata system.
• Used DSMC for bods jobs logs and trace files.
• Worked on implementing complex Universe changes for including prompts, LOVs and complex filters.
• Enhanced existing Batch jobs for design changes and optimized them for large volume data loading.
• Designed and created DI Scripts for File existence check, Daily incremental read, Daily Incremental update, workflow level Script read, workflow level Script update, workflow level Error Handling and Job Dependency.
• Created/Loaded extractors for various Source systems and mapped the objects by creating transfer rules, Communication Structure and Update Rules.
• Tuned Data Integrator Mappings and Transformations for better performance and more efficient loads into Data marts and Data Warehouse.
• Designed and created reusable objects using best practices and guidelines.
• Performed extensive regressive testing and integration testing on ETL and Teradata systems.
• Importing the groups and users from windows Active Directory into Business Objects and granting the users and groups with appropriate rights trough Central Management Console.
• Created Reports with multiple hyperlinks to various reports usingOpen DocumentSyntax.
• Schedule Reports by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user.
• Debugging and testing SQL queries, views and stored procedures in Oracle and SQL Server.
• Performed tuning on existing reports for better performance.
• Creating and Formatting the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, @functionsandFormulaeto analyze the data.Creating and distributing Report Templates to Users andMain Data Providers for creating these reports are - Universes

Environment: Crystal Xcelsius 2008, Business Objects XIR2 (Designer, WEBI), Oracle 10g, SQL Server 2005.

Confidential, Londonderry, NH

Database Administrator-Intern

Responsibilities:

• Configured SAP as well as Oracle rapid-marts and performed maintenance of those rapid-marts
• Tuned data integrator mappings and transformations for better performance such as indexing the source tables and using the data transfer transform.
• Created Data acquisition and Interface System Design Document.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.
• Extensively used SAP BODS ETL process for address data cleansing.
• Developed and tuned all the Affiliations received from data sources using SAP BODS and tested with high volume of data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SAP BODS.
• Implemented complex DI ETL including SCD 1 and 2 and source based CDC for large volume of data from SAP and non-SAP Source systems.
• Created common reusable objects for the ETL team and overlook coding standards.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Involved in coding and developing complex PL/SQL scripts.
• Used ETL to extract files for the external vendors and coordinated that effort.
• Migrated mappings from Development to Testing and from Testing to Production.
• Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin 4.5.
• Responsible for design and build data mart as per the requirements.
• Extracted Data from various sources like Data Files, different customized tools like Meridian and Oracle.
• Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data (staging) to enhance and maintain the existing functionality.
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database
• Supported the Database Administrator in setting up users and tuning databases in SQL 2008.
• Developed reporting templates for reports in SQL 2008.
• Responsibilities as a database include work on a server program. Serve as a backup to the database administrator. Design, create and modify My SQL database.
• Experience with SQL Server 2005/2008 Business Intelligence Studio.
• Develop, implement and maintain the methodology and procedure standards for the effectiveness in the access, backups and recoveries. Work closely with the business areas to understand the requirements and to write complex SQL queries.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery.

Confidential

Business Objects Report Developer

Responsibilities:

• Installed and implemented SAP BODS 4.1
• Involved in the analysis of the user requirements and identifying the sources.
• Created technical specification documents based on the requirements by using S2T Documents.
• Involved in the preparation of High level design documents and Low level design documents.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart. Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges.
• Used Trillium as a Data Cleansing tool to correct the data before loading into the staging area.
• Collect and link metadata from diverse sources, including relational databases and flat files.
• Designed and developed SAP BODS Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Developed reusable Mapplets and Transformations.
• Worked extensively with CMC (Central Management Console) Security, Users and Groups, Authentication.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions. Involved in monitoring the workflows and in optimizing the load times.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Working with Data Integrator Management Console to deploy and schedule batch jobs as Database Administrator and was involved in administrative tasks like Repository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Extensively worked on Performance and tuning of the jobs.
• Designed mapping documents and developed ETL mappings using Informatica.
• Performance Tuning of sources, targets, mappings and SQL queries in transformations.
• Created Functions, Procedures and Triggers in PL/SQL.

Environment: SAP BUSINESS OBJECTS DATA SERVICES 3.0, SAP BW Oracle 10g, Windows Server 2003