SUMMARY:

• 9.5+ years of IT experience in design, development, testing, implementation, and Support. Involved in full life cycle of Business Intelligence Development Projects.
• Experience using TABLEAU 8.0 and 9.0.
• Experience using PENTAHO ETL Tools like SPOON, PAN, KITCHEN.
• Experience working in the LINUX, UNIX and Windows environment. Good knowledge of UNIX Shell Scripting.
• Experience working on databases like ORACLE, SQL SERVER, Teradata, DB2 and Netezza.
• Experience working on BI Reporting tools like Microstrategy 9.X and APPTIO.
• Demonstrated ability to successfully deliver BI Dashboards and Reports, and KPI Metrics.
• Experience in Relational Database Concepts.
• Experience in Scheduling Tools like Tidal
• Working knowledge of Informatica Power Designer and SQL Server Integration Services (SSIS) and T - SQL.
• Experience in integration of various data sources like SQL Server, ORACLE, Netezza, Teradata and Flat files onto the staging area.
• Excellent Verbal and Written Communication Skills and have proven to be highly effective in interacting with business and technical groups.
• Proven experience in complete life cycle of Design, Modeling, Development, Testing Deployment, Maintenance and documentation of ETL. Implemented Data Cleansing, Transformation scripts and necessary Test plans to ensure the execution of the data loading process.
• Experience in Requirements Gathering, Data Discovery, Data Analysis leading to derivation of KPI Metrics for Dashboard development & Report Development.
• Experience in Performance Tuning of the Reports and DB objects.
• Experience in handling multiple projects and requests for multiple business users simultaneously and successfully delivered for AGILE projects.
• Involved in Support and gave of the reports to the business users.
• Excellent interpersonal and communication skills and is experienced in working with senior level managers and developers and analysts across multiple disciplines.

TECHNICAL SKILLS:

ETL: Pentaho, COMPOSITE, PL/SQL

Data Mapping: Pentaho

Data Source: Oracle, DB2, Teradata, Flat Files, SQL Server, Netezza, MySQL

BI Reporting Tools: Tableau, Microstrategy, APPTIO

Languages/Scripting: SQL, PL/SQL, Unix Scripting, HTML/CSS, Java Script, VB.NET, PYTHON

DBMS Access Tools: Toad, ORACLE SQL Developer, SQL Server Management Studio, Teradata SQL Assistant, Aginity Workbench, WINSQL

Scheduling Tools: Tidal

Project Tracking Tools: HP QC, Rally

Versioning Tools: WINCVS, Clear Case, VSS, SharePoint, SVN, GITHUB

PROFESSIONAL EXPERIENCE:

Confidential, Mount Laurel, New Jersey

Business Intelligence Analyst / ETL Developer

Technologies: Pentaho - SPOON, KITCHEN & PAN TABLEAU APPTIO Oracle 11G, PL/SQL, SQL Developer SQL Server 2012, SSMS Netezza, Aginity Workbench MySQL UNIX Shell Scripting, PYTHON Scripting Rally GITHUB

Responsibilities:

• Worked on requirements gathering, analysis and design of ETL and BI Reports.
• Performed Data Cleansing and Standardization Techniques on Source data from heterogeneous data sources.
• Performed ETL Objects migration from COMPOSITE to PENTAHO successfully.
• Delivered Dashboards and Reports using TABLEAU and APPTIO.
• Provided Application support and to the Business Users on the Reports.
• Participated in Performance Improvement by optimization of ETL Scripts, built Indices and used Bulk Loader Utility.
• Handled and delivered successfully for multiple projects and requests simultaneously.

Confidential, Charlotte, North Carolina

Business Intelligence Analyst

Technologies: Netezza, Aginity Workbench, WINSQL Microstrategy Oracle 11G DB2 UNIX Shell Scripting Informatica Power Designer TIDAL WINCVS

Responsibilities:

• Worked on requirements gathering, Impact analysis, Data Analysis and Analysis of Source systems.
• Participated in Design Meetings of the EDW team and suggested ETL changes to accommodate the billing system events.
• Participated in definition of Metrics required for Variance Reports for comparison of Pre billing events and Post billing events data.
• Participated in creation of Microstategy Schema objects like Attributes, Facts, Hierarchies, Metrics and Filters.
• Created Business Intelligence Dashboards and Reports with Microstrategy Desktop Using the schema objects.
• Performed Data Analysis based on the Variance Reports and determined the Root Cause factors causing data variance in the existing Key Metric Reports.
• Provided and reviewed the ETL changes based on the Root Cause Analysis to fix any issues in EDW.
• Created ELT scripts and maps using Netezza SQL.

Confidential, Charlotte, North Carolina

DATA Analyst

Technologies: Netezza, Aginity Workbench, WINSQL Oracle 11G SQL, PL/SQL UNIX Shell Scripting WINCVS

Responsibilities:

• Worked on requirements gathering, Impact analysis, Data Analysis.
• Participated in Design Review meetings.
• Performed Data Mapping Sessions with both Target and Source side team to derive transformation rules and valid values.
• Created the Source 2 Target Mapping spread sheets based on the transformation rules.
• Created SQL, PL/SQL Scripts to test the transformation values and their validity.
• Co-ordinated and helped the Offshore Analyst team.
• Performed Data Profiling Activities.

Confidential

ETL Developer

Technologies: SSIS SQL Server 2005 SQL, T - SQL WINCVS

Responsibilities:

• Worked on Impact analysis, Data Analysis, Design and Development.
• Participated in Design Review meetings.
• Created SQL and T-SQL Scripts for the ETL Development.
• Created Adhoc SQL Reports.
• Created Unit Test Plans and performed Unit Testing and Integration Testing.
• Co-ordinated with the onsite team.

Confidential

Application Developer, SQL Developer

Technologies: SQL Server 2005 SQL VB.NET XML VSS

Responsibilities:

• Analyzed and worked on order flow management of different service orders through various provisioning systems.
• Worked and helped in creating the Order Flow Management design documents.
• Created a VB.NET application which automated the test flows, by generating the source/ input files which mimicked the live service orders.
• Created Unit Test Plans and performed Unit Testing and Integration Testing. Also, tested the complete order management flow.
• Co-ordinated with the onsite team.

Confidential

SQL Developer

Technologies: SQL Server 2005/ 2000 SQL,T - SQL Clear Case

Responsibilities:

• Analyzed order flow management of different service orders through various systems.
• Provided Development and Application Support.
• Created and modified SQL procedures to extract and post back data through various systems.
• Created Unit Test Plans and performed Unit Testing.
• Created Adhoc SQL Reports.