SUMMARY:

• Around 7+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Scope includes creating WebI Reports, Story Board - SAP LUMIRA and Dashboards on Design Studio.
• Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Defined and shipped a new exporting functionality on SAP Business Object Design Studio & Lumira, in collaboration with engineering.
• Worked on Data Scrubbing/Cleansing, Data Quality, Data Mapping Data Profiling, Data Validation in ETL.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Checked the integrity of the Universe using Business Objects Universe Designer and resolved issues.
• Proven development experience using full suite of Business Objects reporting tools: Web Intelligence, Crystal Reports, Information Design Tool, Universe Design Tool.
• Strong Delivery Skills including requirements gathering, gap analysis, effort estimations, functional design, and UAT Support, Master Data Administration, Training and risk analysis.
• Experience in design of Data Warehouse/Data Mart, Star Schema, Snowflake Schema, ODS, ETL process, Data Requirement Analysis, Data modeling &ER-Diagrams, Development, Testing, Documentation and Implementation of Business Applications.
• Good understanding of Oracle Data Dictionary, Oracle Workflow, Data Flow Diagrams, ER Diagrams, Data warehousing concepts, RDBMS and Normalization Techniques.
• Familiar with Data warehousing tools. Used ETL tools like Informatica 8.x/ 7.x to extract and load data.
• Extensively used Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) in SQL to process large data requests.
• Proficient at developing Ad hoc queries and reports using Teradata SQL and UNIX to fulfill data requests from business analysts and financial analysts.
• Proficient at creating Reports, Pivot Tables, VLOOKUP, Hook-up, Index, Graphs, and Match in MS Excel; Proficient at utilizing MS PowerPoint, MS Access, and MS Word.
• Good understanding in Banking, finance, credit card and Health care industry business processes.
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skilful, creative and innovative in developing efficient logic/code.
• Hands on experience and proven practices of resolving performance issues at various (Applications, Database) Levels.
• Working experience around HP ITSM software's like configuration manager, service manager, change management suite etc.
• Strong experience in design and development of ETL process from Staging to Data warehouse and to Data mart
• Experience in Data modeling using Relational (Normalized), Dimensional Data Modeling (De-Normalized), Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.x.
• Experience in Unit Testing, System Testing and User Acceptance Testing, creating test cases using Mercury Testing Tools.
• Changing data loading from SQL Loader to SSIS using templates decreased load time from source to target by about 30% and development time by 70%.
• Aided in the transition of the Business Objects universe from UDT (Universe Design Tool) to IDT (Information Design Tool).
• Technical experience utilizing SAP Business Objects BI development tools (IDT, Web Intelligence, Design Studio, Lumira and Crystal Reports).
• Converted Business Objects Web Intelligence pharmaceutical reports from one universe to another.
• Hands on experience in Installing, Implementing, Migrating the SAP Business Objects and redesigning the Security Model.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin r7.1/7.2, Erwin r8.2, Erwin r9.1/9.5, Embarcadero ER/ Studio 9.7, Oracle Designer, Sybase Power Designer

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports9, SSAS, SSIS

Programming Languages: SQL, PL/SQL, Base SAS, HTML, XML, VB.NET, C, C++, UNIX and Shell Scripting

Database: Microsoft SQL Server, MySQL, Oracle 10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1

Packages: Microsoft Office Suite, Microsoft Project 2010 and Microsoft Visio

ETL Tools: Informatica 7.1/6.2, Data junction, Ab-Initio, Data Stage, SSIS

Data Visualizations: Tableau, QlikView/Qlik Sense, SAP Business Objects, OBIEE, SSRS

Other Tools: SAS Enterprise Guide, Version One and JIRA, R

WORK EXPERIENCE

Sr. Data Analyst

Confidential, Gainesville, FL

Responsibilities:

