SUMMARY

• Over 10+ years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2005/2008 R2 and 2012, 2016 in Production, QA and Development Environments.
• Strong experience with T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005, 2008 R2/2012 Reporting Services (SSRS), SQL Server 2005,2008 R2/2012 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2 and 2012).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012
• Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Extensive knowledge and Hands-on experience with creating and publishing organizational Power BI dashboard
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Hands on Experience on creating database objects in Hive SQL and using it in Pentaho ETL packages.
• Experience in deploying Pentaho ETL packages into higher regions and scheduling the jobs in Enterprise scheduler.
• Very good understanding in setting up file watchers, creating dependencies and creating scheduled jobs in ESP to manage data dependencies and creating alerting system around this mechanism.
• Working with source teams and understanding the daily/weekly and monthly schedules of the source data and setting up ETL jobs accordingly.
• Hands on Experience working with various data sources in Power BI, to import data and create visuals and dashboards.
• Extensive experience in creating Power BI dashboards and integrating into Power BI service to share the reports across organizations.
• Expert knowledge in power BI data gateway, Row level security and other Power BI admin activities.
• Good knowledge on creating power apps using Microsoft tools to manage small and unique data request for business users.
• Experience in working with Database setup, partitions and maintenance.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Hands on experience working with Netezza Database and Aginity Pure Data Analytics.
• Strong knowledge on claim management process well versed with Medicaid and Medicare services, HL7 message validation, ICD9, Electronic Health Records and Electronic Medical Records.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Experience in managing large data sets on MS Excel 2013
• Provided application security support for SQL applications with ADO.NET
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Worked with Business Analysts, Web development team, and users on database solutions.

TECHNICAL SKILLS

Tools: &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQLServer Business Intelligent studio (BIDS), DTS, Report Builder 9.0HP QC, ProClarity 6.2,SharePoint 2007, Team Foundation Server, Aginity Workbench

BI Tools: SSIS, SSAS, SSRS, Power BI, Pentaho

Databases: MS SQL Server 2000/2005/2008 , 2012 MS Access 97/2003/2005/2008.

Language: T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/ 2003/2000/2007 , 2010, Windows Server 2000/2003/2008 , UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee WI

Sr. Business Intelligence Developer

Responsibilities:

• Actively participated in Loan, Transactional related meetings with users, team lead and technical manager to fully understand the requirements of the system.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic and created the same logic in Hive SQL when migrated to Hadoop.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different Databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts in Netezza and used SSIS package for scheduling and execution for data loads.
• Worked on programmatically connecting to all the FTP servers to download the files and load into database on daily basis.
• Experience in downloading files from curl scripts and save them into database using C# loaders.
• Worked on scheduling Email trigger jobs to raise an alert to download the files when an email attachment triggers the mail box.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Experience in Hive SQL and Pentaho, created and maintained Pentaho ETL packages.
• Involved in design, implementation of SQL Server 2012 in Dev, test and prod environment.
• Imported and created relation between different data sources and between multiple tables using Pivot table.
• Involved in securing DB applications with ADO.NET and C# scripting.
• Involved in DB management for the new DW both in Dev and Prod environments.
• Performed DB backup, restore and other data base maintenance work.
• Implemented row level security in Power BI.
• Created Power BI and sport fire reports for business user and executives to support the key decision making process.
• Actively worked on creating Power BI dashboards, connecting live to various data sources, creating a data model with all the available sources in Power BI and created visuals.
• Created and maintained data gateway for Power BI reports to help connect to all various data sources and for effective data loads into the reporting system.

Environment: SQLServer 2012, 2016 Enterprise BIDS - 2012, Windows Server 2008, OLAP, OLTP, MDX, C#, ASP.Net, Data Mart, ETL, MS Office 2013, Performance Point Server 2012,, Power BI, Pentaho, Hadoop.

Confidential, Milwaukee WI

SQL BI Data and Reporting Architect

Responsibilities:

• Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports usingefficient data retrieval techniques.
• Created Sales BI Reporting system to serve all the Sales reporting needs and maintained the application built on Jet reports.
• Designed, Created and maintained custom reports from the business leaders as pert the data requirement and deployed onto the SharePoint for organizational use.
• Created and maintained Power BI dashboard, published reports and dashboard to Power BI service and shared with field sales teams.
• Connected to various sources to pull data into Power BI, created data model and built visuals on top of the data model as per the business requirements.
• Created and maintained data gateway for data refresh in Power Service and schedule auto refresh to pull latest data from the data warehouse.
• Created Power App’s in Microsoft power application wizard to create and manipulate data dashboards as per user requirement.
• Updatedfunctional specificationand technical design documents. Studied the existingOLTP system(s)andCreated facts, dimensionsandstar schema representationfor thedata mart.
• DevelopedAnalysis Services Project. Responsible for identifying and definingData SourceandData Source views. Created cubes and defined the dimensions.
• Created and manipulated new dimensions and measures as per the user needs and added these to dashboards and visuals to bring more integrity and ability to deep dive into detail information as needed.
• Implemented row level security in Power BI dashboards so that users are restricted to only responsible accounts and clients.
• Connected live to Microsoft AX and reported live store stock, plant product dashboard for demand and supply team to handle their tool distribution system.
• Create and maintain project artifacts including;data requirements, technical specifications, test plans, etc using Business intelligence tools.
• Defined attribute properties in aParent Child Dimensions. Responsible for hiding and disabling attributes hierarchies. Sorting attributes members based on a secondary attribute.
• Defining relationships betweenDimensionsandMeasure groups. Involved in the design and development of the SSAS cubes andMDXqueries
• Specifying the named sets for calculations using named queries. Responsible for creating reports based on the requirements usingSSRS 2012.
• Identified the database tables for defining the queries for the reports. Defined report layouts for formatting the report design as per the need. Identified and defined the Datasets for report generation.
• Wrote queries fordrill down reportsto get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports usingGlobal variablesand expressions. Deployed generated reports onto theReport Serverto access it through browser.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.

Environment: SQLServer 2012, 2016 Enterprise BIDS - 2012, Windows Server 2008, OLAP, OLTP, MDX, C#, ASP.Net, Data Mart, ETL, MS Office 2013, Performance Point Server 2012, Jet 2015 Update, Power BI

Confidential, Milwaukee, WI

Sr. SQL BI Developer/Analyst

Responsibilities:

• Designed and created new data warehouse for new reporting systems as per the industry best practices using star schema.
• Experience in MOLAP (Multidimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2014.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Designed incremental daily loaded for large and small data warehouses, data marts as per the reporting requirement
• Configured dynamic check points in SSIS package to allow the package to run from the point of failure.
• Expertise use of various SSIS control flow and data flow components in data transformation between source and destination.
• Deployed the packages to Test, QA and Prod environments and provided support whenever needed.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling plans in the company, top sales based on region and sales based on season.
• Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2012/2014.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Involved in design and successful implementation of SSAS cubes and wrote complex MDX and ad- hoc queries.
• Created and maintained Power BI visuals for portfolio data reporting and used these for higher management presentations.
• Acted as Power BI subject matter expert and handled the entire admin category work load.
• Created massive dashboards on different locations/clients and their claim processing management using Power BI and also integrated this dashboard into SharePoint/CRM live.
• Connected to live to Client data strategy and claims system and imported data to feed Power BI visuals.

Environment: SQLServer 2012, 2016 Enterprise BIDS - 2012, Windows Server 2008, OLAP, OLTP, MDX, C#, ASP.Net, Data Mart, ETL, MS Office 2013, Performance Point Server 2012, Power BI