SUMMARY

• 7+ years of experience in IT as SQL Server Developer and strong work experience on Business Intelligence tools.
• Over 6 years of strong experience in Software Design, Development, Analysis, Testing with Data mart, Data Warehouse, Data modeling and Business Intelligence tools.
• Highly Proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Functions.
• Strong experience in MS SQL Server 2008 with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
• Worked on creating Tables, Views, Indexes, Replication, and other SQL joins and query writing.
• Extensive experience in design of SSIS Packages to integrate data from heterogeneous sources (Excel, CSV, Oracle, DB2, AS400LS, Flat file, Text format Data).
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert and BCP.
• Experienced in Database Backup and Recovery procedures.
• In-depth knowledge of Transact-SQL (DDL and DML).
• Experience in optimizing the database by creating various Clustered, Non-clustered indexes and Query Optimizer.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Experienced in using global variables, expressions and functions for the reports.
• Proficient in handling parameterized reports in SSRS.
• Experienced in sorting the data, defining data source and subtotals for the reports.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Database Technologies/Tools: SQL Server 2008/2005/2000, MS Access 2007/2003

Programming Languages: T-SQL, Visual Basic

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

Reporting Tools: SQL Reporting Services / Analysis Services 2008/2005/2000

Modeling Tools: Microsoft Visio 2003, ER-win 3.x

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTPBCP, OLAP, Database Engine Tuning Advisor (DTA)

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

Other Tools: Microsoft Office 2010/2007/2003

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

MS SQL developer/SSRS/SSIS/SSAS Developer

Responsibilities:

• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Handling Static and Slowly Changing dimension Tables using SSIS package.
• Full and Incremental Loads into Datawarehouse Table.
• Involved in Datawarehouse and Data Mart daily loads and data validation.
• Loading data in SQL Server Analysis Services Cube.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions (SSAS).
• Designed cube to hold summary data for Target dashboards. Developed Cube with Star Schema (SSAS).
• Wrote the queries for the drill down reports.
• Responsible for creating the reports based on the requirements using SSRS.
• Generate several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services (SSRS).
• Identified and added the report parameters.
• Uploaded reports on to the report manager and organized them in folders
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
• Formatted the reports using the Global variables and expressions.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: MS SQL Server 2008(Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Service 2008ASP.Net, MS Excel, Window XP, Toad

Confidential, Irving, TX

MS SQL Developer/SSRS/SSIS Developer

Responsibilities:

• Actively participating in requirement gathering meeting with Analyst and Project team on a regular basis to enhance the performance for specific task.
• Create database objects like tables, views, indexes, Store Procedures, User Defined Functions and Constraints etc as per the requirement.
• Developed Store procedures using variables and parameters.
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by business analysts and UI team.
• Optimized the performance of queries with modification in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables and established Joins.
• Designed complex packages for ETL to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, OLE DB, Excel and Access to SQL Server.
• Used various SSIS tasks such as Data Conversion, Derived Column, and Merge Join. OLE DB command, Look UP then loaded the data.
• Created SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs (SSAS).
• Create various SSIS Packages using ETL Process and Load Source data into SQL Server in a highly efficient way.
• Designed reports from scratch, Import reports from MS Access using Report Wizard in SSRS.
• Created Several Valuable reports (i.e. is for client level by Customer/Time/Region using Tabular Data and Charts etc), for business users.
• Create operational and executive reporting with drilldown, charts and graphs based on report data using SSRS.

Environment: SQL Server 2008, Management Studio 10.0, BIDS, SSIS, SSRS, Windows 2008/2003, MS Visio 2008 Version 9.0

Confidential, Houston, TX

MS SQL Developer

Responsibilities:

• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Created and designed data models using Erwin data modeling tool.
• Designed physical data models and created DDL scripts to create database schema and database objects.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created DTS package to schedule the jobs for batch processing.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.

Environment: MS SQL Server 2005, MS Access2003, DTS, Erwin, SQL Query Analyzer 2005, SQL Developer 2005.

Confidential, NYC

SQL Server/SSRS Developer

Responsibilities:

• Actively participated in gathering business requirements and system specifications.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by business analysts and UI team.
• Modified current database by adding tables & relationships required to support the system.
• Involved in the troubleshooting of Database performance issues and implementing necessary DB changes.
• Increased Stored Procedures performance using SQL Server Traces, Index Tuning Wizards and Executions plans.
• Planning and scheduling jobs for backup strategy to ensure reliable backup.
• Automated content loading via using portable DTS packages to load policy feeds onto HIS.
• Developed different types of reports such as ad-hoc reports, matrix reports, tabular reports using report wizard in SSRS.
• Created Indexed Views to optimize queries and Triggers on Views to populate base tables.

Environment: Windows 2005/XP/NT, MS SQL Server 2005, Query Analyzer, DTS, SSRS, Crystal Reports 10, MS Office 2007, Adobe Reader.

Confidential

SQL Developer

Responsibilities:

• Installation of SQL Server 2000 on Windows environment.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity
• Checks, Update Statistics and Re-indexing.
• Configured and managed merge replication database articles.
• Developed DTS packages to transfer data from heterogeneous data sources and different files like Flat Files, Spread Sheets to SQL Server.
• Data migration (import & export - BCP) from Text files to SQL Server 2000/7.0.
• Created Triggers to enforce data and referential integrity.
• Designed and developed Stored Procedures, functions and DTS packages and error handling using T-SQL for SQL Server 2000.
• Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
• Performed Query Optimization by extensive use of Index implementation and Index Tuning Wizard.
• Responsible for Oracle/SQL Databases and Application performance tuning, physical/logical design and optimization and availability.
• Implemented and maintained industry standards in database management.
• Monitored SQL server performance using SQL profiler, Index tuning advisor for query tuning, stored procedures.
• Maintained the database consistency with DBCC commands at regular intervals.

Environment: SQL Server 2000/7.0, Oracle 8i, MS-Access, Windows 2000, Linux, C++, T-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS.