Sql Server Data
Resume:
Roshni
Employer Details : Ronald,973-***-****,*******@**********.***
Professional Summary:
Over 7+ years of IT experience as a MS SQL Server Developer 2008R2/2008/2005/2000 in
various Industry verticals like Real Time Crime Data, Public Data, Human Resources,
Retail, Health Care, Bank, Finance
Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems
Analysis, Design, Development and Implementation.
Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS
SQL Server Reporting Services, and MS SQL Server Analysis Services.
Experience in Logical and Physical Database design & development, Normalization and
Data modeling using Erwin data model.
Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers,
Tables, Views, User Functions, User profiles, Relational Database Models and Data
Integrity, SQL joins and Query Writing.
Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the
Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS
Access.
Extensive experience working with BCP, SSIS packages, creating jobs and linked servers
for MS SQL Server/Oracle/ Sybase databases.
Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services
(SSIS).
Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
Extensive experience in writing Parameterized Queries for generating Tabular reports,
Formatting report layout, Sub reports using Global Variables, Expressions, Functions,
Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP
Cubes.
Experienced in writing MDX queries to work with cube data.
Expert in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows
performance for monitoring and tuning SQL Server performance.
Strong experience in Database Installation, Capacity Planning, Implementing Backup and
Recovery Strategy for application and database.
Maintained positive communications and working relationships at all business levels.
Education: Certifications:
Masters in Computer Science
Certifications:
Microsoft Certified Technology Specialist – Database Development
Microsoft Certified Technology Specialist – Business Intelligence Development System.
Skill set:
MS SQL Server 2008R2/2008/2005/2000, MS SQL Server 2008/2005 Analysis Services (SSAS),
MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Microsoft
Access 2000/8.0, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, Database
engine tuning advisor, Erwin Data Modeler 7.2/4.2/4.1, Excel VBA, Crystal Reports 8.5, T-SQL,
MS Visio 2005, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0
Server/Workstation.
Project Summary:
Microsoft Corporation Philladelphia, PA
RTCC ( Real Time Crime Center Philladelphia Police Department)
Dec 2011 – Present
MS SQL Server SSIS/SSRS Developer
The Real Time Crime Center (RTCC) is the first centralized technology center for the
Philadelphia (PPD). Its primary purpose is to give field officers and detectives instant and
comprehensive information to help identify patterns and stop emerging crime. The Real Time
Crime Center (RTCC) is the first of its kind anywhere in the world of law enforcement
Responsibilities:
Working experience with agile methodology.
Gathered requirement and created document for further reference.
Developed SSIS package to load data from different databases to SQL Server. Like
Sybase, Oracle, DB2, SQL Server, Excel, Flat File, FTP Server.
Used different Task to accomplish the requirement.
Created data flow with different transformation Like Derived Column, Lookup, Conditional
Split,
Used Script component to call Web Service.
Developed Package with Fuzzy Lookup and fuzzy groping transformation.
Created package for full load as well as incremental load.
Used Variable to store values of parameters.
Created SQL Query using expression to access data.
Developed package for Geocoding address using Script transformation.
Developed package to run continuously.
Scheduled Package to run on schedule using SQL Server Agent Job.
Created package configuration and stored configuration in to Environment variable to
make package dynamic.
Deployed package to different server.
Worked on performance tuning of SSIS Package.
Used expression to format columns using derived column transformation.
Created different kind of report like parameterized report, sub reports, tabular report using
SSRS-2008R2.
Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized
reports using SSRS 2008R2.
Deployed report to different server.
Worked on subscribing and scheduling of SSRS report.
Used cached and snapshot for performance tuning.
Used stored procedure and complex queries for creating dataset
Responsible for performance tuning of SSRS report.
Expertise in performance tuning of T-SQL queries using Sql server profiler, query analyzer.
Used complex T-SQL queries, Joins, Common Table Expression (CTE),
Derived Table, Views, User Defined Function
Configured the report viewing security for various users at various levels using Report
Manager
Environment: SQL Server 2008R2, SSRS, MS Excel 2003/2007, MS Visual Studio 2008,
Windows Server 2008, MS Outlook 2010
United Technologies, Windsor, CT
Aug 2011- Dec 2011
MS SQL Server BI Developer (SSRS)
United Technologies Corporation is a diversified company whose products include Carrier heating
and air conditioning, Hamilton aerospace systems and industrial products, Otis elevators and
escalators, Pratt & Whitney aircraft engines, Sikorsky helicopters, UTC Fire and Security system
and UTC power fuel cells.
Responsibilities:
Gathered requirement and created document for further reference.
Created different kind of report like parameterized report, sub reports, tabular report using
SSRS-2008.
Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized
reports using SSRS 2008.
Responsible for Design, Develop and Deploy of reports in MS SQL Server environment
using SSRS-2008.
Scheduled the report on yearly/quarterly/monthly/weekly basis to run automatically.
Expertise in subscribing and scheduling of SSRS report.
Schedule the reports using different rendering format according to the requirement.
Created report with different methods of retrieving dataset like using stored procedure,
writing complex queries.
Developed interface and reporting stored procedures, views, UDF for efficient data storage
and manipulation
Responsible for performance tuning of SSRS report.
Expertise in performance tuning of T-SQL queries using Sql server profiler, query analyzer.
Expertise in writing complex T-SQL queries,Joins, Common Table Expression (CTE),
Derived Table, Views, User Defined Function
Configured the report viewing security for various users at various levels using Report
Manager
Fine tuned SQL Queries for maximum efficiency and performance.
Created report model project for report builder reports and responsible for helping the
clients for report builder reports.
Provided documentation for all kinds of reports and report builder reports.
Designed and implemented Stored Procedures and Triggers for automating tasks.
Environment: SQL Server 2008, SSRS, MS Excel 2003/2007, MS Visual Studio 2008, Windows
Server 2003, MS Outlook 2010
Edifice Information Management, Parsippany, NJ
Sep 2010-Aug 2011
MS SQL Server BI Developer (SSIS/SSRS)
Edifice is an information services company specializing in the collection, analysis and distribution
of point-of-sale data used by retailers and suppliers to improve their supply chain efficiencies.
Enable collaboration between retailers and suppliers by providing quality analysis, POS reporting,
analysis training, and support services.
Responsibilities:
Planned, Defined and Designed data based on business requirement and provided
documentation.
Gathered data and documenting it for further reference.
Designed Database using Erwin data modeler.
Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort,
Multicasting, Cache Transform, Conditional Split and Derived column etc.
Developed SSIS Packages using Look Up Values & implementing rules provided by
Business in the mapping document.
Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing
purpose.
Used SSIS Variables for storing the values which are used in various components of Data
Flow Task.
Developed Unit Test Plans for SSIS packages for checking the functionality of each
component.
Modified the existing SSIS packages to meet the changes specified by the users.
Scheduled Jobs for executing the stored SSIS packages which were developed to update
the database on Daily basis.
Created the Load packages for loading the CSV files, Flat files into SQL Server using
SSIS 2008.
Generated parameterized reports, sub reports, tabular reports using SSRS-2008.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-
2008.
Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized
reports using SSRS 2008.
Created reports to retrieve data using Stored Procedures that accept parameters.
Scheduled the monthly/weekly/daily reports to run automatically.
Responsible for Monitoring and Tuning Report performance.
Configured the report viewing security for various users at various levels using Report
Manager
Scheduled report and exported in PDF format.
Fine tuned SQL Queries for maximum efficiency and performance.
Provided documentation for all kinds of reports and SSIS packages.
Designed and implemented Stored Procedures and Triggers for automating tasks.
Environment: SQL Server 2008, SSRS, SSIS, MS Excel 2003/2007, MS Visual Studio 2008,
Windows Server 2003, MS Outlook 2010, Erwin 7.2
Alloso Technologies Raleigh-NC
Oct 2009-Sep 2010
MS SQL Server Developer (SSIS/SSRS)
Reduce or eliminate the need for management company equipment and networks at
hotels.Improve performance, Stability, and Flexibility through virtualizations.
Responsibilities:
Worked as a developer in creating complex Stored Procedures, Triggers, Functions,
Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Developed various T-SQL stored procedures, functions and packages.
Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel)
to SQL Server databases using SQL Server Integration Services (SSIS) to overcome
transformation constraints.
Used SSIS jobs for importing data from the flat files that brings the data to the application
tables.
Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns,
Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and 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.
Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in
SSAS.
Working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
Developed complex calculated members, Named Sets using MDX expressions for specific
OLAP reporting requirements.
Created KPI Objects in line with Requirement Docs in SSAS.
Optimized cubes for better query performance.
Aggregated cube with 30% performance for better performance.
Processed cube to perform incremental updates.
Created reports by dragging data from cube and wrote MDX scripts in SSRS.
Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data
sources.
Designed and deployed report with Drill Down, Drill Through, Dropdown menu option,
Parameterized and Linked reports.
Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly
and quarterly Reports including current status.
Prepared the Layouts by placing the fields to the appropriate place according to the
requirement of the final Report.
Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects
to designated Managers and Clients.
Used Database engine tuning advisor, SQL Profiler for Performance Tuning.
Environments:SQL Server 2008/2005, SSRS, SSIS, MS Visual Studio 2008/2005, Windows
Server 2003, MS Visio 2003
Merck,Rahway, NJ
Aug 2008- Sep 2009
Business intelligence system developer
Merck is a global healthcare leading group. It supplies medicines, vaccines, biologic therapies,
customer health and animal product.
Responsibilities:
Designing Data Model and implementing changes in the earlier phase of the project to
accommodate business logic and dynamic nature of the front end application.
Designed and modeled Microsoft SQL Server 2008 data warehouse and data marts,
including the modification of existing Microsoft SQL Server 2005 data warehouse and data
marts.
Used SSIS packages to roll our data to Live Tables and to Processing Database.
Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using
T-SQL, SQL Analyzer and Enterprise Manager
Configure the SSIS Package for run time Parameters and Config file
Develop the Documents for Logging/Error Handling for SSIS Packages
Integrate the SSIS package, converting all existing DTS packages of MS SQL 2005 to
2008 by adding extra SSIS task.
Schedule Package using SQL Server Job for weekly/monthly basis.
Used Checkpoint for avoiding re-executes Package from the first task.
Develop the Slowly Changing Transformation to maintain the Historical Data.
Handling the errors during data moving and Sequencing the task as per requirements.
Developed packages using fuzzy task for data cleansing.
Handling the orphan rows in Dimension and Fact tables.
Participated actively in analysis and discovery phases of data warehouse implementation.
Perform T-SQL tuning and optimizing queries for Reports which take longer time in
execution SQL Server 2008.
Developed interface and reporting stored procedures, views, UDF for efficient data storage
and manipulation
Migrated some Crystal reports to SSRS reports manually
XML result set from Stored Procedures to create custom XML file for third party data
export.
Extensive work on SSIS creating all the interfaces between front end application and SQL
Server 2008 database, then from legacy database to SQL Server Database and vice
versa.
Environment:SSIS, MS SQL Server 2008, Windows 2003,MS Visio 2003
EIS Tech, Atlanta, GA
Jun 2007- Jul 2008
MS SQL Server Developer/SSAS/SSRS Developer:
EIS Technologies offers both IT services and products. EIS engagements include assessments,
implementations, upgrades, managed services and support. EIS express suite of products provide
compressive analytics, dashboards, operational and ad hoc reporting built on auto generated
business views. Provides Business intelligence reporting services for Financials,E-business
projects, E-Business supply chains.
Responsibilities:
Designed Staging Database using ER-win and SSAS Wizard.
Involved in requirements gathering, analysis, design, development, change management,
deployment.
Installed and Configured SQL Server 2005 successfully.
Involved in Login and User Management- Adding logins, roles, groups to the Window NT
and SQL Server and maintaining proper security procedures.
Involved in ER diagrams (Physical and Logical using ERWIN) and mapping the data into
database objects.
Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
Using SSIS package for effective data transfer.
Developed measures and dimension table using SSAS service.
Created calculation member and name set using MDX queries for better result in cube.
Developed KPI’s for business performance.
Utilized SSRS reporting services to generate different types of reports from the database.
Performed Data Analysis for automating various Customers Order Reports utilizing SQL
Reporting Services.
Involved in design, programming, deploy and Unit Testing of requested Reports.
Worked with the Data Architect to migrate legacy data into the new analysis data mart and
created reports for inventory module.
Expertise in Database creation (DDL, DML), database tuning, SQL tuning, performance
planning, backup planning and database administration.
Evaluated database performance and performed maintenance duties such as tuning,
backup, restoration
Environments:MS SQL Server 2005, T-SQL, SSIS 2005, SSRS 2005, SSAS 2005, Erwin 4.2
Wells Fargo, CA
Jun 2006 – May 2007
MS SQL Server Developer/SSIS:
Project Description: The Wells Fargo provides a full range of commercial & individual financial
products and services. Wells Fargo primarily engages in audit, tax and advisory services. This
project was to about develop successful audit system using back-end sql server.
Responsibilities:
Participated in developing logical model and implementing requirements on SQL Server
2005.
Created the database for the reporting team.
Data Migration from Oracle Database and flat files into SQL Server 2005 using SSIS
Packages and BCP.
Solved T-SQL performance issues using Sql server profiler.
Created and managed schema objects such as Tables, Views, Indexes, Procedures and
Triggers.
Created Backup and Restore operations for migrating database from one server to
another.
Created Database Triggers to implement business requirements.
Expertise in creating complex Stored Procedures and Functions to support the front-end
application.
Optimized SQL queries for improved Performance and availability.
Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized
and reduced Data Redundancy, maintained the required level of security for all production
and test databases.
Ensured Data Recovery, Maintenance and space requirements for physical Database.
Reorganize database structures as needed, automate procedures at regular intervals.
Optimized long running Stored Procedures & Queries for effective data retrieval.
Environments: MS SQL Server 2005, SSIS 2005
Bank of Baroda –Gujarat- India
Jun 2005- Jun2006
MS SQL Server Developer:
BANK OF BARODA is INDIA largest private sector bank. Worked on retail collection system, a
GUI based client/server bill collection software, to assist brokers in carrying out their daily
transactions. Implementation of user login and security was developed.
Responsibilities:
Installed and configured SQL server 2000, created logins, users and maintenance plans
managing use of disk memory and connections to the database.
Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using
DTS, T-SQL, Stored Procedures and Views).
Used ER-win, Normalization, Dimension Modeling and Enterprise Manager for Logical and
physical database development.
Imposed Referential Integrity of data by creating different constraints.
Migration of the data from text files to SQL Server database using BCP and SSIS
packages for the processing of different policies.
Managed and Monitored System Utilization.
Created triggers, stored procedures and functions using T-SQL to implement the business
logic.
Designed and Implemented the Stored Procedures and Triggers for automating tasks.
Environments:MS SQL Server 2000, Windows Server, Windows NT, .NET, Erwin 4.1
Contact this candidate