SUMMARY:

• Around 8 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 R2/2005 in Production, QA and Development Environments.
• Experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
• Experience in Managing Security of SQL Server 2005/2000 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Strong experience with T - SQL(DDL & DML ) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005 Reporting Services (SSRS), SQL Server 2005 Integration Services (SSIS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Lookup, Conditional Splits and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• 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.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Able to work independently under minimum supervision.

TECHNICAL SKILLS:

Operating System: Windows 2008 Enterprise/Datacenter Server, XP Professional and Windows 2000, Windows NT 4.0, Windows 2000 Enterprise/Advanced Server, UNIX

Databases: MS SQL Server 2012/2008 R2/2005/2000, MS Access, My SQL

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

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook.

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

Reporting Tools: Reporting Service (SSRS) 2005/2008 R2.

ETL Tools: DTS, SQL Server Integration Services.

Data Modeling: Erwin v 4.0, Visio 5.0

Other Utilities: Management Studio, Visual Studio, Internet Information Server (IIS 5.0 / 6.0), FTP,TCP/IP

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

SQL Server/ BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Interacting with users to understand their reporting and ETL requirements and convert them into functional Specifications.
• Prepared technical specification design document according to the business requirements.
• Created ETL mappings and reporting mappings to develop the SSIS packages.
• Involved in the System study and Database design using MS SQL Server 2008/2012.
• In depth knowledge in SSIS to develop different SSIS packages to load data from various sources into database system and also in SSRS for report generation to create various types of reports.
• Used ETL Transformations to meet the business requirements while created SSIS Packages.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints, joins, and views etc. on various database objects to obtain the required results.
• Created SSIS process design architecting the flow of data from various sources to target.
• Participating in defining ETL strategies, preparing transformation rules and mapping data from source to target.
• Developed ETL Packages in MS SQL Server 2008 for integrating data from heterogeneous sources such as Excel, CSV, Oracle, flat file and Text Format Data.
• Created mappings to load data from source to stage and then target tables using Informatica as ETL tool.
• Loaded all source data into target tables using different ETL tools such as SSIS,Informatica Power Center 9.1.
• Used various Informatica ETL transformations such as Source Qualifier,Expression,Filter,aggregator, Joiner,Lookup,Normalizer,Trasaction control,Rank and Router, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into Production tables.
• Used SSRS to CreateTabular, Matrix, and Drill down, Drill throughreports, Charts and graphs as per customer requirements.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Built reports using SSRS and helped develop efficient reporting solutions and setting up subscriptions as needed for SSRS.
• Created and built letters using VMware Horizon software for VITAL project.
• Used various SSIS transformations such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into Production tables.
• Converted ETL from DTS to SSIS.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Installing and Configuring SQL Server 2008/2005, Analysis services (SSAS), Integration Services (SSIS) and Reporting services (SSRS) for QA and DEV environments.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Environment: SQL Server 2008/2008R2/2012, SSIS 2005, SSIS 2008R2, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), MS SQL Analysis Services (SSAS),Informatica Power Center9.1.

Confidential, Jacksonville, FL

SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Creating, Loading and modifying a new Package or an existing package or add and configure components, making changes object by using Control FLOW Tools and Data Flow Tools and then verify it.
• Automated existing stored procedures to load data into staging and production environments in a timely manner.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and also using SSIS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used ETL Transformations to meet the business requirements while created SSIS Packages.
• Created Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Created of Clustered and Non-Clustered Indexes for Query Performance and fine-tuned existing stored procedures by re-writing sub queries as inner and left joins.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Implemented SSIS and T-SQL executions as jobs under SQL Agent.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: SQL Server 2008/2008R2/2012,SSIS 2005, SSIS 2008R2, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), MS SQL Analysis Services(SSAS), Windows 2000/XP.

Confidential, Houston, TX

SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed DTS packages to copy tables, schemas and views and to extract data using SSIS.
• Created several database constructs such as views, triggers and extensively worked on performance tuning.
• Developed SSIS packages to transform data from SQL 2000/2005 to MS SQL 2008 as well as created stored procedures used in SSIS to load/transform data to the database.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used ETL Transformations to meet the business requirements while created SSIS Packages.
• Creating Tabular, Matrix, Drill through reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Successfully migratedDTS packages/SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
• Successfully migrated all databases, jobs, roles, security from SQL Server 2000 into SQL Server 2008.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Implemented SSIS and T-SQL executions as jobs under SQL Agent.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.

Environment: Windows 2003 Server, MS SQL Server 2000/2005/2008 R2/2012, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS.

Confidential, Kansas, MO

SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Performance tuning of Queries and Stored Procedures.
• Developed DTS packages to copy tables, schemas and views and to extract data using SSIS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Creating Tabular, Matrix, Drill through reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Implemented query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2/2012 Reports Services (SSRS).
• Designed ETL structures for data imports from various sources such as Oracle, TeraData, Excel, Access and DB2.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and also using SSIS.
• Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created several database constructs such as views, triggers and extensively worked on performance tuning.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Created Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Used ETL Transformations to meet the business requirements while created SSIS Packages.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Environment: Windows 2003 Server, MS SQL Server 2005/2008 R2/2012, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker.

Confidential, Boise, ID

SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• I Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Developed DTS packages to copy tables, schemas and views and to extract data from using SSIS.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Created ETL SSIS packages both design and code to process data to target databases.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• 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: Windows 2003 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SQL Server Management Studio.

Confidential, Irving, TX

SQL BI Developer

Responsibilities:

• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Converted ETL from DTS to SSIS.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Worked with development teams in the design of physical databases and in modification.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
• Created SSIS process design architecting the flow of data from various sources to target.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Actively engaged in client meetings in requirement gathering and development updates.
• Developed SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, Microsoft Excel and Access.

Confidential, Dallas, TX

MS SQL Server Developer (SSRS/SSIS)

Responsibilities:

• Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
• Streamlined database design process using creation of table structures in 3NF using DDL statements using T-SQL.
• Facilitated constraints such as Primary, foreign, default, unique and Not Null.
• Implemented Set-based DML statements such as set-based update and delete statements.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and fine-tuned existing stored procedures by re-writing sub queries as inner and left joins.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Offered production support at regular periods for migration and data issues.
• Developed re-usable stored procedures for database application support.
• Created several database constructs such as views, triggers and extensively worked on performance tuning.
• Wrote complex nested Case structures to implement complex business logic.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard.
• Wrote complex stored procedures for streamlining incremental data loads using left join.
• Implemented Data Warehouse ETL design structure utilizing Star Schema. Designed and developed Fact and Dimension structures for various types of data related health information of the patients.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Successfully migrated SSIS packages from development to test to Production environments using SSIS Config files and deployment wizard.
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Implemented SSIS and T-SQL executions as jobs under SQL Agent.
• Actively utilized Microsoft Team Foundation Server and its features for code sharing and updates from other team members.
• Analyzed existing stored procedures using DB Tuning advisor for performance improvements.
• Extensively utilized expression and constraint feature for conditional processing of flat files and flow control in SSIS.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, SQL Profiler, Microsoft Excel and Access.

Confidential, Columbus, OH

SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in development and implementation of SSIS,SSAS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint/Moss2007 integration.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components,error handling.
• Generated Custom ETL scripts using SSIS 2005 and develops and unit test SSIS load processes for performance check.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS 2005 to 2008.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: SQL Server 2005/2008,SQL BI Suite (SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003.