SUMMARY:

• 9 plus years’ experience in the IT industry in Retail, Food, Inventory, ERP, POS, Education, Banking, HealthCare, Manufacturing, Ecommerce, Public Sector, State Govt Domains.
• Expertise in implementation of Business Intelligence and Analytics solutions using Microsoft SQL Server
• Experience implementing end to end application migration and data warehousing projects in OLTP and OLAP environments
• Experience in the entire ETL/Data Warehouse/SDLC stages of Requirement, Data Analysis/Profiling, Logical and Physical Data Mapping, Strategy, Database design, development, Unit testing, conducting conversion mock runs, SIT, UAT, Data Reconciliation and validation and production support and maintenance using waterfall, Agile Scrum and Project Management methodologies.
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL) data from/to SQL Server, SAP HANA, Microsoft Azure, Oracle, Sybase, Microsoft Dynamics AX/GP, NCR POS(ASCII), FoxPro(.dbf), Flat Files, Excel, CSV, and MS Access.
• Create Visualizations, Reports, Dashboards using Tableau & PowerBI.
• Migrate data to/from Microsoft Azure Cloud Platform, Azure SQL DB, Hadoop data on the Azure HDInsight Service using SSIS.
• Strong knowledge of Azure Storage Accounts, Containers, Blob Storage, Azure Data Lake, Azure data factory, Azure SQL data warehouse, stretch Database, Machine Learning, Virtual Machines, Polybase, PDW
• Strong knowledge of Big data, Hadoop, Apache Spark, NoSQL, Sqoop,Tez,Hortonworks,Cloudera,Mapreduce,Hive,Pig, Mahout, Hbase,ORC,Avro,Yarn,Oozie,Apache Storm, Splunk
• Hands on Experience of SAP HANA synonyms, CAL(Cloud Appliance Library),Cloud Cockpit, Hana Studio, Attribute, Analytics, Calculation Views,Files,importing/exporting data,schemas,Procedures
• Up to date with new SQL Server 2016 features .
• Update SSIS packages to SSIS 2012, 2014
• Experience in creating entity relational & dimensional data models with Normalization(3NF),Star schema and Snow flake architectures with Kimball Methodologies & Erwin and Incremental loads using Slowly Changing Dimensions(SCD) techniques
• Expert in scripting T - SQL queries using Joins, Sub Queries, Stored Procedures, Ranking functions, Derived tables, PIVOT, common table expressions (CTEs), views, user defined functions (UDF), constraints & Database triggers.
• Expert in SSIS transformations, package configurations,logging, deployment, variables and expressions, error handling and troubleshooting.
• Experience in performance tuning using clustered, non-clustered, in memory Column store indexes, Profiler
• Experience in Installation, Configuration of SQL Server, Logins, Users, Schemas and Permissions, Automation using Sql Server Agent Jobs, Maintenance Plans, Database Backups and Restoration, Alerts and notifications using SQL Mail
• Experience in SSRS PowerBI Integration, new Report Manager Web portal, Report Builder 3.0,creating matrix, Drilldown, Drill through, Adhoc, cascading Parameterized, OLAP cubes, Sub reports, charts, deployment, caching, snapshots and subscriptions.
• Good Knowledge of SSAS tabular(xvelocity) Data Model, PowerPivot.
• Build SSAS multidimensional cubes using hierarchies,aggregations,KPI’s,calculations using MDX,Translations,data mining, partitions, storage modes.
• Excellent hands on experience in developing Windows, Web applications using ASP.NET, C#.NET and ADO.NET.
• Self-starter, hardworking, and a consistent performer with the ability to work both as a team player and as an individual.
• Strong analytical knowledge coupled with excellent communication and interpersonal skills.
• Proficient in developing clear and concise documentation of all work performed.

TECHNICAL SKILLS

Database: MS SQL Server 2005/2008R2/2012,2014,2016, MS SQL Server Integration Services (SSIS), T-SQL, MS SQL Server Reporting Services(SSRS), Analysis Services(SSAS) ,Oracle 9i/10g/11g-PL/SQL, Reports, XML Publisher Reports, Oracle Applications E-business suiteR12,Sybase ASE 15.5, MSBI, Business Intelligence,

Software Applications: Microsoft Visual Studio 2015,2013,2010, BIDS, TFS, SVN, Message Way, Clear Case, Oracle SQL Developer, Visual Source Safe, HP Project Portfolio Management, HP Quality Centre, Eclipse, MS Office, SQL Server Management Studio, TechnoSolutions Top Team, Business Intelligence Development Studio(BIDS), SQL Server Management Studio, Eclipse, Google Analytics,

Programming Languages: C#, VB.Net, core Java, C, C++

Web Technologies: HTML, CSS, XML, ASP.NET (2.0), AJAX, Cold Fusion (Basics)

Modelling & Reporting: Erwin, UML, Microsoft Visio, R2M Case tool, Tableau 9.0,Tableau 9.2/10.0,PowerBI

Operating Systems: WINDOWS, UNIX, Linux

Testing Tools: Winrunner, Load Runner, Quality Center, QTP

Cloud: Microsoft Azure

PROFESSIONAL EXPERIENCE:

Senior Data Warehouse and Business Intelligence Consultant

Confidential, Miami, FL

Environment: Microsoft SQL Server 2014/2012/2008 R2/2005, SQL Server Integration Services-SSIS, SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, Tableau 9.2/10.0(Desktop/Server), Pyramid Analytics, Team Foundation Server TFS, SharePoint, ServiceNow,Citrix, EPIC, MSOW, Press Ganey, Lawson,EPSi,Caboodle,Azure Data Catalog,PowerBI

Responsibilities:

• Implement Enterprise CRM project with Healthgrades from design to test using SSIS, T-SQL, SFTP
• Implement Enterprise Physician Relationship Management project from design to support
• Implement Hospital Find a Doctor project from design to support
• Work with external vendors and customers to provide extracts, reports, resolve tickets, implement new systems.
• Report to corporate management, interact with business analysts, DBA’s, various departments, PMO office, Software development team
• Provide EPIC Hospital and Outpatient Demographics, Encounters, Procedures, Providers, Payors and Diagnosis extracts and reports to vendors using SSIS,SSRS,Tableau on an automated basis
• Work with SharePoint lists as source in SSIS packages, use SharePoint for team building and task assignment
• Consolidate Physician/Provider data from MSOW and other systems and load to Data warehouse
• Create Data warehouse and analytics Reporting Visualizations and Tableau dashboards for the HR and other departments
• Create Tableau Visualizations using highlighting, disaggregating measures, continuous and discrete fields, combined sets, cascading and context filters,Actions,Hierarchies,Sorting,grouping,Parameters ,Sets, Bins, trendlines,reference lines, maps, Filters, quick and advanced table calcuations,LOD, maps ,background images, measure names and measure values and publish online.
• Work with Tableau live connections to SQL Server , extract to tableau in memory, setup incremental extracts and refresh on a schedule basis
• Data preparation using data source filters, split and other functions,unions,joins,cross database joins and publish data sources to tableau server
• Experience in installing and configuring tableau desktop, Tableau server ,tableau server administration Work with tableau server data sources(.tde,.tds,twbx), web authoring, favorites and snapshots, Setup sites, users, schedules, alerts, projects, workbooks, Roles and permissions, email subscriptions
• Create view type tableau data security with user filters, assigning roles
• Exporting tableau workbooks as images and pdfs
• Perform tableau top N analysis using filters,index,rank
• Create forecasts using tableau forecast quick table calculations
• Create effective tableau presentations using Story Telling, Create dashboards using visual best practices and layout formatting, url actions
• Upgrade Tableau 9.2 workbooks to 10.0.1 , deploy reports to tableau mobile
• Blend data from Excel, Sql Server and other sources using Tableau Data Blending
• Provide extracts and reports for pharmacy deparment,SBCHS, Premier, CMGA, shingles Value based metrics, GL, employee health PPD
• Work with Dynamic data masking and data encryption
• Use Epic Caboodle Data warehouse for building extracts.
• Create SSRS, Report Builder 3.0 adhoc reports, matrix, Drilldown, Drill through, cascading Parameterized, OLAP cubes, Sub reports, charts, and report parts, interactive sorting, deployment, and subscriptions.
• Data warehouse Design and load with ETL from multiple sources using SSIS 2014
• Create Centralized repository for all code artifacts using Azure Data Catalog and TFS
• Upgrade SSIS packages to the 2014 project deployment model and deploy to SSIS DB catalog.
• Design, Development of SSIS packages using XML configurations , parameters to export to flatfiles,csv on a daily load basis
• Developed T-SQL Scripts using joins, subqueries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers, Temporary tables, table variables and PIVOT functions. Creation of tables, constraints,primary keys and foreign keys.

Senior Data Warehouse and Business Intelligence Consultant

Confidential, Hershey,PA

