SUMMARY:

• 6 years of IT experience in Database Design, Development and Support of MS SQL Server 2016, 2012, 2008 R2.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2008 R2.
• Expertise with DDL and DML statements, RDBMS, data dictionaries and normal forms.
• Good knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex Views, Dynamic SQL, Triggers and Cursors.
• Profound knowledge and ability to write stored procedures, using temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experienced in transforming complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• Experience in writing complex T - SQL queries using Inner Joins, Outer Joins and Cross Joins.
• Expert in SQL Server tools like SQL Server Reporting Services, SQL Server Integration services, SQL Server Analysis Services.
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Summary Reports, List Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports, Cascaded Reports, Custom Reports and creating stylish report layouts in SSRS.
• Proficient in migrate earlier versions of SSRS to new 2012 format and developed and deployed new reports as required.
• Successfully designed Tabular model in Visual Studio 2012.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Worked on Power BI and prepared dashboards to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power View & Power BI.
• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance

TECHNICAL SKILLS:

Databases: Microsoft SQL Server (2008/2008R2/2012,2016), Oracle 8i/9i, DB2, MS Access, IBM DB2

Database Tools: MS SQL Server (2008/2008R2/2012,2014), MS-Access, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI

Languages: T-SQL, PL/SQL, VB.net

ETL Tools: DTS, SSIS (SQL Server Integration Services)

Reporting Packages: SQL Server Reporting Services, Power BI, MS Excel.

Tools: /Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Red Gate

Operating Systems: Windows 7, Windows 8, Windows 10, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL Server/ BI Developer

R esponsibilities:

• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.
• Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
• Involved in developing the data warehouse for the database using the Ralph Kimball’s Dimensional Data Mart modeling methodology.
• Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.
• Expertise in Data Modeling, Data Migration, Data Profiling, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools.
• Worked with latest tools like SQL Server Management Studio 2016, SQL Server Data Tools 2017, Toad Data Point to query DB2 Databases and Oracle SQL Developer for Oracle databases.
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Used knowledge of Health Care Information Systems EMR model to develop proposed workflow.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Used Power BI to prepare dashboards to monitor SQL Server Health Performance.
• Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2008R2.
• Developed stored procedures, cascading parameters and custom code for developing complex SSRS reports.
• Created SSRS dashboards using charts, gauges, indicators and data bars.
• Deployed SSRS reports in native and SharePoint mode.
• Used SSRS reports with parameters from Performance Point Services deployed in SharePoint 2013.
• Developed MDX queries for SSRS reports from SSAS Cubes.
• Create and edit alerts on Reports as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Developed complex reports in both SSRS and Crystal reports based on the requirements provided and going through multiple discussions with the team.
• Migrate reports from Dev to Production.
• Used Git as source control for databases to keep all the environments in sync with the Production environment.
• Worked with Redgate tools like SQL Compare, SQL Data Compare, SQL Source Control, SQL Prompt along with the SQL Server Management Studio 2016 to make work easy for committing changes to source control and creating back up scripts automatically.
• Provide on call support after reports are deployed to production.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Expert in generating Sub reports, Standard, Mailing Labels, Cross Tab Reports and Graph reports by using Chart expert of SSRS.
• Extensively shared and global variables across SSRS.
• Converted SAS Code to SQL as per the Business request.
• Making changes to existing reports and new reports from ICD 9 to ICD 10 codes.
• Generate reports with parameters, sub reports, cross tabs, charts using a Crystal reports.
• Developed power view reports using Tabular Models in SQL Server Data Tools.
• Have Knowledge in Conversion Agent and converted word document, PDF, HL7and text into XML format.
• Created standard and data driven subscriptions for weekly, monthly and daily reports.
• Extensively used Tortoise SVN to implement version control for MSBI (SSIS/SSRS/SSAS) projects.
• Training business users on using Excel 2013/2010 to create ad-hoc pivot tables and charts from SSAS cubes and using Performance Point Services (UI).

Environment: SQL Server 2016/2008 R2, Windows 7, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Query Analyzer, Erwin, GIT, TFS, SVN, MS Visio 2007, XML, MS Excel 2007, Visual Studio.

Confidential, Indianapolis, IN

SQL Server/Power BI Developer

Responsibilities:

• Involved in creating database objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Parameterized Stored Procedures and Constraints.
• Created and developed the Stored Procedures, Triggers to handle complex business rules. Wrote complex SQL statements using Joins, Subqueries, Correlated Subqueries and CTE.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Implement Azure and use Azure task factory.
• Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases.
• Designed SSIS packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, XML Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in Incremental data loading.
• Developed SSIS 2012 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2014/2012 for further Data Analysis and Reporting by using multiple transformations.
• Involved in development of Incremental Load process using SSIS Packages and various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed models, reports and dashboards using Microsoft Power BI stack - Power Pivot, Power View, Power query.
• Worked on Power BI and prepared dashboards to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.
• Developed stored procedures, for automating the process of performing tests to identify major employee expenses, cost cutting, monitor KPIs and overall employee expense management.
• Involved in Identified Critical Success Factors (CSFs) and developed Key Performance Indicators (KPIs) for generating reports.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Provided exploratory data analysis solutions using Microsoft BI suite and Power BI for identifying anomalies in journal entry transactions in support of financial reporting and the associated risks of financial statement fraud.
• Utilized Power BI - Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports and created reports and dashboards using Power BI.
• Migrate existing data into the Power BI and create reports in preview portal utilizing the SSAS Tabular.
• Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI.
• Involved on call production support 24/7 for Production Jobs.
• Involved as a Lead for UAT team for bug fixes and production issues.
• Involved in transforming data from dev into Stage & Prod environments using BCP Process.
• Participated in Sprint meting and updating status on reports in Agile Environment.

Environment: SQL Server 2014/2012, SSIS, SSRS SSAS, Visual Studio 2012, Azure, ASP.NET, Power BI, T-SQL, Crystal Reports, Tabular, Excel 2013, Power View, Tableau, PowerPivot, Performance Point, MDX, Report Builder 3.0, DTS, C#, VB.NET, Team foundation server

Confidential

MS SQL Server Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2008 R2 DB objects like tables, Views and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2008 R2 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Ensured data recovery, maintenance, data integrity and space requirements for physical databases are met through formulations and monitoring of policies, procedures and standards relating to database management.
• Experience supporting team of application developers for their .NET web/OLTP database application.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Implemented OLAP Cubes, Facts and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional expression (MDX) to access them.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within measures group and drill through actions.
• Created SSIS package and executed it through Autosys.
• Created Pentaho reports and used parameters to pass in the report.
• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Documented the development work and production release for future reference.

Environment: MS SQL Server 2008/2005, T-SQL, MS Access, Windows 7, .NET, Erwin v4.0, VB.Net, C#, TFS.

Confidential

MSSQL Server Developer

Responsibilities:

• Wrote User Defined Functions and Stored Procedures, and also defined Roles and Privileges to control access to database
• Created tables, Constraints, Defaults, Triggers, Views, and Indexes
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Load data using Bulk Insert.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Create packages, procedures, functions, and triggers; handle database performance and tuning.
• Apply Service Packs for SQL Server database. Creation of new database, starting from scratch i.e. deciding the location of data files and log files on the disks.
• Reorganization of existing databases to standardize the placement of various databases related files.
• Creation of additional databases, logins and roles.
• Data transfers between various servers using DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.
• Ensuring that the backups are running fine for various databases on different servers.
• Providing support to the Application developers on the application databases.

Environment: SQL Server 7.0/6.5, Visual Basic 6.0, and Windows NT 4.0