SUMMARY

• Over 7+ of IT experience, which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server, Oracle) in production environments and providing ETL/Business Intelligence solutions using Microsoft components to various clients (SSIS, SSRS).
• .Extensive experience in Systems Development Life Cycle (SDLC) from Design, Development and Implementation. .Excellent skills in exporting and importing data using Microsoft ETL technologies (SSIS).
• Experience in Performance tuning the stored procedures and reducing the run time by running them in parallell using SSIS Packages.
• Excellent skills in providing ETL solutions to the clients for integrating data from different sources (XML,Excel,Delimited,Oracle,Teradata,SQL Server, flat file) using multiple transformations provided by SSIS.
• Experience in generating XML formatted files using FOR XML clause in T - SQL.
• Worked on Tabular Modeling Development and Multidimensional Modelling Development using SSDT. Create additional Timestamp for report.
• Excellent skills in designing Logical and Physical Modeling of databases. Expereince using Change Data Capture methodology in SQL Server.
• Experience using high complex T-SQL Queries and SQL scripts to perform efficient data load based on complex business rules and produced results for users.
• Extensive experience in TSQL Development which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and User Defined Functions.
• Excellent skills in creating indexes and performace tuning the T-SQL queires uing SQL profiler.
• Excellent skills in reading and understanding T-SQL execution plans and performance tuning with SQL Server Dynamic Management Views.
• Experience in data Migration (using tools like DTS, BCP) between different heterogeneous systems and SQL Server as part of data migration and data maintenance.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and Production servers.
• Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008/2005 with .NET, Import/Export data, Bulk insert and BCP.Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Experience in using Performance Monitor/Profiler to monitor and solve performance issues like Dead Locks and Long running queries.
• Stored procedure (SP), user defined function (UDF), and user defined table function experience with DB2 SQL/PL.Experience in SSRS with Report authoring, Report management, Report Delivery and Report Security.
• Experience in defining query for generating drill down reports in SSRS 2005/2008.
• Extensive Knowledge in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery Actively involved in AGILE SCRUM work environments.
• Good understanding of Health Care, Financial, Banking, Telecom and Insurance domains.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008/2005 , Oracle 11g/10g, DB2, Teradata, MS-Access, Amazon Redshift., Vertica, .

SQL Server Tools: Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Export & Import (DTS), SQL Profiler, Database Engine Tuning Advisor, DBCC, Monitor Resource Usage.

Operating System: Windows NT, Windows 2000, Windows 2003, Sp3, Windows Server 2008,Windows Server 2010, Windows 7, Mac, Linux and Unix Os

Other Tools: SQL Loader, ERWIN, ER Studio, Microsoft Visual Source Safe, Microsoft Office, Microsoft Visio, MS Visual Studio 2003/2005/2008/2010/2012/2013 , Microsoft BIDS, Crystal Reports, Team Foundation Server, HP Quality Center, Bugzilla, Zephyr, Source Version Control (SVN), SQL Developer, TOAD for ORACLE SQL, JIRA, Confluence, Service Now, Trizetto FACETS, TIDAL(Cisco’s Enterprise Job Scheduler), NET FrameWork 5.0, 6.0

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sql/SSIS Developer

Responsibilities:

• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Capable of handling responsibilities independently as well as a proactive team member.
• Involved in the performance tuning and optimization of T-SQL queries.
• Implemented new features that came up in SQL 2012/2014 like Column Store Indexes
• Created complex stored procedures to Pull the data fast and Display data to the front end application
• Generated Runbooks in TFS to easily deploy the code between different database environments
• Experience in Performance Tuning of Stored Procedures and SQL queries using column Store Indexes and splitting the stored procedures and running them in parallel using sql server Integration Services.
• Developed T-sqlScipts for DDL changes to accommodate those changes between Development,Staging and Production Environments.
• Good Knowledge in configuring and working with DB version control system (Red Gate)
• Performance tuned the stored procedures with query hints such as MAXDOP( Max Degree of Parallelism)
• Developed Stored procedures to insert the data from the front end application into the database tables
• Worked on SSIS templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into development, test and production environment and extracted data using SSIS.
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables
• Experience with coordinating with web development team to develop mock up data for testing their API’s
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Created Database Objects - Tables, Indexes, Views,Stored Procedures and User defined functions according to the requirements of the project. proficient in using Windows, Mac, Linux and Unix Os
• Created SSIS Packages/projects to move data from source to destination by using Visual Studio 2015
• Developed utility stored procedures such as Reseed all the tables in the database to their current max identity column value.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Developed the design document for each ETL mapping, defining the source and target tables and all the fields, transformations and the join condition, which helped the users to better understand the type of data.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Expertise in writing T-SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views and Cursors.
• Created many stored procedures for cleaning, manipulating and processing data between the databases.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Environment: Windows2003 Advanced Server,Mac, Linux, Unix, ASP.Net, MS SQL Server 2005/20 TSQL,, Visual Studio 2008/2 SharePoint 2007/2010,TFS

Confidential, Skokie, IL

SSIS/SSRS Developer

Responsibilities:

