SUMMARY

• Over 8+ years of experience in IT industry as SQL Developer, Database Administration in MS SQL Server in Production, Quality & Development environments.Solid experience in RDBMS database design, installation, configuration, performance tuning, optimization, backup and recovery in SQL Server.
• Good experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/TransacT - SQL coding.
• Expert in Extraction, Transforming and Loading (ETL) data using SSIS/DTS; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Expert in creating T-SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2005/2000.
• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity.
• Experience in creating Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Expertise skill in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard.
• Experience in writing complex SQL queries involving multiple tables joins.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views..
• Extensive experience in using various tasks, containers, sources, transformations and destination in SSIS tool while transferring the data from various sources systems into the destination.
• Transformed data from various data sources to SQL Server using BCP, DTS and SSIS.
• Proficient in creating different Package Configurations such as SQL Server, XML configuration and Parent package variable.
• Implemented different Logging in SSIS packages to log events during the run time.
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: T-SQL, HTML, XML, C/C++

Operating Systems: Windows 98/2000/2003/2008/ XP/VISTA/7/8

Databases: MS-SQL Server 2014/2012/2008 R 2/2008/2005/2000

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS).

Reporting Tools: SSRS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008/2010, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Red gate, Lite Speed

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. SQL Server BI Developer

Responsibilities:

• Migrated SSIS packages from SQL Server 2008 R2 to SQL Server 2012 as SSIS packages.
• Planned, defined and designed data based on business requirement and provided documentation for all kinds of reports, DTS and SSIS packages for further reference.
• Developed SSIS Packages using Look Up Values & implementing rules provided by business in the mapping document.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Created SSIS packages to integrate data coming from text files and excel files.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB command, conditional split, lookup, aggregator, multicast and derived column.
• Extensively used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed and Build Cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs using SQL Server Analysis Services (SSAS).
• Responsible for converting Client's online reporting tool to SSRS and Business Objects based on the requirement.
• Used task factory components and transformation like Upsert destination, Update batch transformation, Null Handler Transformation, Surrogate Key Transformation, Advanced Email and SMS Task in SSIS packages.
• Wrote stored procedures and User Defined scalar Functions to be used in the SSIS packages and SQL scripts.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Deployed SSIS package into production and used package configuration to export various package properties to make package environment independent.
• Implemented event handlers and error handling in SSIS packages and notified process results to various user communities.

Environment: SQL Server 2012, Visual Studio 2010, .NET Framework 4.0, VB.NET, MS SQL Server 2008R2, T-SQL,SSRS, SSIS, SSAS, Java Script, IIS, XML, HTML, COTS, MS Excel.

Confidential, Washington, D.C

Sr. SQL Server BI Developer / DBA

Responsibilities:

• Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Developed optimal stored procedures and queries to create data sets for reports.
• Developed SSIS Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations.
• Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
• Worked with SSIS Variables, Scripting, evenT-handlers, package configurations and deployment.
• Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Generated various reports like parameterized, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS) for various projects.
• Created Key Performance Indicators (KPI) and Metrics for Business needs in SSAS.
• Created Use case and Class diagrams in MS Visio using UML notations.
• Migrated several server side controls from (Visual Basic 6.0) VB 6.0 to VB.NET. Also used VB.NET to write server-side code for the user interfaces.
• Involved in Discussion Board for Client Interaction for the change requests and follow-ups
• Using ERWin data modeler R7.2 to reverse engineer SQL Server databases we successfully reverse engineering the 2008 R2 databases.
• Developed, deployed and monitored SSIS Packages.
• Responsible for ETL operation using SQL Server Integration Services and Worked with users in training and support and also have experience in incremental data loading.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using SQL Server Reporting Services 2008.
• Involved in extracting the data using SSIS from OLTP to OLAP.

Environment: MS SQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows server 20 bit, OLTP, Business Intelligence Development Studio - SSIS, SSRS, Performance Monitor

Confidential, NYC, NY

Sr. SQL Server BI Developer

Responsibilities:

• Conducted data migration processes from a legacy environment to an SAP environment utilizing the SSIS Development platform.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Worked on other packages of the SQL server 2005 Edition SSRS, SSAS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Gained working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions in SSAS.
• Worked on deploying and scheduling Reports using SSRS as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Creation and maintenance of Cubes using SSAS as the primary design tool.
• Scheduling and executing SSIS Packages, using SQL Server Agent.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Created different chart reports helped in analyzing perfuming counters using SSRS 2005.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008, Visual Studio 2008,Share Point, Performance Monitor, Query Optimizer, Oracle 10g, MS Access, Java Script/J Query.

Confidential, Roanoke, Virginia

SQL Server Developer

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2000), SQL Server Enterprise Manager (2008R2) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2008R2 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Configured Transactional replication on migrated server.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2008R2.
• Installed, authored, and managed reports using SQL Server 2008R2 Reporting Services.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Database mirroring, database snapshot, DDL triggers, online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.
• Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
• Creating and implementing 2008R2 concepts like DMV’s, DMF’s, Data partitioning, online indexing.
• Using the reverse engineering techniques to migrate the databases and upgraded them from SQL Server 2008 R2 to 2012
• Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
• Involved in DATA Analysis like Analyzing and Accessing collection of Data. .
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows bit, SQL/PL SQL, SSIS, Profiler.

Confidential, Atlanta, GA

SQL server Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Gained working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Created KPI Objects in line with Requirement Docs in SSAS.
• Optimized and Aggregated cubes with 40% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio)
• Used SSIS packages to move data from dev to QA and QA to Production
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment: TSQL, MS SQL SERVER 2008,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS

Confidential, Dallas, TX

SQL Server Developer

Responsibilities:

• Developed applications based on departmental requirements and specifications.
• Used agile methodology for the development.
• Developed complex T-SQL code for the application.
• Created SSIS packages to load data into data warehouse using various SSIS tasks like ExecuteSQL Task, Data Flow Task, send Mail Task.
• Created SSIS Packages to export and import data from CSV files, TXT files and Excel spreadsheets.
• Created Drill down and Drill through reports using SSRS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Involved in resolving operational problems and systems failures by directing and/or performing systems audits, analyzing problems and concise methods for resolution.
• Provide manual testing of Cerner Millennium application that included charting, reporting and printing of patient’s healthcare reports
• Prepared and executed test scenarios to test the functionality of the application
• Involved in Feature testing and Regression testing, bug tracking and defect management.

Environment: SQL Server 2005 with clustering, T-SQL, Windows 2003 Server, Oracle, VB.Net and ASP.Net.

Confidential 

SQL Server Developer

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Configured SQL Server 2000 Environment.
• Established coding guidelines and standards for object oriented and componenT-based development with maintainability, reusability, and performance in mind.
• Wrote queries, stored procedure, functions and views.
• Developed several SSRS reports by using drill down and drill through functionality.
• Designing Client/Server, Web applications using VB.Net, HTML, CSS and JavaScript.
• Creation of tables, constraints, proper indexes on tables for better performance.
• Wrote Test Plans for testing the proper website functionality.
• Also, Responsible for working with the client on establishing deliverables, timeline, managing project scope and project resources
• Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.
• Design and Creation of logical storage (Table spaces, Segments etc.).
• Designed E-R Diagrams, logical and physical data modeling.
• Interacting with business users in getting the reporting requirements..
• Developed and integrated code for enhancement of the application.
• Developed custom reports using Microsoft reporting Services.

Environment: SQL Server 2005, SSRS, VB.NET, Visual Studio 2005, HTML, DHTML, CSS, Java Script.