• Good Working knowledge of Oracle Database Version 11g and SQL server with regards to SAP administration such as database backup, archive log backup, table space management, update statistics.
• Integrated SAP BW with BOBJ 4.1 reporting system include IDT, WebI reports and Design Studio.
• Involved in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Abilities and Informatica Power Center and testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Written PL/SQL Stored Procedures and Functions for Stored Procedure Transformation in Informatica.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Involved in the new projects and helped the team to make the decisions for Business Objects Universes and Reports.
• Leading the team for SAP Data Migration. Managing and allocating work among the team members.
• Developed reports using business objects tools (Crystal Reports) and exported reports into various formats like Excel, PDF etc.
• Used various Crystal Reports features like conditional formatting, designing formulas and parameter passing.
• Utilized ODBC for connectivity to Teradata & MS Excel for automating reports and graphical representation of data to the Business and Operational Analysts.
• Worked on loading data from flat files to Teradata tables using SAS Proc Import and Fast Load Techniques.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SAS, Ms Excel, Ms Access, SQL, and UNIX.
• Designed, created and implemented WebI reports, Webservices (BIWS) and Design Studio Dashboards using best practices.
• Used Business Objects XIR3 extensively and Involved in Full SDLC (software development life cycle) rules are followed for designing new components.
• Trained the users to write the Business Objects reports and helped them with some advanced functions.
• Experience in Data Extraction from and Load into heterogeneous Data Sources such as Oracle, MS SQL Server, Flat files, XML and loaded into SAP ECC, SAP HANA, Data Warehouses.
• Created SSIS Packages for import and export of data between MS SQL Server 2014 database and others like MS Excel and Flat Files.
• Delivered and compelled the demonstrations on Lumira Predictive analysis and HANA Complex Models.
• Developed SSIS transformations & Event Handlers for Error handling and Debugging for the Packages.
• Wrote complicated SQL queries to load tables in the data warehouse DB2 database, decreased data loading time by an estimated 60%.
• Comprehensive understanding of SAP Business Objects configuration and performance tuning.
• Created source to target mapping documents from staging area to Data Warehouse/Data Mart.
• Created dashboards, reports, and analyses that provides a platform for decision making on a variety of business issues.
• Utilized Tableau to create effective data visualizations and dashboards to deliver key business insights.
• Presented and defended complex analysis internally and externally to both technical and non-technical audiences.
• Collaborated with the team to develop a whole process of launching a membership system including points awarding and redemption, gift fulfilment and account maintenance.
• Understood clients' needs and priorities to create detailed models to locate the target group of the CRM campaign.
• Updated and maintained the campaign reports. Compared the performance of the target group and the control group.
• Generated periodic reports such as partner report and credit report for project managers.

Data Analyst

Confidential, Hopkins, MN

Responsibilities:

• Used ETL methodology for data extraction, transformations and loading in a complex Enterprise Data Warehouse (EDW).
• Responsible for all aspects of SAP Basis Administration, system installation, upgrades, database management.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Designer.
• Performed analysis, coding, testing, implementation and troubleshooting on production reports and tables, as well as producing ad hoc reports using SAS.
• Converted and loaded data from flat files to temporary tables in Oracle database using SQL*Loader.
• Extensively used PL/SQL in writing database packages, stored procedures, functions and triggers in Oracle 10g.
• Used Ref cursors and Collections with bulk bind and bulk collect for accessing complex data resulted from joining of large number of tables to extract data from data warehouse.
• Extracted data from various production databases using Teradata to meet Campaign data needs.
• Data loaded into Teradata from flat files using data stage dynamic sequence job with schema file concept.
• Studying Business Requirements Design (BRD) for the enhancements / Physical Data Model changes raised by the business.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets using Explain Plans.
• Graphical representation of the reports using MS Power Point Presentation and MS Excel Charts.
• Optimized high volume tables (Including collection tables) in Teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.
• Educated the team on how to utilize the Teradata tools like Database query logs (DBQL), Visual explain etc.
• Extensively used MLoad, FLoad, TPump and Fast Export Teradata tools both in ETL and UNIX scripts for high volume flat files.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints, Explain plans.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure FastLoad and MultiLoad sessions.
• Designed ETL Mapping Specs for ETL team for Source to Target Mappings and corresponding business rules involved.
• Designed, created and maintained Universes for Business Objects and Web Intelligence users using Business Objects Designer Module.
• Designed and developed the logical and physical data models to support the Data Marts and the Data Warehouse.
• Lead the database development, ETL and report development activities and work closely with On-shore and off-shore developers to ensure proper data flow from SAP to Teradata and is available for reporting solutions.
• Contributed to development of new products and functionality by working in conjunction with editorial, data management and technology groups.
• Skilled at developing reports in Design Studio Graphical Analytical Reporting with Charts and graphs.
• Used SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Skills in Business Objects Universe design, WebI and Crystal reports generation, publishing and migration using Info View, Import Wizard, Central Management Consol.
• Develops reports, charts, tables, graphs, and intermediate statistical analysis using tools such as SAS, SQL, Tableau, and MS Excel.
• Creating Schema & Package with the help of SQL Script in SAP HANA and loading Flat Files data into SAP HANA Studio.
• Highly proficient in writing loader scripts like BTEQ, MLoad, Fload, TPump and Fast Export.
• Involved in full life cycle of Business Objects reporting Application.
• Involved in Universe design using Information Design Tool.
• Created Complex Crystal Xcelsius Reports from the output of Business Objects report data.
• Interacting with the end-user (client) to gather business requirements.
• Used Performance Monitor tool to kill run away queries, abort blocked sessions.
• Developed SQL scripts involving complex joins for reporting purposes.
• Design and build SAP Lumira documents, story boards and visualizations.

