SUMMARY

• A skilled software professional with 7 years of industry experience in design, development and implementation of business requirements with Microsoft SQL Server 2008 R 2/2008/2005/2000 database system in client/server environment.
• Domain expertise in IT Consulting, Banking, Financial, Airlines, Retail and Construction.
• Expert level skills in Data Mapping, Table Normalization, Optimization and Performance Tuning.
• Expert in writing T - SQL queries with DDL and DML commands, complex stored procedures, indexes, triggers and views.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Worked extensively on system analysis, design, development and implementation of projects in Software Development Life Cycle (SDLC).
• Experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS), DTS Import/Export Utility and DTS packages.
• Followed the Microsoft recommended best strategies in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services (SSIS).
• Migrated organization orders, adjustments, objectives and data in various formats like text based files; excel spreadsheets, to SQL Server databases using SSIS to overcome the transformation constraints.
• Experience in handling Performance Tuning of SSIS using Horizontal Partitioning and Vertical Partitioning.
• Experienced in monitoring and scheduling ETL processes using DTS EXEC utilities and batch files.
• Migrated and recreated existing dimensions and cubes using star schema on SQL Server 2008/2005 to achieve the efficiency of SQL Server Analysis Server (SSAS).
• Worked extensively on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Expert skills in handling different Data warehousing methodologies such as Bill Inmon (Top Down design) and Ralph Kimball (Bottom-up design).
• Experience in Online Analysis Processing (OLAP), created cubes, dimensions for schemas.
• Developed Scorecards with advance set of dashboards using different Business Intelligence tools such as ProClarity and Performance Point Server.
• Experience in developing reports using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Drill Through, Matrix, Parameterized and Cascaded Parameterized

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 7/Vista/XP/2000/95/98/NT

RDBMS: MS SQL Server 2008 R /2000, MS ACCESS 2000/03/07

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

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

Reporting & Analyzing Tools: SQL Server Reporting Services (SSRS), Crystal Reports, SQL Server Analysis Services (SSAS)

Languages: PLSQL,TSQL,VB Script, MDX

Web Technologies: HTML,XML

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

BI Developer / SQL Developer

Responsibilities:

• Co-ordinated with the functional team to gather the requirements from business users for designing various types of reports as per the business needs.
• Advanced extensible reporting skills using SQL Server 2008/2005 Reporting Services.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports using SSRS 2008 R 2/2008/2005.
• Involved in scheduling, creating snapshots, creating report subscriptions and data driven subscriptions using SSRS 2008 R2 / 2008.
• Deployed the reports to the report server to access it through the report manager and made sure the reports were available from the front end of the myTE application.
• Expertly handled the performance tuning of critical reports and also managed security model of the reports.
• Created and executed SSIS packages to populate data from myTE data source and load it onto the country specific server.
• Created complex SSIS packages for different data loading operations for myTE application.
• Experienced in writing complex SQL queries, stored procedures, triggers, views, constraints, joins, DDL, DML and user defined functions to implement the business logic.
• Advised the optimization of the queries by looking at the execution plan for better tuning of the database.
• Involved in optimizing code and improving efficiency in databases including re creating clustered and non clustered indexes, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Developed complex T-SQL Queries and Dynamic SQL Queries for reports on Enterprise Data Warehouse (OLAP) and Operational databases (OLTP) and developed reports using Global Variables, Expressions and Functions.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Management Studio, Business Intelligence Development Studio, Microsoft Visual Studio 2005/2008 (SSRS/SSIS), TSQL).

Confidential, Atlanta, GA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
• Created Views to facilitate easy user interface on database tables, and created Triggers to facilitate consistent data entry into the database tables.
• Involved in maintaining Data consistency and Data Integrity with various constraints like Unique, Check, Primary Key and Default.
• Done Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages and VBScript.
• Worked with various Dataflow tasks like Merge Join, Merge Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Implemented Transactions is SSIS packages using Sequence containers and Execute SQL tasks.
• Improved the performance of SSIS packages by implementing parallel execution, removing unnecessary sorting and using optimized queries.
• Designed and created Report templates with Constant Header information like Company logo, Department Name etc. for Weekly, Monthly reports.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.
• Designed Charts with lines, Bar Graphs and Columns to generate reports with cumulative totals.
• Involved in Trouble shooting and Performance improvement of SSRS Reports.
• Deployed various reports onto Report Server and Report Manager in SSRS 2008 R2.
• Worked with Team Foundation Server to maintain a repository of the T-SQL, SSIS developments.

Environment: MS SQL Server 2008 R2, Windows Server 2003, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), MS-Visual Studio.

Confidential, Atlanta, GA

MS SQL/ BI Developer

Responsibilities:

• Identified, tested, and resolved Database performance issues (monitoring and tuning) to ensure Query optimization.
• Analyzed the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to develop a solution.
• Created complex User Defined Functions to be implemented in many Stored Procedures where the same business logic is required multiple times.
• Worked with design, development, implementation and support of ETL processusing SSIS Packages in SQL Server 2008.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Worked with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
• Worked with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Extensively used Script Task to establish connection with FTP server and locate the files within the server.
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Understanding the OLAP processing for changing and maintaining the Data Warehouse, Optimizing Dimensions and adding new Aggregations to the Cube.
• Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Worked with Report Manager to configure Web URLs, E-mail and also Databases for reports.
• Deployed SSIS packages, SSAS Cubes onto Production Server and SSRS Reports onto Report Manager.

Environment: SQL Server 2005/2008 Enterprise, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), MS-Visual Studio, OLTP, OLAP, XML.

Confidential, Richmond, VA

MS SQL Developer

Responsibilities:

• Involved in performance tuning of TSQL queries and Stored Procedures and also optimized query performance by creating indexes.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Use the SQL Server Management Studio and SQL Profiler for studying the SQL statements and procedures and to monitor their performance.
• Define and execute all SQL Server administrative tasks on each registered server.
• Worked on different Data warehousing methodologies such as Bill Inmon and Ralph Kimball.
• Worked with different storage modes in Analysis Services such as MOLAP, ROLAP and HOLAP.
• Created reports by retrieving the data from cube using MDX reports.
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
• Designed MDX queries to retrieve data from SSAS cubes.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Designed Star Schema and Snow flaked schemas in the process of data modeling using Erwin.
• Designed reports, Graphs and deployed reports to web applications using SSRS.
• Created Parameterized reports and Linked reports using book mark links and hyperlinks.
• Developed Ad Hoc reports and deployed it onto Reporting Server using Report Builder.

Environment: SQL Server 2008/2005, T-SQL, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, Analysis Services 2008/2005, SSRS, ProClarity.

Confidential, Rose Land, NJ

MS SQL Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Executed batch files using SQL Agent and developed Stored Procedures for schedules, reports and other client interfaces.
• Used Data Transformation Services (DTS) to populate data from various data sources using the concept of OLEDB.
• Responsible for Data Migration from one environment to the other using DTS packages.
• Worked DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Identified the Data Source and defining them to build the Data Source Views.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Worked on querying the data and creating-on demand reports using Report Builder in SSRS and send the reports via email.
• Developed query for generating drill down reports using Reporting Services.
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.

Environment: SQL Server 2005, T-SQL, Windows 2003/XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SSRS, DTS, Crystal Reports, XML.

Confidential

Jr. Database Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Defined relationship between tables and enforcing entity referential integrity.
• Involved in Implementation of database design and administration of SQL based database.
• Established connectivity to database and monitored systems performances.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server, Windows 2000, Enterprise Manager, DTS, T-SQL.