SUMMARY

• Over 9 years of extensive experience in database analysis, design, development and database administration in SQL 2016/2012/2008/2005 in various SDLC environments.
• Extensive ETL, Analytics and Reporting experience using various technologies (SSIS/SSRS from Microsoft) and Crystal Reports (from Crystal)
• Worked with diversified Industry domains like Power & Utility, Education, Transportation and Supply chain and Talent Hub.
• Worked on creating dashboards/websites in C# andASP.NETwith ETL uploader and downloader facility for the end client.
• The dashboard includes fancy SSRS and SSAS charts and pivot view for the end user to view and access data thus obtained after ETL transformation
• Excellent command of writing ad - hoc queries utilizing Dynamic SQL and PL/SQL.
• Experienced in migrating databases from SQL, Oracle to SQL.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity. Expertise in using data modeling tools like MS Visio.
• 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 Command
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS, Bulk Insert, creating mappings/workflows to extract data from Oracle, DB2,SQLServer, Excel and Flat File sources and load into various Business Entities.
• Expertise in Developing and Extending MS SQL Server Analysis Services 2012 (SSAS) Cubes, Deploying and Processing SSAS objects, and creating tabular models.
• 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.
• Experienced in using visualization tools like Tableau, and Power BI.
• Good experience in developing Power BI dashboard using Share point.
• Good experience in designing and developing web based and windows based applications usingASP.NET, C#.NET, HTML5, Bootstrap, Angular JS, JAVA Script, VB.NET.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, efficient in handling multiple projects, hardworking and a versatile team player.

TECHNICAL SKILLS

Databases: MS SQL Server 2013/2012/2008/2005, DB2, Oracle 10g/9i/8i, My SQL 5.0/4.1, MS - Access 12.0/11.0/10.0/9.0

Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor, SQL Server Dashboard, Business Intelligence Development Studio (BIDS)

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 12/9, Tableau 9.3, Power BI, Microsoft Share Point

Data Modeling: Fact and Dimensional Data Modeling, UML, Logical data modeling and Physical data modeling

ETL Tools: SQL Server Integration Services (SSIS)

Languages: C, C++, C#.net, Asp.net T-SQL, PL/SQL, HTML, XML

Operating System: Windows 98/XP/ 2000/2003/7/8/8.1, Linux, Windows Server 2008 R2 and 2012

Designing Tools: Rational Rose, MS Visio

Web Technologies: JavaScript 1.8.5, XML 1.1, HTML 5.1, CSS 3, Bootstrap, Angular JS

Applications / IDE: Visual Studio 2013/12/10, Adobe Photoshop, Adobe Dream viewer MS-Office, MS-Project

PROFESSIONAL EXPERIENCE

Confidential, Kentucky, Frankfort

SQL BI Developer

Responsibilities:

• Design a universal automated ETL tool using SSIS, C#.Net and ASP.Net that automates the data upload, transformation, validation and integration of multiple data sources into the longitudinal data system. Design an Interface for users in ASP.NET and C#.NET to upload and compare data.
• Created universal SSIS solutions that can integrate multiple data sources into client’s longitudinal data system.
• Responsible for Analyzing new data sources for in corporation into Kentucky Longitudinal Data System (KLDS), Architect, Design and Build new SQL database Tables, Views, Stored Procedures and Functions to import the new data files in to the KLDS, which includes the following stages to pull the new sources - File upload, Data Importing, Preprocessing and Data Matching and Final data promotion to production environment.
• Implementing multiple fuzzy logic matching solution for mapping new data with the existing in many levels using advanced SQL scripts.
• Implementing automated Error handling system that will streamline and separate application errors and data errors and notifies the respective owners with detailed error report through emails.
• Creating complex SQL scripts to investigate the accuracy of the millions of longitudinal master person details like DOB, SSN by comparing the data from multiple data sources using several business rules and implement a process to avoid data inconsistency going forward.
• Transforming data from one server to other servers using tools like Data Transformation Services (DTS) and Integration Services (SSIS).
• Implement several data and column level validations to fine tune data before loading into the SQL database using Store procedures and C#.NET.
• Work with the other developers to build interfaces as needed for data upload and validation as well as routine data maintenance tools.
• Integrating data from heterogeneous data sources like Oracle, Sales force, MS Access, Excel, delimited flat files into SQL Server 2016.
• Create a thorough data mapping for each data source and data format.
• Document all the code changes in Intervals ticket management system and TFS virtual control.

Environment: SQL server 2012/2015, SSIS, Microsoft Team Foundation Sever (TFS), Visual Studio, ASP.NET, C#.NET, Dynamic SQL, PL/SQL

Confidential, OH

BI Developer

Responsibilities:

• Design and develop complex SSRS reports that pull billions of Title issue data and is used by 88 county users.
• Analyze user needs and system requirements to Improve report performance and maintainability of the reporting architecture by optimizing report design and database queries and recommending changes to the overall reporting architecture.
• Interact with various business and functional team heads to finalize the data requirements.
• Design, implement and maintain database objects (tables, views, indexes, etc.) and database security in SQL
• Created SSIS Packages for validating data.
• Participate in the full SDLC process (including coding) of ATPS || system in ASP.NET Windows application.
• Improve report performance and maintainability of the reporting architecture by optimizing report design and database queries and recommending changes to the overall reporting architecture.
• Develop and execute test cases for SSRS reports thus created.
• Worked in an Agile Scrum environment to achieve the tasks within the given sprint deadline.
• Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using SSIS packages and DTS utility
• Administered regular backups, logs and restores of all reporting databases.
• Created and maintained all jobs related to reports.
• Work with ODPS staff to update, patch, and repair the ATPS application software components in the development, test, and QA environments, and develop software changes for promotion to production following best practice and standards as defined by ODPS.

Environment: SQL server 2012, SSRS, Report Builder, Microsoft Team Foundation Sever (TFS), Visual Studio, ASP.NET, C#.NET, Power BI

Confidential, OH

SSRS Developer

Responsibilities:

• Work with various customers and prospects, understands and translates business use cases and/or requirements into data models, analytics reports and scenario models.
• Facilitate information gathering sessions and provides data analysis and data mapping.
• Interact with various business and functional team heads to finalize the data requirements.
• Identifying all use cases on base.
• Design and develop SSRS reports based on the business requirement thus obtained.
• Developed variety of SSRS reports like parameterized, drilldown, drill through, sub reports and ad hoc reports.
• Worked on several complex report features including Calendar reports, multi and select all parameter features.
• Design, implement and maintain database objects (tables, views, indexes, etc.) and database security in SQL
• Developed and executing test cases for SSRS reports thus created.
• Administered regular backups, logs and restores of all reporting databases.
• Scheduled SQL jobs for automatic report generation.

Environment: SQL server 2012, SSRS, Report Builder, Report Manager, Microsoft Team Foundation Sever (TFS), Visual Studio

Confidential, Cleveland, OH

BI / ETL Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Administered Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Created complex Store procedures, Views and functions to validate and transform data as per the business requirements.
• Creating and schedulingSQLserver agent jobs and alerts, scheduled reports for daily, weekly, monthly
• Configure SQL Mail agent for sending automated alerts/email.
• Developed a Queue Manager solution in C#.NET that enables automated queuing and generating of SSRS reports.
• Designed and developed SSRS, Tableau and Power BI reports.
• Built Tabular model and Star Schema cubes using SSAS and creating different dimensions, measures and fact tables.
• Developed a HTML5 and Angular JS dashboard with SSAS power pivot view, SSRS Reports, KPI’s, Uploader, Downloader and user administration.
• Optimizing Database Queries for performance enhancements and Writing T-SQL and dynamic SQL Views and triggers.
• Involved in the engagement economics by providing estimates, keeping track of budgets, and estimating time to completion.
• Lead a team of four to enhance the dashboard for better usability for 2 OTH Clients.
• Performed Code Reviews, worked closely with team members for customization and maintaining code across applications using TFS.
• Responsible for release of code into QA and production.
• Identifying and developing test cases and test scripts to perform load tests for Performance and regression testing.
• Work extensively with cross functional teams in an Agile Scrum environment to achieve the tasks within the given sprint deadline.

Environment: SQL server 2012, SSIS, SSRS, SSAS Tabular model, Windows 2012 Server, Microsoft Team Foundation Sever (TFS), Visual Studio, Data Profiler, Microsoft Share Point, C#.NET, ASP.NET, Angular JS, CSS, Java Script, Excel Macros, Tableau, Oracle 11g

Confidential

Data Analyst/ BI Developer

Responsibilities:

• Actively involved in the gathering requirements and analysis of the requirements related to the project.
• Detailed analysis on existing logs and coming up with a detailed list of analysis and reports to be generated.
• Extensively worked Design and develop SSIS (ETL) packages to validate, extract, transform and load data from different Sources like Oracle, Excel files, flat files to the Data warehouse using different task and transformations like Derived Columns, ExecuteSQLTask and Send Mail task.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations such as ExecuteSQLTask, Mapping, Data Flow Task, Data Conversion, For each Loop Container.
• Created data sources, data source views, dimensions, measures, measure groups, key performance indicators (KPI), perspectives, partition aggregations. And deployment and processing SSAS objects.
• As part of Business Intelligence and Reporting team, played a key role in Development and Maintenance of SSRS Reporting Environment.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports, Created Charts and Drill Down reports using Complex SSRS.
• Was actively worked in all phases of development cycle of SSRS report conversion project. This conversion project was replacing the existing crystal reports and received accolades for rapid report development and deployment.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and trigger.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

Environment: MicrosoftSQLServer 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Crystal Reports XI Release, ASP.Net, c#, Microsoft TFS, Visual Studio.

Confidential, Kenilworth, NJ

MS SQL Server Developer SSIS/SSAS/SSRS

Responsibilities:

• Actively participated in interaction with Users, DBA's and Business analysts to fully understand the requirements of the system.
• Migrating Existing code objects from SQL Server
• Reviewed database design and integration of systems and made recommendations on enhancements and participated in moving legacy data to the data warehouse using ETL.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star and Snow flake schema with Fact and Dimension tables.
• Designed ETL architecture for complete data transfer from OLTP to OLAP using SSIS.
• Performed data conversion from flat file into a normalized database structure and used FTP/SFTP tasks to get Data and Checksum files and upload them back to secured sites based on business requirements.
• Imported data from files usingSQLBULK INSERT in user specified format to database tables.
• Exported the data in/out ofSQLdatabases quickly using BCP Command.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes using SSIS
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers and published Reports to SharePoint site.
• Used Execution Plan,SQLServer Profiler to trace the slow running queries and tried to Optimize SQLqueries for improved performance and availability and CreatedSQLscripts for tuning and scheduling.
• Having knowledge of Normalization and De-Normalization techniques
• Worked in data modeling using MS Visio.

Environment: SQLServer 2008, Visual studio 2008, MS Visio 2007, C#.net, XML,SQLServer Management Studio,SQLProfiler, Database Tuning Advisor, Business Intelligence Development Studio, MS Excel,SQLData Generator.

Confidential

SQL Developer

Responsibilities:

• Installed SQL Server on Windows 2008 Server.
• Involved in the Analysis and Design
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration, Query Performance tuning.
• Backup recovery schedules, Backup scripts.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Trouble shooting Problems by using SQL server profiler. Very Pro-actively identifying the problems before user complaints.

Environment: SQLServer 2008, T-SQL, DTS, Windows 2008, Query Analyzer, SQLServer Management Studio, SSIS