Data Analyst

Confidential, Watertown, MA

Responsibilities:

• Used Data warehousing for Data Profiling to examine the data available in an existing database and created Data Mart.
• Responsible for creating & managing the Business Objects repository and coordinating/performing universe development.
• Extensively used SQL for Data Analysis and to understand and documenting the data behaviour.
• Developed an interactive web page (HTML/ JavaScript) for users to search restaurants, update preference and view recommended restaurants.
• Developed a web service using (Java servlet, REST API) to fetch restaurant data from Yelp API.
• Designed and developed a filtering and sorting algorithm to match similar restaurants based on categories.
• Improved the precision by ordering restaurants based on stars, distance and matched categories.
• Design, develop, validate and integrate reporting and information solutions with Design Studio.
• Using SAP BI (BI Universe design, WebI reports, Dashboard) to develop performance repots and converting Crystal reports.
• Reversed engineered existing data bases to understand the data flow and business flows of existing systems and to integrate the new requirements to future enhanced and integrated system.
• Conducted presentations training sessions and created training documents for the Business users on the use of Business Objects reporting tool and overview of the Universe.
• Performed end to end ETL testing of Custom Tables which were developed for Cognos Custom reports.
• Coordinated the testing process for various periodic reports like.
• Developed complex SQL's to validate the data in periodic reports as a part of Aggregate Testing.
• Involved in Regression testing of Argus Safety(Periodic) and Insight reports (Cognos Custom and Out of the box) to verify if the Hot fix defects have been fixed in the system (Hot fix1 and Hot fix2 Testing).
• Test various BizTalk interfaces developed for the automation of product, license and study configurations.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Performed analysis, coding, testing, implementation and troubleshooting on production reports and tables, as well as producing ad hoc reports using SAS.
• Generated various reports on a daily, weekly and monthly basis using Business Objects Report module.
• Develops reports, charts, tables, graphs, and intermediate statistical analysis using tools such as SAS, SQL, Tableau, and MS Excel.
• Involved in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Abilities and Informatica Power Center and testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Worked with Business Objects Professional services to build a online training material using the SAP Knowledge Accelerator tool for reporting.
• Strong ability to synthesize available data from multiple sources, identify opportunities to maintain, clean & process the data to provide quality reports & analysis.
• Work with large data sets, analyze the data to understand the key business drivers & the implications, engage in discussions on what the data means and presenting it with dashboards reports, graphs, and summaries.
• Involved in SAP security administration and authorization including creating roles, generating profiles, creating roles as per the design.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Designed SSIS Packages to transfer data from flat files to SQL Server using BIDS, and design ETL process.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Utilized MySQL/MongoDB to store user preference and restaurant information.
• Deployed the application to Amazon EC2 for better performance.
• Coordinated the testing process for Out of the Box reports (Argus Insight reports).
• Assist in the configuration of products, licenses and studies in Argus Safety.
• Familiar with EDC, E2B and other data exchanges.
• Provide support for post-production issues, fix the issues, test the issues.
• Lead the design, development, auditing & maintenance of processes & reports.