Sql Server Project Manager

Shajeev Padmanivas

*******@*******.*** / 404-***-**** / U.S. citizen

SUMMARY

Managed, Administered, implemented, deployed and provisioned infrastructure, complex development projects, and production support.

Sound coordination, interpersonal, problem solving, mentoring skills including analytical & leadership capabilities.

Agile Scrum development Methodologies.

Experience of full project lifecycle (requirements, design, development, testing, deployment, version control).

Experience of leading and coordinating off-shore and on-site teams.

More than 13 years of IT experience in client/server and Internet/web application development using AWS, Jenkins, Linux, Tableau, SQL server, IIS, C#, ASP.Net, VB.Net, SQL Server, Oracle, database design/administration, web logic, Flex, Java, JSP, ASP, SOAP, Web Services, XML, PHP, COM, MTS, Visual Basic, AS/400, Visual Interdev, Front Page, HTML, JavaScript, VBScript.

Experience in configuring, administration and maintaining the ColdFusion Application Server on the clustered environment.

Experience in administration of SQL Server/Oracle database, creating and managing databases, integrating SQL server and NT security, continuously enhancing backup and restoration plan and monitoring / troubleshooting and tuning.

Experience with system testing/QA, facilitate UAT sessions with users and follow change management process.

Self-starter, excellent team player, flexible, Dependable, Quick Learner and hard worker.

Possess superior problem analysis skills with exceptional ability to follow project standards and procedures, quickly master new concepts and applications.

Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented or independent environment.

EDUCATION

Bachelor Of Engineering (Computer Science - 1995)

IBM Certification for AS/400

TECHNICAL SKILLS

Tools: AWS EC2, SSRS, SSIS, SQL profiler, SQL Query Analyzer, Apache, Visual Studio, JIRA, Jenkins, Tableau, Nagios, OSSEC, GitHub, WinSCP, VPN, Eclipse, Zend Studio 10, Komodo Edit 8.5, Macromedia Dreamweaver, Flex Builder, WinCVS, Tortoise, Web Trends, ActiveX, COM, Visual Source Safe (VSS) 6.0, Crystal Reports, MS-Visual InterDev 6.0, Front Page, Toad, SQL*Plus, MS-Access 97, BPCS, Erwin, Rational Rose, Visio.

Languages: ASP. Net, VB. Net, C#, SQL server, Python, Bash, PHP 5.6.3, Laravel Framework, Zend Framework, Oracle, ColdFusion MX/5.0/4.5/8/9.0, CFScript, ASP, Visual Basic 6.0, XML, VB Script, JavaScript, HTML, C, SQL, Flex, Java, RPG/400, CL/400

Databases: MS-SQL Server 2012/2008/2005/2000/7, Oracle 9i and MySQL

OS: Ubuntu 14.04, Solaris 8 Sun OS 5.8, Windows, OS/400, DOS, UNIX

PROFESSIONAL EXPERIENCE

Quadrant 4 Systems Corporation Dec’14 – present

Alpharetta, GA

SQL server Administration / Production Application Support

Quadrant 4 Systems Corporation is a technology company that empowers digital transformation in education, through robust SaaS platforms, custom development, quality assurance, and highly specialized professional services.

Responsibilities:

Collaborate with product teams on validating and aligning specific requirements around product enhancements.

Managing and Administration of SQL server, & MySQL

SQL Server T-SQL experience, including Reporting Services (SSRS), and SQL Server Integration Service (SSIS).

Built Tableau Dashboard Reports for different School district analytic purpose.

Installed and used Tableau server versions 8.2 as a front-end BI tool and SQL Server as a back end database to develop workbooks, dashboards and ad-hoc reports.

With Tableau administered users, user groups, connected to multiple data sources, published workbooks on site.

Written stored procedures, triggers, views, batch job scripts.

Performance tuning with SQL profiler and SQL query Analyzer.

Developed and tested extraction, transformation, and load (ETL) processes.

Mapped the Data based on business user requirements and business rules to load data from source flat files to target database tables.

Work closely with IT and Application Development teams for new application installations, releases, and testing.

JIRA, Confluence – For ticketing system and for product requirement repository.

