SUMMARY

• A Microsoft certified Professional wif 7+ years of experience in Data modeling, database design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL Server 2014/2012/2008/2005.
• Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading
• Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles
• Using Normalization and Denormalization techniques
• Experience in creating conceptual, logical, and physical database designs
• Generating complex Transact SQL (T-SQL) queries, Subqueries, Correlated subqueries, Dynamic SQL queries etc. Programming in SQL Server - Using teh stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
• Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations
• Proficient in Performance Tuning/Query optimization using indexes
• Assisted wif automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• 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, Bulk Insert
• Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Worked wif Business Analysts, Web development team, and users on database solutions.
• Experienced wif aggregation using OLAP analysis services cube.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Extensive noledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Organized professional wif excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adapt quickly new technology wif ability to take new roles in minimum time and little training.
• Used MySQL Workbench tool in Extraction and Implemented Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.

TECHNICAL SKILLS

Internet Tools: Windows NT 4.0, Windows 2000 Enterprise/Advanced Server, Windows 2003 Enterprise/Datacenter Server, XP Professional and Windows 2000, UNIX.

Databases: MS SQL Server 2014/2012/2008 R2/2005, MS Access, Mysql

Programming Languages: My-SQL, T-SQL, C, C++, Shell Scripting, SQL, XML, C#, VB.NET, MDX

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook, Google Docs

Database Tools: SQL Server Enterprise Manager, MySQL Workbench, SQL Query Analyzer, SQL Profiler, Razorsql, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer, SQL Client Utility.

Reporting Tools: Reporting Service (SSRS), TFS, Tortoise Git, Github, JIRA DTS, SSIS.

ETL Tools: Erwin v 4.0, Visio 5.0

Data Modeling: Management Studio, Visual Studio.

MS Tools: Internet Information Server (IIS 5.0 / 6.0), FTP,TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

SQL server Developer wif SSIS

Responsibilities:

• Performed Data Mapping and screen to screen mapping by using teh data dictionary of teh OLTP server and OLAP Server access.
• Worked wif business gathering requirements.
• Used MySQL Workbench tool in Extraction and Implemented Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled teh SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Worked wif different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources and Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on development, stage and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Nonclustered Indexes on tables for performance optimization of complex stored procedures.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Experience in creating conceptual, logical, and physical database designs.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Handling of Errors and Runtime Errors using VBA.
• Used SQL Analyzer and Profiler for monitoring teh SQL statements and procedures.
• Created Joins and Subqueries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled teh SSIS packages to run at different intervals to load teh data into SQL Server.
• Deployed teh created SSIS packages in Development and Testing environments.
• Created Linked Servers to retrieve data from other databases.
• Optimized teh T-SQL query performance wif modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.

Environment: MS SQL Server 2014, Visual Studio 2013, MySQL Workbench, Integration Services (SSIS 2012/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, ETL, Performancepoint Server 2007, MS Excel.

Confidential, Irving, TX

SQL Server /SSIS Developer

Responsibilities:

• Performed Data Mapping and screen to screen mapping by using teh data dictionary of teh OLTP server and OLAP Server access.
• Involved in business meetings wif teh stakeholders and wif teh business analysts for teh project requirements using agile methodology.
• Creating Schema Database diagrams, Tables structures and maintain teh relationships wif constraints and indexes as per business logic.
• Created Stored procedures, User Defined Functions (UDF), views, Joins and system defined functions, Temp Tables, Table Variables etc.
• Increase teh query performance, Handling teh errors in script level and used Transactions.
• Preparing teh release/rollback scripts as per production deployment process.
• Using transformations like Derived Column, Conditional Split, Aggregate, Rowcount, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Experience in creation of validation and Ingestion packages as per teh business logic
• Extensively working in Data Extraction Transformation and loading into staging tables, validate teh records on staging tables through validation process tan valid records are insert into production tables through ingestion process.
• Developed System logging and Custom logging on task and package level.
• Implemented Package Template and Package configurations.
• Experience on rendering teh Reports in teh form PDF, Excel and .CSV formats
• Performed Unit Testing and integration testing on teh completion of Development for requirement.
• Involved wif teh client interaction for functional and Technical clarifications and solutions.
• Involved in resolving teh Production issues and deployment Process wif DBA's while deploying to different environments.
• Preparing Technical design documents (TDD), Code Review, Promotional and Deployment Process Documents.

Environment: Microsoft SQL Server 2008, MS SQL Server 2012, MS SQL Server Integration Services 2012, DTS, SQL Profiler, MS Office, Windows Server 2007.

Confidential, Salt Lake City, UT

SQL Server Developer

Responsibilities:

• Created Store Procedures to transform teh data and worked extensively in T-SQL for various needs of transformations while loading teh data.
• Written complex SQL queries using joins, subqueries and correlated sub queries to retrieve data and Triggers to carry out various tasks from teh database.
• Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.
• Used SQL Server Profiler to trace teh slow running queries and teh server activity.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Used various SSIS tasks such as Conditional Split, Derived Column, Data Conversion, Fuzzy lookup, merge, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
• Imported and Exported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
• Automated teh SSIS jobs and email alerts using SQL server agent job for daily, weekly and monthly loads.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
• Used reporting objects like Tabular, Matrix, Sub report, Charts, Parameterized and Cascading parameterized reports using SSRS-2008.
• Deployed and Published teh Created Reports to Microsoft Sharepoint Server and also uploaded them to Microsoft Performancepoint Server.
• Fixed Back end issues related to teh Desktop GUI Screens to halp Users.
• Running Data Scans on Production/ QA Environments as per teh requests from SYSOPS.
• Aware of working wif different ticketing workflow systems like JIRA and SRS.
• Documented teh development work.

Confidential, OH

SQL Server Developer/ SSIS/SSRS

Responsibilities:

• Understanding teh report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at teh database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating teh integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed teh created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, Foreach Loop, Conditional Split, Union all, Script component.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control teh flow of SSIS package
• Excellent report creation skills using Microsoft Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Created scorecards wif executive summary dashboards using MS Office Performancepoint server 2007 Dashboard designer that display performance monitoring measures.
• Designed and developed Data-mart using SSAS.
• Build Cubes on Enterprise Data Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Performed DBCC checks and fixing data corruption in Application databases.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual sourcesafe.

Confidential, Jackson, MS

SQL Server Developer

Responsibilities:

• I was involved in database design and defining ETL processes.
• Created Multi-Dimensional Cubes using SSAS.
• Used SSIS to extract and load data from different sources.
• Used various transformation components in teh data flow task to implement business logic to merge data from different sources.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Deployed SSIS packages and Reports to Production Servers.
• Conversion of DTS packages in SQL Server 2000 to SSIS packages SQL Server 2005.
• Developed several reports using reporting services.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Creating functions and developing procedures for implementing enhancements.
• Creating and Modifying T-SQL stored procedures/triggers for validating teh integrity of teh data.
• Created ETL package for data conversion using various transformations tasks.
• Created various scheduled jobs to handle teh data migration from SQL 2000 to 2005 periodically.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Responsible for Query optimization and Performance tuning.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Experience in Data Analysis, Normalization, Data warehousing, Data Cleansing, Data Modeling, Data Mapping, Erwin 3.0 in OLTP & OLAP environments.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, and usage based optimization, besides providing security by providing perspectives.

Confidential

SQL server Developer/SSIS/SSRS/DBA

Responsibilities:

• Written complex stored procedures, User Defined Functions, Triggers using T-SQL.
• Created DTS packages for data transfer between teh two environments.
• Security issues related to logins, database users, and application roles and linked servers.
• Performance tuning of SQL queries and stored procedures using SQL profiler and Index tuning advisor.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.
• Resolved any deadlocks issues wif Databases/Servers on a real-time basis.
• Generated reports in SQL Server Reporting Services (SSRS) using table control, matrix control for cross tab reports.
• Developed Tabular, Drilldown, Parameterized, Charts, Sub-Reports using SSRS.
• Defined Report Layouts for teh report design as per teh need.
• Installed SSRS, Configured teh Report Server and Deployed Reports.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual sourcesafe.