Summary:

• Over 6 years of IT experience in the Analysis, Design, Development, Administering Client/server application using Microsoft SQL Server and BI suite Development, UAT and Production Environment . Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications .
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BIsuite, Reporting and Analytics.
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP , Data Transformation Services DTS and SQL Server Integration Services SSIS 2005/2008 .
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• SQLServer 2005/2008/2012 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes.
• ETL implementation using SQL Server Integration Services SSIS .
• Developing reports on SSAS SSRS on SQL Server 2000/2005 . Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Expert in creating the MDX cubes and dimensions. SSAS
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN
• Experience with adhocreporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores, replication etc.
• Exposure to CMMI, ISO and QAprocesses, change control management, source safe, version controlling etc.

Technical Background:

Professional Experience:

Position: SQL BI DEVELOPER

Responsibilities:

• Worked on SQL Server Integration Services SSIS to integrate and analyze data from multiple heterogeneous information sources Oracle Sybase
• Created packages in SSIS with error handling.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Experience in upgrading SQLServer software to new versions and applying service packs and hot fixes and unattended Installations.
• Managed the migration of SQL Server 2008 databases to SQL Server 2012
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Designed and developed SQLSSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQLserver 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Responsible for ETL operation using SQL Server Integration Services SSIS and Worked with users in training and support and also have experience in incremental data loading.
• Experience in creating complexSSIS packages using proper control and data flow elements.
• Worked with different methods of logging inSSIS.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Building UAT and Test environments using Production backups.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Involved in migration of SSRS from SQL 2008 to SQL 2012
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services , SQL Server Analysis Services, Crystal Reports ,SharePoint 2007 , T-SQL, ODBC, Excel, Access, Windows 2000/XP

Confidential

Position: SQL BI DEVELOPER

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008R2 using SSAS, SSIS, SSRS
• Generated several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services
• Involved in installation, configuration and Setup of SQL Server 2008R2
• Involved in Migration of Databases from SQL Server 2008 to SQL Server 2008R2
• Generated parameterized/Drilldown, Drill Through Cascaded reports using SSRS
• Involved in complete life cycle of database, which includes designing of database, Populating lookup data, Creating Stored Procedures as per front end developer's requirement and commercial transitions, writing Triggers, creating user defined functions and created Views to simplify the complexity of the data structure.
• De-normalized some tables that used lots of computations and joins
• Maintained integrity constraint to facilitate consistent data entry into the database by creating check constraint, triggers
• Worked with SQL Profiler for tracing, auditing and PerformanceTuning and routine DBA activities like Query Optimization effective SQL Serverconfiguration for better performance and cost reduction
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks
• Created, maintained and executed jobs.
• Implemented all the ServicePack changes.
• Successfully implemented backup procedures and scheduled maintenances for the databases.
• Performed Database Refresh tasks from production to Development and Staging Servers

Environment: Windows 2008 server, SSIS, SSRS, MS SQL Server 2008/2008R2, MS Access, Excel, Query Analyzer, Profiler, T-SQL, Oracle 10g/ 9i

Confidential

Position: SQL BI DEVELOPER

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services
• Involved in Installation, Configuration and Deployment of SSRS Reports using different topologies
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008
• Maintained patient records from various healthinstitutes in MS SQL Server 2008
• Implemented major changes to the MS SQL database for overall performance enhancement,
• Developed Stored Procedures, tables, queries, views
• Performed backup procedure to the database as a disaster recovery method.
• Reviewed and made changes to the queries to meet new customer requirements.
• Implemented methods to display the appropriate data to different type of users based on various criteria.

Environment: Windows Server 2008, SQL Server 2008, SSRS, SSIS

Confidential

Position: Jr.SQL BI DEVELOPER

Confidential is the Confidential. The project involved the backend maintenance and development of LIC's enormous databases which contained valuable customer data.

Responsibilities:

• Performed Installations and configuration of SQL server 2005 and upgraded SQL server installations wherever necessary.
• Created new tables, indexes, triggers, static/dynamic stored procedures, and some user defined functions
• Involved in the gathering and analysis of the end user requirements
• Performed Backup and restore operations
• Carried out Performance tuning and troubleshooting of SQL queries and stored procedures using SQL Profiler, Query Plan Graphical and Textual and Statistics I/O
• Transferred data from various heterogeneous data sources like Excel, Fixed Width Flat Files, and MS Access to SQL Server 2005

Environment: MSSQL Server 2005 Enterprise Edition, Enterprise manager, Query analyzer

Confidential

Position: Jr. SQL BI DEVELOPER

Confidential

This project was developed for Confidential. We designed and developed a web application for maintaining the books available in the library. Each student receives a registration form from the librarian. Upon completion of the form, students are assigned a user name and password. Students may access the system via a web interface which allows them to search books easily by entering the related topics. The system then states if the book is currently available or not and allows the students to hold the book or request to reserve it. Then the librarian performs the book issue and return task.

Responsibilities:

• Designed and analyzed the SQL Server database and involved in gathering the user-requirements
• Developed logical and physical design of database for project on basis of user requirements
• Created look up tables to match the students login with their password
• Created reports using SSRS
• Created jobs which will alert the librarian when the student does not return the book before the due date
• Created stored procedures, which returns the information of the student based on his library card number
• Created and managed indexes, which enabled quick searches and retrieval of information requested

Environment: SQL Server 2005 Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard , MS Access.