Resource provisioning and configuration for development, QA, performance testing, Demo, and production environments.

Managed and monitor multiple servers with different OS (Ubuntu, CentOS, Windows, and Linux) at multiple locations /Data Centers.

Used Nagios to monitor the server.

Implementation and deployment of cross platform solutions; Provide Tier-1 production support for systems of responsibility: log and track issues to resolution; perform analysis of issues to either resolve or escalate to Tier 2 support; identify workarounds where necessary, communicate & coordinate with vendor support teams and internal IT staff.

Production Support for various solutions build with IIS, Visual Studio, C#.net, SQL Server, PHP, and MySQL

AWS EC2 administration and managing the instances and security groups.

Creates and maintains all databases required for development, testing, load and production usage.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Performs ongoing tuning of the database instances.

Provides technical support to application development teams. Perform general technical trouble shooting and give consultation to development teams.

Installed and configured Jenkins tools on Linux and windows platforms and installing Jenkins plug-ins.

Continuous Integration using GitHub & Jenkins.

Knowledge on Continuous management tool like Puppet

Working knowledge on Python.

Selenium Webdriver Python integration for Web UI automation.

Customer data processing on Production environment.

Production Support.

Streamlined application delivery to get applications out to customer faster

Manage DevOps supporting tools and infrastructure for Off-shore resources

System administration using tools like Putty, WinSCP.

Creating virtual machines using VMware Virtual Center

Created Mock-ups, wireframes & prototyping web application UI

Conducted daily Team Lead Huddle

Significant knowledge of MySQL & PHP

Experience in LDAP /Active Directory

Experience with APIs / Apigility

Tools Used: AWS, JIRA, Agile, VMware vSphere client, GIT, Putty, Visual Studio, C#, SQL server,, ETL, SSIS, SQL reporting Manager, LAMP (Linux, Apache, MySQL, and PHP), PHP 5.6.3, Ubuntu 14.04, Laravel Framework, Zend Studio, PhpmyAdmin, XAMPP, Apache HTPP web server, OpenVPN, Jenkins, Puppet, Python, PyCharm, IDLE, Nagios, Linux, Moodle, Tableau.

CORE Education & Consulting Solutions, Inc. Oct’09 – Nov ‘14 Atlanta, GA

Production Application Support / Senior Application Developer

EdMastery, is a comprehensive K-12 assessment and learning management solution tool for students to take exams, lesson assignments and teachers/instructors to grade/ review the assessments/assignments. Edmastery is highly scalable and intuitive, allowing educators to easily use assessments in the classroom, within a school, or across the district or region. Edmastery allows development of question items, exams and lesson plans in easy to use system. The tool has gradebook facility for students, teachers, parents and administrators to review the summary and individual item scores. The tool can be used for formative, summative, high stakes or any other types of assessments as required. The edMastery product is based on C# / ColdFusion/ SQL server technology and has been used successfully at 10 different installations.

Responsibilities:

Managed day-day to operation for Edmastery – wearing multiple hats which includes project manager, architecture, designer, developer, tester, to keep the system running efficiently and highly visible within the company for past 4 years.

Experience in configuring, administration and maintaining the ColdFusion Application Server on the clustered environment.

Designed, developed, tested and deployed the entire application using Cold Fusion, C#, and SQL server on the clustered CF/SQL server environment.

Developed custom tags, CF Components and modules using Cold fusion.

Wrote Cold Fusion Scripts for business Rules, Administration and for various reports generation.

Coded Admin tools using Cold fusion.

Involved in multiple successful product release, server migration and new client accquistion.

Development of business requirements and program specs; database design and implementation; creation and maintenance of database and web applications; the ability to develop, execute, and analyze test plans.

Accountable person for the product which includes load testing, making sure invoices are sent on time, payments received, etc.

Revamped requirement management process by abandoning the existing approach of ad hoc changes based on client hourly email.

Managed on site and off-shore team which includes developing schedules and keeping track of budgets which includes servers, resource cost, data backups.

Managed resource allocations and hardware allocations for all edmastery customers.

worked closely with the senior management and development team to develop product strategy and lead its execution.

Key person for multiple migration for different clients which includes different versions of edmastery with around 10 diffferent sites.

Agile project management using Scrum.

Participated in daily Scrum meeting to discuss the daily status and sprint planning for the upcoming plan of development environment.

HomeRoom

•Development in WAMP/LAMP environment.

•Experience with PHPmyadmin

•OOP programming with Zend Framework (1.9)

•Assessment management with MySQL through query optimization

•Source version control with GIT

•Interactive UI design with AJAX, jQuery, CSS, HTML, JavaScript

•JavaScript frameworks such as jQuery or Prototype

•Configuration/admin of Apache 2.x

Tools used: Cold Fusion, SQL server, IIS, ASP.net, C#, PHP 5.3.28, MySQL, Eclipse, Komodo Edit, MySQL, SharePoint, Apache, Microsoft Visual Safe, MS Visual Studio, GIT, CSS, HTML, JavaScript, JIRA, @Task

AT&T / Cingular Wireless Apr’05 – Sept’09

Alpharetta, GA

Senior Technical Consultant

In AT&T's information technology universe there are currently many diverse systems that support departments and workflows, including support groups, applications, hosts and entities. While each of these systems performs a function that is essential to the corporation, each is by its nature an independent system.

By consolidating and establishing connections between important IT sites and key data elements, PRISM enables significant advances in the ability of stakeholders and management to easily locate the data they need for timely, fact-based decisions.

MyPrism is an web-based portal that facilitates project management and status reporting of active projects by providing a centralized project repository for project components like status, issues,timelines and artifacts & linking all other IT sites used by the AT&T(Cingular) IT division. This web based tool can be accessed via any compliant browser and provides real-time project information and reporting with easily understood “dashboard” interface with features like click and drag windows, RSS feeds, etc. The whole architecture is built using BEA WebLogic Server, Java, ColdFusion, SQL server, and Oracle 9i.

Responsibilities:

Gathered business requirements from the end users, analyzed and translated the business detail in to technical design and specification.

Designed, developed, tested and deployed the entire application using Cold Fusion, Java, and Oracle.

Helped team Architect for database designs.

Tuned complex SQL queries for better performance.

Wrote shell scripts for various staging and production code push.

Managing Production servers.

Monitoring the production & staging servers.

Scheduling & maintaining the cron jobs.

Troubleshooting cron job issues.

Designed Data Model and Screens for new versioning project.

Developed custom tags, CF Components and modules using Cold fusion, Java.

Wrote Cold Fusion Scripts for business Rules, Administration and for various reports generation.

Coded Admin tools using Cold fusion.

Used CVS for Configuration management.

Performed SQL server and ORACLE database duties on development, Integration and production databases.

Involved in re-engineering the existing database.

Created and maintained multiple T-SQL queries.

Created tables, views, Stored Procedure, functions, packages using PL/SQL.

Developed complex queries (nested, sub queries) to retrieve the data.

I was responsible and assigned to work with multiple teams on multiple roles across the PRISM team.

Coordinate with Development & Production managers to report the progress, track changes, and implement clients input.

Other responsibilities include mentoring other developers and supporting end users, creating testing scripts.

Tools used: Cold Fusion MX, Java, Solaris 8, BEA WebLogic Server 8.1, ClearQuest, Eclipse, Tortoise, WinCVS, MS-SQL Reporting Server, Macromedia Dreamweaver, JavaScript,SQL server, Oracle 9i, Erwin, Exceed, Putty, MS-Visual Studio

DEKA Technologies Inc. Jan’05 – Mar’05

Alpharetta, GA

IT Manager

LookingGlass ERP is a complete accounting system that can meet all of the accounting and business management needs of any size organization. LookingGlass ERP is implemented in ASP. Net and Visual Basic.Net, using Multi-Tiered design and taking advantage of today's latest most advanced database system, SQL Server 2000, Looking Glass ERP can meet all of the enterprise needs.

Looking Glass ERP's multi-tier design separates the Interface (Presentation Layer) from the Business Logic and the Database Layer, so the system can be easily adapted to environments or scaled across multiple systems. The system and all of its layers (Tiers) are completely written in Visual Basic.Net and ASP.Net. The system currently ships with the following tiers: a database tier in SQL Server 2000 or MSDE 2000, a VB .Net GUI presentation layer, an ASP .Net web-based presentation layer, and a business logic layer implemented using Web Services in VB Dot Net.

Responsibilities:

Application design & development using UML, Visio, VB.net, ASP.Net, Crystal Report, SQL-Server, SQL, Stored Procedures, Database Trigger and Database Procedure.

Interpreted client requests and took initiatives to resolve complex problems within the mandated timeframes.

Implemented all the business logic classes and the database interaction methods.

Build end-to-end business solutions as per departmental standards.

Managed cross-functional teams made up of developers, DBAs, web designers and engineers.

Involved in re-engineering the existing database.

Created Web Service & Web Reference layers for the multiple Presentation Layers.

Perform all SQL Server related duties including but not limited to: Design and maintain multi-million record databases; Stored Procedures, Triggers, Queries, and other T-SQL programming; DTS (Data Transformation Services), SQL Agent Job scheduling; security and user administration; database performance issues; automated data update; Write T-SQL scripts for data processing tasks.

Setup the entire database in SQL server 2000.

Visual Source Safe used as source code repository.

Responsibility includes installation, administration and maintenance of the entire database.

Created Tables, Views, Stored Procedures.

Setup the Application and database servers.

Tools used: .NET framework, ASP. Net, VB.Net, ADO. Net, Visual Studio.Net 2003, Web Services, SOAP, Visual Source Safe, IIS 5.0, JavaScript, SQL Server 2000,Crystal Reports, DTS, XML, UML, RUP, MS-Excel, MS-Access.

Federated Financial Corporation Jan’03 – Dec’04

Alpharetta, GA

IT consultant

LeaseLoan.com

LeaseLoan.com, along with its many secure extranets, is built using a high scalable architecture. The sites are built on a set of shared business rules that are accessed through CF Mappings. This allows LeaseLoan to rapidly adapt to new initiatives and market changes, and also improve performance of specific modules with out touching the applications. LeaseLoan's Real-time credit approval engine is a Java based solution, accessed from the pool of CF web servers via CFX tags initializing RMI connections to the remote App Servers. The whole architecture is built on Linux, Apache, CF, XML, Java, and Oracle 8i.

Responsibilities:

Coordinate with client managers to report the progress, track changes, implement clients input.

Designed, developed, tested and deployed the entire application using Cold Fusion, Java, Oracle.

Developed custom tags, APIs and modules using Cold fusion, Java.

Wrote Cold Fusion Scripts for business Rules, Administration and for various reports generation.

Developed PDF template with Acrobat Writer.

Coded Admin tools using Cold fusion.

Visual Source Safe used as source code repository.

Performed ORACLE database tuning, backups, exports, and imports on production and test databases.

Involved in re-engineering the existing database.

Created tables, views, Stored Procedure using PL/SQL.

Responsibility includes installation, administration and maintenance of the entire database.

Other responsibilities include mentoring other developers and supporting end users, creating testing scripts.

Tools used: Linux, Cold Fusion MX, Java, SSH Secure Shell Client, Visual Source Safe, IIS, Macromedia Dreamweaver, JavaScript, Oracle 8i, XML, SQL plus, SQL plus Worksheet, Crystal Reports.

Foodbuy LLC Sep‘01 – Dec’02

Alpharetta, GA

Project Manager

Compass Group USA - Applicant Tracking System

As a senior Application developer, I was assigned to develop an Applicant Tracking System for Compass Group (majority owner of Foodbuy LLC). Primary business reason to build an in-house applicant tracking system includes:

Reduce costs of recruiting.

Increase the quality candidates supplied to hiring managers.

Reduce recruitment cycle time.

Increase revenue for recruiting division of Compass Group.

Responsibilities:

Designed, developed, tested and deployed the entire application, with VB.NET, ASP.NET, ADO.NET, of more than 100 web application pages.

Created various Components to be used within code behind pages.

Perform all SQL Server related duties including but not limited to: Design and maintain multi-million record databases; Stored Procedures, Triggers, Queries, and other T-SQL programming; DTS (Data Transformation Services), SQL Agent Job scheduling; security and user administration; database performance issues; automated data update; Write T-SQL scripts for data processing tasks.

Setup the entire database in SQL server 2000.

Responsibility includes installation, administration and maintenance of the entire database.

Created Tables, Views, Stored Procedures.

Setup the Application and database servers.

Integrated with Microsoft Outlook using VB.NET and MAPI.

Tools used: .NET framework, ASP.Net, VB.Net, ADO.Net, Visual Studio.Net 2003, Web Services, SOAP, Visual Source Safe, IIS 5.0, JavaScript, SQL Server 2000,Crystal Reports, DTS, XML, UML, RUP, MS-Excel, MS-Access.

Foodservice.com – a Foodbuy Company

Foodservice.com is the largest community dedicated to the foodservice industry. The site attracts over 165,000 site visits each month for a variety of services, including an industry job board, product and company listings, discussion forums, weekly commodity market reports, industry news published daily, and a newsletter sent to over 30,000 subscribers each Friday. Foodservice.com was voted "Best of the Web" by Forbes Magazine in 2000 and 2001.

Responsibilities:

As the Web and Database Developer, I was tasked with maintaining the entire Web site as well as building new features into the site.

Entire web site, http://www.foodservice.com build on Cold fusion.

Involved in complete design and implementation of system using UML for class and workflow design, gathering use-case requirements from client.

Maintaining and Coding Stored Procedures for MS-SQL Server.

Supported, managed and integrated new modules to FoodService.com.

Wrote Admin Tools like Targeted Email Campaign (email to foodservice Operators, who has given permission to receive information from companies, doing business in the foodservice industry), billing summary, and demographic details.

Heavily developed dynamic pages, user interfaces, and mini-sites using Cold fusion, XML, ActiveX, COM, Java Applets, Visual Basic, MS - SQL Server.

Setup the Application and database servers.

WebTrends were used to analyze web traffic, track visitors, and web site statistics.

Tools used: Cold Fusion 5.0/MX, WebTrends, CGI, Java Applets, XML, ActiveX, COM, Visual Basic, MS-Windows 2000, MS- SQL Server 2000, CSS, JavaScript, HTML, VB Script.

GalSoft Inc., Atlanta Jan‘00 – Aug’01

Client: Optima Technologies, Inc.

Senior Application Engineer

Optima have established a library of pre-configured components, interfaces, and domain expertise in certain vertical industries. Developed in close conjunction with client partners and strategic alliances, Optima have created vertical solutions suites for the industries like financial planning, Healthcare, Insurance, Building Constructions and IT Consulting Practice Management.

Interpreted client requests and took initiatives to resolve complex problems within the mandated timeframes using ASP, MS-FrontPage, VB, XML, and Java.

Involved in re-engineering the existing database.

Developed class diagrams and object interaction diagrams as a part of low level design using Rational Rose.

Used Java servlets to create custom dynamic applications

Done heavy testing using Mercury Inertactive’s Winrunner, LoadRunner, etc.

Tools used: Visual Basic, ASP, MS-FrontPage, XML, Java, JDBC, Tomcat 3.3, JavaScript, HTML, VB Script, Winrunner 7, Linux Server, Oracle.

Client: Federated Systems Group, Duluth

Federated Department Store's Human Resource's employee self-service site (In-Site), allows real-time access to associate-specific information from the Federated intranet. Employees can display and update associate-specific information 24 hours a day from home, office, or a remote location (using a dial-in connection to the Federated private network). All updates made to personal information on the In-Site intranet, take place immediately.

In-Site provides Human Resource professionals with the following benefits:

Increased productivity for HR services and Federated employee services

Improved transaction accuracy

More time to focus on HR issues and not data processing

Enhanced associate communication

Responsibilities:

Involved in design of an online job application, accessible to both Federated Associates and external candidates. Involved in engineering the database and setting up the link from development center to client place. Developed class diagrams and object interaction diagrams as a part of low level design using Rational Rose. Developed Component Object Model (COM).

Tools used: Coding done using Visual Basic, Cold Fusion 4.5, JavaScript, COM, Applets, MTS, MSMQ, Visual Interdev, VBScript, Crystal Reports 8, Oracle 8 used as backend; IIS 4.0 used as web server.

Client: FACS, New York

Project: RMI (Return Merchandise Authorization via Internet)

The objective of this system is to obtain authorization for merchandise to be returned. It enables the vendors to annotate the disposition of return merchandise goods via Internet. The system replaces the current manual process involving faxes and telephone calls.

Interpreted client requests and took initiatives to resolve complex problems within the mandated timeframes. Involved in re-engineering the existing database and coding as per the requirement. Developed components using VB for the maintenance of database, login validation, etc. These components were extensively used throughout the project. Took initiative to setup IIS web server and make web server accessible from the workstation. Used Oracle as backend.

Tools used: Cold Fusion 4.5, JavaScript, HTML, VB Script, ASP, COM, DCOM, UltraEdit, Oracle, Linux Server

Client: PowerTel Inc – Engineering Reports

The objective of this system is to collect data from all Powertel Subsystems which include Voice Mail Systems, iSMSC, CMG-SMSC and VASP; and to generate Web based reports and graphs for Engineering and Marketing departments. The system consists of two parts: a) data retrieval and b) reporting. The data collection was performed on a Data Collection (DC) Server which is a Sun Enterprise Server with an Oracle 8i database. Data was loaded into the Oracle 8i db using SQL loader. Once captured, web-based reports and graphs were created and were accessible to authorized personnel with various levels of access privileges.

Responsibilities:

Involved in generating various reports and graphs, building the SQL queries, writing Stored Procedures, modifying existing Shell files to meet the client requirements. Utilized Cold Fusion as front-end and Oracle as backend (installed in Linux Server). Option was provided to view the graph in MS-Excel.

Tools Used: Cold Fusion 4.5, JavaScript, Applets, VBScript, COM, Visual Interdev, XML, Oracle 8 used as backend, Linux Server

Information Business System Inc., India May 95 - Dec 99

Lead Developer

Client: Corporate Intranet – IBS, United Kingdom

A system was required by IBS India to manage their entire Human Resources function, covering all aspects including interviewing and recruitment, maintenance of employee records, CV management and maintenance, and remuneration and performance records. The system was designed to be able to cater to most industries, and is therefore required a design that was both flexible and modular. An important part of the package is the query module enabling employees to be short-listed with specific combinations of skills.

Member of the team responsible for the Corporate Intranet development for IBS. Involved in interactions with the users to determine the requirements and to design the project. Responsible for coding and testing. Developed class diagrams and object interaction diagrams as part of the low level design using Rational Rose.

Tools used: Cold Fusion 4.5, Visual Basic, VB Script, Front Page, IIS, JavaScript, ADO, Windows NT, ASP, MTS, Visual InterDev.

Client: First Data Management Services, Melville, NY

Responsible for the coding, and testing of a Human Resources application. Developed class diagrams and object interaction diagrams as a part of low level design using Rational Rose.

Tools used: HTML, ASP, JavaScript, IIS, ADO, Windows NT, MTS, MSMQ.

Client: Comtech Wireless, Inc., NJ

Used Object Linking and Embedding (OLE) from sources such as the MS ClipArt Gallery, MS Word, and Oracle Graphics for an inquiry application. Created reports using Reports 2.5 with a report trigger for auditing.

Tools used: MS Word, Oracle, HTML, ASP, JavaScript, IIS, ADO, Windows NT, Crystal Reports

Client: Reckitt & Colman, Deutschland

BPCS Ver 6.0.04 modifications and developments

Reckitt & Colman, a Deutschland based company engaged in manufacturing of moulded Plastic furniture, was implementing BPCS 6.0.04 Client server version. Its business and operation was spread across over Europe. SSA (System Software Associates), Benelux was the principle consultant in this project and IBS was providing technical assistance. This involved studying the user requirement, understanding BPCS process, identification of modules for modification, development of technical specification, unit and system testing. Tasks involved programming, modifying existing programs according to the Conceptual Designs, which were developed to cater to the client’s Business requirements. This project was executed on site, which is in Deutschland.

Tools Used: IBM AS/400, OS/400, AS/SET, WIN 95/ WIN NT Work station,

RPG/400, CL/400

Contact this candidate