SUMMARY:

• Over Eight years 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.
• Worked with different teams to set up the development and test Autosys environments.
• Experience in data Migration (using tools like DTS, BCP) between different heterogeneous systems and SQL Server as part of data migration and data maintenance.
• Created Queries and Tables using MySQL.
• Experience in Jobs, Sending Alerts using SQL Mail, SMTP Mail in SSIS.
• 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 creating simple to complex parameterized SQL Reports using SQL Server Reporting Services (SSRS).
• Experienced in working on different data bases like Oracle, MS SQL Server.
• 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.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and interpersonal communication skills.
• 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, Minnetonka, MN

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-sql Scripts for DDL changes to accommodate those changes between Devlopment, Staging and Production Environments.
• Strong Understanding of the FACETS front-end application.
• Development and deploying of the SSIS 2005/2008 packages to maintain, update and migrate the data into and from the FACETS application database.
• Worked with different teams to set up the development and test Autosys environments.
• Assisted in configuration, development and testing of AutoSys JIL and other scripts.
• 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.
• Wrote complex SQL queries to extract and validate the data from the Facets database
• Extensively worked with Member/Subscriber and HIPAA Privacy Facets application groups.
• Designed AutoSys based solutions for communication of issues to technical teams.
• 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.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Used C# for creating classes and worked on integrating Crystal Reports with ASP.NET.
• Set claim processing data for different Facets Module.
• Extensively used Autosys and DBMS Scheduler for scheduling the nightly batch jobs
• 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.
• Involved in configuration of FACETS Subscriber/Member application..
• Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
• Did the forward and backward data mapping between the fields in mainframe and FACETS.
• 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, Bloomington, MN

Sr. MS SQL Server / SSIS Developer

Responsibilities:-

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for Migration of SQL server 2005 to SQL server 2012 by writing migration scripts and a clause that checks whether the migration script is valid for the version of the target database.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports.
• Used C# for creating classes and worked on integrating Crystal Reports with ASP.NET.
• Designed AutoSys based solutions for communication of issues to technical teams.
• Extensively used Autosys and DBMS Scheduler for scheduling the nightly batch jobs
• Development of client/server and multi tired applications using the SQL on different platforms like Windows NT/2000/XP, UNIX, Perl and Linux.
• Involved in configuration of FACETS Subscriber/Member application..
• Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
• Did the forward and backward data mapping between the fields in mainframe and FACETS.
• Designed AutoSys based solutions for communication of issues to technical teams.
• Wrote complex SQL queries to extract and validate the data from the Facets database
• Extensively worked with Member/Subscriber and HIPAA Privacy Facets application groups
• Played major role in designing reusable, scalable and maintenance of ETL Templates
• Used C# for creating classes and worked on integrating Crystal Reports with ASP.NET.
• Conducted peer designing, code reviews, standard documentation and ETL procedures
• Designing and developing SSIS packages, configuration files, and functions
• Experienced in Unix/Linux, windows & Solaris environments.
• Created and optimized database objects such as views, functions and stored procedures as per requirement.
• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables
• Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Set claim processing data for different Facets Module.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Worked on Tabular Modeling Development and Multidimensional Modelling Development using SSDT. Create additional Timestamp for report.
• Validated data from Clarity DB for single instance Project.
• Using transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects. Implemented BCP for bulk inserts.
• Transferred data from various data sources systems including MS Excel, MS Access, flat files to SQL Server using SSIS. Created SSIS packages and scheduled the jobs to run automatically.
• Table renaming, splitting or merging columns and changing the data type or size of the column
• Dealing with large data movements and Guard clauses which stops making changes to the migration script if it doesn't need to run.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Set claim processing data for different Facets Module.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Designed ETL package, with ETL Import/Export wizard for transferring data.
• Data migration (Import & Export - BCP) from text to SQL Server.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder..
• Converted existing excels based reports and crystal reports to SSRS reports.
• Created Drill-down, Parameterized and Sub-Reports using SSRS
• Deployed and uploaded the SSRS reports to Report Manager for the end users and involved in enhancements and modifications.
• Improved existing reports performance by using execution log2 and optimized the underlying procedure and queries.

Environment: Windows2003 Advanced Server, ASP.Net, Mac, Linux Unix, 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, Las Vegas, NV

SQL/MSBI 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 functionalities and included interactive drill down reports, report models and dashboard reports.
• Connected to Amazon Redshift using OLE DB and ODBC 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 execution plans, sql profilers and did query optimization
• 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 BI Application 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 chart controls, filters, Interactive Sorting, SQL parameters 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 source data, creating prototypes and sample reports to help with requirements and design.
• Developed physical data models and created DDL 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, stored procedures to check the data entry and payment verification.

Confidential, Salt Lake City, UT

BI Project Coordinator (Sql/SSIS)

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-SQL stored 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 Single Sign On Concepts.
• Worked on ASP.NET and able to fix many UI issues in estimated timeframes.
• Having hands on experience in DR Processes including Log shipping and Database Mirroring.
• 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 temp tables, 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:

• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.
• Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server - Stored Procedures, Triggers, User-defined Functions and Views, Cursors
• Performance tuning of Stored Procedures and T-SQL Queries
• Implementing SQL Server Indexing and Query optimization using Indexes
• Normalization and De-Normalization techniques
• Involved in Backing up databases and refreshing Data across environments
• Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULKINSERT etc.
• Maintained a good client relationship by communicating daily status and weekly status of the project.
• Managed requests that came from the client as well as the development teams.
• Managed and monitored system utilization.
• Managed backup and disaster recovery of the team.
• Managed the security of the servers (Logins and users).
• Designed stored procedures and triggers for automating tasks.
• Worked on complex data loading (implemented the batch data cleansing and data loading).

Environment: Tools: MS SQL Server 2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler.