PROFESSIONAL SUMMARY:

• Above 5 and half years of professional experiences with expertise in analysis, designing, developing and maintaining OLTP Databases, Data warehouses using MS SQL Server 2008 R2/ 2005/ 2000 and implementing end-to-end ETL strategies along with Analysis Services and Reporting Services in development, testing & production environment.
• Adept with Data Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Expert in OLTP relational data models and OLAP dimensional models.
• Expert in ER-diagrams and normalization processes for designing Databases and Data Warehouses.
• Proficient in creating Tables, Stored Procedures, Indexes, Views, Functions, Triggers and other user defined functions to optimize and improve response time to meet the business requirements.
• Used automation for Database Maintenance tasks by creating Jobs and Alerts using SQL Server Agent.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Involved in creating end-to-end ETL strategies that includes extracting, transforming, conforming and loading.
• Skilled in designing, configuring, programming and testing end user reports
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports,ad-hoc Reports and Charts using SSRS based on Relational and OLTP databases.
• Proficient in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.
• Involved in SDLC methodologies and gathering business requirements through JAD sessions, System Analysis, developing and testing Database design and its maintenance.
• Excellent communication and interpersonal skills, self motivated, quick learner and determination to learn new technologies, strong Team player with excellent interpersonal and team work skills.

Technical Skills:

Databases: SQL Server 2008, 2005, 2000 & 7.0, MS-Access 2000/2003/2007
Database Tools: Management Studio, SQL Server Profiler, SSIS, SSAS, SSRS, DTS,MS Access ,Business Intelligence Development Studio
Languages: T-SQL,C, C++, VB, XHTML, XML, Familiar with UNIX
OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP
Web Servers: IIS 5.0, Apache Tomcat
Other Tools: Erwin, Microsoft Visual Studio 2003/2005,2008, Microsoft Visio
Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Confidential, MO Dec 2010-Aug 2011
SSIS/SSRS Developers

Confidential, is leading community bank serving customer throughout Missouri and Kansas. It provides wide range of product and services to meet the need of commercial consumers and small business customers. The project was to move efficiently the data from its old system to master data management platform .One of the major responsibility involved creation of ETL Strategy to extract the data from old mainframe system and deposit in to Master database platform.

Responsibilities:

• Participated in meetings and provided think tanks to develop conceptual database design, normalization and improve functionality and achieve optimal performance.
• Involved in creating conceptual, logical and physical model by using Erwin tool. Forward Engineered OLTP Database to SQL 2008 Server.
• Involved in identifying the source system and creating mapping documents based on the schema comparison from DB2, Excel, CSV and flat files.
• Involved in Changed Data Capture and Aggregations during ETL process.
• Created SSIS packages for processing data and moving to staging area for massaging and data scrubbing.
• Used Conditional split, Derived column and Data Conversion task for cleaning the data.
• Used Sort task to merge the data and loaded in the final database and event handling and loggings to handle an error.
• Created Stored Procedures, views and user defined functions.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created reports, drilldown reports according to requirement and for day to day analysis purpose by creating store procedure and views and deployed them on SSRS server.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent.

Environment: SQL Server 2005/2008 R2, Business Intelligence Development Studio (BIDS), SSIS, SSRS, ER-Win, Windows Server 2008 R2.

Confidential, MO Mar 2010-Jul 2010
SQL Server/SSIS Developer

Confidential, is a largest health insurance provider in Kansas City area. It offers health empowerment and trust support to millions of people in Kansas City area. The project included implementation of enterprise graded ETL solution to help it scale, as well as faster data processing.

Responsibilities:

• Involved in designing logical and physical database by using Erwin tool for dimensional modeling (Star schema) and further forward Engineered Data Model of Staging Database to SQL 2005 Server.
• Created and implemented a stored procedure to perform database maintenance tasks like index rebuilds.
• Created SSIS package to clean and load a data to data warehouse.
• Used SSIS Packages to extract transform and load data from multiple input sources like Excel files, Production SQL Servers into SQL Server Staging Database.
• Created complex stored procedures to perform data profiling in the pre-staging database.
• Implemented various types of SSIS Transforms in Packages including Slowly Changing Dimension, Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column, Script Component Source, Script Component Destination, etc.
• Promoted SSIS Packages from Test Environment to Production Environment by maintaining multiple package configurations in SSIS.
• Created ad-hoc Reports using SQL 2005/2008 Server Reporting Services.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.

