SUMMARY

• I.T Professional with 8 years of experience in application design, development and implementation of Data Warehouses & Data Marts for Transportation, Health Care, Pharmacy, Health Insurance, Banking and Utilities industries.
• Extensive Experience in gathering requirements from business users and Product Owners.
• Performed elicitation of the business requirements and analyzed the complex scenarios after analysis.
• Worked with Agile, SCRUM and Kanban methodologies.
• Experience working with a team in facilitating Brain storm sessions, Business gathering and implementation and worked closely with end users and conducted interviews to capture the needs.
• Facilitated technical discussions between IT team and stakeholders.
• Experience with Data Modeling and Dimensional Modeling
• Experience in Dimensional Modeling using Kimball and Inmon approach.
• Experience working with Star and Snowflake Schemas.
• Sound knowledge of RDBMS concepts, SQL, PL/SQL, T - SQL (Oracle 11g/10g/9i, Sql Server 2008, DB2, Teradata), Cloud Data Amazon Redshift
• Extensive experience with Informatica Power Center 9.5/9.1/8.6/8.5/8.1.1/7.1.3/7.1.1/7.0/6.2/6.1 Client tools - Designer, Repository Manager, Workflow manager, Workflow Monitor and Informatica Scheduler
• Successfully worked with complex mappings using a variety of transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, stored procedure, Xml parser, normalizer, sequence generator, etc.
• Extensive experience in debugging mappings. Identified bugs in existing mappings/workflows by analyzing the dataflow and evaluating transformations and optimized code in SQL for better performance.
• Knowledge of MS SQL Server Package SSAS, SSIS, SSRS
• Extensive Experience in Tableau working with Tableau Desktop, Tableau Server, Tableau Reader, Tableau Online in multiple versions 8.1,8.0,7,6.
• Experience using Tableau to create visually interactive reports, requests, filters, dashboards and workbook design.
• Hands-on experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau
• Tableau Administration user experience administering privileges, user groups and scheduled instances for reports.
• Sound knowledge of SDLC process best practices and various deliverables in SDLC.
• Experience working with UNIX and Scripting for automation.
• Good knowledge in Business Objects and created various list reports, cross tab reports, charts, universe.
• Highly motivated, Reliable, Responsible, Good team player. Communicate issues and risks appropriately to projects members.
• Data Quality to remove inconsistencies in data and MDM to remove duplicate data.

TECHNICAL SKILLS

Operating Systems: Windows (NT, 2000/03/XP/Vista/7), UNIX (Solaris, AIXv5.2).

Languages: MS SQL Server 200X, Oracle 11g/10g/9i/8i,TeradataV2R6/V2R5, SQL, PL/SQL,T-SQL, DB 2 8.0/7.0/6.0 , C, Shell programming, Perl Scripting, SSH Secure Shell, putty, Liquid Editor Studio

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.5/8.1.1/7.1.3/7.1.1/7.0/6.2/6.1 (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), MSSQL-SSIS, OWB, ODI, IDQ, IDE, MDM, OBIA 7.9.6.4

Reporting Tools: Tableau9/8.x,BusinessObjectsXI 3.1,R3-R2-R 1/6.1/6.5/5.1.6/5.1 , QlikView 9.0/8.5,SSRS

Data Modeling: DW/ETL, OLTP, Erwin 7.2/4.5/4.2/3.5/3. X,Oracle SQL DM

Databases: Hadoop Hive, Gem Fire, Oracle 8i/9i/10g/11g, MS SQL Server 2000/2005/2008 , Teradata 13 V2R6,SFDC,SAP,Amazon Redshift

Scheduler: Tidal, Autosys, Control M, Maestro, PC Scheduler, Informatica Scheduler, Bamboo

Others: MS Office, MS Visio, TOAD, FTP, SFTP, Toad, SQL Developer, Micro Strategy, Data Profiling, Data Mining

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Business Intelligence/Data Analyst/Data Visualization Engineer/DWH/ETL Analyst

Responsibilities:

• Participated in verbal workout sessions with PO and stakeholders to capture the requirements.
• Gathered requirements from PO and translated the requirements to user stories translated functional requirements to technical requirements for the business intelligence platform.
• Tracked the effort using JIRA and used SCRUM methodology to deliver the output.
• Assisted with dimensional modeling, schema design and consumption model for the report.
• Worked closely with Data Modeler to data map the required fields and tables for consumption model.
• Big Data Platform Hadoop Hive, Gem Fire, Amazon Redshift, Green Plum was used as a data source to build the highly interactive dashboards.
• Worked with Tableau Online using Amazon Redshift for reports using cloud services.
• Created operational reports for GE Transportation’s Operations Portal using Tableau Reporting and created dashboards rich in visualization.
• Created visual interactive dashboards with Tableau calculated fields, parameters, action filters and API’s for decision making.
• Defined best practices for implementation and integration of Tableau platform.
• Performed User Acceptance Testing (UAT) and created different test scenarios to be validated by the business for interactive reports.
• Conducted Gap Analysis to show the current and proposed functionalities of the project during UAT
• Worked extensively on optimization and performance tuning of reports on the server and database
• Worked with end users closely to ensure results meet their needs and successfully integrated reports with different environments and delivered it to the end users.
• Demo sessions with PO after every sprint session to see if results meet their needs.
• Documented and created compact user manual for the report usage
• Successfully did three projects from end-to-end

