Sql Server Data
Resume:
Bhattarai, Charu
Chicago, IL
***************@*****.***
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