SUMMARY

• Over 11 years in teh Client Engagement, Project Coordination & Delivery, Data Modeling, Architecting Enterprise Database/Data Warehouse Design, Business Intelligence Solutions, Visualizations and Data Governance using best practices in Agile/SCRUM Metholodology in Healthcare, Insurance, Retail, Banking, Medical, Advertising & Media, Pharmacy & Finance.
• Lead & managed cross functional teams (up to 14 people) for large/ medium & small scale projects and delivered complex projects to Diverse Stakeholders. Worked wif teh PMO to establish process, budget and resource planning, tracking of metrics, sharing best practices, release management and on - time project delivery.
• Created Business Requirements Document(BRD), Source to Target Mappings for Data Management and Project Roadmap, Data Governance and Risk/Issue management.
• Extensive experience in Design & Development of Conceptual, Logical & Physical data models, Data Marts, Operational Data Store (ODS), OLAP (Tabular Cubes), Dimensional Data Modeling (Star Schema & Snow-Flake) for Fact, Dimensions & Bridge Tables, starting from inception to implementation and ongoing support using MS SQL Server 2008/2012/2014/ Azure, MySQL, PostgreSQL and Vertica Columnar database using ERWIN and TOAD Data Modelers.
• Expertise in Design & Development of Enterprise reports & Visualizations, Scorecards & Dashboards, predictive & forecasting Reports using SQL Server Reporting Services (SSRS) (using MS Business Intelligence Development Studio 2008/2010 and SSDT 2013/2015), Tableau and Excel 2010/2013, PowerView, PowerPivot, Power BI Desktop, Azure portal, SharePoint (On Premise & Office 365).
• Extensive experience in performing ETL transformations and creating jobs and packages using SQL Server Integration Service (SSIS), Pentaho (Kettle & Spoon) for SalesForce integration and Python (Pandas Library), Azure Portal (Data Factory / Azure BLOB Storage) for importing and transforming data for XML, FTP, Flat Files, Multiple servers, Look up Transformations, Scripting, Merge Joins and many other in-built components.
• Conducted Design Review Meetings, Technology Upgrade workshops and Report training for End Users. Helped teh Users to use Power BI Desktop and Excel 2013 as a Self-Service Power BI model reducing dependencies on teh Developers and Analysts to check Data Integrity
• Team builder wif strong leadership qualities. Demonstrated initiative, drive, and ability to manage multiple priorities. Exceptional Communication, Interpersonal, Analytical and Presentation skills.

TECHNICAL SKILLS

Programming: C#, VB.NET, T-SQL, PL-SQL, Batch Scripting, Python (Pandas & SparkSQL).

Hadoop/Big Data: Cloudera Hadoop CDH 5.2.0, APACHE SQOOP, Hue, HIVE, Impala, HDFS.

Tools: /Libraries: TFS / VSTS, Erwin Data Modeler, SharePoint 2013, Office 365, MySQL Workbench, JIRA, GitHub, Pandas, PyCharm.

Biz. Intelligence Tools: SSDT 2013/2015 (SSIS/SSRS/SSAS), MS Excel, Power Pivots, PowerView & PowerBI Desktop & portal, Tableau 9.0/9.3, Spotfire, Pentaho(Kettle & Spoon)

Database/Servers: SQL Server 2016/2014/2012/2008 R2, Oracle 10g/11g, Vertica, MySQL, HDFS, PostgreSQL, SQL Azure Cloud (BLOB & Data Factory)

PROFESSIONAL EXPERIENCE

Confidential, Iselin NJ

Senior BI Specialist and DW/ETL Lead

Responsibilities:

