SUMMARY

• 8 years of experience in Project Design, Analysis, Development & Management using Microsoft SQL 2000/ 2005/2008/2008 R2 and 2012.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) of MS SQL server 2005/2008/2008 R2/2012.
• Excellent skills in designing Logical and Physical Modeling.
• Experience in defining Query for generating drill down reports in SSRS.
• Experience in Iterative and Incremental software development.
• Experience in installing, upgrading and configuring MS BI pack.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Design, Development and Implementation.
• Good knowledge indatabaseandData warehousingconcepts.
• Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.
• Experience in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, back - up/recovery, running Database Consistency Checks (DBCC).
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS.
• Worked on OLAP Data warehouses, Modeling, Design, Data mining, working with slowly changing dimensions.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Implemented SSIS transformation like Lookup transformation, Derive Column, Conditional Split, Merge Join, OLEDB Command, and Row Count.
• Developed various business reports. Reports are provided in PDF-format, HTML-format, and can be printed directly to the specified printer.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience in defining Query for generating Cross-Tab, Conditional, Drill-down and Sub reports.
• Provided 24x7 production support to Batch, continuous flow process for daily, monthly and weekly job schedule
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and also worked in a technically challenging environment.

TECHNICAL SKILLS

Databases: MS SQL server 7.0/2000/2005/2008 , 2012 Oracle, MS Access.

SQL Server Tools: SQL Server Management Studio, BIDS (SSIS,SSRS), SQL Server Query Analyzer, DBCC, BCP, SQL Server profiler.

Development Skills: SQL, PL/SQL, SSIS/SSRS

Languages: VB Script, T-SQL, HTML, XML, Java Script

Operating System: Windows 95/2000/2003/ XP/VISTA/7, Windows NT

Tools: ERWIN, Visual Basic 6.0, PL/SQL Developer, TOAD, Eclipse, Visual Studio 2010

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

Sr MS SQL/BI Developer

Responsibilities:

• Designed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database which has to be displayed in various forms.
• Configured Checkpoints on SSIS packages so that the package would restart from the point of failure.
• Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.
• Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business.
• Created consolidated tables in SQL Server by joining different tables.
• Created Scripts for Data Flow and Error Handling using Script component in SSIS.
• Used DBCC Utilities for Performance Tuning, Query Optimization and Client Server Connectivity & Database consistency checks.
• Created indexes on SQL Server tables for significant performance boost.
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc in SSIS packages.
• Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and also Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Used the SSIS Configuration files to make the packages connections, variables etc configurable and maintained the same on Test and Production environments.
• Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and Parameterized reports using SSRS.
• Implementing and Deploy of XML Web Services (SOAP).
• Worked on Migrating from SQL Server 2008R2 to SQL Server 2012.

Environment: SQL Server 2008/2008R2/2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), SQL Server Data Tools 2010, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2010, Windows XP/7, MS Office 2007/2010, MS Access.

Confidential, Dallas TX

MS SQL/BI Developer

Responsibilities:

• Worked closely with the business Analyst for understanding the requirement and also involved in planning and designing data based on business requirements.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension,Data Conversion, OLE DB command, Union All, Flat file Source, Flat file Destination, Conditional Split and more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created C#.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Created package dependencies by calling Child packages within Parent.
• Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
• Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and Parameterized reports using SSRS.
• Generated SSRS Report through SSIS Package using script component as per business requirement.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business.
• Documented all the project work in support for maintenance.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (, SSIS, SSRS), MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Windows XP, MS Office 2003/2007, MS Access.

Confidential, Chicago

MS SQL/BI Developer

Responsibilities:

• Develop Stored Procedures, Views, Joins and Sub queries to enforce the business rules.
• Created tabular, matrix, chart, drill down/drill up, drill through, and parametric reports according to business requirements.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning
• PerformanceTuningofSQLqueriesandstoredproceduresusingSQLProfilerandIndexTuningWizard.
• Tested, Cleaned and Standardized Data meeting the business standards usingFuzzy /lookupsusing SSIS tasks.
• Created charts, graphs, sparkle lines in (SSRS) module.
• Adding header and footer information, capturing the report execution time using the system built in fields.
• Used SQL Server Integration (SSIS) to import data from multiple vendors’ heterogeneous data sources (excel sheet, text file, access database, SQL server database into Staging Area
• Created various Parameterized including Dropdown parameters, Linked, Drill-through, Ad-Hoc reports, Drill-down, cascading reports.
• Built theSSRSreports from Different Databases like Oracle, and SQL Server.
• Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server, Report server.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports usingSQLServer Reporting Services 2008.
• Designed and written the queries in the query builder for retrieving the data.
• Created charts, graphs, sparkle lines in (SSRS) module.
• Adding header and footer information, capturing the report execution time using the system built in fields.

Environment: SQL Server 2012/2008R2/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), Microsoft Office Share Point Server, XML and Windows Server 2003.MS Excel, Windows 7, SQL Server Management Studio (SSMS).

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, and development.
• Developed backup restore scripts for SQL Server as needed.
• Written various stored procedures for the purpose of application development.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Database recovery and database maintenance pl
• Data conversion from Text File into SQL Server Table.
• Created constraints and validated database integrity.
• Job scheduling and alerts.
• Created many complex Stored Procedures / Functions and used them in Table Reports.
• Creating reports and hosting it in the web for the users.
• Created reports for the senior management.
• Tested successfully all stored procedures on SQL 2000 server.

Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler