• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio Data Tool and Visual studio 2012.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSIS in visual studio 2012.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Performed data conversion from flat file into a normalized database structure.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Waddell & Reed is among the most enduring asset management and financial planning firms in the nation, providing proven investment and planning services to individuals and institutional investors.

• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Identified and defined the Datasets for the report generation.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server 2012 Reporting Services (SSRS) in Data tools (Visual Studio).
• Formatted the reports using the Global variables and expressions.
• Successfully extracted transformed and load data into data warehouse.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Used Sharepoint to get all documents required for project and implementation steps.
• Presentation of application to Users and management.
• Involved in the installations and implementation of Application Projects.

BNY Mellon is a global investments company dedicated to helping clients manage and service their financial assets throughout the investment lifecycle weather clients create hold, manage, distribute or restructure their investment .As a part of development team, my role was to populate data warehouse using SQL Server Integration Service (SSIS), to design, create analyze and test cubes using SQL Server Integration Service (SSAS) and to create reports according to the business requirement using SQL Server Reporting Service (SSRS).

• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Environment: SQLServer2012, SQLServerBIDevelopment Studio (BIDS) 2012, SSIS, SSRS, SSAS, Oracle 9i/10g, ClearCase, Clear quest, SQL LiteSpeed, Visual SourceSafe, T-SQL, ETL, Autosys, MS Access, Windows XP/2007 Server.

The World Bank is an international financial institution that provides loans to developing countries for capital programs. The main goal of the World Bank is the reduction of proverty, promotion of foreign investment, international trade and facilitation of capital investment. This project was done by building an online transaction processing system (OLTP) based on MS SQL Server 2008R2 and it's Reporting Services which would provide space for growth and standardizing its forms and templates.
• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server 2008 to 2008R2 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated Environment: SQL server 2008R2, Windows XP/2007, SSIS, SSRS, SSAS, T-SQL, ETL, BIDS 2008R2, Windows 2000 Advanced Server, Microsoft Share point Portal Server, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL LiteSpeed, Dell Power Edge 2650, 1750, and 2600.

UBS is a global financial services company which provides investment banking, asset management, and wealth management services for private, corporate and institutional clients worldwide. The project was to create ETL processes (SSIS) to populate summary data structures and analysis cubes and development and performance tuning of stored procedure queries to investigate data issues and to create new reports structures for business units.
• Responsible for creating logical and physical model using ERWIN.
• Built a package to transfer data between OLTP and DW databases.
• Created Views to reduce database complexities for the end users.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 200R2 and in adding calculations using MDX.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS. Environment: SQL Server 2008R2, BIDS 2008R2, Integration Services 2008R2, Oracle 9i, Visual SourceSafe, TSQL, ETL, Autosys, Rational Clear Case, Clear quest, MS Access, Windows XP/2003 Server.

Guardian life ins.corp SQL Server, protects families and small businesses through innovative technology, products, and services. As a part of the team, the goal of the project was development of Billing and Customer Relationship Management system (CRMS) as well as online multi-carrier enrollment through the Enrollment program for the company. The project also involved Creating SSIS packages for transferring the data from different systems and also creating the reports using SSRS 2008.
• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Created the reports based on the requirements using SSRS 2008.
• Used VB.NET to create user define functions in SSRS.
• Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server. Environment: MS SQL Server 2008, DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer, ETL, Erwin, MS Visual Source Safe FTP Communication, MS-Visual Studio, VB.NET, MS Access, Oracle 10g, UNIX, XML, XSLT, ADO.Net.

McKesson is the largest healthcare services company which provides pharmaceuticals, medical supplies, and information technologies to customers in every segment of the industry. They work with Medicaid and Medicare, among other government programs. This is the complete solution for Mckesson which includes modules like patient registration system, doctor scheduling, lab track system, discharge system billing system and deposit system. It has a dynamic facility for adding the registration type for each patient. An advanced search facility has helped clients, patients and doctors to search their desired records easily.
• Used SSIS Packages to transfer data from different sources to SQL Server using BIDS.
• Used in designing, developing and deploying reports in MS SQL Server environment using SSRS, SSIS in BIDS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Used 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 function, stored procedures and triggers.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and send mail task etc.
• Created many complex Stored Procedures and Triggers.
• Created packages in DTS and SSIS, for data conversion using various transformations tasks
• Built and unit tested reports using SSRS (SQL Server Reporting Services)
• Created reports that call Sub reports in SSRS.
• Developed reporting module using .NET application with set of RDL based reports using SSRS and Complex Stored Procedures.
• Maintained already present reports in Crystal Reports 2008.
• Worked with drill down, cross tab reports as well as chart control reports.
• Successfully understood and implemented the reporting requirements with less amount of supervision.
• Followed up and worked in tandem with the report requestors to sign off the reports within a stipulated amount of time.
• Worked with XML parameters while passing multi value parameters from the report to the stored procedures.
• Involved in writing SQL Scripts using T SQL to create the datasets for the reports.
• Also created stored procedures based datasets (Datasets that get data using stored procedures).
• Used Joins and sub queries concept for extracting data from multiple tables.
• Involved in writing stored procedures that are used for building consolidated datasets for better reporting needs.
• Extensively used SSIS (SQL Server Integration Services) to load data from different data sources and flat files including but not limited to text excel and comma separated files etc.
• Performing query plans and making sure each and every query is running at its maximum potential and speed. Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, T SQL, ETL, .NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T SQL, Visual Studio, VB.NET, IDE, Windows 2000/2003 Advance Server/XP, MS Excel, MS Access, MS Visual Studio 2005/2008

First data is a provider of electronic commerce and payment solutions. The company's portfolio includes merchant transaction processing services such as credit, debit, payroll and other prepaid card offerings. The project involves forecasting and budgeting, Claim Processes, Accounts Receipts, Payments, General Ledger, Journal Voucher, Petty Cash Voucher. The main objective was to enhance the services capabilities to the customers.
• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Generated stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects. Environment: MS SQL Server 2005, MS Access, DTS, Erwin 4.1, SQL Query Analyze, VB.NET, Crystal Report