Project Lead / Database Architect Resume

PROFESSIONAL SUMMARY:

18 years of experience in the IT industry and Functional domain experience involves Retirement, Purchase & Inventory, Accounting, Payroll, and Sales & Distribution
13 years of Professional experience working in the capacity of Architect, Performance Tuning Specialist, Sr. Database Developer Analyst and SQL Engineer
10 years of experience in team management
Highly adaptable and experienced SQL Database Developer with a proven track record of high client satisfaction
Excellent experience in Data/Database Migration projects
Superior ability to support and develop analysis solutions and data transformations
Expertise in Query performance, Superior technical problem - solving and code debugging skills
Excellent ability to develop and implement data and reporting solutions
Profound understanding of SDLC (software development life cycle)
High achievement record in process quality improvement and efficient data solutions management
Superb maintenance of all working relationships
Comprehensive knowledge of computer languages
Extensive experience in Oracle and SQL Server Database design developing T-SQL queries, stored procedures, and triggers using SQL Server 2000, 2005,2008,2012,2014
Effective in working independently and collaboratively in teams and proactive and results-oriented leader skilled in mentoring and motivating the dynamic team to exemplary performance.

TECHNICAL SKILLS:

RDBMS and related tools: SQL Server, Oracle 7.x, 8.x, Oracle 8i, Oracle 9i, DBA Studio, SQL*Loader, Toad, SQLLiteSpeed, ERWIN, SQL Profiler, SQL Query Analyzer

NoSql DB: Mongo DB

Programming Languages HTML, JavaScript, T: SQL, SQL, PL/SQLDevelopment Tools--Developer Forms 6i, 5.0, 4.5, Reports 6i, 3.0, 2.5

Reporting Tools: SQL Server Integration Services (SSIS), Crystal Reports, SQL Server Reporting Services (SSRS), Crystal ReportsVersion Control Software -- Visual SourceSafe, Perforce and TFS

WORK EXPERIENCE:

Confidential

Project Lead / Database Architect

Responsibilities:

Database Tool development(database backup and restoration application)
Database Optimization and Performance Tuning
Database Design / Modeling / Complex data migrations and upgrades using SSIS packages
Identified and optimized SQL statements in stored procedures/reports, which werepain points. There was a 30% improvement in the stored procedures and 50% improvements in the reports.
Extract, transform, and load data from legacy IBM servers into SQL Server
Track and report weekly on per cent complete, slippage, project effort and duration to complete and other key project metrics.
Lead the team to prioritize signed off project work based on analysis of strategic importance, tasks outstanding, obstacles or barriers, resources and deadlines.
Developed aData Archival Tool, which archives data (1 year old data) to an archival database and deletes from the real time database over the weekend as a part of the weekly database maintenance schedule
Manage offshore database team
Provide functional and technical expertise to team

Confidential

Project Lead

Platform: Visual Studio.NET 2005, .NET 2.0, and VB.NET, ADO.NET, XML, XSLT, SQL Server 2005, BizTalk 2006, Microsoft Enterprise Practices Library, ILOG Rules Studio, SSIS, GECS, SQL Reporting Services, IIS 6.0, Windows Server 2003

Responsibilities:

Involved in performing feasibility analysis and studying the existing system
Managed the software team and reported to the managers
Worked with DBA\'s to create users and groups on IQ and granting appropriate permissions
Created database libraries to be reused in various applications.
Provided end-to-end data analysis, documentation to map data, work flow, and processes from disparate sources
Query Optimization for handling large amounts of data and making data retrieval faster
Analyzed data for business users and answer specific questions.
Provided oversight and design support to Production Support resources

Confidential

Team Lead

Platform: HTML, JavaScript, Reports 6i, and Oracle 8i

Responsibilities:

Corresponded with the clients and explored the prospective customers
Preparation of presentation using Microsoft PowerPoint, documentation of software developed for users, programmers, and management
Managed the team members, trained new employees, as well as established employees
Responsible for requirement gathering, analysis, and design
Developed ad-hoc database queries and reports for users

Confidential

Platform: Forms 6i, Reports 6i, Oracle 8x

Team Lead/Programmer

Responsibilities:

Coded, tested, and integrated different modules
Validated and reorganized data collected from various concerned sources
Designed database following normalization rules
Maintenance and upgradations of previously developed applications
Developed stored packages, procedures, and functions

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship