SUMMARY

• Over 7+ years of IT industry experience in using Microsoft SQL Server 2000/2005/2008/2008 R2 for data design, Data migration, Business Intelligence, Database Development, and Administration.
• Domain expertise in Banking, Financial, Airlines, Insurance, Scouting, Gas Trading, and Healthcare Solutions.
• Strong analytical and problem - solving skills along with inter-personnel communication skills as well as ability to acquaint to fast changing environments.
• 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).
• Experienced in developing, deploying and monitoring ETL tasks using SQL Server Integration Services (SSIS) packages, DTS Import/Export Utility and DTS packages.
• Followed the Microsoft recommended best strategies in the design, development, and implementation and testing of the ETL using 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.
• Experienced in Performance Tuning of SSIS packages 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 various types of reports like Drill Down, Drill Through, Matrix, Parameterized using SQL Server Reporting Services (SSRS).

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server 2000/2005/2008/2008 R2, MS Access

LANGUAGES/SCRIPTS: C, C++, T-SQL, PL-SQL, VB Script

MICROSOFT TECHNOLOGIES: MS Office, Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, Visual Studio

OPERATING SYSTEMS: Win 98/NT/2000/XP/Vista/7, MS-DOS, UNIX, Windows Server 2003 Enterprise, MAC OSX

TOOLS: AND UTILITIES: Crystal Reports, DTS, SSRS, SSIS, SSAS,, Visual Source Safe, Team Foundation Server(TFS),Agile development environment, Performance point Server, Erwin, SQL Profiler, Database Engine Tuning Advisor, Index Tuning Wizard, SQL Agent, Maintenance Plans, Security, Replication, OPEN LINK.

PROFESSIONAL EXPERIENCE

Confidential, Kannapolis, NC

MS SQL Server/ BI Developer

Responsibilities:

• Migration of Data from current system to dimension and fact tables into Kimball modeled data warehouse using Extract, Transform and Load (ETL).
• Developed multiple Stored Procedure to support business logic for extracting data from source as well as Data Validation.
• Worked on various Transformations like OLEDB Command, Conditional Split, Derived Columns, Merge Joins during Data Migration.
• Worked on Data validation process in order to match source to target data.
• Worked on Entity-relationship (ER) Model and created Source To Target mapping document to support.
• Developed SSIS package in Team Foundation Server(TFS) environment.
• Worked with different Configurations in order to change the package properties dynamically.
• Worked intensively on Data Validation while migrating data to Data Warehouse.
• Fine tuned DML, DDL scripts with lock hints for performance boost.
• Worked with SQL Server Agent to create the job and monitor closely for job run.
• Troubleshoot the ETL packages as well as issues occurred during daily job load.
• Supported SSRS Report writer with the data issues and clarifying the business logic on extracting the data for the report.
• Created SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: SQL Server 2008 R2 Enterprise, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSRS,SSAS), MS-Visual Studio 2010, Team Foundation Server (TFS),OLTP, XML.

Confidential, Irving, TX

MS SQL Server/ BI Developer

Responsibilities:

• Developed Archive Process to relieve the transactional system of data storage based on the business logic that helped to reduce about 65% of the transactional data storage. By implementing this process, the performance was a great achievement.
• Developed a Bi-directional Synchronization Process From Oracle environment to SQL Server Environment using SQL Server Integration Services(SSIS).
• Developed a procedure that helped the Application where the customer reside whether in Transactional data Storage (OLTP) or had stored in the Historical Data Storage based on the business logic customers are needed to pullback in the Transactional data storage for the business.
• Involved in software development life cycle including database design, development, testing, optimizing, deploying on development.
• Helped in detailed design and requirements documents with logic to help team members understand the requirements and design.
• Performed design/code reviews to make sure that the design/code adheres to customers’ standards and meets industry’s best practices.
• Created and developed database objects such as tables, indexes, Stored procedures, and T-SQL code with proper grants to all the users and roles using SSMS 2008.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
• Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.
• Worked with various Dataflow tasks like Merge Join, Merge, Aggregate, OLEDB Command and Conditional Split while designing SSIS Packages.
• Involved in maintaining Data consistency and Data Integrity with various constraints like Unique, Check, Primary Key and Default.
• Worked with design, development, implementation and support of ETL processusing SSIS Packages in SQL Server 2008.
• Worked with different Control flow tasks in creating SSIS packages such as Data Flow Task, For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Worked Extensively with SSIS to Import, Export and Transform the data between the linked servers.
• Identified and resolved problems encountered during development and releasing the SSIS code.
• Created different reports based on business needs using SQL Server Reporting Services (SSRS).
• Worked with development teams in the design of physical databases and in modification.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Drill through 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.

