PROFILE:

• Over 15 years of experience as Architect / Software Engineer in Database Development using Microsoft SQL Server, MS BI and Oracle.
• Extensive experience as Data Architect, Business Intelligence using Microsoft Technologies.
• Worked 6 years at Microsoft.
• Excellent Analytical, Data Modeling and Performance toning skills.
• Working in all areas of software development cycle.
• Extensive experience in Database Design/Data Modeling and Data warehouse design and Business Intelligence.
• Analyzing software requirements.
• Designing software solutions.
• Proficient in developing Data related applications.
• Worked in various Data Migration Projects and redesign of Data Warehouse.
• Excellent Transact SQL skills.
• Intermediate exposure to Cloud Platforms. (MS Azure).

TECHNICAL SKILLS:

Primary Skills: Microsoft SQL Server, SSIS, SSAS, SSRS, Oracle and Erwin. Data Modeling, Business Intelligence, SQL Performance Tuning.

Databases: Microsoft SQL Server, Oracle

PROFESSIONAL EXPERIENCE:

Data Warehouse Architect

Confidential, Tampa, FL

Environment: MS SQL SERVER 2016, Informatica Cloud, PowerBI.

Responsibilities:

• Working as a Data Architect on Confidential Project.
• This is a new Data Warehouse building from scratch.
• We Pull data from various sources like Salesforce, GreatPlains and from many internal systems.
• Confidential is designed as a Star Schema dimensional model.
• Loading data from Source systems to Staging, ODS layer and then to Confidential using Informatica Cloud as ETL tool.
• Dashboards and Reports are created using PowerBI. Primary focus is on Data Warehouse design and Performance tuning.

Data Warehouse Architect / Development Database Administrator

Confidential, Tampa, FL

Environment: MS SQL SERVER 2008/2012/2014 , SSRS.

Responsibilities:

• Working as a Data Warehouse Architect and Administrator for Reporting Project. Data Warehouse project to consolidate all Clients Practice/EMR data to Azure SQL Database.
• Most of the work is in MS SQL and MS BI(SSIS & SSRS).
• A complete Star Schema is designed, and data loaded to it using SSIS. Visualization (Dashboards & Reports) are created using Poser BI. Worked on ETL Architecture, Data Warehouse Design, Development, Semantic Layer, Testing and Deployment. Created ETL Framework which will support Full and Incremental data load to Azure SQL Data Database consistently with proper Logging and Auditing enabled. Used Azure Machine Learning to predict few Patient behaviors.
• Also working extensively on Performance tuning of existing queries for Reporting and Client/Server applications.
• Primary focus is new Reporting environment using SSRS and enabling users to create their own reports using Views created by Development team.
• Working on all aspects of SQL Server including New features/Database design, Performance tuning and Report writing. Other tools used are SolarWinds DPA, RedGate Azure Explorer, SentryOne Query Plan explorer.

Data Architect

Confidential, Tampa, FL

Environment: MS SQL SERVER 2012/2014, MS BI & Cloudera Hadoop.

Responsibilities:

• Working as a Data Architect in all IT Projects of the company. Created Confidential 2.0 and maintained all existing Data Warehouse and Data marts.
• Confidential 2.0 is designed/developed and deployed to Production on AWS.
• A Well thought ETL Framework is created for SSIS and religiously used in all SSIS Packages.
• Confidential integrated Member data, Provider data and Claims data from multiple Health Insurance clients.
• All above data in conformed to industry standard dimensions like ICD, DRG etc. SSRS and Tableau is used to generate Reports from EDW.
• Confidential is created using Data Vault Method. Created multiple Data marts on top of EDW. Helped DBA to move all Server infrastructure to AWS.
• Also created a DocumentStore database to store pdf and doc files generated by HRA and other Survey systems.
• Involved in Data Modeling, Creating Data Flow Diagrams, ETL Framework, Automating ETL Development and ETL to integrate client’s Health Care Data to Confidential systems. Defining Data Flow, Database design and Architect ETL Packages using SSIS are the primary focus.
• Extracted Data from Flat files, XML, Relational Systems and also from Big Data Cloudera Hadoop to EDW.
• Processed huge amount of Claims Data to EDW. Expertise in Performance Tuning, Indexing for large Data sets, Auto - generate SQL/ETL Code.

Data Engineer

Confidential, St Petersburg, FL

Environment: MS SQL SERVER 2005/2008 R2, Oracle, MS BI & Erwin.

Responsibilities:

• Working as a Data Engineer at the Fixed Income Public Finance Department.
• This department creates and maintains municipal public finance deals in an OLTP system.
• In this project phase, PFDeals system integrates Data from an external vendor called IPREO.
• Involved in Data Modeling and ETL to integrate external vendor data to Raymond James systems.
• Defining Data Flow, Database design and Architect ETL Packages are the primary focus.

Technical Architect

Confidential

Environment: MS SQL SERVER, MS BI

Responsibilities:

• Involved in database design/budget of the new BI Solutions.
• Work includes Data modeling, Performance tuning, Data mart design, SSIS, SSAS Solutions and Dundas visualization.
• Architect ETL Process to get data from different Sources including Search Networks like Bing, Google Analytics, Double-Click, Facebook, Marin etc. Solution/Design BI Reports using SSRS and Dundas.

Solution Architect

Confidential, Boston, MA

Environment: MS SQL SERVER, MS BI, Oracle, Business Objects

Responsibilities:

• Involved in design/budget of the new BI Solutions.
• Also work as Data Architect for Enterprise
• Data Warehouse and on various Data Marts.
• Architect ETL Process to get data from different Sources including Oracle db, Flat Files etc.
• Solution/Design BI Reports using Business Objects.

Director

Confidential

Environment: Window Server 2008, MS SQL SERVER, MS BI, Accounting S/W.

Responsibilities:

• Development/ Implementation of everything a Small business requires.
• Developed a Reporting system in MS SQL platform.
• Integrated data from Industrial furnaces to the Database system.
• Connected and integrated multiple Sensor data to the DWH.
• Streamlined all Networking infrastructures within the company.
• Installed and configured a Microsoft Network using Windows Server for Small Business.
• Collected data from Fax Machines, Telephone systems to the Company database for efficient Reporting, Generated multiple SSRS Reports for Management.
• All Banking transactions aligned with the Accounting system.
• Automated accounting reconcile process with Banking Statements.
• Responsible for BI, ETL.
• Design of Analysis Services Dimension and Cubes, Scorecards.
• Report Design in Reporting Services.
• Database Design / Data Validation etc.

BI (Business Intelligence Reporting)

Confidential, Bellevue, WA

Environment: MS SQL SERVER, Data Warehouse Project. (SSIS, SSRS)

Responsibilities:

• Responsible for Data Warehouse ETL.
• Design of Analysis Services Dimension and Cubes.
• Report Design in Reporting Services.
• Database Design / Data Validation etc.