Environment: Microsoft SQL Server 2014/2012/2008 R2/2005,SQL Server Integration Services-SSIS,SQL Server Reporting Services SSRS,SQL Server Analysis Services SSAS,ALOHA POS,Gateway POS,Visual Fox Pro,NCR POS,Retalix,ScanMaster,Microsoft Dynamics GP Great Plains, Oracle 11g ,Excel 2013,KWI POS,Countwise Attendance, Microsoft Office 2013,T-SQL,Microsoft AZURE, Report Builder 3.0,Tableau,Hdinsight,Microsoft Dynamics AX,Messageway,Shiloh,PowerBI,TFS,SVN,SAP HANA,MuleSoft,Winscp,Informatica

Responsibilities:

• Design of Data warehouse and data marts with Star schemas and Snowflake architecture and Kimball Dimensional Modelling
• Logical and physical schema design using SSMS diagrams and ERWIN with normalization and denormalization,referential integrity.
• Gap Analysis and requirement specifications design of source transactional file formats(CSV,Text,Delimited) from various vendors.
• Design, Development of SSIS packages to load existing systems ASCII, delimited Flat Files, FoxPro(.DBF) POS sales, ERP Microsoft Dynamics GP/AX,SAP HANA data to SQL Server staging area on a daily incremental/full load basis
• Create data mappings and transformation logic from staging to Data warehouse.
• Develop SSIS packages to Extract, Transform Load (ETL) from staging layer to the data warehouse on a daily/near real-time basis.
• Create Data warehouse and analytics Reporting Visualizations using Tableau& PowerBI dashboards,adhoc analysis, Story Telling, report types like pie,bar,map,trendlines,mark,donut chart, bubble Filters,Hierarchies,Data Blending, Parameters and publish online.
• Create Tableau Visualizations using highlighting, disaggregating measures, continuous and discrete fields, combined sets, cascading and context filters,Actions,Hierarchies,Sorting,grouping,Parameters ,Sets, Bins, trendlines,reference lines, maps, Filters, quick and advanced table calcuations,LOD, maps ,background images, measure names and measure values and publish online.
• Experience in installing and configuring tableau desktop, Tableau server ,tableau server administration Work with tableau server data sources(.tde,.tds,twbx), web authoring, favorites and snapshots, Setup sites, users, schedules, alerts, projects, workbooks, Roles and permissions, email subscriptions
• Create view type tableau data security with user filters, assigning roles
• Datawarehouse ETL testing using tableau
• Perform tableau top N analysis using filters,index,rank
• Create forecasts using tableau forecast quick table calculations
• Create effective tableau presentations using Story Telling, Create dashboards using visual best practices and layout formatting, url actions
• Create SSIS Packages to migrate data from / to Azure Cloud (Azure SQL Database) , Azure Blob Storage
• Create SSIS Packages to export/import data from / to SAP HANA.
• Work on SAP HANA in memory DB to Import/Export data ,creating schemas,tables,explain plans,procedures,synonyms,sequences,Hana Studio,Hierarchies,Attribute,Analytic,Calucation views.
• Develop SSIS packages using Lookup, multicast, conditional split, derived column ,Rowcount transformations,Foreach Loop Container, File System, Execute SQL /Package/Process, Send Mail Tasks ,Connection Manager Expressions, OLEDB command,SCD
• Upgrade SSIS packages to the 2012 and 2014 project deployment model and deploy to SSIS DB catalog.
• Configuration of SSIS packages using XML Configuration files,parameters,enivronments,logging,master and child packages,variables and expressions,error handling and troubleshooting.
• Design and develop SSIS packages to export SQL Server data to Excel,Flat files for reporting.
• Automated use of Winscp to export SFTP source flat files to Messageway servers using SSIS on a daily basis.
• Create Technical Design and strategy for ETL,DataWarehouse Design, Reporting, requirement specifications, Business Rules, Data Mapping ,Key decisions and metadata management.
• Developed T-SQL Scripts using joins,subqueries,Ranking functions, Derived tables, common table expressions (CTEs),stored procedures, views, user defined functions (UDF), constraints & Database triggers Joins, Temporary tables, table variables and PIVOT functions. Creation of tables,constraints,primary keys and foreign keys.
• Performance tuning of Data Warehouse tables and queries by clustered, on clustered indexes, parallelism in SSIS
• Loaded Dimension and fact tables sourced from External data sources like SAP,Teradata,SAP BW.
• Automated backups of the staging and Data Warehouse dev,UAT and Production databases and backup retention policy
• Worked as SQL admin for installation of SQL Server, Database email notifications(for job failures or issue with source files), operators, maintenance plans, Server disk space management, backup/restore, Creation of SQL Server Logins and assign security permissions
• Create SQL Server Agent jobs for loading Datawarehouse,Staging,Reporting extracts on a daily basis.
• Create SSRS PowerBI Integration, Report Builder 3.0 adhoc reports, matrix, Drilldown, Drill through, Adhoc , cascading Parameterized, OLAP cubes, Sub reports, charts, report parts, interactive sorting, deployment, subscriptions.
• Performance tuning of reports queries, report caching and snapshot execution.
• Publish reports to SharePoint and report server and adhoc reporting using t-sql and report builder 3.0
• Build and deploy multidimensional SSAS cubes using hierarchies,aggregations,KPI’s,calculations using MDX,Translations,data mining using clustering, decision trees, naïve Bayes algorithm,partitions,rolap storage modes, pivot tables reporting,
• Used SSMA for Oracle to import from Oracle into Sql Server. Data profiling of Oracle DB by running Oracle SQL queries.
• Design, development and Automation of Archival process of Source System FTP files into dated folders using SSIS Packages containing For each loop enumerators,Config Files, File System Task and SQL Server Jobs to run on a nightly basis.
• Design and Development of Data warehouse Slowly Changing Dimensions.
• Using SSIS packages with concurrent data flow tasks,SSIS Fast Load, synchronous transformations to improve performance.
• Analyse SSAS cubes in Excel using pivot tables, power pivot, power query, data bar Sparkline and indicators, conditional formatting.
• Development and Automation of data reconciliation T-SQL queries and comparison against business reports to validate the overall data migration. Created test plans for Data warehouse build.
• Weekly/Daily meetings with users and Business Analysts for scope & Data warehouse requirements, writing adhoc sql queries for data analysis
• Planning of tasks involved and provide estimates, weekly status reports to the client for building the data warehouse.
• Proactive feedback/escalation of project risks, dependencies, design enhancements and development strategy to the Project management team for staying on track.
• Conduct Joint development and work sessions to collaborate with the team and fix architecture issues and sql fixes and testing.
• Work with Managers to prepare WBS for Data warehouse development work.
• Thorough understanding of the business process through data analysis using t-sql.
• Conduct Code review and Walkthroughs. Identifying, and documenting ETL Standards and best practices for the development team.
• Download & upload data from Hadoop HDFS & Azure HDInsight through SSIS

