SUMMARY

• 7+ years of IT experience inMicrosoft SQL Server BI stack(SSIS, SSRS, and SSAS/SQL)across various domains such as Retail, Finance, HealthCare and Insurance.
• Good Exposure in Developing, Monitoring, Extracting, Transforming data using SSIS/DTS,BCP, Import/Export Wizard and Bulk Insert
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, MS Excel, XML and Flat files.
• Good exposure in maintenance and administration of SSIS by creating jobs, alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Good experience in creating various reports like Parameterized, Cascading, Tabular, Drilldown, Matrix, Chart and Sub - Reports.
• Experience in providing Logging, Error handling by using Event Handler for SSIS Packages
• Experience in Database administration tasks such as Adding/Removing Logins, Database back up, Restoring the database and shrinking of the database.
• Highly proficient in the use of T-SQL for developing Schemas, Stored Procedures, Indexes, Triggers, Cursors, dynamic sql, Tables, table variables, Sub queries, Ranking functions, User Defined Functions andSQLjoins.
• Experience using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, and Check, Unique etc.).
• Experience working in RDBMS such as Microsoft SQL server, Oracle.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Good Knowledge in Dimensional modeling for OLAP and OLTP (star and Snowflake).
• Experience in optimization tools such as SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience using version control system such as TFS (Team foundation server)
• Good Exposure in Oracle.
• Experience working with Kimball Methodology.
• Experience working inSDLC and Agile (Scrum) Methodology.
• Experience in creating calculated Measures, Key Performance Indicators (KPIs) usingMDX.
• Good knowledge in SharePoint.
• Energetic and self-motivated team player with excellent communication, interpersonal, and leadership skills, thrives in both independent and collaborative work environments.

TECHNICAL SKILLS

Database: SQL server 2005/2008R 2/2012/2014/2016 , Oracle 10g

Database Tools: MS SQL server Management Studio, TOAD, SQL Developer, SQL server Profiler, MS Access.

Reporting Tools: SQL Server reporting services (SSRS)2008R2/2012/2016, Report Builder, SharePoint 2013,Power BI

Framework: .Net 2.0/3.5/4, ASP.Net

Programming Languages: C#,T-SQL, PL/SQL

Operating System: Windows Server 2003/Windows server 2005/2008/2012/2016.

Other Tools: MS Visual studio 2005/2008/2010/2013/2015 , TFS, Sql Server Data Tools, MS Visio, MS Office, Confidential Infosphere, Batch Scripting, Powershell.

PROFESSIONAL EXPERIENCE

SQL/SSIS Developer

Confidential, Naperville, IL

Responsibilities:

• Involve in Analysis of the Buyer to be automated.
• Interact with Review Analysts for Business Requirements.
• Develop new Stored Procedures,views,User defined functions for buyers.
• Created SSIS packages using different transformations like condition split, execute sql flow task, data flow task, data conversion to extract data from excel and flat files.
• Worked on Execution of the paths depending on the success or failure of other tasks with precedence constraints to determine the workflow.
• Use of BCP commands to export data.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Extensively used dynamic SQL, Joins, CTE’s, User defined Functions,Cursors and subqueries.
• Used SSIS Data Transformation tasks such as Conditional Split, Data Conversions to cleanse the data.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships
• Experience in writing sub queries and aggregatefunctions such as max, min, sum, count using TSQL.
• Monitor the monthly Jobs.
• Create and schedule jobs using SQL server Agent.
• Perform code refactoring. Rewrite existing SQL code.
• Set up profiler to trace slow running queries and optimization.
• Create datasets, expressions in SSRS.
• Create Tabular, Subreports, Drilldown reports using SSRS.
• Develop visualizations using SSRS to show the subscription usage of buyers.
• Create Report Subscriptions to file share.
• Prepare deployment Scripts.
• Fix defects raised in QA/ Production environments.
• Worked in troubleshooting, debugging stored procedures and upgrading existing ones with new requirements.
• Responsible for developing various reports like Drilldown, Cross tab, Sub-reports, Tabular reports for the finance team.
• Worked in troubleshooting, debugging stored proceduresand upgrading existing ones with new requirements.
• Perform Unit Testing.
• Used JIRA for tracking issues and User Stories.
• Used GIT for version Control.

Environment: Windows server 2016, SQL server 2016, MS Excel, JIRA, Git, Git Bash, Java 1.8, SQL server Data Tools 2016, SSIS, SSRS, Confluence, MS Visual Studio 2015.

SQL Server Developer

Confidential, IL

Responsibilities:

• Involved in Sprint planning with the BA and Architects.
• Working in Agile/Scrum Methodology.
• Designing and maintained conceptual, logical and physical data models.
• Create Stored Procedures, user defined functions, views, cursorswith fast forwardin SQL server according to the User Story.
• Extensively used CTE, Joins,subqueries, Table Types and Table variables in SQL server.
• Used ranking functions such as row number(), transposing columns to rows(PIVOT) along with sub-queries.
• Design Database tables and establish Primary/Foreign key relationships and constraints such as Check and Defaults.
• Involved in migration of SSIS Packages from SQL server 2014 to SQL server 2016.
• Handled exceptions in TSQL programming effectively.
• Have done data Modeling using Confidential Infosphere.
• Implemented Pagination in SQL server (to retrieve 500 rows based on the Page Number Provided) to improve performance.
• Perform Unit Testing.
• Fixed defects raised in CIT/SIT/UAT environments.
• Used Git as Source Control.
• Experience in using Developer Tools in Web Browser.
• Completed HIPAA Training.

Environment: Windows server 2016, SQL server 2016, Angular JS, Java, Eclipse, Confidential WebSphere, Git, Confidential Infosphere 9.1.3, MS Visual Studio 2015, Putty, SQL Server Data Tools - SSIS.

SQL Server/SSIS/SSRS Developer

Confidential, IL

Responsibilities:

• Involved in preparing the System requirement specification document and design document.
• Created ETL packages dealing with different data sources (SQL Server, XML, FlatFiles) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Developed the Stored Procedures, Triggers, and Views using TSQL.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
• Created database maintenance jobs such as rebuild indexes and update statistics.
• Worked on various task such as Execute SQL Task, Execute package task using SSIS.
• Identify and troubleshoot issues in Failed/Aborted packages.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and adding the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Develop Tsql statements as per the requirements.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS from OLTP data sources.
• Scheduled reports using report manager.
• Migrate SSIS pakages from SQL server .
• Generated WeeklySubscriptions reports for the analysis of end users by using SSRS.
• Performing unit testing for the SSIS packages and reports.
• Prepare environment for quality assurance and user acceptance testing.
• Prepare deployment document for rollout.
• Used TFS for maintaining the code.

Environment: Windows server 2008/2012, SQL server 2014/2012, Windows7, TFS,Visual Studio 2010/2013,MS Visio,VB,SQL server agent,SQL Profiler,Toad.

MS SQL Developer

Confidential, IL

Responsibilities:

• Involved in gathering the requirements from the clients and preparing the analysis, design and test case documents.
• Developed ETL packages in SSIS using Control Flow and Data Flow Tasks.
• Develop code in C# for writing the functions for SSIS.
• Developed automated jobs using SSIS for data refreshes which runs every quarter thereby eliminating manual data operations involved.
• Created reports with SSRS, using the report parameters, query parameters, Filters and Expressions for FACS application.
• Creating Stored Procedures for reports generation.
• Write batch scripts for few jobs depending on requirements.
• Migrate DTS packages from SQL server R2.
• Migrate packages from SQL server R2.
• Experience in DB Admin tasks such as DB Backup, Shrinking Database (Transaction logs) and Updating Statistics after loading the daily huge load data.
• Involved in design, programming, deploy and Unit Testing of requested Reports.
• Built the dimensions and fact tables with star schema using SQL Server Analysis Services (SSAS)
• Worked on Dimensions, facts, adding attribute to dimension and using various MDX built in functions while creating Calculated Measures and Key Performance Indicators(KPIs).
• Developed stored procedures, Cursors, Tables, Views, SQL Joins for applications using TSQL.
• Implemented SSAS Cubes, Fact and Dimension tables to perform analysis.
• Created reports using SSRS according to requirements.
• Deploying the report and configuring the report server
• Deploy the SSIS packages into production.
• Performed code fixes for issues raised in quality assurance.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Environment: Windows server 2008/windows server 2005,Windows 7,VB.net,SQL server 2008R2,Visual Studio 2008,MS Visio,SQL server agent,SQL Profiler,MS Analysis Services 2008.

C#/SQL Developer

Confidential, KY

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Developed Stored Procedures,Tables, Views,Indexes and functions using TSQL.
• Experience in database maintenance tasks such as backup and recovery of the database.
• Automate workflow using SSIS.
• Developed WebForms using ASP.Net and C#.
• Used Javascript for Client side validations.
• Used ADO.NET Connection, Command, Datasets, Data Adapter, and Data Reader to retrieve and store the data in SQL Server.
• Consumed SOAP Webservices (ASMX/WSDL).
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Migrated the DTS packages to SSIS.
• Involved in reporting using Crystal Reports.
• Involved in Unit Testing by preparing the test plan and test cases and executing them.
• Creation of deployment document and document issues encountered during roll out.
• Involved in post-production support.

Environment: Windows server 2005, MS Sql server 2005, MS Visual Studio 2005, IIS, MS Office, C#