• Managed a team of 12 developers and 2 QA people (on site and off-shore) and delivered a $3 million project to teh stake holders and Worked wif Customers/clients on a regular basis to address key development milestones, any issues, upcoming project initiatives and next milestones.
• Document business processes and project schedules wif details of activities, schedules and effort.
• Worked wif teh team to implement a plan for Data Management and Roadmap, Data Governance and Risk/Issue management to update teh stake holders on a weekly basis.
• Performed extensive Data Volumetrics and profiling of teh existing HEDIS and HCVA data ingestion and processes, analyzed teh existing hardware and software infrastructure and teh Data warehousing and Business Intelligence requirements.
• Established and led design review, regular or ad-hoc reviews, and issue management meetings to ensure sync up on Business Requirements, Technical Design and Process wif teh tech team.
• Created Business Requirements Document(BRD), Source to Target Mappings, Conceptual, Logical/Physical Data Models using Erwin Data Modeler.
• Designed teh Enterprise Analytics Datawarehouse in SQL Azure Cloud- Table structures, Stored procedures, CTEs, Cursors, Primary Key/ Foreign Key Relationships, Indices (Clustered, Non-Clustred, Column Store), Performance tuning (Manual as well as Index Tuning Wizard).
• Designed and implemented complex ETL transformations by developing, scheduling and deploying complex SSIS packages using SQL Server Data Tools on Visual Studio 2015 on Azure VM for various sources like SalesForce.com API, Vertica, Oracle 11g, SQL Server 2014 / 2016, XML, Flat files, FTP, APIs & Excel.
• Designed and scheduled Data Factory Jobs on Azure to import data into teh Azure blob using Azure BLOB Storage Explorer. Creating row level security using roles in PowerBI.
• Designed teh 2nd Enterprise Analytics Datawarehouse in HP Vertica 7.2.3 to be able to load data in and out of HDFS to be queried using HIVE. Created teh projections and necesssary queries for loading and quering teh data. Used Python using PyCharm for Extraction, Loading and Transformations (ETL) for loading data into Vertica database using Pandas dataframes.
• Created Enterprise reports, Scorecards and Dashboards using SQL Server Reporting Services and Excel 2013, Power BI Desktop and Azure portal. Built predicitive and forecasting models using DAX. Worked on PowerBI security model for row level as well as Database level.
• Conducted Design Review Meetings, Technology Upgrade workshops and Report training for End Users. Helped teh Users to use Power BI Desktop and Excel 2013 as a Self-Service Power BI model reducing dependencies on teh Developers and Analysts to check Data Integrity.
• Used JIRA for SCRUM planning and VSTS / GitHub for data repository version control.
• Installed Pentaho BI suite and imported SalesForce.com data into teh exisiting MySQL DW tables.
• Scheduled Kettle jobs for automating data import from SalesForce.com by using SF.com queries.
• Used Hadoop/ Cloudera CDH 5.2.0 on Cent OS (Linux based) to create Big Data Infrastructure. Used Apache SQOOP, Hue Management Software and Hive to import large volumes of data into a HDFS cluster of 450+ Nodes. dis data was tan loaded into Vertica 6.1.1 columnar database.
• Used Python (Pandas & Pyspark 2.1) using PyCharm for Extraction, Loading and Transformations (ETL) for loading data into Vertica database using Pandas data frames.

Environment: SQL Server 2014/ Azure, C#, Python, Vertica 6.1.1, Cloudera Hadoop CDH 5.2.0, HDFS, Apache SQOOP, HIVE, Cent OS, SalesForce.com, Hive, My SQL, SSDT 2013 (SSRS, SSIS, Tabular SSAS Cubes), Pentaho (Kettle & Spoon), PowerBI (Desktop, PowerPivot, PowerView), Tableau, Spotfire, PyCharm.

Confidential, New Jersey

Senior SQL Analyst and DW/ETL/BI Specialist and Lead

Responsibilities:

• Managed a team of 6 developers and delivered a $1.2 million project to teh stake holders and worked wif Customers/clients on a regular basis to address key development milestones, any issues, upcoming project initiatives and next milestones.
• Document business processes and project schedules wif details of activities, schedules and effort.
• Designed teh Enterprise Database Architecture - Table structures, Triggers, Complex stored procedures, CTEs, Cursors, Primary Key/ Foreign Key Relationships, Table valued and Scalar Value Functions, performance tuning and create indexes. Created Source to Target Mappings, Conceptual, Logical and Physical Data Models using TOAD Data Modeler.
• Designed and Implemented Complex Tabular cubes in SSDT 2013 and Excel 2013 using DAX for creating PowerPivot, PowerView and Power-Map Visualizations deployed to users using Office 365 and SharePoint 2013.
• Designed and implemented a console application for extracting teh various Data Feeds using using API / web methods like Vindico, PointRoll, XAXIS, DART/DFA, Celtra, Twitter, Facebook etc
• Created Enterprise reports, Scorecards and Dashboards using SQL Server Reporting Services and Excel 2013, Power BI (Excel). Built predicitive and forecasting models using DAX. Worked on PowerBI security model for row level as well as Database level.
• Designed and implemented complex ETL transformations by developing, scheduling and deploying complex packages using SQL Server Integration Services 2008/2012 (SSIS).
• Used Team Foundation Server 2010 for version control.

Environment: SQL Server 2012/2014, MySQL Work-Bench, Oracle 11g, SSDT 2013 (SSRS, SSIS, SSAS), Visual Studio Online, Theobold, SAP-BW, SharePoint 2010/2013, PowerPivot, PowerView, Erwin.

Confidential, Dallas, TX

Application, Database and SQL Server BI Developer

Responsibilities:

• Involved in designing and developing teh Business Logic and UI for various Use Cases.
• Designed teh Database and Data Warehouse (Star, Snowflake schemas -Fact and Dimension tables) - Table structures, triggers, stored procedures and Primary Key/ Foreign Key Relationships, Table valued and Scalar Value Functions.
• Designed and implemented teh entire Historical Data Migration of all teh existing loans in multiple spreadsheets to teh newly created database. Teh size of teh database was approx 1.2TB.
• Used SQL Server Reporting Services 2005/2008 to design, render and test teh reports using complex expressions to calculate, group, filter, parameterize, and format teh contents of teh reports.
• Performed ETL transformations using SSIS (SQL Server Integration Services) via teh Business Integration development environment in Visual Studio 2005/2008.
• Implemented some Batch Scripting Tasks, Schedules packages and set up jobs in SQL Server 2005/2008.

Environment: C#, Visual Studio 2005/ 2008, SQL Server 2005/2008 R2 (SSIS, SSRS)

Confidential, Raleigh, NC

Database and Web Dev Intern

Responsibilities:

• Responsible for designing, developing and testing first phase of application using ASP.NET, C#, ADO.NET, HTML, JavaScript and SQL Server 2000.
• Utilized Unified Modeling Language (UML) technologies for a complete view of teh application including class diagrams, sequence diagrams, activity diagrams.
• Used ADO.NET to access teh Data Layer which is entirely based on XML and provides platform interoperability and scalable data access.
• Responsible for writing Stored Procedures, Triggers and Indexing in teh back end.
• Used Crystal Reports Viewer to generate Employee Status Reports. Responsible for creation of Setup project for packaging and deployment of completed phase of software application.

Environment: Visual Studio.NET, C#, ASP.NET, ADO.NET, XML, Web Services, JavaScript, IIS 5.1, Windows XP, SQL Server 2000, HTML, Crystal Reports, Triggers and Stored Procedures.

Confidential

Database and Business Intelligence Developer Intern

Responsibilities:

• Interacted wif end users to gather business/report requirements. Designed teh Business Requirement Document (BRD) as well as participated in design review meetings.
• Created table structures, triggers, stored procedures and Primary Key/ Foreign Key Relationships, Table valued and Scalar Value Functions, perfomance tuning and indexing.
• Performed complex ETL transformations, created and automated complex packages using SQL Server Integration Services 2005 (SSIS) for development of teh Corporate Scorecard and Registeries Reports using Oracle 9i, SQL Server 2005 sources, Flat files (MS Excel and CSV).
• Processes included designing complex BULK transformations, script components, derived columns, MERGE-JOIN, complex look ups and data transformations from different servers.
• Created Enterprise Profit & Loss and Financial Reports, Dashboards and Scorecards using MS Excel. They included drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters and charts. Created stored procedures, triggers and functions in SQL Server 2005 for teh generation of ad-hoc and canned reports.