Data Warehouse and Business Intelligence Consultant

Confidential , PA

Environment: SSIS 2008,BIDS,SQL Server 2008 R2, T-SQL,Visual Basic .NET, C# .NET, XML, TechnoSoultions Top Team, Microsoft TFS, Microsoft Project, Sybase ASE 15.x, Microsoft Access, SSRS,Microsoft Excel,QAS

• Loaded legacy source data from Sybase, Access, and Sql Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import &Export Wizard, Sql Server Migration Assistant (SSMA) and SSIS packages.
• Performed data profiling, data analysis to identify legacy data that needs to cleansed prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.
• Worked with L&I Subject Matter Experts, and Deloitte Database Architects to create data mappings. Performed GAP Analysis on data mappings, and data element transformations.
• Used majority of the transformations, tasks, containers in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All,Multicast,Sort,Copy column,Data conversion during development.
• Used Fuzzy grouping transformation to consolidate data and submitted data cleansing reports to the client.
• Created custom Logging and Auditing framework incorporated in an SSIS package template that was used in the project’s ETL packages.
• Identifying, and documenting ETL Standards and best practices for the development team.
• creating data conversion and migration strategy, design and conversion development documents. Participate in Data Modeling Sessions.
• Hosted SSIS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development. T-SQL development included queries using joins,subqueries,Ranking functions, Derived tables, common table expressions (CTEs),stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Improved the performance of SSIS packages by Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB on a daily basis.
• Deployment of SSIS packages to the conversion server and schedule SQL Server Agent jobs to automate on a weekly basis.
• Experience in creating master and child packages, using package configurations (XML,SQL Server)and SSIS logging.
• Experience in usage of variables and expressions in packages, writing VB,C#.net scripts in script component task.
• Conduct Code Walkthroughs, and perform SSIS peer reviews.
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests, lookup data changes incorporation, logins & permissions. Created linked servers to write validation queries against the source and target present on different servers.
• Used Team Foundation Server 2010 to check in code artifacts and Techno solutions Top Team third party tool for process oriented tasks like assigning tasks, logging & assigning code defects, check in key decisions, documents etc.
• Created database staging tables for running the QAS batch for Postal Address Validation.
• Implemented framework for Lookup data changes, Automation of Applying Database Change Request scripts to the target DB.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Involved in entire conversion stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design,development,Unit testing, conducting conversion mock runs,SIT,UAT,Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping, Meeting Minutes, Key decisions from the client,SSIS introduction material to the client.
• Worked with Managers to prepare WBS for SSIS/Database development work.