• Developed SSIS templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into development, test and production environment and extracted data using SSIS.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS SQL Server 2008 to MS SQL Server 2012 using SSIS Packages in Business Intelligence Development Studio.
• Validated data from Clarity DB for single instance Project.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalitiesand included interactive drill down reports, report models and dashboard reports.
• Connected to Amazon Redshift using OLE DB andODBC data sources connector and tables.
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Implemented new features that came up in SQL 2012/2014 like Column Store Indexes, Pagination, OFFSET and SEQUENCE, setting up permissions and roles for users at both database and server level.
• Worked intensively in query executionplans, sqlprofilers and did queryoptimization
• Integrated data from multiple sources and stored them in Operational Data Stores (ODS) to pass it further down to Warehouse for reporting purposes.
• Worked on both Normalization and De-normalization approach and implemented them appropriately for Warehouses and Marts.
• Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients and managers.
• Created various weekly and monthly reports showing detailed information in SSRS.

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012 , TSQL, Amazon Redshift, Visual Studio 2008/2010/2013 , SharePoint 2007/2010, Tableau, SSIS, SSRS,SSAS((multidimensional and tabular models)Vertica, Erwin.

Confidential

SQL BIApplication Developer

Responsibilities:

• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Conducted Data Analysis and did Data Modelling and Created the ER diagrams using Logical Schema and Star Schema.
• Generated ad-hoc reports using MS-Excel and Crystal Reports.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Validated data from Clarity DB for single instance Project.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert)
• Involved in error handling of SSIS packages by evaluating error logs
• Successfully extracted transformed and load data into data warehouse
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards reports(SSRS) according to business requirement.
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created reports in SSRS with different type of properties like chartcontrols, filters, InteractiveSorting, SQLparameters etc.
• Extract Transform Load (ETL) development using SQLServer2005, SQL2008 Integration Services (SSIS).
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Migrating SQL Server 2005databases into SQL Server 2008.
• Created SQL Server Reports using SSRS 2008.Identified the data source and defined them to build the data source views.
• Involved in the analysis and profiling of sourcedata, creating prototypes and samplereports to help with requirements and design.
• Developed physical data models and createdDDL scripts to create database schema and database objects.
• Formatted the report layout for the requirement of the end users.
• Used DDL and DML for writing triggers, storedprocedures to check the data entry and payment verification.

Confidential

SSIS/SSRS-Developer

Responsibilities:

• Involved in supporting more than 80 Users for various Reporting and Analytics requirements across multiple Business Units and departments.
• Created Databases, Schemas, Tables, Cluster/Non-Cluster Indexes and various other database objects Wrote efficient Stored Procedures for the optimal performance of the system
• Responsible for Creating and Modifying T-SQLstored procedures/triggers for validating the integrity of the data
• Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Involved in writing multiple reports incorporating business logic and user requirement.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Validated data from Clarity DB for single instance Project.
• Developed Complex SSRS Reports involving Sub Reports
• Created large enterprise reports for various Business functionalities assigning report parameters.
• Developed Report Models using Report Builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Worked on deployments moving data from DEV to Stage and PROD.
• Working knowledge in publishing Websites and SingleSignOn Concepts.
• Worked on ASP.NET and able to fix many UI issues in estimated timeframes.
• Having hands on experience in DR Processes including Logshipping and DatabaseMirroring.
• Implementing all high availability techniques like clustering, log shipping, replication.
• Working experience with Column store indexes, table partitioning in SQL SERVER 2012.
• Worked in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temptables, cte’s, redesigning schemas and many more.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc. and vice versa.
• Used various control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task etc and different data flow tasks.
• Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Involved in Security administration, granting permissions, roles and maintain various AD Permissions at database and report levels.
• Interacted with end users and customers and act as functional analyst /development member with various cross functional teams
• Well versed in doing remote support for various levels of customers across different geographical locations.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables

Confidential

Software Engineer

Responsibilities:

• Created check constraints to maintain data integrity.
• Created views to facilitate easy User Interface Implementation, and Triggers on them to facilitate consistent data entry into the database.
• Implemented Performance Tuning in SQL server and in SSIS packages.
• Created Business-Crucial Stored Procedures and functions with best execution plan to support efficient data storage and manipulation.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and ptimized the procedures and triggers to be used in production.
• Implemented triggers for checking complex business conditions, providing security for the tables.
• Worked with exception handling in stored procedures.
• Optimized the performance of queries with modification in T-SQL queries, removed the unnecessary columns and redundant data, normalized table.
• Created User Defined Functions (UDF) to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Created databases, tables, Cluster/Non-Cluster Index, unique/check constraints views, Stored Procedures, triggers, rules and defaults.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Configured SSIS packages using package configuration wizard to allow packages to run on different
• Created cross-tabs, drill-down and sub-reports using SSRS. Deployed RDLs to report server.
• Created jobs performance report that queries system tables to track the duration of each job and weekly- average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, interactive sorting, SQL Parameters etc.
• Designed SSAS cube to hold summary data.
• Created user defined hierarchies depending on the business requirement using SSAS.

Environment: SQL Server 2012/2008, T-SQL, SSRS, SSIS, SSAS, .Net Framework, TFS, Management Studio 2005/2008/2012 , Query Analyzer, MS Access. Visual Studio 2005/2008/2012 .