Environment: Tableau Desktop/Server 8.3/9, Green Plum, Hive Hadoop, Gem Fire, Spark, Amazon Redshift, SQL, JIRA,Bamboo

Confidential, Las Vegas NV

Data Analyst/DWH/ETL Analyst/Business Intelligence/Data Visualization

Responsibilities:

• Gathered functional and technical requirements for detailed design of ETL requests from end users, analyzing scope and providing estimations.
• Created, migrated and maintained real-time CDC (change data capture) and batch Informatica ETLs which consolidated data into an active, relational Teradata (13) warehouse from AS400 & SQL Server sources for reporting activity across the casino floor, including member player activity, food & beverage transactions & lodging data.
• Designed and developed ETL processes based on business rules, job control mechanism for Ultimate Gaming
• Designed reusable transformations and worked with complex mappings
• Developed ETL mappings, designed, tested and migrated into production
• Performance tuning of ETL mappings at source, target and transformation level at the database end.
• Documentation of the ETL Flash process jobs for Confidential
• Implemented best practices, documented processes and analyzing areas for improving mappings.
• Designed and developed ETL processes based on business rules, job control mechanism for Ultimate Gaming
• SCRUM approach for monitoring daily progress
• Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for decision making

Environment: InformaticaPower Center 9.5/9.1, SQL Server 05, Teradata (13), Teradata SQL Assistant, Tidal Enterprise, Tableau Desktop 8.0

Confidential, Houston, TX

Data Analyst/DWH/ETL Informatica Analyst

Responsibilities:

• Assisted in Data Model for Patients using Oracle Data Modeler and created Hubs, Links and Satellites
• Transformed business requirements into effective technology solutions by creating Technical Specifications for the ETL from Functional Specifications
• Designed, Developed, Deployed and implemented ETL mappings using Informatica.
• Successfully Analyzed FDW crystal reports and DTS extracts.
• Analyzing the reports to indicate which stored procedure is connected to which crystal report and coding.
• ICD10 analysis might allow to add an extra column to the stored procedure along with thereport
• Efficiently populated Inventory from Sales Force cloud database listing all the dashboard reports that are being impacted by cancer and diagnosis.
• Worked with the testing team for their strategy presentation and reviewed code.
• Managed and listed all the USON Application User Access list for USON Environments.
• HEAT software 9.6 interface and HEATPROD database troubleshoot and debugging
• Succeeded in reporting and solving technical issues and SSRS reporting while using HEAT SOFTWARE.

Environment: Oracle Data Modeler, Oracle Data Integrator, Rapid ACE, SQL Server 05&08R2, SSAS, SSIS, SSRS Informatica 8.6, Oracle 11g, Crystal Reports 8, Sales Force, HEAT 9.6

Confidential, Windsor, CT

DWH/Data Analyst/ETL Informatica Analyst

Responsibilities:

• Used Incremental aggregation for CDC (Change Data Capture) alsoBalanced Load transformation on servers using PDO
• Informatica Scheduler was used to manage the schedule of all jobs and job dependencies
• Identified and corrected bottlenecks and tuned the complex Informatica mappings for optimized performance.
• Solved defects and fixed bugs in production environment, improved performance of ETL mappings.
• Designed, developed, deployed and implemented ETL mappings in PROD Environment

Environment: InformaticaPower Center 9.1/8.6, SAP Business Objects 3.1, Oracle 11g, BAM (Oracle), BPM, TPG flat files, HP-UX B.11.31 (U ia64), HP ALM, HP Quality Center 10.00, SQL Developer, Toad, and Unix

Confidential, New York, NY

DW/ETLInformatica Developer

Responsibilities:

• SCD Type II mapping for updating Credit Card Information and providing faster credit processing for customers.Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters. Lookup, update strategy, and stored procedure transformations, etc.
• Re-engineered lots of existing mappings to support new/changing business requirements.
• Developed reusable transformations, mapplets, sessions, worklets to make Informatica code very modular and reuse as required. Experience using Business Objects reporting.

Environment: Informatica Power Center 9.1/8.6/8.5, Repository Manager, Designer, Work Flow Manager, Informatica Scheduler, Oracle 11g/10g, SQL Server 2008/2005, SSIS, SSRS, TeradataV2R6/V2R5, XML Files, Flat Files, CSV files, PL/SQL(Stored Procedure, Trigger, Packages), BO XI 3.1, QlikView 9.0/8.5, Autosys, Erwin 7.2, OLTP, MS Visio, SQL Developer, TOAD, Windows 2003/2007, UNIX-AIX 5.3, Sun Solaris 5.8