SUMMARY

• Over 6 years’ experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Servers 2008, 2005, 2000, in Production, QA and Development Environments.
• Expert in installation and upgrades of/to SQL server 2008/2005/2000 and its service packs, database migrations, backup, recovery and maintenance of SQL Server 2008/2005/2000 databases
• Proficient in installation, configuration, development, deployment, and troubleshooting reporting services using SSRS 2005/2008 across various environments.
• Built SSRS project to generate reports with desired forms(Webpage, PDF, Excel and etc.) to present statistics information according to business requirement
• Involved in integrating the SSRS reports to portals, delivering them using Email Links, PDFs etc.
• Experience in developing Fail - over strategy plans & High availability (mirroring, replication and Log shipping) of SQL server databases
• Experience with configuring Transactional Replication & Snapshot Replication
• Strong experience in Creating Databases and writing queries involving stored procedures, user defined functions, tables, views, indexes, relational database models and data integrity based on Functional requirements and System Design that meet the business and technical objectives.
• Involved in huge data migrations, transfers using utilities like integration service (SSIS), Bulk Copy Program (BCP) and Bulk Insert.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling SSIS packages.
• Highly experienced in enterprise reporting in generating reports using Linked Reports, Sub Reports, Adhoc Reports, Drill down reports, Drill through reports and filters, charts in SQL server reporting services.
• Proficient in the use of T-SQL for developing stored procedures, triggers, tables, user functions, SQL joins and query writing.
• Created Documentation, ER Diagram using ERWIN and MS VISIO.
• Proficient in design of ETL and SSIS packages for integrating data using OLEDB connection from different sources (XL, CSV, FLATFILE) by using multiple transformations provided by SSIS such as Aggregate, data conversion, conditional split, fuzzy lookup, merge.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Involved in Automating daily administrative tasks including database backup and recovery.
• Extremely motivated, diligent, conceptually strong team player with an ability to take new roles.
• Excellent problem solving skills for delivering useful and compact solutions.
• Has the ability to work in a fast paced environment, Good team player and can work independently.

TECHNICAL SKILLS

Operating Systems: Windows NT/95/98, Windows 2000/XP:

Databases: MS SQL Server 2008/2005/2000 , MS Access 2003, MS XL:

Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Database Tuning Advisor, Business Intelligence Studio, DTS, SSIS,SSRS, Export & Import, Exposure to Cisco Router devices, Juniper Basics, ERWIN and MS Visio, Lite speed:

Languages: SQL, TSQL, HTML, XML:

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

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

BI Developer

Responsibilities:

• Developed reports using SSRS and published as PDF, Excel and CSV formats.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Modified the format and structures of the reports according to the end-user requirements.
• Created Ad-Hoc reports using Report Builder.
• Worked on Stored Procedures and Database Triggers.
• Worked extensively in writing and debugging stored procedures, triggers, Inner Joins, Outer Joins and views.
• Develop SSIS packages to extract and transform data.
• Developed SSIS packages for File Transfer from one location to the other using FTP task.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc to Access etc.
• Used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Handled large table loads and reporting from different source (Flatfile, Excel.) files using SSIS and sql adhoc queries.
• Create the necessary indexes to improve the query performance.
• Working with Different methods of taking Database Backup and Recovery procedures.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in project planning, scheduling for database module with project managers.
• Physical and Logical Data Modeling using ERWIN.
• Worked with various business groups while developing their Applications, assisting in database design, phasing from Development to QA and to production environment.
• Creating and managing scheme objects such as tables, views, Indexes, Procedures, triggers and maintained Referential Integrity.

Environment: Windows server 2003, SQL Server 2008 R2/2008/2005, SSIS, SSRS, BIDS, SSMS

Confidential, DALLAS, Texas

SQL Developer/ BI Developer

Responsibilities:

• Worked extensively on creating SSRS canned and ad-hoc reports (Model based) using Business Intelligence Development Tools
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server
• Regular monitoring of Time/Data driven Subscription based SSRS reports (Daily, Monthly, Weekly) and SSIS external file transfers
• Created parameterized reports for the users and clients, with drill-down, drill-through features.
• Transferred Data to data warehouse and exported files in various formats based on requirements using SSIS Packages.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Involved in Creation of Dimensions using STAR Schema.
• Created Entity Relationship (ER) diagrams based on requirements.
• Worked extensively on creating stored procedures, views and reports.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports.
• Generated Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients, Formatted reports for various Output formats.
• Managed business issues on connectivity, permissions, data validation and worked closely with business analysts for report generation. .
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Coordinated with DBA in creating and managing tables, indexes and triggers.
• Worked with various business groups while developing their Applications, assisting in database design, phasing from Development to QA and to production environment.
• Creating and managing scheme objects such as tables, views, Indexes, Procedures, triggers and maintained Referential Integrity
• Involved in database and log Backups & restoration, backup strategies, job scheduling.

Environment: Windows server 2003, SQL Server 2008 R2/2008/2005, SSIS, SSRS, BIDS, SSMS

Confidential, Woodlands, TX

SSIS Developer

Responsibilities:

• Wrote Stored Procedures, queries, Views and Functions in SQL Server 2005 and 2008 environment.
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005.
• Worked in an environment which has configured transactional and snapshot replication.
• Generated the drilldown, drill through, Parameterized and linked reports using the SSRS.
• Developed SSRS Reports in the Production Environment.
• Prepared technical specifications for the development of SSIS (ETL) packages to load data into various target tables and defining ETL standards.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Created Entity Relationship (ER) diagrams based on requirements.
• Created mappings to load data extracted from flat files, XML files to staging area using SQL Server SSIS.
• Created mappings using, split and join transformations.
• Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into other database.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Established backup and recovery of SQL server 2005.

Environment: Windows XP, MS SQL Server 2005/2008, T-SQL, SSRS, SSIS, ERWIN, .NET