Environment: SQL Server 2005, Business Intelligence Studio (BIDS), SSIS, SSRS, ER-Win, Windows Server 2003 R2

Confidential,, UT May 2009-Oct 2009
SSRS Developer

1-800 contacts is world leader in retail business of the contact lenses. Company maintains the inventory of 20 millions contact lenses and on an average sells about 150,000 replenishment contact lenses. Project involved implementing data marts for their day to day operations. By analyzing the data in the warehouse, the management would be able to measure their marketing and promotion, and decide on future actions to improve operations.

Responsibilities:

• Used SQL Server 2005 to create and alter queries for data management
• Used SSIS Packages to extract, transform and load data from multiple input sources like flat files and excel sheets into SQL Server 2005 Staging Database.
• Experience in developing SSIS packages to extract data from various sources, transform them and loading to data marts.
• Was responsible for detecting errors in ETL Operation and rectify them.
• Used SQL Server Agent for creating, maintaining and scheduling Jobs.
• Was responsible for detecting errors in ETL Operation and rectify them.
• Created reports using SSRS (SQL Server Reporting Services).
• Configured and maintained Report Manager and Report Server for SSRS.
• Designed Cubes and involved in Cube processing in SSAS.
• Created ad hoc reports using Reporting Services 2005.
• Improved the performance of stored procedures and SQL scripts considerably.
• Documented the entire database design for two projects and entire ETL process.

Environment: SQL server 2005, SSIS 2005, SSAS 2005, SSRS 2005, Windows Server 2003,Microsoft Office 2007 (Word, Excel, Visio), Flat Files, Windows XP and Vista

Confidential, Nepal Feb 2006-Nov 2007
Database Developer

Confidential, was establishing with the aim to address the acute need of total comprehensive cancer care in Nepal. The Project involved creation of Data Base objects like tables, triggers, views, Stored Procs for the support of front-end applications and populate the tables and databases with BCP, DTS technologies from heterogeneous sources like text files, excel sources without violating the consistency checks of the databases.

Responsibilities:

• Designed and developed data structures to store enterprise data in a SQL Server 2000 enterprise environment.
• Maintained databases, including updating statistics, re-indexing, structure modifications and index analysis.
• Created database objects like a pre staging database tables and relations to import the required data from OLTP and cleansed it.
• Implemented logical model/physical design and forward engineered it to SQL server using ER Win.
• Created stored procedures that will audit several databases and inform of any changes in them.
• Assisted software engineers and end users with query writing, database access, and general information about source and relational warehouse tables and dimensions.
• Used data source view wizard in business intelligence development studio to define a data source view in SQL Server.
• Involved in creating several ad-hoc reports in support of management needs as well as scheduled the deployment of reports and modified their appearances.
• Completed transaction analysis and performance tuning of database applications and batch processes.
• Defined technical requirements and data architectures for the data warehouse and involved in the documentation of the development team deliverables.

Environment: SQL Server 2000, SQL, MS Visio, ERWIN, and Windows 2000, DTS

Confidential, Nepal Oct 2003-Jan 2006
Database Developer

Confidential, is Nepal's one of the leading commercial bank, providing services like ATM, credit/debit card operation, 365 days of banking, SMS banking and further more. The project involved maintenance of customer information for the purpose of making decisions, such as loan approvals etc. Back-end work included writing and modifying Stored Procedures and Triggers.

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned the SQL queries using hints for maximum efficiency and Performance
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
• Reports developed using SQL server Reporting services.
• Designed the Logical and Physical design of database for projects on basis of user requirements.

Environment: Windows 2000 Server, MS SQL Server 2000, T-SQL.

Education:
MBA, major in Management Information System

References:
Available upon request.