TECHNICALSUMMARY:

• Senior Data management professional with rich experience in building data warehouse and ETL solutions
• 20 years of experience in the software industry performing the rolesof Architect, Manager andDeveloper. Have MCTS certification in Business Intelligence development
• Built logical, physical data models on Life sciences, Revenue management, Health care and CRM domains
• Strong presentation and client engagement skills
• Build RFPs, SOWs and POCs
• Strong experience withETL processes, Star Schema, Data Marts, stored procedures , T-SQLs
• Built data warehouses using Inmon and Kimball methodologies
• Experience managing onshore and offshore teams
• Knowledge of Java, Hadoop, No SQL- Mongo DB

TECHNICALSKILLS:

• Databases: SQL server 2000/2005/2008 R2/2012, Postgres, Oracle 10g/9i/8i ,DB2,Progress
• Database DBA Tools: Pgadmin,SQL Server Management Studio, Query Analyzer, Enterprise Manager, Aqua studio, Quest TOAD ,Embarcadero DBArtisan and Grid Control
• Languages/Products: Java, PL/SQL, SQL Plus, VB Scripts, XML, SQL Loader, SQR, Progress 4GL, JCL, Unix Shell Programming, Telnet, Vi editor, Embarcadero DTStudio ,Cognos,Qlikview, Liferay, Tableau 8.2, Amazon EC2, Eclipse
• Software: SSIS, SSAS, SSRS, Informatica 9.0,IDS Informatica Data Services , PowerCenter, SSIS, SSAS, SSRS, DTS 2000, ERStudio, JIRA, TFS, VISIO,Remedy,MKS and VSSafe
• OP Systems: Sun Solaris 8, 7 , HP-UX 11.00/10.2 , Linux, Windows XP/2000/NT, Unix

EXPERIENCE:

Confidential

BI/EDW Architect

• Responsible for the design of a client facing data warehousing solution
• Performed the requirement analysis and defined the project plan
• Responsible for designing and developing the data warehouse solution with student admission/college data
• Defined the logical and physical data models
• Wrote 70 SSIS packages for the ETL Process
• Installed and administered Tableau Server 8.2
• Developed Tableau workbooks and dashboards
• Created several stored procedures, triggers in the database
• Built database views on the source system PostGres 9.3 and SQL Server
• Built reports using SSIS and cubes using SSAS
• Participated in the design meetings with the product team
• Develop stored procedures and triggers for the Enterprise Architecture team

Confidential

Solutions Architect

• Designed and developed Enterprise DataWarehouse solutions for large pharmaceutical clients
• Responsible for defining logical and physical data models
• Defined the Data Warehouse Architecture
• Build solutions to measure Brand, Field performances
• Created several SSIS Packages, T-SQLSand stored procedures for various ETL projects
• Managing a5-member team, responsible for maintaining the budget, project plan, building burn-down charts and interacting with the clients
• Provide advice to Senior Management on new technologies
• Build RFPs, SOWs and travel to client locations for renewal of accounts and develop new business opportunities

• Worked extensively with IMS, Wolters-Kluwer,Veeva and Concur data feeds

• Installed Informatica 9.0.1 on Windows Server. Developed several workflows, mappings, maplets using Powercenter client.
• Installed Qlikview, Liferay products and designed Qlikview solutions

Confidential

Technical Leader

• Responsible for designing the back end of the OLTP system
• Designed and developed programs to load patient information files using SSIS.
• Wrote several stored procedures, developed SSIS packages and architecture applications that processes complex datasets and feeds data into the database.
• Created databases, tables, views, T-SQLs, Triggers in SQL Server 2005
• Responsible for back up and restoration of data
• Performed root-cause analysis, tuned SQL queries and participated in code reviews
• Monitored the file load processes and provided status reports to the management
• Contacted the clients to resolve issues, as part of the Operations role
• Ensured the files are loaded as per the SLA
• Mentored and gave directions to Junior developers
• Performed project management tasks including scheduling, allocation of work, overseeing and collaborating with the Business Analysts and QA team.

Confidential

Technical Leader/ Manager

• Responsible for managing a team of 6 Engineers
• Responsible for requirements gathering
• Define and maintain data technology architecture
• Responsible for design, development and deployment of an ETL application that will load data into the Oracle system and data warehouse
• Responsible for building the logical and physical data models
• Developed several T-SQLs and stored procedures
• Gave directions to team, define project delivery schedules and update project summary sheets
• Provided technical recommendations and suggest best methods and procedures to code
• Define the budget for the project and allocate work to the different team members
• Participated in weekly status meetings conducted by the PMO and CIO
• Coordination with development teams, QA and documentation

Accomplishments:

• Reconfigured the SSIS packages for 64-bit environment that reduced the processing time by 15
• Conceived a simple XML concept for storing the Client's layout and business rules which enables a non programmers Business analyst or programmers to set-up a new client
• Made updates to the code for superior performance, data quality and easy on boarding of new clients
• Optimized the Oracle stored procedures and reduced the load time by over 40
• Created generic ETL programs to serve multiple types of clients were able to migrate 11 Insurance clients Progressive,21st Century, One Beacon, Hartford etc in just 20 days
• Helped developers solve challenging problems and advising on solution strategies

Confidential

Enterprise Data-warehouse

• Built logical design and physical design of the databases
• Responsible for the extraction, transformation and load of data from various heterogeneous sources into the SQL Server Database
• Wrote several PL/SQL code, Oracle Stored procedures, T-SQL Stored procedures, DTS Packages and SSIS/SSAS packages
• Created ER diagrams to illustrate the data models
• Built 6 data marts from scratch
• Built over 80 dimensional tables, 25 ODS and 10 fact tables in the Data Warehouse
• Wrote Cognos reports for users and trained them to use the star schema

Accomplishments:

• Wrote PL/SQL procedures with DBlinks to extract data from Oracle 9i and 10g databases simultaneously
• Optimized the SQLs, recommended function-based indices reduced the query time by 10
• De-normalized the Data warehouse tables for faster querying reduced the reporting time by 25
• Created materialized views in Oracle to store aggregated data improved performance by 8
• Survey response data mart helped the company to improve the CSI score by 1.5
• Created an application in vb.net to display the CSI scores and display the scorecard information
• Fixed bugs, tuned sub-queries, improved processing time and enhanced the data warehouse availability to 100