Sql Server Project Manager
Resume:
Name: Trilok S Takhi
Contact Number: 404-***-****
E-mail ID: acdejr@r.postjobfree.com
[pic]
Summary
. Nine plus years of extensive IT experience in requirements gathering,
analysis, design, database and ETL development, testing of various
applications.
. Relational Database Management System (RDBMS) Database design, Data
Migration and Database upgrade.
. More than six years specialized in Microsoft technologies primarily in
SQL Server 2008 R2/2005/2000 database development.
. Three years of experience in RDBMS database designing. Implemented
three projects. Experience in writing complex T-SQL queries, stored
procedures, triggers, views, cursors. Performance Tuning of T-SQL
queries, Index Performance tuning was also part of responsibilities.
. More than five experience on reports development using Seagate Crystal
Reports version 11. Two years on SQL Server Reporting Services.
. Sound knowledge on data warehouse concepts like Analysis Services,
Cubes, Data mart. Also understands the database models like Star
Schema, Snowflake and got training on Data Warehouse.
. Experience with Energy and Utilities, Manufacturing, Property and
Casualty Insurance, Retail industries and Professional Education
System.
. Experience in design and data modeling tools like MS VISIO and ERWin
. Exceptional problem-solver with keen ability to resolve technical
issues, provide for system enhancements, analyze/define business
processes for improvements in processes
. Excellent team player who listens, thrive on collaborating with
diversely talented team members, and integrates their divergent
thoughts, opinions, and perspectives into meaningful action
Technical Skill set:
Data Warehousing SQL Server Integration Services (SSIS
ETL Tools 2005/2008R2),
Data Transformation Services (DTS),
Informatica Power Center 8
Operating Systems Windows NT/ XP, Windows 95 / 2000 / 2003 /
2008R2,
Linux
Programming VB.Net,
Languages Visual Basic,
ASP.Net,
ASP
Databases SQL Server 2008 R2/ 2005 / 2000,
Oracle 9i/10g,
MS Access,
MySQL
Reporting Tool Seagate Crystal Reports,
SQL Server Reporting Services (SSRS),
Data Reports,
Structured Query Reporting (SQR)
Excel
Configuration Microsoft Team Foundation Server (TFS 2010),
Management Tool
Visual Source Safe 6.0,
PVCS
Scripting VBScript,
Java Script,
HTML,
OSQL using SQL Server 2008
Data Modeling Tool MS Visio
File Transfer Tool FTP
Educational Qualification:
1. Masters in Computer Applications (MCA) from Thapar Institute of
Engineering and Technologies, Patiala (Punjab), India.
2. Bachelors in Science (B.Sc.), Punjab University, Chandigarh, India.
Work Experience:
. Georgia Professional Standards Commission Dec, 11 - To date
. LPL Financials, San Diego, CA Nov, 10 - Dec, 11
. CardinalHealth, Dublin, OH Mar, 10 - Nov, 10
. The Hartford Insurance, Hartford, CT Dec, 08 - Feb, 10
. The Coca-Cola Company, Atlanta, GA Aug, 07 - Nov, 08
. Direct Energy, Houston, TX Feb, 07 - Aug, 07
. British Petroleum, Chicago, IL Sept, 05 - Jan, 07
. Ace Technologies, India Mar, 03 - May, 07
Client Name: Georgia Professional Standards Commission, Atlanta, GA
Designation: SQL Server DBA /SSIS Developer
12/05/2011 - to date
Project Description: Worked on multiple projects while in Georgia
Professional Standards Commission. Description of each project, Roles and
Responsibilities are given below.
. Traditional Program Management System (TPMS) Project: TPMS provides
the way for providers of traditional education preparation programs to
inform Georgia Professional Standards Commission (GAPSC) of their
program participants to support data collections in connection with
GAPSC's program approval function, support State and Federal
reporting, allow for granting eligibility to take GACE assessments,
and to support other functions as may be developed in the future. The
TPMS facilitates batch upload of large numbers of records from a
provider to GAPSC, addition and editing of individual records by a
provider, download of selected records to the provider, and basic
reporting capabilities for both the provider and GAPSC.
Roles and Responsibilities:
o Created logical database design using ERWin.
o Created physical database, indexes, constraints, stored
procedures, functions and triggers.
o Created SSIS package for file transfer process using File
Transfer Protocol (FTP) for migrating files from out of network
server to production server. Created SSIS packages for importing
and processing Excel, CSV data in SQL Server.
o SSIS packages execute in production using confir
o Created reports using SSRS to show the number of files received,
processed and unprocessed from different schools. Also scheduled
the report to refresh the data.
o Production deployments and coordination among different teams.
o Coordinated with third party called ETS to transmit data from
Professional Standards Commission of eligible candidates to give
test.
o Daily progress report to Chief Information Office.
o In this project worked as database administrator as well as
developer.
. Database server upgrade from SQL Server 2000 to 2008R2 Project: This
project was to upgrade SQL environment from SQL 2000 to 2008R2.
Roles and Responsibilities: In this project worked as DBA
o Upgraded all database servers (Development, Test, Production,
and Research) from SQL Server 2000/2005 to SQL Server 2008 R2.
o Installation and configuration of SQL server 2008R2.
o Planning and Analysis of space requirement for exiting databases
over next five to ten years.
o Restoration of databases in QA or Development servers from
latest production backup.
o Upgraded DTS packages to SSIS packages.
o Moved all the databases from old servers to new environment.
o Moved all the database users and SQL logins to new respective
environments.
o Modified about sixty stored procedures which were using
xp_sendmail and replaced with sp_senddb_mail utility.
o Worked closely with System Administrator team.
o Upgraded some SQL reports using XML.
o Migrated all the jobs to new upgraded environment.
o Installed third party tools used in vendor supplied
applications.
o Production support related issues like stored procedure tuning,
modification of table columns or creation of new tables.
Environment: SQL Server 2008 R2, Visual Studio version 2008/2010, MS
Windows 2008 R2, Team Foundation Server 2010 (TFS), Integration Services,
SQL Server Reporting Services 2008, ERWin.
Client Name: LPL Financials, San Diego, CA
Designation: Sr. SQL Server Developer
11/29/2010 - to date
Project Description: LPL Financial serves the unique business needs of over
12000 financial advisors with unbiased research and nonproprietary
products. LPL financial has reporting system called Portfolio Manager (PM)
reporting system and it is used by financial advisors. Broadridge (client
to LPL) sends business data to LPL server daily in raw text files. These
files are parsed, loaded and processed at LPL.
Roles and Responsibilities:
. Created stored procedures for synthetic transactions to determine the
Opening Buy and Closing Sell accounts. Opening Buy synthetic
transactions are determined by looking at the positions and
activity/transaction data for a particular account. The difference of
quantity between position and transaction determines the type of
synthetic activity. Similar stored procedure created for Closing Sell
synthetic transactions.
. DIS Job Scheduler (Data Integration Service - Scheduler): Created SQL
scripts for DIS Scheduler to execute the stored procedure to populate
the synthetic transaction data. This is the automated process which
execute at scheduled time.
. Backward compatibility SQL Script: To safeguard the existing
production database the backward compatibility SQL scripts were
created before new production release. Once the production script
executed and due to some reason did not support the new environment,
then backward compatibility scripts were executed to bring back the
database to previous position.
. Data availability: LPL Financial organization has three different SQL
Server environments called BODS, LPL and AXA. When Broadridge project
deployed in production, worked with LPL business team to validate
production data. Also ensured the data is available in all three
environments.
. T-SQL script to Alter tables (add columns, drop columns,
add/drop/modify constraints).
. Performance tuning.
. Created logical and physical table structure for Broadrigde Database.
. Written test cases for testing stored procedures.
. Coordination with job scheduling team (Integration services).
. Loading business data in development and QA environment received from
Broadridge using Updater tool (interface).
. Created user guide for production deployment.
. Maintained stored procedure, SQL Script code in Microsoft Team
Foundation Server (TFS 2010).
Environment:
SQL Server 2008 R2, Visual Studio version 2010, MS Windows 2008, Team
Foundation Server 2010 (TFS), Data Integration Scheduler (DIS), SQL Server
Reporting Services 2008.
Client Name: CardinalHealth, Dublin, OH
Designation: Technical Lead / SSIS-SQL Developer
03/01/2010 - 11/19/2010
Project Description: Customer Service Workstation (CSW) is a Windows-based
(GUI) application used by all Cardinal's Pharmaceutical Distribution (PD)
Centers to serve customers. It provides Customer Service Representatives
(CSRs) the ability to access these functionalities:
. Customer Inquiry
. Order Inquiry
. Credit Inquiry
. MRA Entry
. Product Inquiry
. Order Entry
. Call Tracking
. Drop ship
CSW processes are broken into three tiers
Tier 1: CSW workstation/desktop/Virtual PC: Resides on the client
workstation, contains Graphical User Interface (GUI) logic, and performs
minimal caching with remote refresh for customer lookup. Tier1 performs
DCOM calls to Tier2 using a sync DCOM callbacks to return requested data.
CSW Tier1 is written in MFC (Microsoft Foundation Class)/C++.
Tier 2: NT Server (CVP - Cardinal View Port): Performs service locating,
caching of definitional data, supports DCOM requests from Tier1, uses DCOM
free threaded model for session management of multiple users and
communicates with Tier3 hosts through structured data packets with order
dependent and field length specified protocol. The implementation of
asynchronous communications between Tier1 and Tier3 allows for push from
Tier3 all the way to Tier1 without polling and without blocking any
requests. CSWTier2 is written in C++.
Tier 3: Host System (AS/400): From Tier2 a text based command request
structure is passed via sockets to the host. Responses are text based
structures formatted with fields and field lengths. The host system
contains live business data while Tier1 and Tier2 transport and display the
data upon user request. CSWTier3 consists of all business rules for
processing requests and getting information. If CSW Tier3 is down then CSW
user will get an error message saying that he/she can't connect to host.
Roles and Responsibilities:
. Created SSIS packages and deployed in Production SQL Server 2008.
These SSIS packages process daily call records to Oracle database. ETL
job then pull data from Oracle and load in Teradata database. The
business user views the daily call data reports using Microstrategy
reporting tool. The current database SQL Server 2000 was using DTS
packages which upgraded to SQL Server 2008. There was one issue, the
Microsoft OLE DB Driver for Oracle was not working in new 64 bit
operating system environment. By using linked server and breaking
process in two different jobs resolve the issue.
. Responsible for testing and validating SSIS packages and data in
staging and training environment after upgrading database to SQL
Server 2008.
. Created a utility using OSQL in SQL Server 2008 and removed the old
process. There were forty database servers. One process was executing
weekly on each database server. This process was used to detect
printing issue, which was logged in one table. The old process was
creating forty files. From the size (greater than zero byte) of each
file the business user was detecting the server to look into. I
created all results summarized in one file with only that server which
has issue.
. Modified T-SQL queries in existing stored procedures to improve the
performance.
. There was replication process in SQL Server 2000. It was replicating
data from central Production server to local four different CSW
databases. Same process implemented in the SQL Server 2008. My
responsibility was to compare data on both SQL Server 2000 and SQL
Server 2008 environments. I used one non-documented stored procedure
provide by Microsoft, which selects all the tables from one database
and inserting in table.
. Migrated application server (OS windows 2003) to new server with
upgraded operating system (Windows 2008)
. Written test cases to validate the data in staging and production
environment.
. Coordinated and validated data with Oracle, Micro Strategy and ETL
team
. Experience with Microsoft Business Intelligence Development Studio
(BIDS) and Report Builder 2.0
. Weekly/daily status update to client manager.
Environment:
SQL Server 2008, SQL Server 2000, Oracle 10g, SQL Server Integration
Services (SSIS), Data Transformation Services (DTS), SSRS, SQL Plus, ASP,
IIS 7, Windows 2008, Visual Studio version 3.5, PL/SQL
Client Name: The Hartford Insurance Services, Hartford, CT
Designation: Technical Lead
12/01/2008 - 2/28/2010
Project Description: Worked as Technical Lead with The Hartford Insurance
organization. The Hartford organization is in insurance business from
almost two hundred years. The target of this assignment was cost reduction.
Reduced operating costs resulting from process improvements leading to year-
over-year productivity improvements. Reduced penalty and interest payments
as a result of increased staffing flexibility to handle business
fluctuations. In this assignment, there were seven different business work
streams (different projects) which were outsourced. I worked on four work
streams. 1) Medical 2) Medical Record Collection 3) Staff Legal and 4) Back
Office. Each work stream is broken in below work flow: 1. Process: Each
process touches set of applications to complete a task. 2. Application:
Each application will touch different screens in application. 3. Screen:
These are the application screens. 4. Data Fields: There are the data
columns bounded with the database.
Roles and Responsibilities
. Implementation of performance measurement tool called Aternity.
Applications were accessed across different geography like India and
Philippines. This tool was very useful to determine the latency issue
especially when application response time was slow or any network issue.
. I was responsible to make sure the application which was dealing with
Property and Casualty claims is up and running. As Hartford organization
had outsourced claims business. Helped business to define the storage
strategy to store the claim letters based on region.
. Worked with business team to classify different applications used for
each business processes. This activity helped client to define the role.
. Migrated data from MS Access to SQL Server 2005 using SSIS packages.
. Created reports using SQL Reporting Services Tool. MS Access was
supporting these reports using data reports tool and moved to SQL Server
2005.
. Created RBAC (Role Based Access Control) document for each work stream.
. Data mapping: This activity was to identify the applications which
contain PII (Personal Identifiable Items). Requirements were to mask the
data fields which contains PII elements e.g. Personal Data accessed from
Department of Motor Vehicle office through application to validate the
driving license record.
. Coordination with Business Team and middle management to get approval on
RBAC. RBAC approved by Legal group, The Hartford Information Protection
Group and Software Governance group.
. VMware: Testing of applications by fields users. Resolved issues
proactively logged by field testers.
Environment:
SQL Server 2005, SSIS, SSRS, MS Access, VMware, Citrix, MSOffice, Windows
XP Version 2002,
Client Name: The Coca Cola Company, Atlanta, USA
Designation: Technical Lead
Aug 2007 - Nov 30, 2008
Project Description: It was production support role. I worked on Legal,
Finance and Human Resource related applications from client location in
Atlanta, USA. Two HR applications related to Compensation, Stock Option
System are the most critical applications from total twelve applications. I
have handled efficiently without any escalation. Other applications are
vendor supplied and some are customized and implemented by The Coca Cola
Company. These applications were created in different technologies, which I
was supporting with the help of offshore team.
Roles and Responsibilities:
I was responsible for production support of Legal, Finance and Human
Resource related applications from client site. Helped business teams to do
the day to day transactions. Two HR applications 1. Employee compensation
recommendations (CTR) 2. Stock Option System (SOS) were the most critical
applications from total twelve applications. I had handled very efficiently
over the period of fifteen months without any escalation. Other
applications were vendor supplied and some are customized and implemented
by in house IT team. These application were build in different
technologies.
. The main responsibility was to understand the requirement of existing
/ new application, create change request document and send to offshore
for development / enhancement.
. Transitioned applications to offshore team. Mentored and scaled up the
offshore team in Incident / Ticket resolution.
. I was supporting these applications 24 x 7 with the help of offshore
team. Whenever client have some issues related to application, server
performance, network issue. Client meetings on critical issues.
. Weekly Human Resources business team status review meeting.
. Responsible for the transmission of Stock data to Merrill Lynch daily.
In case data fail to transmit then coordination with vendor IT team to
make sure the data received correctly.
. Supported Reporting System of Stock Option System (SOS) application,
which was in Structured Query Reporting (SQR)
. Worked on incident management tool called HP Service Center.
Environment:
Windows 2000 /2003, MS Access, Visual Basic, Crystal Reports, SQL Server
2000/20005, SQR, ORACLE 9i/10g, Informatica, PL/SQL
Client Name: Direct Energy, Houston, TX, USA
Designation: Developer - SQL Server 2005 and SSIS
Feb 2007 - Aug, 2007
Project Description: Direct Energy Marketing Limited, a leading gas and
energy provider in USA. It has more than 1.5 million clients. Gas
Forecasting application provide the forecasted gas data for the customers.
It uses the historic weather data and forecast the weather report. The
process executed daily and gives the monthly forecasted gas data. The PIPE
application use the gas forecasted data and schedule the gas for customers.
Roles and Responsibilities:
. Studied the existing application system which was based on MS Excel.
The application was very slow and users were not happy with the
existing system. It was taking close to four minute to retrieve data
from remote database server each time. After implementation of new
application, it was taking less than fifteen seconds to bring data
from database server. I created a in local data center and created
SSIS packages, which were transmitted data from remote server to local
data center. It improves the performance drastically.
. Created logical database model using MS-Visio and created the physical
Database.
. Written Store Procedures, Functions, Views, Triggers.
. Fine tuned the existing T SQL queries.
. Business team interaction, Troubleshooting, Data Storage, Jobs
monitoring / Scheduling.
. Code was written in VBA, I converted that code to Visual Basic. -
. Designed and implemented SQL Server Integration Services (SSIS)
packages. These packages were loading data from different source
servers to SQL Server 2005 database
. Created about twelve reports using SQL Server Reporting Services
(SSRS) tool.
. Weekly status report to Project Manager.
. Created Functional Specification document and Production Support.
Environment:
MS SQL Server 2005, MS SQL Server 2000, SSIS, SSRS, VBA, MS Access, MS-
Visio, Windows 2000 /2003, Visual Basic
Client Name: BRITSH PERTOLEUM, USA
Designation: Microsoft SQL Server Developer and ETL Designer
Jun 2005 - Dec 2006
Project Description: Project Description: British Petroleum has leading
energy business - delivering oil, gas and renewable resources. Load
Tracker's aim is to design and develop a customized load tracking and
metrics reporting application that supports BP's Scheduling and Logistics
operations staff and Logistics management.
The ETL part of the Load Tracker Execute phase is involved in migrating
data from their source systems Aspen (Oracle) and TMS (Oracle) to the
target server in SQL Server 2000.It involves the challenge of handling
dynamic source data which either comes every fifteen minutes or which comes
twice a day
Roles and Responsibilities: Designed ETL and written transformations.
. Designed DTS packages and there schedules
. Written stored procedure, triggers, Performance tuning of SQL
queries.
. Client interaction for daily status call of project
. Handled three members ETL team
Environment: Windows 2000, SQL Server 2000, C#, ASP.Net, MS VISIO 2000,
Business Objects, Data Transformation Services (DTS) Packages.
Client Name: Supreme Rubber Industries, India
Designation: Team Lead
Sep 2004 to May 2005
Project Description: Production control and material management software
was developed to manage the production and maintain the inventory
(Finished, Semi Finished, Ram material, Compound stock). The application
functions about enquiry detail of product from new customer or from
existing customer. Then software generates the detailed quotation of the
required product. After the settlement of prices of the product then there
was Order Processing module which includes detailed client order, order
enhancement, order scheduling etc. On the basis of orders received
production planning module gives the detailed information about the exact
raw material required and time required to produce the ordered quantity.
Stock was updated though the raw material module. Inventory module handles
the generation purchase order, material receive and issue. Production
module gives the detail about the product and updates the finished stock.
The last module is billing and feedback of products and various detailed
reports.
Roles and Responsibilities:
. Responsible for business requirements. Based on business requirements
created technical document for application.
. Database designing, Data Modeling (Visio 2000)
. Written stored procedure, triggers, Coding in Visual basic 6.0
. Based on business requirement. There were many different reports
required for senior management. The tools used to generate the report
was Seagate Crystal Reports version 8.0
. Client interaction and weekly progress update.
. End user Training
Environment: Windows 2000 Server, SQL Server 2000, Visual Basic, Seagate
Crystal Report
Client: Balbir Singh Pvt. Ltd., India
Role: Microsoft SQL Developer and Team Leader
From: May 2004 to Aug 2004
Project Description: The transportation system and general accounting
package has been designed and implemented successfully. The company BSPL
has big infrastructure in terms of plant and machinery. It has about fifty
trucks, cranes and same number they are hiring on daily basis for
transporting soil, stone etc. from one place to another. There are
different parameters of charges (e.g. trip, distance, weight, time) for
lifting and unloading the material. The main module is the DPR (Daily
Progress Report) of every machine, vehicle and employee. This software also
maintains the accounting system based on the expense and payment of every
vehicle and employee of the company. The reporting module has various
reports to get instant information vehicles and accounts of various
customers / machines etc.
Responsibilities: Overall responsibility to handle the project
. System Analysis, Database Designing
. Client interaction.
. Software Implementation.
. Daily activities of Team.
. Reporting to Project Manager about the progress of project.
. Training to end user
Environment: Visual Basic 6.0, SQL Server 2000, Crystal Reports 6.0, COM.
Client: Arushi Communications Pvt. Ltd,
Role: Sr. Programmer
Mar 2004 to May 2004
Project Description: The calls management software has been designed to
manage the data of telephone calls. Arushi communication is a call centre
and receiving call from different location. The moment user receives the
call they enters the detail of call like phone number, calling person,
location etc into the software. Similarly outgoing calls user is entering
the detail. On the basis of this data, performance of each user is
calculated and different reports are generated.
Responsibilities: Migrated data from MS Excel to SQL Sever using DTS
Package
. Database Designing, Coding
. Written stored procedures, triggers, views.
. Client interaction.
. Generated various performance related reports
Environment: VB.Net, SQL Server 2000, Crystal reports, Windows 2000
Client: Tojo Vikas International Pvt. Ltd,
Role: Senior Programmer
From: April 2003 to February 2004
Project Description: Workflow Management Software has been designed and
developed specifically for Medical Transcription Industry. This package
maintains the workflow of document files and keeps track of sound as well
as document files. There are four levels through which the files move and
finally transcript files uploaded at the client server.
Reports: 1) Medical Transcription, Quality Assurance Level 1, Quality
Assurance Level 2 and QM daily performance report.
2) Graphical presentation of line count and accuracy of
Medical Transcription, Quality Assurance Level 1, Quality
Assurance Level 2
3) Daily total production report.
4) Job status report.
5) Shift wise production report etc.
Responsibilities: Programming in visual basic, form designing.
. Interaction with business user about the progress of project.
. Various reports using the crystal reports tool.
. Software Implementation and user Training.
Environment: Visual Basic 6.0, SQL Server 2000, Crystal Reports
Client: Total Credit Management
Role: Sr. Programmer
Sep 2002 to Mar, 2003
Project Description: Credit Management System is very user friendly
software which deals in payment from debtors and maintains the track of
communication between debtors, creditors and agents. System always
maintains the history of previous communication between the clients and
debtors and set the next date for communication. The software also keeps
the billing system and commission from various debtors. User can insert the
new client, debtor, and creditor from same screen without moving to master
screens while creating new file against new case. User can send mail, fax
or letter to the different debtor or agents. The system will save the
record or update the record if by mistake user is closing the screen
without updating the record. There is a search module in this software
through which user can search the desired record.
Responsibilities: Was involved in collecting the business requirement,
. Prepared data model using MS Visio Modeling Tool.
. Programming in Visual Basic.
. Generated about twenty reports using crystal reports tool.
Environment: Visual Basic 6.0, MS-Access 2000, Crystal Reports 6.0
Client: Friends Globe Pvt. Ltd., Delhi
Role: Sr. Programmer
Jan 2002 to Aug 2002
Project Description: M/s Friends Globe is a consultancy organization, which
provides services in hospitality. It has several major clients
(organizations) which deal in various areas like software development,
Mobile Phones (Nokia), Tractor Division (New Holland Tractor) etc. Friends
Globe keep the updated information about their clients are as follows.
. Insurance expiry information
. Passport expiry information
. Insurance claim
. Keeps the information of departure and arrivals of passengers to
and from various countries with dates and time.
. Travel history of particular passenger of particular organization.
. Visa and air tickets arrangement.
. Hotel Booking
. Personal information of all customers.
. Birthday, wedding anniversaries through e-mail.
. Monthly / weekly backup from all clients at Corporate Office.
Responsibilities: Involved in Software Maintenance and enhancements.
. Reports generation in Crystal reports.
Environment: Visual Basic 6.0, MS-Access 2000, Crystal Reports 5.0
Contact this candidate