SUMMARY

• 8+ Years’ Solid expertise in Creating Complex Applications using Tableau 10.2/9.1/8.1 , SAP BusinessObjects BI 4.1/4.0/ XI 3.1, Crystal Enterprise 2011/2008/XIr2/10/9/8.5/8 and 4 years in mainframe.
• Designed and developed Work books and interactive Tableau Dashboards to provide detailed and enhanced visualization of data using key features available as per the requirement of the users.
• Excellent understanding of Application Development LifeCycle and expertise in Data modeling and Data Warehousing using Agile Methodology.
• Experience in Business Objects BI4.1/BI4.0/XI3.1/XIR2/6.x/5.x (Business Objects SDK, Desktop/Web - Intelligence 4.1/ 4.0/ XI3.1/ XIR2, CMC, CCM, CMS, Launch pad, Info view).
• Experience in designing Universe, Web Intelligence, Desktop Intelligence, creating ad-hoc reports and archiving reports along with performing User acceptance testing and Data accuracy test.
• Extensive experience in Designing and Developing Reports such as List reports, Parameterized, Mail Label, Cross tab Reports using the base tables, Views, Commands, involving Formulas, Subtotals, running totals and Sub reports using Crystal Reports 2011/2008/XIR2/10/9/8.5/8.
• Developed complex report and Dashboard using PowerBI and migrated an existing crystal report into PowerBI.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Developed visualization reports using DOMO as an alternative to Tableau.
• Experience in Database Applications with Oracle, SQL Server, MS Access and very efficient in tuning the SQL queries and using several tools & utilities.
• Experience in writing and debugging Stored Procedures, Views and triggers using T-SQL Script.
• Good Knowledge of installation, configuration of MS SQL Server 2005, 2000 and 2008.
• Hands on experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Working experience in Relational Database Management systems (RDBMS), Star Schema and Multidimensional Data Modeling.
• Experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages. Extensively involved in installation of Oracle database, performance analysis, tuning, and capacity planning.
• Strong experience in single and multi-dimensional data warehousing applications using Business Objects Enterprise and Business Intelligence Products.
• Strong skills of writing SQL Queries using SQL Server /Oracle Databases.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading ETL.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, HTML, DHTML, Java, JavaScript, ANSI SQL/ Presto / Hive/ MySQL, Python,, PHP, Perl, Ruby

Databases: Oracle 8i/9i/10g/11g, SQL Server 2000/05/08, Teradata, Sybase, IBM DB2, MS Access

Tools: Business Objects 4.1/XIR3/R 2/6.5/6.0/5.1 , Crystal Reports XI/10/9/8, Tableau 10.2/9.1/8.1 , Power BI, SSRS, DOMO, WebFocus.

ETL: Informatica Power Center 6.2/7.1/8.6/9.5 , Business Objects Data services, SSIS, IBM DataStage 8.0.1DW Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Design

Others: ERWIN 4.1.2/4.x/3.x, Excel, version control, SQL Navigator, SQL Developer, TOAD

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

• Developed huge number of reports using Business Objects as part of CluePoints reports requirement for different studies like EVOLVE II, EVOLVE Short DAPT against Keystone database to generate different types of reports like Protocol Compliance, Visits, Visit Compliance, AE (Adverse Events), Enrollments etc.
• Used tables and added new derived tables to the existing BO Universe as per the requirement and published to create new reports and improve existing reports.
• Worked on a very critical issue where a standard Business Objects report (AE Coding report) used by all the Studies was populating duplicate records for only 1 Study (Longevity) to figure out what was wrong and responded back to the user in very short period.
• Worked extensively as part of Clinical IT team to understand the business and involve in the development of the reports based on the requirements of users from various departments in BSC like RM (Rhythm Management), IC (Interventional Cardiology) using Tableau.
• Reviewed and involved in obtaining the Business requirement documents along with business analysts and developed complex reports based on the requirements and going through multiple discussions with the team.
• Created a Tableau Dashboard to compare types of treatments called SOLYX and OBTRYX II, where units like Enrollments, Subject Retention, Queries, AE’s, Deviations are compared which are interactive and can be filtered for desired time periods and Studies Involved in the program.
• Developed Interactive dashboards for RM (Rhythm Management) and IC (Interventional Cardiology) departments to visually evaluate different scenarios by adjusting key variables using Tableau.
• Imported Views from RAVE database, improved and Enhanced according to the Keystone Database to access all the required Data.
• Developed report on various studies including sub-reports, Maintained and enhanced existing Crystal reports as per the requirement changes and moved to production.
• Mapped various Studies to GUI RULES which are part of overnight Keystone run to insert new data (new studies) into keystone.
• Initialized and documented on the Source to Confidential Mapping of each study in the GUI RULES for easy access and clear understanding of the source and Confidential of each study being accessed for various purposes.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Worked with Informatica team to perform FULL Load of the database whenever required
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using Informatica.
• Worked on the existing Materialized views used for Catalyst reports to enhance and make changes eliminate an existing issue.
• Created and enhanced Materialized views, involved with team in making necessary changes to Keystone Rave Body and Study Specific Packages for new studies and to improve performance of the reports of existing studies.
• Used Tortoise SVN for version control and coordinated with team on the latest version of any existing code or which is under development.
• Used BOX tool to save and update documentation on different processes and sprint Deployment related files and notes online which can be accessed by all the team members. Updated as soon as the development work is finished.
• Used JIRA tool during sprint and daily Stand-up to track progress on the projects assigned and bug fixes.
• Extensively followed Agilemethodology, especially Scrum process and Extreme programming for software development.

Environment: Tableau 10.1, Business objects, IDT, Crystal Reports 11, Info View, BO Web Intelligence, Tortoise SVN, JIRA, BOX, Informatica, Oracle 11g, PL/SQL, TOAD 12.10, SQL Developer, Win SQL and Windows 7.

Confidential

BI Developer

Responsibilities:

• Worked extensively with the team to understand the business and involve in the development of the reports based on the requirements from various clients working with Confidential .
• Reviewed Business requirements documents from business analysts and prepared functional specification documents and completed the report application development.
• Used Business Objects to develop complex reports based on the requirements provided and going through multiple discussions with the team and responsible for scheduling reports to higher officials on Monthly Basis.
• Included Report Design and Coding for Standard Tabular type reports along with Drill Down, Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Applied security features of Business Objects like row level, report level & object level security in the universe to make the sensitive data secure.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Desktop.
• Developed few sample dashboards using Tableau to present the data with excellent visualization and got the approval from users.
• Interactive dashboards were developed using Tableau for executives to visually evaluate different scenarios by adjusting key variables.
• Developed ad-hoc reports along with static reports using Crystal reports and scheduled them to run on monthly/quarterly basis as per the requirement.
• Developed complex reports using drill down, slice and dice, master/detail for analysis purpose and headcount.
• Developed dashboards using Xcelsius and Crystal reports for Health Living Online Analysis, Health Assessment, Risk Stratification, Lifestyle Risk Factors, Medical Risk Factors and Various other factors.
• Developed very crucial reports using SSRS with complex formulas and queried database to generate different types of reports like MCTQ ( Confidential Tobacco Quit), CallitQuits and Stratification Billing Reports.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Created UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and execute the • SQL's on UNIX environment.
• Created, tested, and documented Teradata Multiloads for moving data into Teradata.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools, Informatica Server, Repository Server manager.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Worked on Change Data Capture on both Source and Confidential level for SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Used TFS as a tool to keep track on the progress of work assigned and for the version control of the development.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Documented and updated bugs/defects along with workaround solutions using Quality Center.
• Extensively involved and was part of the team in developing reports and dashboards using POWERBI (SSRT).
• Helped in providing all the required metrics and calculations along with the required fields for creating a cube for the development of a report called AMCO using POWERBI.

Environment: Tableau 10.1, Business objects 4.0, IDT, Info View, CMC, Crystal Reports XI R2, POWERBI, Xcelsius, SAS, SSIS, SSRS, Teradata, Oracle 11g, PL/SQL, TOAD, SQL Developer, Win SQL, Windows 7.

Confidential - Bethesda, MD

BI Developer

Responsibilities:

• Involved in gathering requirements from the users, creating spec and layout of the report.
• Worked with the team to understand the Business Rules and Process of Logistics.
• Interacted with the ‘Operations’ Team in understanding the requirement and the data mapping of the reports.
• Modified and developed new reports and few dashboards using Tableau tool with enhanced visualization of the data.
• Involved in tuning the SQL Queries for better report performance.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Designed multiple reports which include ‘Bill of Lading Report’, ‘Packing List Report’, ‘Open Orders Report’, ‘Inventory Adjustment Report’, ‘Stock Status Report’ etc. using Tableau.
• Worked in ‘Application Reporting’ team for designing new reports using Tableau &Crsytal along with production support of the existing reports.
• Developed universes as per the requirement and migrated from one environment to other.
• Created Sub-reports to implement the UOM Conversions for the Items from eaches to Cases or from Cases to Pallets as per the report requirements to the existing Crystal Reports.
• Responsible in moving the reports from TEST to PRODUCTION folders after Customer's approval and scheduled reports on CMC Server on daily/weekly/monthly to be sent to the customers.
• Effectively designed reports using Views, Stored Procedures, Sub-Reports, Cross-Tabs, Drill - Down, Running Total Fields and Shared Variables using Crystal reports.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports including shared and global variables by using Chart expert of Crystal Reports.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems and to export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Gathered requirements for shipping labels and designed customer specific labels using Loftware.
• Extensively used different fonts and symbologies in printing the Barcodes on the reports.
• Responsible for the support and development of new and existing shipping and packing labels.
• Used Cherwell ticketing system for version control of the reports and to know the status of the report.

Environment: Tableau, Crystal reports, SSIS, Oracle 11g, PL/SQL, SQL Developer, Windows.

Confidential

BI Developer

Responsibilities:

• Involved in gathering requirements from the users, creating spec and layout of the report.
• Developed Tableau visualizations and dashboards, created action filters, parameters and calculated sets for preparing dashboards and worksheets from multiple data sources using Data Blending. usingTableau Desktop.
• Modify and developed many existing reports as per the requirement changes by adding new logics and removing existing logics and by creating new Parameters, Formulas etc., as the line of Business changes periodically using Tableau.
• Used Footprints tickets for version control of the reports to know the status of the report.
• Schedule the reports using Infoview to run at specific times in a day/week as desired by the Business Users.
• Designed and developed Crystal Reports, the Cross-Tab Reports for displaying vital data and summary reports with drill-down capabilities.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Applied Agile Methodology for all BI Reporting and Security project.
• Creating reports using SQL SSRS 2008 and perform maintenance of existing reports
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Using InformaticaPowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Used ETL (Informatica) for Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from the legacy systems and load the data into Confidential database.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implemented in Data Integrator jobs.
• Used advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Create various database objects like Tables, Views and Stored Procedures by using Toad.
• Assist UAT team in testing the reports using SQL queries in TOAD, SQL developer and Win SQL and advise them with necessary changes.

Environment: Tableau 9.1, BO Web Intelligence 3.1, UDT, Info View, Business Objects Designer, Crystal Reports XI R2, Oracle 10g/9i, PL/SQL, SSIS, SSRS, TOAD, SAS, Rapid SQL, SQL Developer, Win SQL, UNIX, Windows 7.