Professional Summary

• 3+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments with various business domains.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, specification writing, development, testing, and implementation.
• Experience in design of Logical and Physical Data Modeling using Erwin.
• Experience in Normalization /De-normalization and Normal Forms.
• Expertise in T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, cursors and user defined functions.
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS.
• Experience in developing packages and deploying them to file system and SQL server.
• Experience in Error handling by using Event handlers and also provide custom logging for SSIS packages.
• Experience in scheduling the jobs for SSIS packages, Sending Alerts using SQL Mail.
• Expertise in report writing according to the business requirement in SSRS.
• Experience in developing different types of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, parameterized performance, Chart Reports and Sub Reports using SSRS 2008.
• Extensive knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Strong analytical, administration and problem solving skills dedicated to maintain the high quality standards. Good communication skills, ability to work independently.

Educational Qualifications

• M.S., Information Technology
• Bachelor of Technology in Computer Sciences

Technical Expertise

Management Studio, Enterprise Manager, Query Analyzer, Data Base Engine Tuning Advisor, SSIS, SSRS,SSAS Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008, DTS Import and Export Wizard

RDBMS:

SQL Server 2008/2005/2000, DB2 UDB, MS-Access 2003/2000

ETL Tools:

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

Reporting Tools:

SQL Server Reporting Services (SSRS)

Third Party Tools:

Red Gate Data Generator, Data Compare, SQL Compare, Team Foundation Suite (TFS), VSS

Certification
Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Professional Experience
Confidential,MA Mar\'12 - June\'12 SQL BI Developer

Confidential,is an integrated health system founded by Brigham and Women’s Hospital
and Massachusetts General Hospital. In addition to its two academic medical centers, the Partners system includes community and specialty hospitals, community health centers, a physician network, home health and long-term care services, and other health-related entities. Partners is one of the nation’s leading biomedical research organizations and a principal teaching affiliate of Harvard Medical School. Partners HealthCare is a non-profit organization.
Responsibilities:

• Created new tables, wrote stored procedures and user defined functions for application developers.
• Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
• Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects. Implemented BCP for bulk inserts.
• Created various connection managers (OLE DB connection, flat file connection, Analysis Services connection, Excel connection) available in SSIS to collect data from heterogeneous sources such as SQL Server, flat files, excel.
• Developed SSIS Packages using fuzzy lookup transformation, file system task, Foreachloop container.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Deployed Packages in the file System.
• Used SSIS Documenter for documenting SSIS packages
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Created Drill down reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).

Environment: SQL Server 2008 Enterprise, Windows Enterprise Server 2003, Visual studio 2008, Performance point, .NET Framework, C#, ASP.NET
Confidential,MA Jun\'11 – Mar’12
SQL BI Developer

Confidential, is one of the world’s leading software and technology services companies. SunGard provides software and processing solutions for financial services, education and the public sector. It also provides disaster recovery services, managed IT services, information availability consulting services and business continuity management software.

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system
• Tested and created Views, User Defined Functions and Stored Procedures for new and modified business requirements.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries and Stored Procedures.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005/2008 using SSIS, BCP and Bulk Insert.
• Created, tested, modified and scheduled SSIS packages to update the tables on a day to day basis.
• Developed SSIS Packages using fuzzy lookup, xml, Script task, OLEDB, file system task etc.
• Experience in troubleshooting and tuning the performance of long running SSIS packages.
• Implemented logging for Audit purposes.
• Experience in data cleansing before loading data warehouse.
• Created SSIS packages to incrementally load the data into ODS and Enterprise data warehouse.
• Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Develop and deliver dynamic reporting solutions using SQL Server 2005/2008 Reporting Services (SSRS).
• Deployed, scheduled reports and added users to the data base.
• Created ad-hoc Reports using OLAP Cubes.
• Documented reports and packages created.

Environment: SQL Server 2008 R2 /2005, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSAS, SSRS, Visio, VSS.

Confidential,Oct’10-Apr’11
Jr. SQL Server Developer (Intern)

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed software and database solutions.
• Involved in the Data modeling, Physical and Logical Design of Database
• Developed T-SQL Queries and procedures for processing business logic in the database.
• Used performance tuning techniques to improve performance for the slow running SQL.
• Created tables, indexes, views, sequences, constraints, triggers and procedures.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Involved in generating Table reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Develop and deliver dynamic reporting solutions using SQL Server 2005/2008 Reporting Services (SSRS).
• Deployed, scheduled reports and added users to the data base.
• Created documentation as required.

Environment: SQL Server 2008, Microsoft Business Intelligence Development Studio, T-SQL, SSRS, Erwin, TFS

Confidential,Hyderabad, India Mar\'08-Jul’09
Jr. SQL Server Developer

Confidential,is an Americanmultinationalprovider ofinformation technology, consultingandbusiness process outsourcing(BPO) services.
Responsibilities:

• Creating new Database with objects such as tables, views, indexes, triggers etc.
• Developed a data model and implemented the same using ERWIN.
• Created effective Normalization /De-normalization and Normal Forms.
• Involved in designing and writing Stored Procedures, Triggers, Cursors, functions and maintained referential integrity and implemented complex business logic using T-SQL for SQL Server 2000.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Performing query plans and making sure every query is using appropriate useful indexes.
• Designed and created packages using Business Intelligence Design Studio, organized them in Solutions and Project
• Worked with report parameters and performed multi valued Parameterized and cascading parameterized reports using SSRS in Visual Studio.

Environment: SQL Server 2005/2000, Microsoft Business Intelligence Development Studio, T-SQL, Erwin