Post Job Free

Resume

Sign in

Sql Server Project Manager

Location:
Puducherry, PY, India
Posted:
February 09, 2016

Contact this candidate

Resume:

Ebinezer Jayakumar actgm2@r.postjobfree.com

https://www.linkedin.com/in/ebinezer-jayakumar-1bb63978 Mobile: 816-***-****

Professional Experience

** ***** ** ********** ** analysis, design, development, testing, application performance tuning/engineering, scalability study, and server sizing in distributed deployment environment using .NET technologies and 7 years as Project Manager and played roles of Sr. Developer/ Team Lead in the area of ‘Distributed Solutions Practice’ and ‘Business Intelligence Practice’.

Large Scale Project Management (1-3 million dollars in budget) with successful track record in delivery.

Effective negotiation skills with Business and Information Technology stakeholders and provided value added consulting services in capturing Business requirements for various technology work streams.

Having professional experience in SharePoint technologies in implementing eDiscovery.

Worked in different domains like: Pharmaceutical, Distribution and Education domains.

Extensive experience working with C#, VB.NET, ADO.NET, ASP.NET, Web Services, Java Scripting and SQL Server Programming

Experience in implementing various types of replication and database performance tuning on SQL Server 2000 and SQL Server 2008.

Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and ETL package design, and RDBM systems like SQL Servers.

Developed Reports using Crystal Reports and SSRS (SQL Server Reporting Services) for various projects.

Excellent communicator; leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.

Expert in agile and waterfall project management methodologies; Able to manage large project teams and known for high-quality deliverables that meet or exceed timeline and budgetary targets.

Technology Proficiency

•Language : C#, VB.Net, T-SQL, FORTRAN

•Operating System : Windows VISTA/XP/2000/NT/98/95/2003

•GUI : Visual Basic 6.0

•RDBMS : Oracle 9, SQL Server 2008 and MS Access 2000

•Technologies : ASP.NET, .NET Framework 1.1/2.0/4.0, SharePoint 2013

•Imaging Tools : Microsoft Visio

•Reporting Tools : Crystal Reports 11, SQL Server Reporting Services (SSRS)

•Version Tracking Tools : Visual Source Safe 6.0

•Data Access Technologies : ADO, ODBC, ADO.NET, SSIS, SSAS

•Data Modeling : Star Schema, FACT & Dimensions Tables

•Domain : Distribution, Pharmaceutical and Education.

Career Progression

Project Manager

Oct 2010 to Till Date

Project Leader

Oct 2008 to Sep 2010

Senior Software Engineer

Aug 2006 to Sep 2008

System Analyst

Jan 2005 to July 2005

Senior Programmer

Dec 2003 to Dec 2004

Programmer

Apr 2002 to Nov 2003

Achievement Highlights

•Outstanding performer of the year 2010 in Barry Wehmiller

•Best Project Award (Delivery Management System) 3 years in a row

•Excellent Customer Feedback (Delivery Management System)

Education

Degree

Year of Passing

Master of Computer Applications

2002

Bachelor of Science Computer Science

1999

Project Details

eDiscovery Implementation July 2015 – December2015

Client : Dayhuff Group

Description

This project involves implementing eDiscovery Center SharePoint site collection to identify, search, and export content from Exchange mailboxes, SharePoint sites, and searchable file shares.

Responsibilities:

1.Set up an eDiscovery Center

a. Create an eDiscovery Center

b. Configure Exchange Online as a result source

c. Create a security group for eDiscovery managers

d. Assign eDiscovery permissions in SharePoint Online

2. Plan and manage eDiscovery cases

3.Create a case

a.Add sources and place them on hold

b.Run queries and export content

c. Close cases

4. Searching and using keywords in eDiscovery

5.Filters and Queries

a.Operators and Proximity in Keywords

b.Using Wildcards and examples for applying rules

6.Create and run eDiscovery queries

a.Add more content sources while creating a query

b.Export eDiscovery content and create reports

c.Create reports about exported content

Application Migration (R & D - DSS and CPPM) June 2014 – June 2015

Client : AbbVie – R&D IT

Role : Project Manager

Description

This project involves migration of all the servers belonging to R&D Data and Statistical Sciences and Clinical Pharmacology applications from the current Abbott Data Center to the new AbbVie Data Center.

Responsibilities:

Creating a detailed schedule and plan for application migration