Environment: SQL Server 2008 R2 Enterprise, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server (TFS),MS-Visual Studio, OLTP, XML.

Confidential, Marshalltown, IA

MS SQL BI Developer

Responsibilities:

• Developed technical specifications and analyzed business needs with managers and development Teams.
• Written Common Table Expressions (CTE) and used analytical functions while writing stored procedures.
• Developed Triggers and Stored Procedures to in corporate the business logic and process.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Involved in tuning of Stored Procedures and query optimization for the improvement of deadlock situations and hang-ups on server.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Used Data Manipulations to optimize the performance, which includes modification of T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing table, establishing Joins and creating clustered/non-clustered indexes where necessary.
• Worked on formatting the SSRS report using Global variables and expressions.
• Developed query for generating drill down reports using Reporting Services.

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

Confidential, Atlanta, GA

MS SQL Server/ BI Developer

Responsibilities:

• Performance tuning and monitoring of Stored Procedure and T-SQL Queries.
• Created indexes on selected columns to speed up queries and analyses in SQL Server Management Studio.
• 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.
• Used SSIS to create ETL packages to validate, extract, transform and load data warehouse databases, data mart databases.
• Used Execution Plan, SQL Server Profiler to improve existing queries and optimized SQL queries for better performance and availability.
• Involved in Incremental Data Load from different sources into Main SQL database Engine with ETL Operations.
• Used different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Build different packages in SSIS using combination of multiple Dataflow Transformations.
• Created Master SSIS packages to execute set of packages that load data from various sources onto the Data Warehouse on timely manner.
• 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.
• Worked with Report Manager to configure Web URLs, E-mail and also Databases for reports.
• Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine.
• 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, Township, IL

SQL/ BI Developer

Responsibilities:

• Involved in gathering business requirements, definitions and design of the data sourcing and data flows, data quality analysis, working in conjunction with data warehouse architect on the development of logical data models.
• Interacted with Development management Teams to analyze business necessity and creating new technical specifications.
• Created SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Tasks, Data Flow Tasks, Execute Package Tasks to generate underlying data for reports from excel, text file, MS Access and CSV files to Data Warehouse.
• Migrated and Converted Crystal Reports into SQL Server Reporting Services (SSRS) by using MS SQL Server Reporting Services.
• Wrote complex T-SQL queries, stored procedures, triggers, cursors and user-defined functions (UDF's).
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas driven, summarized and conditional formatting) using SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Involved in development and modification of existing Financial Reports and Marketing reports which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
• Created Jobs Performance report that queries sys tables and shows how long each job ran and weekly-average duration using SSRS.
• Used ETL from heterogeneous sources system. Assisted DBA in using the repository manager to give permission to users to create new users and repositories.
• Maintained and provided support to users for the deployed reports.
• Used of Ad-Hoc Report with Report Builder and Programming Reporting Services.
• Created Development and Production support documents.
• Developed Query for generating drill down reports in SSRS 2005.

Environment: MS SQL Server 2005/2000,SQL Server Management Studio (SSMS) 2005,SSIS-2005, DTS-2000, SSAS, VB 6, OLAP, OLTP, Load Runner, SSRS-2005, SQL Server Profiler, Visual studio 2005, SQL Analyzer, Enterprise Manager and SQL Server Agent.

Confidential, Rose Land, NJ

MS SQL Server Developer

Responsibilities:

• Responsible for gathering and 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

Junior MS SQL Server Developer

Responsibilities:

• Developed scripts for restoring backup for SQL Server as needed.
• Upgraded to latest version of SQL 2005 from SQL server 2000.
• Performed replication of data using Transactional method.
• Responsible for planning, executing, and maintaining data integration projects and database upgrades.
• Involved in Performance tuning and Query Optimization.
• Used Active-X scripting in SSIS for transformation of data into staging tables.
• Managed and coordinated with remote user for change request and optimization of application.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Created joins and sub-queries for complex queries involving multiple tables.
• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form for highest performance.
• Managed Database files, transaction log and estimated space requirements.
• Created and managed users, roles and groups and handled database security.

Environment: Windows XP, SQL Server 2000 / 2005, SSIS

Confidential

Junior MS SQL Server Developer

Responsibilities:

• Created new database objects like Stored Procedures, User Defined Functions, triggers, Indexes and Views using T-SQL.
• Worked on DTS Package, DTS Import/Export for transferring data from different Databases to SQL Server.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Used joins, database links, and developed reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users.
• Created stored procedure to transform the Data and worked extensively in T-SQL for various needs of the transformation while loading the data.

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