SUMMARY

• Experienced with all phases of data warehouse development lifecycle, including requirements gathering, Analysis, design, development, implementation, testing and support/maintenance.
• Exceptional background in analysis, design, development, customization, implementation and testing of software applications / products.
• Demonstrated expertise utilizing Data Integration tools, including Informatica, SSIS, Talend and various RDBMS including SQL Servers, Oracle, MySQL and Teradata.
• Extensive experience in Data Modeling, Data Quality, Data mart / Data Warehouse and Enterprise data architecture development and enhancement.
• Expertise in developing BI reports using various BI tools including Tableau, MicroStrategy, QlikView and SSRS.
• Experience in scheduling of ETL jobs using Tivoli work scheduler and Autosys.
• Extensive knowledge of data transformation, understanding of data modeling concepts, ability to understand and work with complex data models.
• Strong leadership with experience training and mentoring developers and advising technical groups on ETL best practices.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Worked closely with data scientists and analysts to design and maintain scalable data models and pipelines.
• Highly motivated self - starter and a good team -player with excellent verbal/written communication skills.
• Managed and mentored team of developers distributed globally in all facets of the SDLC for ETL Production Operations & System Support.
• Used TFS and Jira to manage Production Support issues and resolutions.
• Used ScrumBan boards and agile methodologies to manage and develop projects through various phases of the SDLC .
• Good knowledge of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and Map Reduce programming paradigm.
• Volunteered for Informatica User Group leader for Iowa chapter.

TECHNICAL SKILLS

• Databases: Teradata, Oracle, Sybase, Amazon Redshift, Hadoop, Hive, DB2, MS SQL Server
• Database Tools: Aqua Data Studio, SQL Assistant, Toad, SQL Developer, SQL Server Integration Services, SQL Server Analysis Services, Business Intelligence & Development Studio, SSMS, SAS, Attunity, Aginity for Redshift, SQL Workbench
• Development skills: T - SQL, PL/SQL, MicroStrategy, SSIS/SSRS/SSAS
• Languages: VB.net, VB Script, T-SQL, PL/SQL, HTML, CSS, XML, ASP.net, JavaScript, Python, C, C++ and MDX, Shell scripting
• ETL Tools: Informatica 9.6.1, SSIS (SQL Server Integration Services), Pentaho, Talend
• Reporting Packages: SQL Server Reporting Services, Tableau, QlikView, SAP Business Objects, Spotfire, Microstrategy
• Tools: /Methodologies: MS Visio, Erwin, TFS, SVN, LIMS, Scrumban, Agile, SQL Profiler, Jira

PROFESSIONAL EXPERIENCE

Confidential, Hayward, CA

Sr. Data Warehouse Engineer

Environment: Informatica 8.x, 9.x, Oracle 11g, PL-SQL, Erwin, MS Visio, SaaS, Tortoise SVN, Toad, Dimensional/Relational Database, LIMS, Scrumban, Nextgen EMR, Spotfire, Sybase, SQL Server, Teradata, Aqua Data Studio, SQL Assistant, Jira, Attunity.

Responsibilities:

• Responsible for EDW/BigData data warehouse application design, data quality, development, testing and deployment.
• Involved in the all phases of the project such as Requirement gathering and analysis, Data analysis, Mapping, Data modeling, ETL design, development and maintenance.
• Completed architecture of automated Greenhouse data mart, Developed Data Model and build the workflows.
• Developed the CDC pipeline for Data Warehouse, Using Attunity tool.
• Involved in Informatica Big data Management(BDM) edition, for POC to Achieve faster, more flexible, and more repeatable data integration, governance, and security on Hadoop.
• Involved in designing / enhancing architecture solutions that are performant and of quality standards
• Identify and recommend improvements in production application solutions or operational processes in support of data warehouse applications and business intelligence reporting (ie, data quality, performance, static and dynamic reports.
• Provide administrative technical support for EDW Applications; assists with documentation and training.
• Involved in BI Development using Tableau, MicroStrategy, Business objects and help/mentor business users with self-service module.
• Research, manage and coordinate resolution of complex issues through root cause analysis as appropriate
• Establish and maintain productive relationships with technical leads of key operational sources systems providing data to EDW / BI /Big Data
• Participate in production migrations and upgrades, develop processes for sustaining the EDW and BI environment and ensure implementation of the same

Confidential, Minneapolis, MN

SQL/SSRS/BI Developer

Environment: SQL Server 2008/2005, Oracle-10g, 11g, T-SQL/PL-SQL, Windows XP, Linux, Visual Studio 2008/2005, SVN, Ankh SVN, Report Builder 2.0, Toad, Reporting Tools, Business Objects, Crystal reports, Report Manager, SharePoint Site, Quality Center, SSIS, SSRS, MicroStrategy, Dimensional Database, Microsoft-Office Suite.

Responsibilities:

• Built various SSIS packages having different tasks and transformations for various business areas and Scheduled SSIS packages
• Created different reports along with shared Data Sources using SSRS.
• Created various functions, views, procedures using PL/SQL and Complex Datasets with SQL.
• Created Parameterized reports and build Single-valued, Multi-valued, Drop- down, Textbox parameters.
• Developed Cascaded Parameters for various reports.
• Designed drill-down and drill-through reports in SSRS, drill-through reports that can navigate to other reports or to other URL.
• Made subscriptions for reports through Report Manager.
• Designed SSIS work-flows and standards for various ETL jobs and Data transformations.
• Involved in database modification process and data re-modeling process for Sales, Orders
• Created SSIS packages to move data from Oracle to SQL Server and also from other sources including CSV, Text, Access and Excel files
• Involved in Resolving advanced and complex application bugs and configuration issues.
• Migrated reports from SQL Server 2005 Version to SQL Server 2008 Version
• Applied Version control to the Project. Used Ankh SVN on client machines.
• Augmented the system Triggers and defined the Triggers to perform the required action.
• Configured and setup Autosys for scheduling Jobs with specific logic.
• Used Quality Center to assign the bugs, defects, issues and the update the status of them. Also to retrieve the requirement documents.

Confidential, NJ

SQL/BI Developer Dec 2009 - Dec 2011

Environment: SQL Server 2008/2005, Oracle-10g, T-SQL/PL-SQL, Windows XP/2003, Visual Studio 2008/2005, TFS2008/2005, Report Builder 2.0, Crystal Reports, Erwin, Informatica, SSIS, SSRS, MicroStrategy, SSAS, MS-Visio, Share-Point Designer, MOSS-2007, Microsoft-Office 2003/2007, Rational Clear Quest and Rational Clear case

Responsibilities:

• Involved in gathering business requirements from business and clients to develop various reports and cubes
• Created functional requirement specifications and supporting documents for business systems
• Designed Informatica work-flows and standards for various ETL jobs and Data transformations.
• Used Agile Methodology in various projects.
• Developed complex SQL and Database objects in SQL Server 2008, Oracle 10g, 11g
• Involved in database modification process and data re-modeling process for Sales, Orders
• Created SSIS packages to move data from Oracle to SQL Server and also from other sources including CSV, Text, Access and Excel files
• Built various SSIS packages having different tasks and transformations for various business areas and Scheduled SSIS packages
• Migrated reports from SQL Server 2005 Version to SQL Server 2008 Version
• Created Partitions in Cubes on time dimension for optimizing the performance
• Designed Hierarchies by setting name column and key column as there was no strong hierarchies defined
• Designed drill-down and drill-through reports in SSRS, drill-through reports that can navigate to other reports or to other URL
• Migrated reports from SQL Server 2005 Version to SQL Server 2008 Version
• Published reports on to Share-Point and Report Server and set the data-driven subscriptions for these reports
• Used MS-Office Web Components to show data directly from the cube on a web-browser as a OWC Report

Confidential, Atlanta, GA

SQL Server / BI Consultant Oct 2008 - Nov 2009

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Informatica, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Reporting services, MicroStrategy, SQL Server Analysis Services, Visio, Share-Point.

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs
• Participated actively in designing the system database structure
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server 2008
• Designed Informatica work-flows and standards for various ETL jobs and Data transformations.
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008.
• Installed and administered Microsoft SQL Server 2008/2005, SQL Server Integration Services 2008/2005, SQL Server Reporting Services2008/2005 and Team Foundation Server 2005/2008.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Generated Reports using Data Source Views in Report Builder 2.0
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Performed performance tuning of stored procedures using SQL Server Profiler
• Used Query Analyzer, Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server