Identifying the various platform dependencies for the applications

Identify the resources required to successfully complete the migration from application and platform perspective

Coordinate stakeholder discussions to review the plan and approach for migration

Schedule and track the various activities required pre and post migration on a day to day basis

Coordinate and resolve any issues faced from a managerial standpoint

Coordinating communications with all the business stakeholders’ pre and post migration

Documented Lessons Learnt and worked with migration coordinators to improve the migration process

Mitigated risk factors through careful analysis of financial and statistical data.

Maintenance of Delivery Management System Mar 2012 – Jun 2014

Client : Directory Distributing Associates, Missouri, USA.

Role : Project Manager

Description:

Delivery Management System, here after referred to as DMS, which runs on Microsoft SQL Server 2000 and .NET Framework 1.1. Since the SQL Server 2000 is not supported as the main line software by Microsoft, DDA has decided to upgrade their application database to SQL Server 2008 with minimum impact to the DMS application. The .NET framework 1.1 should be upgraded to .NET framework 4.0 to inherit the features of the improved framework version.

Responsibilities:

Prepared the project charter which includes scope, issue priorities chart, timeline to resolve issues, define the roles and responsibilities

Monitor replication synchronization to verify data purity

Set up and monitor the Disaster Recovery - Roll back

Identify changes or enhancement on the application and came up with cost and effort estimates.

Environment : SQL Server 2000, SQL Server 2008

ASCEND BI Oct 2011 – Mar 2012

Client : Day Huff Group, USA.

Role : Project Manager – Technical

Description:

Analyze and understand the business to come up with a data warehouse design for ASCEND’s 7 business unit.

Responsibilities:

Analyzed the requirements and derived the business flow

Data Integration, Defining the gap between what data is available and its quality versus what the business has requested

ETL, Extract information from the application data storage, transform it according to a predefined set of rules, and then load it into the data warehouse, where it can be transformed and accessed to produce report output

Suggested the IT team for Server environment for data warehousing

Coordinated with client in preparing questionnaire to understand the business

Lead the team through entire cycle of the project.

Environment : SSIS, SSAS and SSRS

HATS Reports Jun 2011 – Sep 2011

Client : Day Huff Group, USA.

Role : Project Manager

Description:

Ohio Department of Job and Family Services, here after referred to as ODJFS, has a reporting database environment which gets populated every night from Hearing and Appeals Tracking system. Reports that are used for administrative purposes are produced from this reporting database environment in Crystal Reports and Oracle.

Responsibilities:

Analyzed the requirements and estimated the effort in terms of hours

Lead the team in development of reports using Crystal Reports

Lead the team through entire life cycle

Business Requirements Gathering, Interview employees from each department, and different levels within each department, about what they believe to be the primary goals of these reports.

Environment : Crystal Reports and Oracle

Migration from SQL Server 2000 to SQL Server 2008 Mar 2010 – May 2011

Client : Directory Distributing Associates, Missouri, USA.

Role : Project Manager

Description:

Delivery Management System, here after referred to as DMS, which runs on Microsoft SQL Server 2000 and .NET Framework 1.1. Since the SQL Server 2000 is not supported as the main line software by Microsoft, DDA has decided to upgrade their application database to SQL Server 2008 with minimum impact to the DMS application. The .NET framework 1.1 should be upgraded to .NET framework 4.0 to inherit the features of the improved framework version.

Responsibilities:

Prepare the DMS application to work on SQL Server 2008

Replication - SQL Server 2008 Distributor and SQL Server 2000 Subscriber

Replication - SQL Server 2008 Distributor and SQL Server 2008 Express as Subscriber

Replication Testing - SQL Server 2008 Distributor with SQL Server 2000 and SQL Server 2008 Express as Subscriber

Deployment Plan

Acceptance Testing

Disaster Recovery - Roll back.

Environment : SQL Server 2000, SQL Server 2008

Enhancements to Delivery Management System Jul 2008 – Mar 2010

Environment : ASP.Net using VB.Net, JavaScript, SQL Server 2000

Client : Directory Distributing Associates, Missouri, USA.

Role : Project Manager

Description:

Delivery Management System is a migration project from the legacy Windows based FoxPro application to the web based Microsoft ASP.Net application. The system helps in maintaining the day to day activities of DDA in delivering telephone directories to the customers. The project architecture has a Central DB Sever connected to several remote Web + DB servers and also involves SQL Server Replication.

Responsibilities:

Understand the current pay card process and define the flow chart of existing system

Derive the flow for the proposed system and validate with business user

Gather requirements for the enhancement

Coordinating the Go Live.

BI Solution for BW Corporate Jan 2008 – Jun 2008

Environment : SQL SERVER 2005 Integration and Analysis Services, SharePoint, ProClarity

Client : Marquip Ward United, Hayssen Sandiacre and Thiele Technologies

Role : Project Leader

Description:

L3 team and the corporate IT teams of Barry Wehmiller groups have defined the first KPI as ‘On time Delivery’ based on the shipment of the product. Dashboard with drill down features needs to be developed to show the KPI status, what contributed the delay for shipment and what percentage of delay happened with an option to drill down to the details.

Responsibilities:

Worked as project lead and responsible for technical aspects of the project. Leading a team of 7 members in development, deployment and delivery of the core system modules using iterative and incremental development of project development process.

Work with delivery manager to schedule development, work estimation, risk identification and mitigation plan.

Author formal analysis model, design document, test plans and deployment documentation.

Worked in database design of Dimension and Fact table.

Responsible for design and develop as per application framework guidelines.

Delivery Management System Aug 2005 – Dec 2007

Environment : ASP.Net using VB.Net, JavaScript, SQL Server 2000

Client : Directory Distributing Associates, Missouri, USA.

Role : Project Leader

Description:

Delivery Management System is a migration project from the legacy Windows based FoxPro application to the web based Microsoft ASP.Net application. The system helps in maintaining the day to day activities of DDA in delivering telephone directories to the customers. The project architecture has a Central DB Sever connected to several remote Web + DB servers and also involves SQL Server Replication.

Responsibilities:

Working as team lead and responsible for technical aspects of the project. Leading a team of five members in development, deployment and delivery of the core system modules using iterative and incremental development of project development process.

Work with delivery manager to schedule development, work estimation, risk identification and mitigation plan.

Author formal analysis model, design document, test plans and deployment documentation.

Will be required to provide leadership to technical resources including mentoring, code review and work assignment management.

Responsible for design and develop as per application framework guidelines.

Did the implementation ONSITE at St. Louis USA.

PCMC FORTRAN to .NET Conversion Apr 2005 – Jul 2005

Environment : ASP.Net using VB.Net, JavaScript, SQL Server 2000

Client : PCMC, Green Bay, USA.

Role : System Analyst

Description:

PCMC FORTRAN to .NET Conversion is a migration project from the FORTRAN application to the windows based Microsoft ASP.Net application. The system helps in maintaining the day to day activities of DDA in delivering telephone directories to the customers. The project architecture has a Central DB Sever connected to several remote Web + DB servers and also involves SQL Server Replication.

Responsibilities:

Converted the requirements into strong technology solutions using .NET Framework supported language like VB.Net.

Mitigated technical risks at early stage of the project by developing proof of concept of core engine and performing critical functional and load test.

Authored formal architectural document, analysis model, design document, test plans and deployment documentation.

Planned system capacity to support required load and scalability to support anticipated growth.

Scottish House Prices Jan 2005 – Mar 2005

Environment : ASP.NET, SQL Server 2000

Role : System Analyst

Description:

This is a web-based application for Scottish House which is a shopping website. We are involved in creation of a Breadcrumb control, which takes care of the navigation through the parent item and all of its child items. The breadcrumb control is created in such a way that it may be reused for any applications. The user control is build with all the necessary properties to handle shopping websites.

Responsibilities:

Design and Developed the breadcrumb control

Involved in the Architecture and design of all the project modules.

Developed deployment strategy for the solution.

Converted the requirements into strong technology solutions.

Led five members in execution of this project.

Lottery Fun Group Sep 2004 – Dec 2004

Environment : ASP.NET, SQL Server 2000

Client : LFG Groups, USA.

Role : Senior Programmer

Description:

This is a web based application for a lottery group website. They are maintaining all the member info, lottery winning number, winning number selection everything online. One of the robust applications designed to achieve on line credit card processing for members to buy in lottery with a good security system. User can check online whether his lottery number matches the actual winning number.

Responsibilities:

Developed search the winning number module.

Developed auto order assign module.

Designed and Developed maintenance of personal details module.

Web Services to Search a Biz Jun 2004 – Aug 2004

Environment : ASP.NET, SQL Server 2000

Client : LFG Groups, USA.

Role : Senior Programmer

Description:

This is a web services developed to search the business that are registered with the CPA Finder, USA. It is like a search portal that has two options for search namely, basic search and advanced search. The basic search for the entered keyword in business name, type, city and state and list the matches in a grid, while the advance search has more formatting options like number of search items to display, sorting order etc. This web service enables the users of the site to locate the business in their area with respect to their types.

Responsibilities:

Developed the web services for searching the business

Design and developed the formatting tools.

BULK EMAILER Feb 2004 – May 2004

Environment : C#, SQL Server 2000

Client : Marketing Analyzers, USA.

Role : Senior Programmer

Description:

This is a window based auto mailer application, which uses the SMTP server and system.web.mail namespace to send email to the list of address from Sql server database. This application is designed in such a way that the email is being sent one by one to the recipients email id’s so that it seems to be sent as a personalized email.

Responsibilities:

Worked on auto email send module.

Implemented Timer and Progress bar controls.

Creation Reporting Tool – Using XSLFO Dec 2003 – Jan 2004

Environment : ASP. NET, XSLFO, MS Access 2000, Java Script, Adobe Photoshop 7.0.

Client : CPA Finder, IL- 60714, USA.

Role : Senior Programmer

Description:

This is a tool that is going to be implemented in an insurance promotion site that inherits all the functionalities of an insurance portal. This tool is used to create reports based on the following structure. ASPX pages to XML – XSLT – XSLFO – PDF. The 3rd party tool called CHIVE APOC XSLFO for which the clients own the license achieves this. This is the partial work we are doing on the portal and also we are to develop a web services for this portal, which has the ability to perform full search operation on the portal.

Responsibilities:

Full analysis about the CHIVE 3rd party tool.

Worked on XML (XSLT) pages to PDF conversion.

Creation of web Services to implement search.

BIZ BUY SELL Aug 2003 – Nov 2003

Environment : ASP. NET, SQL Server 2000, Java Script, Adobe Photoshop 7.0.

Client : CPA Finder, IL- 60714, USA.

Role : Programmer

Description:

This is a business maintenance site that inherits all the functionalities of a Business portal. Here business is termed as biz and hereafter mentioned by the same. It includes various services such as Add a Biz, Show up a Biz, Search for a particular biz with various search criteria options and formatting options like number of records per pages too.

Responsibilities:

Developed adding a biz module.

Developed search a biz module.

Design and Developed auto emailed module.

Designed and Developed maintenance of personal details module.

Photo Gallery Feb 2003 – Jul 2003

Environment : ASP. NET, SQL Server 2000, Java Script, Adobe Photoshop 7.0.

Client : GBS Network Inc. USA.

Role : Programmer

Description:

This is a photo gallery site that inherits all the functionalities of a photo gallery portal. It includes various services such as creating albums, adding photos, emailing an album, emailing a photo for the members. Managerial level functionalities include viewing the albums, photos and various users etc. He can

Perform any data handling on the site.

Responsibilities:

Developed emailing an album module.

Developed emailing a single photo module.

Design and Developed display of photos in an album module.

Designed and Developed maintenance of personal details module.

Small Notes - Online Education Center Apr 2002 – Jan 2003

Environment : ASP. NET, Sql Server 2000, Java Script, Flash 5.0, Adobe Photoshop 7.0

Client : Western University, USA.

Role : Programmer

Description:

This site is designed for an online education center, Small Notes. This site includes various functionalities such as auto email of forgotten passwords and various web links to the related subjects, scrolling message window, online test, FAQ maintenance, help system and grading system. The students those who possess a valid Use rid can take up the practice test and grade themselves. The FAQ maintenance is designed in such a way the queries from the students can be automatically added to the FAQ table if the web master decided it has the top priority. The requisition of forget password will result in auto emailing of password after certain authorization procedures are completed. The message board can be update with range of dates by administrator. This message board helps in displaying the current events that are to come in the given dates by the web master, so that student can be aware of all activities that happen around them. Help desk support is also provided for new user.

Responsibilities:

Developed auto mailer module for forgotten password and web links to related subjects.

Developed FAQ Maintenance module.

Design and Developed Online Test and grading module.

Developing binary tree based indexing and search algorithm, which increased the search performance of the product by 10x.



Contact this candidate