Summary:

• Over 7 years of extensive experience in data warehouse complete life cycle using SQL Server 2000/2005/2008 R2 suite of products SSIS/SSRS.
• Hands on experience in SQL Server DTS and SSIS (Integration Services) package design, constructing, and deployment.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008 R2.
• Conversant with all phase of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Expert in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008 R2.
• Experienced in writing Stored Procedure/TSQL coding, Performance Tuning, Physical and logical Database Design, and Triggers.
• Successfully migrated content from SQL server 2000 to SQL server 2005, SQL Server 2005 to SQL server 2008.
• Experienced in connecting to database components using C#, VB.NET for Data Access.
• Expert in designing, maintaining & tuning various RDBMS such as SQL Server 2008 R2/2005/2000.
• Experienced in deploying the cubes on the Analytical Server and connecting the cube objects with various cubes.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Strong understanding of finance module and loan center application. Performed dynamic calculations, developed, reviewed, and optimized queries in SQL Server.
• Excellent communication, analytical, personal skills and ability to learn new concepts.
• Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well.

TECHNICAL SKILLS
MS SQL Server 2000/2005/2008, SQL Server Integration Services ,SQL Server Analysis Services, SQL Server Reporting Services, C#.NET, VBScript, OLAP,OTLP,ODBC,MS Access, C, C++, Windows NT/2000/XP/Server 2003, T-SQL, PL/SQL, HTML.

Professional Experiences:

Confidential, DE feb12– Till date Role: IT Analyst
Credit Risks Authorization Decision Engine (ADE) structure and flow makes Credit and Fraud Authorization decisions to Approve, Decline, and Grant Additional Credit above the Credit limit or hold below the Credit Limit based on the customer profile. It also decides the suspected fraud authorization to Decline or Approve or Queue. This application enables to deploy the Credit probability to improve the credit decision and deploy new strategy flow and robust econ evaluation. It impacts 52MM/month benefits on top of initial Rule set release. I am working on 
Projects:

• REISSUE
• Overlimit & Delinquent Decline
• Fraud Authorization
• Control Zones
• Holiday Management Strategy

which involves extracting Provider data from external sources, Scrub and standardize and load it in to Master Data Management (MDM) and used Written SQLs to pull the data for business needs and Send them as reports to SSD on timely and Ad-hoc/Dynamic basis

Responsibilities

• Working in close with Business and addressing the data requirements for Analysis.
• Created Stored Procedures, Triggers, Views and Functions for the application.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries and Stored Procedures.
• Created a SSIS package which acts a template with built in features for Auditing and Error Handling
• Used Import/Export wizard to move data into multiple servers
• Created batch files for the SSIS packages to execute from the command line
• Scheduled SSIS packages to run on a scheduled basis using Windows scheduler to do Benchmark testing
• Worked closely with BA during the development of the Interfaces
• Created Technical specification documents for each SSIS package developed
• Wrote expressions on Precedence Constraints to validate the condition and go to next step
• Administered and monitored SSIS packages
• Developed several Complex Reports using SQL Server Reporting Services (SSRS).
• Created Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Efficiently used Configuration files while deploying packages to different servers for changing the connection manager
• Used SQL Multi script to create script of the tables and send it to different servers at a time

Hardware/Software:
MS SQL Server 2008, T-SQL, TFS, SharePoint, Red Gate Tools

Confidential, ID Nov2010-Dec2011 Role: SQL Server Developer
Confidential deal with complex social, economic and individual issues, often helping people in crisis situations. Our programs are designed to strengthen families and promote self-reliance.Last year, we served almost 340,000 people, one out of every four Idahoans. 
Project requirement: 
The project focused on developing a client specific data-mart that enables the company to prospect for new clients and track the activities of existing clients to better serve them and offer them additional products and services.

Responsibilities:

• Created SSIS packages to Extract data from different providers like NPPES, DEA, AMA in different formats and load to Sequence tables.
• Experience in working on tools like Satori, DQ Global, Net-Gender.
• Used SQL Packager, Red gate tool to create a .exe file of the Database and deploy it to Development and QA
• Created Automated Job Steps to process Weekly and Monthly data.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel,*.Txt file, *.CSV files
• Experienced in writing expressions based on Business Requirements.
• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008 R2.
• Involved in analyzing Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Experience in Parameterized, Dynamic and Static reports.
• Created complex Stored Procedures and Views to pull data into reporting services from the Databases .Governed and maintained performance and analysis portfolio of SSRS report.
• Developed, Prepared Unit Test documents for all SSRS reports.
• Developed several stored procedures to handle large amount of data manipulation.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Experience in Creating SSIS custom components by using C#.NET programming and have hands on experience on VB while writing Expressions in SSRS.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Created Technical specification documents for each SSIS package developed and involved in preparing detailed Technical Documentation.

Hardware/Software:
MS SQL Server 2008, T-SQL, TFS, SharePoint, Red Gate Tools 

Confidential,VA Apr2009-Oct2010 Role: IT Analyst
Confidential is an American consulting firm, with 80 other offices throughout the United States. It is recognized as one of the most prestigious technology consulting firms in the world .The project involved creating a database schema to perform analysis on the company performance for the past 2 years using SSAS and to generate various reports for sales and marketing department using SSRS

Responsibilities:

• Designed staging database using ERwin and SSAS wizard.
• Designed a new schema for the OLAP database.
• Generated cubes to perform analysis and created fact and dimension tables.
• Involved in defining referenced relationships with the measure groups and fact tables.
• Defined granularity within a measure group and drill through actions using SSAS.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Created Key Performance Indicator (KPI) objects in SSAS and created calculate member in MOLAP cube using MDX in SSAS.
• Created various parameterized reports, drill through reports using SSRS.
• Generated ad hoc reports using MS reporting services and crystal reports.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented Stored procedures and triggers for automating tasks.
• Scheduled jobs and alerts using SQL server agent.
• Implemented a well-planned backup and restore strategy that protects databases against data loss.

Hardware/Software:
MS SQL Server 2005/2000, SSAS, SSMS, SSRS, T-SQL, ERwin 4.2/4.1/4.0, MS Visio 2003, DTS, Enterprise Manger, Query Analyzer,Oracle 9i,0racle 10g.

Confidential,WA Jul2008-Mar2009
The project was to migrate data from MS SQL Server 2000 database to MS SQL Server 2005 database and generate reports to analyze company performance

Responsibilities:

• Created Database objects – Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Responsible for scheduling the subscription reports with the Subscription report wizard.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouse using SQL Server SSIS.
• Transformed data from MS SQL server 2000 to MS SQL server 2005 using OLE DB connection by creating various SSIS packages.
• Used the execute DTS package task to execute DTS packages.
• Created data transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Created SSIS packages to execute rules and load data to data warehouse.
• Wrote VB.NET or C#.NET code in script components in SSIS to validate the Data from Data base sources
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Merge, 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 packages to migrate data from different data sources to data warehouse.
• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis

Hardware/Software:
MS SQL Server 2005/2008, T-SQL, SQL Server Reporting services 2005/2008, SQL Server Integration Services 2005/2008.

Responsibilities:

• Carried out a developer’s role on MS SQL Server 2000, MS Access databases (using DTS, T-SQL, Stored procedures and Views).
• Worked on Logical and physical database development (using ER-win, Normalization, Dimension modeling and Enterprise manager).
• Involved in generating reports using third party tools.
• Worked on MS SQL server tasks such as data loading, batch jobs, BCP, DTS and indexes.
• Created and automated regular jobs such as daily/weekly report generations.
• Managed and monitored system utilization.
• Managed backup and disaster recovery of the systems.
• Managed the security of the servers,as a part of administration duties.
• Developed complex T-SQL code for the application.

Hardware/Software:
MS SQL Server 2000/7.0, Windows NT 4.0 Server, Windows NT, T-SQL, ERwin 4.0

Education:
Bachelor of Engineering