• 8 years of IT experience in Microsoft Database Technologies with various Industry verticals like Banking, Health Care, Child Support and DMV as a Database developer in MS SQL server 2005/2008 databases.
• Experience in Database migration/Conversion from legacy systems to SQL Server 2005/2008.
• Marveled in Query Optimization, Performance tuning using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Experience in extracting and transforming data using Import/Export Data, Bulk Insert, BCP, Data Replication, Data cleansing and DTS Packages.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent and SQL Profiler.
• Designing, testing and implementation of high availability solutions for databases for large, medium and small customers.
• Expert in creating complex Stored Procedures, User Defined Functions, Triggers to facilitate data manipulation and data integrity in T-SQL ORACLE databases.
• Extensively worked on developing and deploying applications using: SQL Server 2005/2008, Microsoft office, MS access VBA and macros.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Expertise in developing drill-through, drilldown reports using SQL Server 2005 Reporting Services SSRS .
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer.
• Hands on experience in creating SSIS packages.
• Worked with OLAP and Data warehouse application and worked with star schema, snowflakes schema dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.
• Extensively worked on system analysis, design, development, testing and implementation of projects SDLC and capable of handling responsibilities independently as well as a proactive team member.
• Experience in using Agile methodologies.
• Created Partition Metadata for OLAP partition and Fact Table.
• Involved in migration of existing data base objects and complex data base structures by generating T-SQL Script file to run against the targeted production database.

Confidential

Sr. SQL server/ETL developer

Responsibilities:

• Involved in building the conversion software to move data from legacy system to newly developed RIMS system using SSIS TSQL stored procedures.
• Involved in generating T-SQL scripts for creating database objects, maintain backup and migration.
• Involved in Data Profiling activity and maintaining DICT database hosting meta data from legacy systems
• Imported data from various Sources like CSV, TAB delimited .XLS using SSIS.
• Developed complex T-SQL code for the application conversions.
• Developed and maintained windows based application to launch SSIS package
• Wrote and integrated Stored Procedures to generate the Reports.
• Formatted the reports using Global variables and expressions. Deployed generated reports onto the Report Server to access it through browser.
• Created Parameterized reports and linked reports.
• Created Cross-Tab, Drill-down reports using SSRS.
• Experienced in designing ad-hoc reports using report builder 2.0 in SQL server 2008 SSRS
• Created Triggers to enforce data and referential integrity using T-SQL scripting.
• Communicated with QA team when necessary
• Experience in creating tables, writing stored procedures , triggers ,cursors , views and performance tunning.
• Expert in extracting and transforming data using ETL Tools SSIS packages and experience in performance tunning
• using BCP for Bulk copy operation and Bulk Insert.
• Hands on experience in creating ETL packages using SQL Server 2008 Integration Services SSIS .
• Created SSIS packages for File Transfer from one location to the other using Script Component.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility and SSIS services.
• Experience in designing custom code in VB.net for Implementing Table/Column Level Error Handling
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Transform and map data from MS Access, MS Excel, and DB2 to SQL Server 2005/2008 by using ETL tools like SQL Integration Services SSIS .
• Worked with SharePoint 2007 for document management, collaboration and automation of business processes using workflow.
• Wrote queries for reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions. Deployed generated reports onto the Report Server to access it through browser.
• Skilled in sorting the data and defining subtotals for the reports.
• Hands on experience on error handling using event handlers, breakpoints, check points.
• Performed data conversion from different data sources using SSIS packages.
• Experience in dealing with large scale financial databases from legacy systems and loading them in to current systems.
• Performed data transfer and database transfer for server relocation, using SSIS package.

Environment:

MS SQL Server 2012, MS SQL Reporting Services 2010, T-SQL, SSIS 2010, Visual SourceSafe, Win 2003 server.

Responsibilities:

• Migrated Conversion data from legacy QS1 systems to SQL SERVER 2008
• Created new tables, wrote stored procedures in T-SQL for application developers and some user defined functions. Created T-SQL scripts for tuning and scheduling.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Continuously interacted with end user to gather business requirements.
• Generated different types of Reports like Tabular, Matrix, and Charts.
• Created stored procedures and user-defined functions for different Reports.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Extensively used TSQL to manipulate and architect to produce results for users.
• Worked in the use of Agile approaches Scrum and maintained daily activities using Task Board.
• Understand the High Level Design Document and create the Mapping Document.
• Defined table and column level Mapping Rules from mapping document.

Environment: MS SQL Server 2008-2005-2000ssssss, SSRS, SSIS, Project server 2007, VSS, Office 2007 bundle, Windows XP, Windows 2003 Server, crystal reports.

Responsibilities:

• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Continuously interacted with end user to gather business requirements.
• Generated different types of Reports like Tabular, Matrix, and Charts.
• Created stored procedures and user-defined functions for different Reports.
• Deployed and configured the reports in the Report Server.
• Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis.
• Created complex correlated sub queries to generate reports.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Generated reports by passing parameters through URL Developed reports using SQL Server Reporting Services.
• Performed data mapping the report columns with the database tables and columns. Documenting the data mapping and relationships between tables.
• Created On demand Pull and Event Based delivery Push of reports according to the requirement.
• Maintained report security by creating Service Accounts and Security Groups and configuring in the Report Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Creation and Maintenance of Indexes for various fast and efficient reporting processes.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.

Environment:

MS SQL Server 2005, MS SQL Reporting Services 2005, T-SQL, SSIS 2005, Visual SourceSafe, Win 2003 server.

ARGO Teller Payments captures and perfects a financial institution's retail and commercial transactions at the teller line, minimizing the need for back-office Intervention. This approach also improves the customer experience because customers leave with printed receipts instead of provisional credit.

Responsibilities:

• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Constructed OLTP and OLAP Databases.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases, data mart databases
• Configured packages event logs.
• Created ETL SSIS packages both design and code to process data to target databases.
• Fine-tuned DML, DDL scripts with lock hints for performance boost.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Extensively used TSQL to manipulate and architect to produce results for users.
• Used multiple join statements to retrieve data from multiple several tables.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Scheduled the Reports to run on daily and weekly basis.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment:

MS SQL Server 2005, SQL Server Business Intelligence Development Studio SSIS, SSRS , MS Access.

Responsibilities:

• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Gathered requirements from users.
• Wrote user requirement documents based on functional specification.
• Designed data models using Erwin.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Developed source to target specifications.
• Developed scripts to load data from JD Edwards Oracle tables and flat files into Enterprise data warehouse.
• Worked on Unix and Shell Scripting
• Developed stores procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures
• Validated the server logs for server errors which are running on UNIX boxes.

Environment:

SQL Server 2000, T-SQL, VB.net, Wincvs.