SUMMARY:

• (8+) years of IT experience, which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2016/ 2014/ 2012/20 ) in production environments.
• Achieved massive dollars in savings by implementing Kit’s logic.
• Reduced hours of deployment to 7 hours from 13 hours on every SDLC by automation of system intense steps.
• Optimized application performance by 500% in evaluating SSA federal Validations. (i.e. 100,000 applications on a given packet size)
• Extensive experience in TSQL Development which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and User Defined Functions.
• Extensive experience developing and implementing Confidential SQL Server integration services (SSIS (ETL)), Confidential SQL Server Analysis services (SSAS) MDX/ DAX scripting, Confidential SQL Server Reporting Services (SSRS) and MDX / DAX for data warehouse and data mart solutions.
• Extensive experience in developing interactive dashboard, visual in Power BI.
• Provide significant key performance indicators and insights using Power BI.
• Develop, maintain and enhance existing Power Bi report\dashboard.
• Involve in data discovery\ development of Power BI complete requirements.
• Experience in data Migration (using tools like DTS, BCP) between different heterogeneous systems and SQL Server as part of data migration and data maintenance.
• Experience in Jobs, Sending Alerts using SQL Mail.
• Involved in ETL design, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS (ETL).
• Experience in defining query for generating drill down reports in SSRS 2005/2008.
• Good knowledge in SQL Server Analysis services, OLAP, OLTP Design & Implementation.
• Complex SQL DML/ DDL Queries / Dynamic SQL / SQL Scripts / Views / JOINS (Inner Join / Left Outer Join / Right Outer Join /
• Union / Union ALL / Self Join) / Ad - Hoc Requests / Common Table Expression (CTE) /stored procedure, Function, Trigger, Indexes, Cursor, Explain/execution plan and Import/Export of data.
• Familiar with OLAP cubes and fact table, star and snowflake schemas.
• Excellent skills in designing Logical and Physical Modeling using ERWIN Tool.
• Experience in designing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models.
• Package migration from one environment of Integration service to another i.e. Dev to UAT to Prod.
• Design, build, and implement new report formats and layouts using Power BI and Confidential SQL Server
• Control Power Bi schedule refresh and provide timely data insights\ updated insights.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/ 2014/ 2012/2008/2005, Oracle 10g/9i/8i, DB2, Sybase, MS-Access.

SQL Server Tools: Business Intelligence Development Studio (BIDS), SSMS, SSRS, SSAS, Enterprise Manager, Query Analyzer, Export & Import (DTS), SQL Profiler, TFS-GIT. Visual studio 2015, Crystal Reports.

Operating System: Windows NT, Windows 2000, Windows 2003, Sp3, UNIX,Linux.

Languages: C, C++, PHP, T-SQL, VB, Unix Shell scripting, VB.NET. Python, R, Power Query, DAX, MDX, M Query.

Other Tools: SQL Loader, ERWIN, ER Studio, Confidential Visual Source Safe, ProClarity, Confidential Office, Confidential Visio, MS Visual Studio 2003/2005, Crystal Reports, Tableau, Team Foundation Server, EDI,Jira

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Data warehouse Developer

Responsibilities:

• Developed Datawarehouse solution from scratch for Life Eclipse application.
• Developed new SSRS reports for Marketing Property and Causality on Underwriter Performance.
• Design, build, and implement new report formats and layouts using Power BI and Confidential SQL Server
• Created Life Eclipse Dashboard to show no of days takes from policy received to a decision.
• Capture Underwriter performance metrics by days taken for each stage of a life policy.
• Develop test run of tabular model design in power pivot and enhance the original model up on approval.
• Enhancement of Power BI reports based of end user request and Publish updated reports on sprint basis.
• Created number of Power BI POC dashboards in proposing and tracking key metrics in capturing Agent performance and Household.
• Handled Household in force exception report for multiple measures.
• Parameterize SSIS (ETL) packages through environment variables.
• Enable transaction load in SSIS (ETL) via transaction support.
• Project level Deployment of SSIS (ETL) packages via Visual studio.
• Experience in developingSSASTabular Cubes, Dimensions and data source views and Deploying and Processing.
• Created Dashboard to track down agent performance on daily\weekly\monthly basis and rank metrics.
• Created multiple SSRS\Dashboards to measure key metrics, Performance measures to support life, PnC products.
• Created crosstab, drill down, drill through report and cascading parameter reports in SSRS.
• Written complex SQL CTE and Recursive CTE statements using joins, sub queries and correlated sub queries.
• Work on continuation enhancement of Tabular model of SSAS, and implement new DAX measures.
• Created Household in force (HIF) vs Policy in force (PIF) dashboard to track business KPIs to show case weekly, monthly and year over year growth.
• Extensive experience on writing DAX queries (calculated columns, Measures) in SSAS Model and in Power Bi reports.
• Created multiple dashboard and maintained data flow in timely fashion to provide up to date insights using Power Bi\SSRS reports.
• Developed PowerPivot model to validate two different repots by creating cross lookup and indirect formulas to populated data based on dynamic name change in sheets and reports.
• Schedule and run of daily job via SSIS (ETL) packages over SQL agent.
• Educated new users on how to use Power Bi in creating their own reports using established SSAS Life Cube.
• Follows business model and gathers, analyzes quantitative/qualitative data to develop and support the enterprise data Reporting\Visualization i.e. PowerPivot\ Power BI
• Implemented Hash bytes logic for easy to use SCD2 execution.
• Work with both MDX and DAX model of Analysis service to deliver day to day report for the business need and decision making.
• Developed package to fetch data from tabular models using DAX queries and validated against existing Snapshot model of analysis service.
• Designed and developed new tabular model for internal use of measures data fetch on Household in force (HIF).
• Created dedicated MCD (Marketing Consolidated Power Bi Dashboard) to capture all key metrics from different SSAS Cube and report it in once centralized location.
• Automated the task of generating reports on predefined client requirements.
• Experience in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX / DAX / M Query.
• Initial analysis of source data, Policy counts, Household counts and information statistics are easily visualized using excel PowerPivot and data model.
• Built complex SSIS (ETL) packages for data migration and loading or data from client various files flat files, database, excel .
• Developed dynamic solution to provide on spot verification of data quality with pivot table and PowerPivot.
• Deployed Multilayered Tablix report based of report parameter and dynamic Policy counts (SSRS) report using single templet to generate multiple use case.
• Worked on tuning SQL procedures for better performance and to make sure SQL uses less resources (SSMS).
• Experience in developingTabular SSASCubes, Dimensions and data source views and Deploying and ProcessingSSASTabular objects.
• Work on Change Request i.e. CR.
• Extensive experience in Systems Development Life Cycle (SDLC) from Design, Development, and Implementation.
• Experience with distributed or centralized source code repositories (GIT, TFS, SVN, etc.)

Environment: MS SQL Server 2014/ 2012/2008/2005, Windows 2010, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS (ETL)), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS) Tabular, MS Excel ( PowerPivot), Flat File,, SQL Profiler,C#.NET, VB.Net, TFS, VSS, Visual Studio 2015/2017,Jira, Confluence.

Confidential, Columbus, IN

Data warehouse Developer

Responsibilities:

• Reduced hours of deployment to 7 hours from 13 hours on every SDLC by automation of system intense steps.
• Supports site ERP go-lives
• Development of new enhancement on existing OLAP model to in corporate user need.
• Experience in using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• MDM to manage version of entities and data set.
• Parameterize SSIS (ETL) packages through environment variables.
• Enable transaction load in SSIS (ETL) via transaction support.
• Project level Deployment of SSIS (ETL) packages via Visual studio.
• Educate \ Train users on Power BI usage\Functionality.
• Handled daily data load from OBIEE into Online Analytical Processing OLAP in SSAS and DAX Scripting.
• Developed dashboard to track down the diesel engine parts procurement status and time taken from origin to destination.
• Created self Service BI (SSAS Global cube) and maintained it on daily basis.
• Created DAX measures to report metrics, measures and calculation to support Global cube and respective POWER BI\SSRS reports.
• Creation of new measures in Tabular with DAX scripts.
• MDM to manage Integration, view and access roles.
• Design, build, and implement new report formats and layouts using Power BI and Confidential SQL Server
• SSIS (ETL) Package merge from on environment to another via visual studio
• Support in data migration through data migration tool such as SSIS (ETL).
• Support in data analysis through data analysis tool such as SSAS and DAX measures.
• Database Monitoring & Troubleshooting, Implementing database mail.
• Analyze the input request and evaluate the possible solution for new enhancements.
• Data Categorization and Data validation to achieve higher accuracy of report needed.
• Implement power pivot report generation and Power Bi dashboard creation and use of DAX Measure to report metrics.
• Written complex SQL CTE and Recursive CTE statements using joins, sub queries and correlated sub queries.
• Capture log of SSIS (ETL) package execution in exaction log table and error log tables.
• Debugging of SSIS (ETL) package using break points.
• Validate data via data viewer in SSIS (ETL) packages over pipe lines.
• Created reports for users in different departments in different continents using web-enabled reporting by SQL server reporting services and SharePoint
• Write complex store procedures with input parameters for generation of monthly, weekly and daily report.
• Maintain data quality throughout the system and in every deliverables.
• Understand Mapping and cross lookups between different business units.
• Provide complete project status at Review meetings.
• Import of Daily data from Oracle servers OBIEE to Confidential Self Service Intelligence SSBI platforms
• Supported in continues development of Existing Power Bi dashboard and help develop new one as per end client and POC requirements.
• Involved in ETL design, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS (ETL).
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Involved in performing data conversions from flat files into a normalized database structure.
• Experience in developingSSASCubes, Dimensions and data source views and Deploying and Processing.
• Debug and fix any existing Power Bi dashboard, DAX, MDX measure.
• Schedule and run of daily job via SSIS (ETL) packages over SQL agent.
• Follows business model and gathers, analyzes quantitative/qualitative data to develop and support the enterprise data Reporting\Visualization i.e. PowerPivot\Power BI
• Extract data using multiple programming languages such as SQL, Python and R in resolution of system integration across multiple complex environments, finance, purchasing and Claims systems.
• Created Power Bi report tract Jira ticket closure and time spent on each ticket based on escalation levels.
• Work on Change Request i.e. CR.
• Extensive experience in Systems Development Life Cycle (SDLC) from Design, Development, and Implementation.
• Experience with distributed or centralized source code repositories (GIT, TFS, SVN, etc.)
• Completed six different self-study data science s, while trying to improve quality of data feed.
• Python Programming.
• Storytelling Through Data Visualization
• Python Programming Intermediate
• Exploratory Data Visualization
• Data Analysis With PANDAS
• Data Analysis

Confidential, Seattle, WA

MSBI Developer

Responsibilities:

• 100% Multi-Dimensional Cube migration is achieved less than the duration of time proposed (i.e. 1 Month of skilled labor savings)
• Developed each cube in each time manner, processed and deployed to Dev followed by production on UAT signoff.
• Experience in using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Created stored procedures and triggers to capture updated and deleted data from OLTP systems
• Educated users on how to use and create new Power Bi dashboard.
• Supported multi-tier tax calculation Power Bi dashboard based of new SSAS service.
• Schedule and run of daily job via SSIS (ETL) packages over SQL agent
• Written complex SQL CTE and Recursive CTE statements using joins, sub queries and correlated sub queries.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Involved in ETL design, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS (ETL).
• Involved in performing data conversions from flat files into a normalized database structure.
• Experience in developingSSASCubes, Dimensions and data source views and Deploying and ProcessingSSASobjects.
• Maintaining Relation database and incremental updates migration.
• Expertise in Production migration of New releases and Enhancements
• Clear understanding & working knowledge of HIPAA EDI protocols.
• Extensive experience in resolving issues at all levels of project life cycle
• Built MDX / DAX Queries using SQL Server Analysis Server (SSAS)
• Created, Deployed and maintained current and new SSRS\Power Pivot reports\Power Bi Dashboards.

Environment: MS SQL Server 2012/2008/2005, Windows 2010, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS (ETL)), SQL Server Reporting services (SSRS),, POWER BI,SQL Server Analysis Services (SSAS),MS Excel, Flat File, Oracle 10g,Erwin, SQL Profiler,C#.NET, VB.Net, TFS, VSS, Visual Studio 2015.

Confidential, Sacramento, CA

Senior SQL Developer\Data Analyst

Responsibilities:

• Optimized application performance by 500% in evaluating SSA federal Validations.(i.e. 100,000 application on a given packet size)
• Have developed a new automated integrated service for posting SSA, MEDICARE, EQUIFAX xml files for RRV Renewal Redetermination Validation for auto renewal of apps in bulk process.
• Performed applicationSQL TuningusingSQL Trace Explain planfor better performance
• Automation of several job, Handling Data on auto time maintained SQL agent jobs.
• Fine tuning SQL procedure to consume less system resources.
• Worked on state subsidy project in data load using Integration services.
• Involved in ETL design, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS (ETL).
• Building necessary package for workflow automation.
• Generation or reports based on clients request and post on production servers upon request with one step automation.
• Created Power Bi report to show status of each application and counts to measure performance of calc engine.
• Calc Engine is the central part of Health Application handled by SIS.
• Database Monitoring & Troubleshooting. Implementing database mail.
• Developed Tableau visualization and dashboards using Tableau desktop.
• Participated in the implementation, testing and deployment activities
• Import data from oracle database and set up initial data warehouse concept for report generation process.
• Worked on generating various dashboards in Tableau server using various data source.
• Implemented various transformations using Audit, Fuzzy Look-up, Multi-Cast, Column Conversion and Term Look-up etc. to enhance the whole ETL process.
• Expert in defining Queries for generatingdrill downanddrill throughreports inSSRS 2008.
• Created reports for users in different departments in different continents using web-enabled reporting by SQL server reporting services and SharePoint
• Implement interfaces for proper disposition of person request for the requested programs.
• Write complex store procedures with input parameters for generation of monthly, weekly and daily report.
• Maintain detail documentation and process flow of all HHSC EDI processes.
• Building, publishing, customized, interactive reports and dashboards, report scheduling using Tableau server.
• Addressed bugs with QA, and respond quickly to other business needs.
• Gather requirements and design of data warehouse and ETL development packages.
• ImplementedSQLlogins, roles, authentication nodes as a part of securities polices for various categories of users.
• Involved in development of multi-month interface and post completion of applications with respect to programs and their rules.
• Involved in data migration of Arizona database to heaplus implementation (Database Administration).
• Converted ACA (Affordable Care Act), DES, ACE, AHCCCS database to Heaplus and Heaplus Multi month.
• Configured ALWAYS ON setup between different DATA Centers and on Multi Subnet Cluster.
• Configured ALWAYS ON, Integration service catalogs in SQL 2012.
• Experience in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX / DAX script.
• Built complex SSIS (ETL) packages for data migration and loading or data from client various files flat files, database, excel .
• Scripted backend procedure for use in implementation towards interfaces used in front end.
• Worked on tuning SQL procedures for better performance and to make sure SQL uses less resources.
• Monitoring and tuning SQL Server performance with using Execution Plan, Performance Monitor, and SQL Profiler.
• Work on Change Request CR and provide estimates.
• Provided explicit permissions to specific tables to users in databases
• Worked with architects and developers to design SQL queries for new development
• At the request of end users or management, research questions involving HHSC EDI applications and how the data is organized and populated.

Environment: MS SQL Server 2012/2008/2005, Windows 2010, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS (ETL)), SQL Server Reporting services (SSRS),, POWER BI,SQL Server Analysis Services (SSAS),MS Excel, Flat File, Oracle 10g,Erwin, SQL Profiler,C#.NET, VB.Net, TFS, VSS, Visual Studio 2015.

Confidential, NJ

SQL developer

Responsibilities:

• Involved in developing logical and physical data models using ERWIN tool.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS (ETL).
• Created packages using SSIS (ETL) for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Design and development of DWH to accommodate upcoming update or incremental data sets.
• Designed and developed the reports per the requirements using Tableau
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS).
• Implemented SQL Server Analysis Services (SSAS) for building the data cubes.
• Developed relations between fact and dimensions of the tables.
• Regular maintenance of Relation Database.
• Work on Change Request CR and provide estimates.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
• Created queries for generating drill down reports in SSRS.
• Formatted the reports using the Global variables, expressions and Functions.
• Optimized SQL statements for customer summary reports.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Ability to create custom Tableau reports using SQL.

Environment: MS SQL Server 2008/2005, Windows XP, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS (ETL)), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS), MS Excel, Flat File, Oracle 10g, Erwin, SQL Profiler, C#.NET, VB.Net.

Confidential, Peoria, IL

Design Engineer

Responsibilities:

• Working on current NPI and CPI issues of DEF Tanks for various diesel engine programs
• Detailing of Tank GP-DEF (Basic), Tank GP-DEF, Module AR-DEF and Module GP-DEF
• Experience with Team center Engineering and EDS
• Resolved CI card’s for the wiring group on different engine arrangements like ENGINE AR
• BASIC & ENGINE AR-COMPL of C27/32
• CPI issue on engine model 3412 for C27/C32 where there was repeated failure of the coolant temperature sensor
• CPI issue on wiring group of ENGINES AR-COMPL for C7 & C9
• Solid Modeling and Detailing for C9, C15/18 and C27/32 Harness and Wiring group using Pro/Electric
• Design concept of different sensor groups for C140 engine and also detailed the Harness and Wiring group drawings
• Solved visual issues, CPI issues of C9 and C27/32 engines
• Designed and detailed sheet metal parts for various engine applications