Professional Summary:

• MS SQL Server Developer over 8 years of strong experience in various domains like Financial, Healthcare, Retail and insurance with expertise in MS SQL Server 2012/2008r2/2008/2005/2000 and SSIS, SSRS, SSAS, CADIS.
• Expert in Microsoft Business Intelligent Studio 2010/2008 SSIS/SSRS/SSAS
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Building crystal Reports by using MS Excel Pivot Table , By using Different Chart tool and various data sources like XML/SQL /SSAS.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services SSIS .
• Expertise in developing and modifying multi-dimensional cubes using SQL Server Analysis Services SSAS .
• Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Mastery in extracting and transforming transactional information using DTS Import/Export wizard, BCP Bulk Copy Program DTS Data Transformation Services and SSIS Packages from SQL Server.
• Expertise in developing and modifying multi-dimensional cubes using SQL Server Analysis Services SSAS .
• Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database Service packs, hotfixes and Security Patches.
• Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support
• Use CADIS for the security implementation and mastering data by Bloomberg source data.

Business Skills / Technical Skills:

MS SQL Server 2012/2008R2/2008/2005/2000, Visual studio 2012/2010/2008 SSAS/SSIS/SSRS , Microsoft Access 2007/2003, Microsoft Excel Pivot Table , Outlook, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, ASP.Net Frame Work 2.0, C , Oracle, DB2, Crystal report, Erwin8/7.3/3.5,Windows 2007/2005 Advanced Server/Professional, Window XP, MS Access, Java, My SQL, CADIS 8.1, SQL Compare 10

Professional Experience:

Confidential

Role: Business Analyst Database Developer

Responsibilities:

• Used visual studio 2012 to doing database development and integration development and also used AutosysJil files to create job scheduling for integration and Java.
• Created BNTC Best Number to Call and BTTC Best Time to Call files for the business by using database and integration backend and java and MSP in front hand tool.
• Worked with BA, QA and Rules developer to make sure everything is up to date.
• Made huge performance tuning in Green Field as compared with existing system called Pulse.
• Also worked with the EDW, ASD, Skip Trace and DM Loan and Borrower team to make sure they were good from their side so receiving the data from them is quicker.
• Used Agile methodology to achieve Goal by using regular scrums and Sprints.
• Used multiple Transformation like Sort , Data Conversion, Conditional Split , Derived Column, LookUp , Merge and Multi Cast while creating SSIS Packages.
• Created ETL packages with different data sources SQL Server, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS. Performed Documentation for all kind of SSIS packages.
• Also Up for the Production Support 24/7 . So the whole system is running Up to date.

Tools Technologies:

MS SQL server 2008,2008R2,2012 ,SSIS, SQL Profiler and T-SQL, Visual Studio 2010,2012 , Microsoft Office, Index Tuning Wizard, Query Analyzer, SQL Compare 2010, TFS

Confidential

Role: SQL Server/ BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Successfully built a new end to end Bloomberg credit risk module from data feeding to mastering by using CADIS.
• Use SSRS to create the report for the marketing people by using combination of SSAS and Database. So they can present up to date information in front of the future business.
• Investigate and Analyzing data quality tool and creating Analysis documents for the management
• Worked with the Clnt Hub database. And help client by using their DWHTemp and DWHModel Destination databases by Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency for the clean data.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
• Create reports by using the pivot table MS Excel by using the OLAP data source for the sales department and keep them up to date to get more future business.
• Successfully implemented indexes on tables for optimum performance.
• By Using SSRS We trigger the SSIS and Write Log into the Reports including IT request Link.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Created OLAP cubes using SSAS to analyze the business condition of the sales
• Extensively used Joins and Sub-queries including CTE for complex queries involving multiple tables from different databases.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Experienced in creating package dynamics by using SSIS transformations and variables.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.

Tools Technologies:

T-SQL, MS SQL Server Integration Services 2012, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio, Erwin, Windows XP, MS Office 2007/2010, MS Access, Power Pivot, CADIS 8.1.

Confidential

Role: SQL Server TSQL/SSIS/SSRS

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction
• Wrote standard complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Accountable for Backup and Recovery Strategy and Planning.
• Created ETL packages with different data sources SQL Server, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension SCD , Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Data quality done by using the Data cleansing by using ETL development
• Use Packages by testing and Cleaning the Standardized Data by using tools in Data
• Flow Transformations Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more for existing and new packages.
• Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Logged various packages as well as individual tasks using SQL server log providers like text file, sql server database, trace file, xml file.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Maintain data quality by using the SCD and loaded into target database
• Used sub reports functionality for complex report calculations.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.

Tools Technologies:

MS SQL Server 2012, T-SQL, SQL server Integration service 2012, SQL server reporting service 2012, Erwin7.3,Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003.

Confidential

Role: SQL Server T-SQL Developer /SSRS/DBA

Responsibilities:

• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Applied monthly patches and hot fixes.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Using ETL to build the required data mart.
• Generated Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Tools Technologies:

MS SQL server 2008R2, SSRS, SQL Profiler and T-SQL, Windows 2003 server, and Visual Studio 2010, Microsoft Office, Index Tuning Wizard, Query Analyzer, SQL profiler.

Confidential

Role: MS SQL Developer/ SSRS, SSIS, SSAS Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Created Parameterized, matrix and drill down reports using SSRS 2008.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Actively supported business users for changes in reports as and when required using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Deployed the generated reports created using SSRS 2008 on to the server.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.

Tools Technologies:

MS SQL Server 2008, MS Analysis Services 2008,MS SQL Reporting Services, T- SQL, Crystal Reports, Windows XP, Query analyzer, SQL Profiler, MS Excel.

Confidential

Role: SQL Server Developer/ SSIS Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Designed database, tables and views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using SSIS Packages.
• Generated ETL packages with different data sources SQL Server, Flat files, Excel source files, Oracle and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension SCD , Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Tuned SQL statements Using Indexes and stored procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.

Tools Technologies:

SQL Server 2008, SSIS, Windows 2003 server, MS Access, Excel

Confidential

Role: SQL developer

Responsibilities:

• Mostly involved in gathering business Requirement and Online System Specification and building up a solution to implement in CAIS.
• Implemented batch processing for approval process by creating a wrapper driver which used ISQL conducting various BCP, select out and select into commands.
• Wrote complex stored procedures to process prospective customer information and balanced the processing load between front end and back end.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2005.
• Successfully migrated old data from legacy systems FoxPro and external system including DB2 and excel into SQL Server 2005 using DTS, BCP and ActiveX scripts.
• Created scripts to verify and reconcile the migrated data from legacy system to CAIS
• Developed interface store procedure to upload customers driving record from DMV in XML format to CAIS
• Monitored query using query analyzer and tuned queries and procedures to boost database performance.
• Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios.
• Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
• Assisted in designing and creating user Interface.

Tools Technologies:

MS SQL Server 2005/2000, MS Access, DTS Data Transformation Service , BCP, Query Analyzer, SQL Profiler, Erwin3.5, Windows Performance monitor, text files, Windows XP.