PROFESSIONAL SUMMARY:

• 7 Years of overall IT experience in Analysis, Design, Development Implementation of Data Warehousing solutions including SQL Server Database Development and Business Intelligence BI .
• Acquired experience with full Software Development Life Cycle SDLC , which includes Requirements, Planning, Analysis, Design, Agile Development, Testing, Implementation and Support.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Experience in ETL processes involving migration and in sync processes between two databases.
• Experience in Microsoft Visual C in script component of SSIS.
• Experience in MS SQL Server Reporting Services SSRS and SQL Server Integration Services SSIS .
• Experience in working with Data warehouse using ETL tools and strong understanding of Data warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP and Multi-dimensional Models for query and analysis.
• Good experience in data migration methodology.
• Expert in data modeling for Data Warehouse and Data Marts, Ad-hoc reporting, Web Integration and OLAP solutions.
• Proficient in RDBMS technologies such as MS SQL Server, Oracle and IBM.
• Well versed in the development of SSAS cubes and writing MDX queries.
• Strong business software design development experience in Banking, Insurance, Healthcare, and Manufacturing domains using MS SQL Server, MS SQL Server Integration Services SSIS , MS SQL Server Reporting Services, MS .NET 3.5.
• Good experience in developing complex T-SQL queries using stored procedures, functions, triggers, views, joins, sub-queries.
• Expertise in developing complex business critical interfaces and reports in SSIS and SSRS.
• Good knowledge in defining data warehouse star schema, fact table, cubes, dimensions, measures using SQL Server Analysis Services.
• Skilled in error and event handling, precedence constraints, break points, check points and logging.
• Proven experience in data-driven subscriptions in SSRS and using various transformation tasks is SSIS.
• Experience in data-migration of highly complex huge volume of data from AS-400 to SQL Server.
• Well versed with development of Dashboards, Scorecards, Drill-down and Drill-through reports using SSRS
• Hands-on experience in scheduling and deploying reports using Report manager.
• Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Provided production support after deploying the application into the production environment.
• Strong writing and documentation skills for the management, development and control of documentation.
• Experience in object oriented programming, in C , C and VB in MS Visual Studio 2008 environment.
• Good Knowledge in Applicant Tracking Systems like Taleo/Kronos. Worked on integrating the ATS systems with one of the core platforms developed for Tax Credit Screening.
• Experience in creating Business Objects reports using Web Intelligence.
• Experience in White Box, Black Box and Unit Testing in Various Modules in Database level and Application Level.
• Quick Learner, highly motivated, organized, result oriented professional and an enthusiastic team player with strong technical and communication skills.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio BIDS .
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Explained the whole design of ETL Process using Visio tool.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Microsoft SQL Server 2008 / Microsoft SQL Server Integration Services 2008/Microsoft SQL Server Reporting Services,

Confidential

Responsibilities:

• Gather requirements for the reports development and deploying it and accessing the reports from the Tax Application.
• Interface with the client to gather requirements for the interfaces, to import data, from various source files oracle database to the Tax Application database. The interface also included data-cleansing activity.
• Prepare detailed level design unit test cases for the interfaces and reports
• Create Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for the application
• Develop SSIS package to Extract, Transform and Load data into the application database
• ETL for data warehouse. Usage of Type1 Type 2 slowly changing dimensions
• Developed various types of reports like Drill Down, Drill Through parameterized reports using SQL Server Reporting Services
• Involved in deployment of SSIS package and SSRS reports to make them available for the end users
• Created SSIS packages to include data cleansing tasks making use of transformation tasks like Fuzzy Grouping Fuzzy Lookup
• Involved in performance tuning of complex time consuming T-SQL Stored procedures and functions
• Lead my team at the client location and assisted the offshore team with the development activities
• SQL Server Profiler for tuning report queries and improves performance in SQL Server
• Provided my offshore team with my inputs on the technical front and clarifications on the business requirements
• Interface with the client to gather requirements to gather requirements for enabling the integration between ATS the Tax application
• Lead the development activities from Onsite for the development of web services for enabling the integration.

Environment: Microsoft Dot Net 3.5/SQL Server 2008, MS Excel Windows 2003 server, Business Intelligence technologies like SSIS SSRS.

Confidential

Responsibilities:

• Created parameterized reports in SSRS.
• Involved in gathering users requirements and worked closely with the Business Users.
• The reports developed included drill down reports, drill through reports, hierarchy related reports configuration using data driven subscription
• Deployment of SSRS reports to make them available for the end users.
• Design the SSIS Framework Package template for initial load and incremental load for extracting, transforming, and loading data from various RDBMS and Non-RDBMS systems with proper configurations, logging/auditing, package error handling, data error logging and checkpoint
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Deployment of SSIS package
• ETL for data warehouse. Usage of Type1 Type 2 slowly changing dimensions
• Performance tuning of Stored Procedures and modification of database model as needed for enabling good performance of the reports and interfaced developed
• Managed the release activities of the project which also included creating release notes deployment steps document
• Design Development of Reports and Interfaces per the business needs.
• Preparing unit test plans for the Reports Interfaces.
• Performing Integration testing of the reports Interfaces
• Code Review
• Deployment of reports interfaces, to make it available for the business use.

Environment: SQL Server 2005/SQL Server Integration Services 2005/SQL Server Reporting Services 2005.

Confidential

Responsibilities:

• Involved in the database migration of the existing legacy application data to the new HMIS NextGen application database. The data migration involved Extraction, Transformation and Loading based on the Business Rules for the migration
• Work involved Data Architecture of the OLTP database for the new HMIS NextGen Application
• Normalized the data, created OLTP tables, views, indexes, triggers and efficient stored procedures and Functions
• Checked Performance Tuning of the Database by optimizing the queries with modification in T-SQL queries. Normalized tables, established joins and created indexes wherever necessary.
• Building query execution plans and making sure each and every table has the necessary Indexes existing for a better performance of the query execution
• Development of Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for the application
• Worked on developing Reports and managing reporting services
• Creating the forms/documents using SSRS. Deployment of the forms created in SSRS and integrating it with the NextGen application
• Involved in the development of the core modules of the HMIS Next Generation application.
• Involved in the build and deployment of the application.
• Involved in the code review/reviewing the unit test plans created by the testing team/creating deployment document to list down the steps for deployment/Release management of the software product
• Supported the application during the User Acceptance Testing phase of the project
• Provided support to the application in the production environment after the application went live

Environment: SQL Server 2005/SQL Server Integration Services 2005/SQL Server Reporting Services 2005

Confidential

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, data conversion, historical data, and audit analysis.
• Used SQL BIDS to design SSIS packages to transfer data between servers OLTP to Staging , loaded data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Transferred Flat files from different sources to the ETL tier by using BCP.
• Responsible for Performance tuning for SQL scripts, stored procedures, triggers, functions using SQL Profiler.
• Generated reports using SSRS. The reports developed included drill down reports, drill through reports and charts.
• Data cleansing using SSIS.
• Preparing unit test plans for the Reports Interfaces.
• Performing Integration testing of the reports Interfaces.

Environment: SQL Server 2005/SQL Server Integration Services 2005/SQL Server Reporting Services 2005