Summary:

• Over 7 years of IT experience in as a Microsoft certified BI Developer that includes Migration of the data and Reports Development using SQL Server 2008R2/2008/2005/2000 and Visual studio 2008/2005.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008 with expertise on data normalization and building Referential Integrity Constraints.
• Adept in assembling Database for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2000/2005/2008.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, and constraints.
• Extensive experience in rendering reports to XML, TIFF, CSV, Excel, Acrobat and Web Archive formats, and fabricated various SSRS reports using OLAP CUBEs and SQL Server.
• Extensive experience in creating subscriptions of the reports with report parameters including data driven subscription using both email and file share delivery methods.
• Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.
• Expertise in creating Report Models for building Ad hoc reports using SSRS and creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Expert in performing troubleshooting on Report Processing, Subscription, Delivery and Configuration Problems including capability of solving performance issue with the SSRS reports such as faster report rendering, query execution, and data retrieval.
• Proficient in Merging data from various Heterogeneous Data sources in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Exceptional interpersonal aptitude, effectively identify and resolve problems using available resources, strong orientation in customer service/satisfaction and a quick learner who thrives in a team oriented environment.

Education: Master of Science in Computer Engineering

SkillsSet:
MS SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MS SQL Server 2000/2005/2008/2008 R2, T-SQL, SQL Server Management studio, Business Intelligence Development studio (BIDS), DTS, ETL, Windows 7/Vista/XP/2003/2000, Query Analyzer, SAS, PL-SQL.

Projects Summary:

Confidential, New Hartford, NY 3/2012 - Present
Sr. MS SQL/BI Developer
Confidential is a world leader in the invention, production and supply of the high-nickel, high-performance alloys used for the difficult jobs in engineering. The scope of the project was to create the link between Oracle database and the SQL Server and to write the queries to extract the data from the Oracle database through the linked server, getting all the related data from different sources on the defective part number.
Responsibilities:

• Gathered requirements from the excel master spreadsheet for the customers generated defective parts summary and loaded the data from the source to SQL Server database using SSIS 2008/2005.
• Created the SSIS package to extract the data from the Oracle database and Load to the SQL Server by providing the Oracle connection.
• Moved the Bulk data from the Oracle Database to the SQL Server in the form of SQL Server tables using Microsoft Attunity Connectors, keeping time into consideration.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master defective parts source spreadsheet to the SQL Server table and update the old data.
• Schedule the SSIS package on daily basis for the Defective parts source generated by the customer to the excel spreadsheet using SQL Server Agent Jobs.
• Designed the Linked server to make SQL Server talk with Oracle keeping SQL Server primary.
• Wrote T-SQL queries using Openquery to extract the data from the Oracle database through the Linked Server in the SQL Server Management Studio.
• Created and wrapped the T-SQL queries to the linked server in the stored procedures by providing the defective part number as the parameter.
• Used the PL-SQL and SAS codes to run and moved the results in the CSV file format, latter running the SSIS package to move to the SQL Server tables.
• Modified the queries and optimized them by indexing, finally making the stored procedures on the heat number of the parts.
• Mapped and interfaced all the stored procedures by creating the interfaces between the different sources and getting all the information related to the part number.
• Moved the final stored procedure result into the flat file using DTSwizard.

Environment: MS SQL Server 2008/2005, Windows 2000/NT/XP, SSIS 2005/2008, Microsoft Attunity Connectors, SAS, PL-SQL, T-SQL, Query Analyzer, XML, ETL.

Confidential, Oaks, PA 9/2011 – 2/2012 
MS SQL/BI Developer
CONFIDENTIAL is a global provider of asset management, investment processing, and investment operations solutions. The aim of the project was to create packages to migrate data from different sources and to format and generate reports, which contained the details of the different type of insurances, the brokers, the agents and the customer’s data.
Responsibilities:

• Gathered requirements from the business users, created technical specification documents and loaded the data from different sources to SQL Server database using SSIS 2008/2005.
• Used the concepts of precedence constraints and look up tables to validate data while dealing with SSIS along with developing and scheduling the SSIS packages to perform daily ETL tasks.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008/2005.
• Migrated reports from MS SQL Server Reporting Services 2005 to 2008 and created complex reports using SSRS 2008/2005 from the OLAP cubes for end user analysis.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008/2005 using data from a variety of sources.
• Published and scheduled the reports in different formats using different delivery extensions such as file share, and email.
• Performed tasks to run every day to update changes in the base tables and tested required queries and reports before publishing.
• Utilized Performance Point Server to create Scorecards and Dashboards to monitor Business performance and its utilities.
• Optimized and implemented stored Procedures and triggers for automating tasks and also managed indexing, debugging, optimization and performance tuning using T-SQL.
• Modified/created SQL Joins, Sub–queries and T-SQL codes to implement Business rules by documenting the project steps by facilitating to the team members.

Environment: MS SQL Server 2008/2005, Windows 2000/NT/XP, SSIS 2005/2008, SSRS 2005/2008, Performance Point Server 2007, T-SQL, Query Analyzer, XML, ETL.

Confidential, New York City, NY 5/2010 – 8/2011
MS SQL /BI Developer
Confidential is the branch of municipal government in New York City that manages the city’s school system which is the largest school system in United States. 
The main objective of the project was to collect data from various database sources from city databases to statewide data warehouse, e-scholar system to perform analysis and then integrate them with the existing systems to create reports in SSRS.
Responsibilities:

• Involved in Planning, Defining and Designing data based on school requirements and provided documentation.
• Built SSIS packages from different sources and loaded complete 2006-2011 historical student data to the state warehouse database.
• Assembled SSIS packages and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transferred the data into data warehouse.
• Furnished various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Fabricated and scheduled SSISPackages along with the successful implementation of deploying data packages to the appropriate destinations using SSIS.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation and created different type of reports including Cross-tab, Drill-down, Sub reports, parameterized reports by complex formula.
• Operated and created Report templates, bar graphs and pie charts based on the updated financial data of the school and scheduled to run the reports automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Constructed procedures to pass on to parameterized reports and to ensure the quality, usability and accuracy of the reports.

Environment: MS SQL Server 2005/2008, MS Visual Studio 2005, Windows XP Professional, MS SharePoint, SSRS, SSIS, Performance Point Server.

Confidential, New York City, NY 3/2008 – 4/2010
MS SQL Server Developer/ SSIS Developer
Confidential is engaged in providing a range of financial services to consumers and corporate customers. The scope of the project was to build a centralized data warehouse that can be used by the financial group and analyze profit and loss information of the organization by general ledger accounts.
Responsibilities:

• Involved in migrating data from various sources into the SQL Server 2005 using ETL (Extract, Transform, Load) tool SQL Server Integration Services (SSIS).
• Succeeded in migrating data between heterogeneous sources (flat file, Excel and SQL Server 2005) using SSIS, BCP (Bulk Copy Program) and Bulk Insert.
• Mapped all DTS (Data Transformation Service) packages to SQL Server Integration Services (SSIS) and modified the packages according to the advanced feature of SQL Server Integration Services.
• Monitored performance and optimized SQL queries for maximum efficiency and implemented fine tuning of database objects and server to ensure efficient data retrieval.
• All data were migrated to the staging server and then the data were later processed to the OLAP (Online Analytical Processing) Server to use with SSAS for analysis purpose.
• Aided the team in designing, implementing and managing data warehouses OLAP cubes to use with SQL Server Analytical Services (SSAS) 2005.
• Executed data mapping and transferred data from staging tables to database tables using SQL Server Integrated Services (SSIS) transformations.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard and improved data load performance by analyzing database design and query plans.
• Associated in designing database objects like indexes, views, user defined functions, triggers, stored procedure, constraints, and roles by documenting all the procedures involved in the database for future reference.
• Created SQL server configurationsforSSISpackages to group logically related column types and to transfer data.

Environment: MS SQL Server 2000 Enterprise Edition, MS SQL Server 2005, SSRS, SSIS, SSAS, MS Access 2003, Import and Export Data, MS Project Server.

Confidential, Louisville, KY 1/2007 – 2/2008 
MS SQL Developer/ SSRS Developer 
Confidential offers a wide range of health insurance products and the services. The goal was to develop reports (sales and statistics) on weekly, monthly, quarterly, and annually basis on historical data. It also accounted on developing the reports which included advertising made by the company every month. 
Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for transformation, and data extraction.
• Utilized database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Created various database objects such as tables, indexes and views based on the requirement and designed the queries for the reports by identifying the required tables from the database.
• Generated various reports with drilldowns and dropdowns from the cubes by connecting to the Analysis server from SSRS.
• Extensively involved in designing and writing the queries in the query builder for retrieval of the data from the database for generating the reports in SQL Server Reporting Services.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Created and worked with drill down reports and identified the report parameters to create the reports on requirements.
• Used various report items like sub report and charts to develop the reports in SSRS and deployed the generated reports on to the server using the Reporting Services Report Manager.

Environment: MS SQL Server 2000/2005, Reporting Services (SSRS 2000/2005, Microsoft Visual Studio 2005, BIDS, SQL Profiler, Visual SourceSafe, MSOffice, HTML, MS Access, Query Analyzer, Erwin and Visio. 

Confidential 6/2004 – 12/2006 
MS SQL Server Developer
Confidential is a global leader in providing integrated information solutions to business and professional customers. The main aim of the project was to re-organize the customer database with the real time updated information.
Responsibilities:

• WorkedonClient/Servertools likeSQLServerEnterprise Manager and Query Analyzer to AdministerSQLServer.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Performed complex queries, triggers and stored procedures, views and user defined function and updated Database Statistics and Re-indexing.
• Involved in performance tuning using indexing (Clustered Index and Non-Clustered index) by minimizing table scans.
• Created Database Maintenance Planner for the Performance ofSQLServerwhich covers Database Integrity Checks and routine backups.
• Planned the complete back up of the Database and Restore the Database from Disaster Recovery.
• Coordinated with the supervisor to design and implement database logical and Physical Schemas.
• Worked on DTS Package, DTS Import/Export for transferring data from DB2 Database and Data migration (import & export - BCP) from Text toSQLServer.

Environment: MicrosoftSQLServer2000, HTML, Microsoft Visio 2000, Microsoft Visual SourceSafe, Query Analyzer, SQL profiler and Windows 2000/XP, T-SQL.