SUMMARY

• Over 7 years of experience in database development, modeling, testing, deployment and business intelligence using SQL Server 2016,2014,2012, 2008, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS) in healthcare, insurance and retail industries.
• Worked with various teams and user groups in designing and developing the reporting warehouse.
• Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings.
• Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, analytics and reporting needs.
• Expert in designing reports using SQL Server Reporting Services (SSRS) based on OLAP cubes.
• Experience in developing custom reports and different types of tabular, matrix and distributed reports into multiple formats with SQL Server Reporting Services (SSRS).
• Expert in enhancing the reports visually by adding the visual elements including charts, graphs, gauges and maps to SSRS reports.
• Experience in creating SSIS packages based on multiple data source including SQL Server, flat file, excel and oracle.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of data migration and data maintenance.
• Designed SSIS package to extract appropriate records and output them to data marts and warehouse.
• Experience in developing scripts in SSIS to synchronize stored procedures, email output and log messages.
• Designing and maintaining data management and data processing solutions using SSIS, includes error handling and Slowly Changing Dimensions (SCD).
• Experience in creating jobs, SQL mail agent, alerts and schedule SSIS packages in SQL Server.
• Expertise in developing and extending SSAS cubes, data mining models, deploying and processing SSAS objects, and writing MDX queries.
• Experience in normalize and de - normalize data in the process of building database and reporting.
• Familiar with process of testing, troubleshooting and debugging on each unit of work, including jobs, SSIS package, SSRS reports and SSAS cubes.
• Expert in migration of databases from older versions of SQL Server 2008 to SQL Server 2012.
• Extensive database programming Experience in developing complex T-SQL queries including stored procedures, User Defined Functions (UDF), triggers, views, temporary tables constraints and indexes using various DDL and DML commands.
• Excellent Experience in monitoring SQL Server performance tuning in SQL Server2008/2012 using SQL profiler, query analyzer, enterprise manager, index tuning wizard, and windows performance monitor.
• Having full understanding of Software Development Life Cycle (SDLC) with substantial experience on object oriented analysis and design methodologies
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player knowledge of dimension hierarchies, drilldown, sub reports, and Key Performance Indicator (KPI)
• Expert in creating and developing Power BI and Tableau dashboards in to rich look.

TECHNICAL SKILLS

Programming Languages: C, C#, ASP.net, VB.net, Java, Python, SQL & PLSQL

Web Technologies: HTML, XML, JavaScript, AJAX, SOAP And Active X.

Database Environments: Oracle 11g/12c, MS SQL Server 2008/2012/2016 , MySQL, DB2 and MS Access

ETL Tools: SQL Server Integration Services (SSIS), and Informatica.

Reporting Tools: SSRS, Oracle Forms & Reports 6i/9i/10g, Crystal Reports 8.0, Tableau, Cognos and Power BI

Other Tools: Microsoft Visual Studio, Oracle 11g,, SSAS, SQL Developer, SQL Server Management Studio, Microsoft Azure, Eclipse IDE

MS-Tools: MS-Visio, Outlook, Advance Excel, Word, and PowerPoint

Operating System: Windows NT/XP/Vista/7, Windows 95/98/2000/NT, Windows Server 2003/2008.

Version Control Tools: CVS, TFS, SVN, GIT

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Business Intelligence Developer

Responsibilities:

• Developed store procedures, triggers, views and user defined functions for better performance in SSIS and SSRS
• Analyzed queries performance with SQL query analyzer, optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Installed and configured SQL Server 2008, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) which were highly efficient to monitor the central console and SQL Server instances and detecting problems before affecting transaction of online users.
• Implemented the online indexing making the transaction in SQL 2008 faster nearly three times as compared to the SQL Server 2005.
• Merged data from heterogeneous data sources including MS SQL server, flat file and MS Excel to SQL Server 2008 using SSIS packages.
• Participated in to design ETL architecture and processes records from different locations, and successfully met challenges of very high volume of data.
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers in SSIS.
• Imported XML data file as data source and put into the desired database in SSRS and SSIS.
• Generated different type of customized reports including drill-down, drill-through in SSRS.
• Created and executed the stored procedures and complex queries for reports.
• Deployed, scheduled the reports and send the output via email in report manager.
• Responsible for generating different types of daily and weekly Reports based on specifications and user's requirements using SSRS
• Documented all the work and all the process of integration and reporting services for further references.
• Interacted with development teams and managers to analyze business needs and developed technical specifications.

Environment: SQL Server 2005/2008, SSIS, SSRS, Microsoft Operation Manager, SQL Query Analyzer, ODBC, VBScript, Windows 2000/XP/7, MDX.

Confidential, Brentwood, TN

SQL/SSRS Report Developer

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables and Table valued Functions for data extraction, data load and transformations.
• Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab-delimited and pipe-delimited.
• Worked on several State Reports and used SSIS to create multiple destination files from single/multiple sources.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc. and scheduled SSIS packages.
• Created SSRS (SQL Server Reporting Services) reports having multiple Parameters and cascading parameters, Navigation to a sub reports and created book marks when report is exported to PDF or EXCEL File.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Responsible to build Reports for different Markets and ADHOC reports as per request.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS (SQL Server Integration Services)
• Documented Back out Implementation Plan for all the work done and also created the CMD files.
• Worked with Team foundation server version Control to maintain the different versions of Code, RDL Files, Back out Scripts, CMD files & SSIS Packages.
• Created Subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Worked with Oracle Application database to pull Claims, Providers, and Members information for various reports and extracts.
• Provided 24/7 Production Support for the maintenance & scheduling of reports.

Environment: SQL Server 2012/2014, Report Builder 3.0, Business Intelligence Studio (SSIS, SSRS), C#.NET, T SQL, MS Excel.

Confidential, Berlin, VT

SQL Developer

Responsibilities:

• Prepared the complete data mapping for all the migrated jobs using SSIS
• Responsible for creating and designing SSIS package
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
• Use package configuration to migrate SSIS package from one environment to other
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Involved In writing Complex T-SQL Queries.
• Backing up master & system databases and restoring them.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Involved in testing and debugging stored procedures.
• Designed, built and tested SSAS Cubes on SQL Server.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process the cubes (SSAS), partitions as and when required.
• Writing the DAX statements for Cube
• Designing Visualizations in Tableau 9.2

Environment: MS SQL Server 2008/2012, SSIS, SSAS, TFS, Windows 2003/2008, Deployment Wizard, Visual Studio 2010, MS Excel 2007, Tableau, C#, ASP .Net

Confidential, Phoenix, AZ

SQL Server/SSIS Developer

Responsibilities:

• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.
• Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2008.
• Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts.
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse .
• Maintained error logs for the Stored Procedures.
• Used Team Foundation Server and Visual Source Safe as a version control tool.
• Developed logical queries to not triggering email limit error for ETL batch jobs.
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily.
• Solved the issues associated with ETL Data Warehouse Failure.

Environment: MS SQL Server 2008, Microsoft Visual Studio 2010, Team Foundation Server (TFS), MS VISIO, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Excel, Microsoft Office SharePoint Server