Bhattarai, Charu

Chicago, IL

773-***-****

aco6zy@r.postjobfree.com

Objective:

I am pursuing a career in Information Technology that utilizes my experience while opportunity to

expand my knowledge gains and growth within an organization.

Academic Qualification

• BACHELORS IN COMPUTER ENGINEERING

Technical Certification:

• Querying Microsoft SQL Server 2012

• Administering Microsoft SQL Server 2012 Databases

Currently Pursuing: Implementing a Data Warehouse with Microsoft SQL Server 2012

Technical Skill:

Operating Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008,

Systems Unix, Linux,

Databases SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE

10g/11g, MySQL

Database Tools Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server

Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio

ETL Tools SQL Server Integration Service (SSIS), Informatica, ab-natio

Page 1 of 8

Languages SQL, T-SQL, PL/SQL,C#, .NET, Java, HTML, JavaScript, Jquery, PHP, XML

Reporting Tools SQL Server Reporting Service (SSRS), Cristal Report

Office Tools MS WORD, MS EXCEL, MS VISIO, MS Project and MS Power Point (2003,2007,2010)

Summary Of expertise:

• Over 7 years of Professional experience in Information Technology and over 6 years in database design,

development of MS SQL SERVER 2000/2005/2008/2008 R2 with Business Intelligence tools SQL MS Server

Reporting Services (SSRS), MS SQL Server Integration Services (SSIS)

• Expert in creating Parameterized Reports, Drill through and Drill Down reports, Tabular reports,

Linked Reports, Sub-Reports using MS SQL Server Reporting Services.

• Ability to prioritize and complete multiple tasks and detail oriented, quick learner, self driven, strong team

player, hard worker. Willing to take responsibilities

• Strong working knowledge in Reporting Services Architecture, Report Designer, Report Builder, Report

Manager, Scheduling report and Publishing a Report.

• Strong working knowledge of Microsoft SQL Server with skills in query writing and performance tuning.

• Strong working knowledge of Data Visualization in SSRS.

• Execute data mining techniques for advanced analysis of data and report generation.

• Experience in Installing, Upgrading, managing, configuring, migrating and troubleshooting MS SQL

Server

• Worked extensively on TSQL Code, including complicated joins and cursor loops, creating indexes for

fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.

• SQL performance tuning by modifying SQL or adding/changing indexes.

• Actively involved in Normalization (3NF) & De-normalization of database.

• Support an internal team of Developers, Designers and test engineers.

• Conducted research to collect and assemble data for databases .

• Analyzing legacy System data to migrate data from old system to new system

• Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table,

Attributes, Hierarchy, Fact Table, Lookup Table.

• Involved in different kinds of Data Model Instance and they are Conceptual Design,Logical Design and Physical Design.

• Creating Exception Report after comparing Data source and destination.

• Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis,

Design, Development and Implementation.

• Experience with large-scale relational databases

• Good Knowledge of normalization/de-normalization of database tables, developing (DDL) and (DML)

and building referential integrity for the (RDMS)

• Performs database development and maintenance tasks.

• Designs and develops databases structures, scripts, transformation (ETL) scripts and common components

• Good understanding of ACID properties, Locks, Recovery model

• Good knowledge of making SSAS Cubes and can writes MDX query as well

• Understanding of data warehousing concepts such as Cubes, Fact Table,

Dimensions Table, OLTP, OLAP

• Experience in writing SQL Queries, TSQL, Stored Procedures, Views, Functions, Indexes, and database

Triggers.

Page 2 of 8

• Experience in designing and developing SSIS packages for loading data from Oracle, text files, Excel, Flat

files to SQL Server database.

• Good understanding of developing Star Schema, Snow flake Schema and Dimensional Data modeling

using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.

• Expert in creating packages for migration of the data from one source to different destination using SSIS and

Handling error with Event handler using SSIS

• Experience in the design, development and implementation of RDBMS using MS SQL and using oracle

8i/9i as well.

BI Developer/Database Analyst August 2013 – February 2015

Accretive Health, Chicago, IL

Accretive Health is one of the companies associated with health care providers to strengthen the financial stability of

healthcare providers through excellence, best people and leading technology, thereby increasing healthcare access for

all. Accretive Health is the single most important company to strengthen the financial position of healthcare provider’s

lies in a dramatically improved, end-to-end, technology-underpinned execution of the Revenue Cycle with innovative

technologies and dedicated people.

Responsibilities

• Experienced in Data Modeling used to define and analyze data requirements needed to

support the business processes within the scope of corresponding information systems in organizations.

• Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using

expressions to calculate, group, filter, and parameterize report using SSRS.

• Review reporting outputs for transparency, consistency, and accuracy.

• Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the

requirements of the business users and application development.

• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and

quarterly Reports including current status.

• Developed Strored Procedures for the DataSet to build the reports for the client

requirements.

• Created SQL Joins, sub-queries and other SQL code to implement business rules.

• Performance tuning, and optimization of procedures and queries.

• Used DBCC commands for Database maintenance (Rebuilding Indexes).

• Worked with the use of Data Modeling Standards for all projects requiring a standard

means of defining and analyzing data within an organization, to manage data as a resource, for the integration of information

systems, for designing Databases/Data Warehouses.

• Installation and configuration of SQL Server 2008 R2

• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS

Excel, SQL Server 2008 and Flat files.

• SSIS packages to update tables with monthly data and automated it through scheduled

jobs for the beginning of every month.

• Created reports using stored procedure. Involved in scheduling, creating snapshots and

subscriptions for the reports using SSRS 2008 R2.

Page 3 of 8

• Designed packages which utilized tasks and transformations such as Execute SQL Task,

Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.

• Developed packages in SSIS with error handling.

• Created Package Configurations to deploy packages from development to production

server.

• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling

large volume of data from various data sources using BCP in staging database from MS Access, excel.

• Involved in creating report models and applying row level security filters for report model.

• Experienced in participating meetings with business users to gather the requirements.

• Involved in the analysis of existing database structures and creating the new tables and

views as per the requirements.

• Worked with development teams in the design of physical databases and in modification.

• Involved in the process of Data Modeling which includes professional data modelers working

closely with business stakeholders, as well as potential users of the information system.

• Creating Star Schema, Snow Flake Schema using the concept of data Modeling.

• Experienced in Dimensional Data Modeling and some of the terms commonly used are

Dimension Table, Attributes, Hierarchy, Fact Table, Lookup Table.

• Involved in different kinds of Data Model Instance and they are Conceptual Design,Logical Design

and Physical Design.

Environment: MS SQL Server 2008/2008R2, SQL Server Integration services (SSIS), SQL Server Reporting Services

(SSRS), SQL Server Analysis Services (SSAS),T-SQL, Microsoft Office 2010, OLAP, MS Visio.

SQL Server Developer/BI Developer February 2011 – June 2013

Grant Thornton, Oakbrook, IL

Grant Thornton Specializes in auditing, management consulting, corporate finance, risk management and information

technology. It works with clients to improve their overall financial reporting processes to help them better understand

their business and keep informed all year long of accounting, financial and regulatory developments that may impact

their business.

• Created User Defined Functions, Views, stored procedures as per business requirements

• Optimized the performance of queries with simplifying queries like removing unnecessary columns, eliminated

redundant and inconsistence data

• Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the

other using FTP tasks

• Performed Normalization and De-Normalization techniques from both OLTP and OLAP system in creating

Database objects

• Used control flow tasks like For Loop Container, For each Loop Container, Sequential Container, Execute Tasks,

Email task and different Data Flow Tasks

• Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes,

Hierarchy, Fact Table, Lookup Table.

• Involved in different kinds of Data Model Instance and they are Conceptual Design,Logical Design and Physical

Design.

• Worked on Transforming and Loading data using SSIS Import/Export wizard

• Developed Tabular Reports, Sub-Reports, Matrix Reports, Drill down Reports and charts using SSRS

• Performed sorting, formatting and grouping to custom reports in SSRS and also published reports to the report

server virtual directory

Page 4 of 8

• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers

• Hands on experience with developing reports using SSRS

• Interacted with Developers in troubleshooting application and Report Developing

• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term

extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task 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

• Tuned several slow running queries in Production. Implemented Indexes to achieve time performance

Environment:

SQL Server 2005/2008, Windows 2003/XP, Enterprise Manager, SSIS, SSRS, SSMS, SQL Profiler, T-SQL

Database Developer December 2009-February 2011

Verisk Health, Richmond, Virginia

Verisk Health is a leading provider of data services, analytics, and advanced technologies that answer the

industry’s most complex challenges. With a focus on reducing risk across all domains of healthcare, Verisk

Health’s broad solution suite is designed to help health plans, employers, providers, and other risk-bearing entities

improve the quality of healthcare delivery, reduce costs, ensure appropriate revenue, pay claims accurately, and

support compliance.

• Responsible for optimizing queries for reports which take longer time in execution with SQL Server

2008/2005.

• Created Complex ETL Packages using SSIS to extract data from OLTP database to staging tables to

partitioned tables with incremental load.

• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into

SQL Server Database.

• Developed, deployed, and monitored SSIS Packages.

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle),

Excel Spreadsheet to SQL Server 2005/2008.

• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL

Server.

• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format

data) to SQL Server.

Page 5 of 8

• Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension

Table, Attributes, Hierarchy, Fact Table, Lookup Table.

• Involved in different kinds of Data Model Instance and they are Conceptual Design,Logical Design and

Physical Design.

• Design and normalize the databases and created different objects like tables, views, Stored Procedures,

UDF’s, indexes rules and defaults on MS SQL server.

•Involved with Transact SQL (T-SQL) Coding, writing queries, functions & triggers.

•Worked with production Support Team to Hot Fix the critical Issues.

•Created complex SQL queries using table joins (inner and outer), temporary tables and table variables.

•Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using

SQL Server Reporting Services (SSRS).

•Experience in deploying and scheduling the reports based on quarter, month, and year reports.

•Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).

•Developed, monitored and deployed SSIS packages.

•Worked on Excels to upload the data from excels to database.

•Responsible for implementation of data viewers, error configurations for error handling of the packages.

•Optimized long running Stored Procedures and Queries for effective data retrieval.

•Optimized queries by looking at Execution Plan for better tuning of the database.

•Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and

XML files and migrating the data into destination using SQL Server Integration Services (SSIS).

•Handlers in SSIS packages

•Implemented Event Checkpoints to rerun the failed package from the point of failure.

•Responsible for creating user groups and assigning permissions.

•Created DTS packages to transfer objects from development server to production.

•Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy

for SQL Servers.

SQL Server Developer July 2008– September 2009

Page 6 of 8

Standard Chartered Bank, Kathmandu, Nepal

Standard Chartered PLC is a British multinational banking and financial services company headquartered in London. It

operates a network of more than 1,700 branches and outlets across more than 70 countries.

Responsibilities

• Design and normalize the databases and created different objects like tables, views, Stored Procedures,

UDF’s, indexes rules and defaults on MS SQL server.

• Involved with Transact SQL (T-SQL) Coding, writing queries, functions & triggers.

• Created complex SQL queries using table joins (inner and outer), temporary tables and table variables.

• Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using

SQL Server Reporting Services (SSRS).

• Experience in deploying and scheduling the reports based on quarter, month, and year reports.

• Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).

• Developed, monitored and deployed SSIS packages.

• Worked on Excels to upload the data from excels to database.

• Responsible for implementation of data viewers, error configurations for error handling of the packages.

• Optimized long running Stored Procedures and Queries for effective data retrieval.

• Optimized queries by looking at Execution Plan for better tuning of the database.

• Experience in developing ETL packages with the different sources as Flat Files, Excel, Text files, and

XML files and migrating the data into destination using SQL Server Integration Services (SSIS).

• Handlers in SSIS packages

• Implemented Event Checkpoints to rerun the failed package from the point of failure.

• Responsible for creating user groups and assigning permissions.

• Created DTS packages to transfer objects from development server to production.

• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy

for SQL Servers.

• Setup and maintained Linked Servers.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services

(SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

System Administrator July 2007 – March 2008

Rosebud School, Kathmandu

• Diagnose hardware and software problems, and replace defective components.

• Perform data backups and disaster recovery operations.

• Maintain and administer computer networks and related computing environments, including

computer hardware, systems software, applications software, and all configurations.

• Plan, coordinate, and implement network security measures in order to protect data, software,

and hardware.

• Operate master consoles in order to monitor the performance of computer systems and

networks, and to coordinate computer network access and use.

• Perform routine network startup and shutdown procedures, and maintain control records.

• Design, configure, and test computer hardware, networking software and operating system

software.

Page 7 of 8

• Recommend changes to improve systems and network configurations, and determine hardware

or software requirements related to such changes.

• Confer with network users about how to solve existing system problems.

• Monitor network performance in order to determine whether adjustments need to be made, and

to determine where changes will need to be made in the future.

• Train people in computer system use.

• Load computer tapes and disks, and install software and printer paper or forms.

• Gather data pertaining to customer needs, and use the information to identify, predict, interpret,

and evaluate system and network requirements.

• Analyze equipment performance records in order to determine the need for repair or

replacement.

• Maintain logs related to network functions, as well as maintenance and repair records.

• Research new technology, and implement it or recommend its implementation

• Maintain an inventory of parts for emergency repairs.

• Coordinate with vendors and with company personnel in order to facilitate purchases

Page 8 of 8

Contact this candidate