SUMMARY

• Over 13+ years of experience as Project Manager/Scrum Master and successfully Managed and delivered Enterprise level Large to Medium scale projects.
• Provide successful IT service focusing on tools, process, tests and quality control for product development.
• Demonstrated expertise in creating, analyzing and applying Project Management Institute fundamentals (PMBOK) to the solution of complex problems.
• Proficient with Share Point, Microsoft Visio and full understanding of the Software development life cycle (SDLC).
• Interacting with different business and project stake holders, consensus building, requirements gathering, translating the business requirements into technical functional specifications, make sure business requirements are fulfilled and delivered as per the commitments.
• Provided a weekly update to project executive sponsors.
• Experience managing the complete Project planning and execution.
• Experience managing onsite and offshore team
• Knowledge of contracting trends, licensing models, and traditional and emerging contract and vendor performance models
• Created training material for new project members and managed on boarding of new project members,
• Strong business analytical skills, organizational skills, oral written communication skills, cross group collaboration, negotiation and decision - making skills;
• Developing and negotiating contract terms, conditions, modifications, penalties and incentives, while working with key stakeholders to ensure that their requirements are met.
• Good knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• High level proficiency with requirement analysis, system design, and Object Oriented Design (UML).
• Strong SQL Server Administration skills using various backup strategies, Model (simple, bulk and full), database maintenance plan, user (NT/SQL) security authorizations, database creation, Tables, indexes.
• In depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views for speedy performance using SSMS and SQLCMD.
• High proficiency with SQL Server Architecture (Fundamentals of SQL Server Architecture, Features of SQL Server, Relational Database Components, Database Architecture, Relational Database Engine Architecture, Administration Architecture, Application Development Architecture).
• Proficient in monitoring SQL Server Performance using SQL Profiler(Dead Locks/Long running queries), Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard and Windows Performance Monitor.
• Microsoft Certified Technology Specialist - Microsoft SQL Server Implementation & Maintenance (70-431).
• Experience in implementation and maintenance of Very Large Databases (VLDB) and estimating the growth of the databases and maintaining Fill Factors.
• Highly skilled in data migration of data from Excel, Flat File, Sybase, Oracle to MS SQL Server using tools like DTS, SQL Server Integration Services (SSIS), BULK INSERT, BCP and Replication between SQL Server (heterogeneous/homogenous).
• Experience in Disaster Recovery with Backup and Restore Strategies and scheduling those backups.
• Experience in creating jobs, SQL Mail Agent, Alerts, operators and schedule SSIS and DTS Packages.
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Database Security.
• Hands on Experience in implementing Log Shipping for fail over support and Database Mirroring.

TECHNICAL SKILLS

Relational Databases: SQL Server 2016/2012/2008/2005 / 2000 / 7.0 , MS-Access 2000/2003/2007 , Oracle 9i & 10g, My SQL4/5.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC,SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages: C, C++, C#, JAVA, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL.

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor.

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. Project Manager/Scrum Master

Responsibilities:

• Responsible for planning and implementing all the SQL Server’s Data Center Migration from Moni old data center to New Data Center with Zero production down time.
• Coordinate the development and support of multiple Software as Service applications. Monitoring progress to ensure specified time lines are met with required deliverables.
• Manage development projects from concept to implementation. Maintaining project scope, determining valid time lines, and providing progress updates.
• Develop strong team relationships by providing weekly status reports to key stakeholders and IT teams which included a cost performance review and schedule tracking.
• Manage multiple complex IT projects through MS Project and other management automated tools, using both Agile and traditional Project Management methodologies.
• Organized and facilitated Project/Sprint planning, daily stand-up meetings, reviews, retrospectives, sprint, release planning, demos, and other Scrum related meetings.
• Directed business forecasting and financial analysis activities and identify opportunities and risks along with action plans to ensure attainment of project financial goals.
• Responsible for meeting with customers, determining requirements, communicating the requirements to the internal architectural team and managing the overall implementation to make sure all groups are working toward a single goal.
• Scrum Master for the team handling the development efforts, project planning and budget planning of the development efforts.
• Facilitating sprint planning, sprint review and sprint demos for development team, Risk Planning and Release forecasting for the Development team
• Reporting overall status to PMO
• Act as primary point of contact for development teams, oversee daily workflow of teams and track project deliverables.
• Resolving impediments for the team via collaboration with external teams, awareness and effective relationship building
• Providing the SME knowledge to the process leads and helping then adopt Agile practices.
• As a Scrum Master and helping them adopt Tools for Agile Planning
• Scrum Master of the Tools Enhancement Development Team.

Confidential, Irving, TX

Sr. Project Manager/Scrum Master

Responsibilities:

• Responsible for overall coordination, status reporting, financial reporting, and stability of technical software development, infrastructure and/or implementation project oriented work efforts. Responsibilities included managing multiple projects simultaneously.
• Established and implemented industry best practice project management processes and methodologies to ensure projects are delivered on time, within budget, and adhere to high quality standards to meet or exceed the needs of the clients.
• Negotiated and communicated changes regarding scope, budget or schedule of the project and acted as the final decision-maker during all stages of the project life cycle.
• Working as a Scrum Master and Agile Coach in implementing Scrum as an Enterprise Project Methodology.
• Agile Adoption- Leading the effort, creation of Agile Center of excellence.
• Jira Tool Configuration and Administration for Agile adoption.
• Creating team dashboards in Jira to effectively communicate the status to the management
• Educating the teams on Scrum Methodology.
• Facilitate communications between the Product Development team and the other areas of the organization such as Product Management, Sales, Services and Support.
• Work in a Scrum Master role as the organization transitions from a waterfall to agile process.
• Lead Scrum Meetings (Daily Stand-ups, Release Planning, Sprint Planning, Sprint Reviews, Retrospectives, Scrum of Scrums, and Backlog Grooming sessions).
• Create documentation in the form of specifications, User Stories, and Organizational (Internal) User Guides.
• Assist with User Interface design including creating wire frames and working closely with developers to approve prototypes.
• Conduct new functionality reviews throughout the development process with stakeholders to ensure that the design and functionality meets expectations and acceptance criteria.
• Created User stories, Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc.
• Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, and Regression Testing and logged down defects using JIRA.
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision making support.

Confidential, Bentonville, AR

Sr. Project Manager/Scrum Master

Responsibilities:

• Actively participated in managing the GFCS project and interacted with Confidential customers, Business Analysts in gathering business requirements and implementing them.
• Responsible to manage and approve Change controls for SQL Server in Remedy for Pilot, and Production Rollouts.
• Managed project throughout the project lifecycle (Initiate, Plan, Execute, Control, and Close).
• Planned and directed activity definition and sequencing, project schedules milestones, deliverables, cost estimates, quality requirements and plan.
• Worked with stakeholders to formulate and define project scope and objectives and to define project requirements, deliverables and continuously managed stakeholder expectations.
• Established communications with interdependent projects, worked collaboratively to meet deliverables.
• Ensured that the quality of project deliverables meets customer requirements.
• Established objective outcome based metrics that can be used to monitor and communicate the effectiveness of IT Project delivery
• Defined and executed the existing project governance controls to Agile/SCRUM project methodologies that can be applied across multiple projects of varying size and complexity.
• Facilitated regular resource planning discussions across IT in an effort to forecast, monitor and advise on overall resource supply and utilization and resource constraints.
• Conducted integrated change control including project plan updates and performance reports.
• Closely monitored change requests and prevented unapproved requirement modifications that would have resulted in scope creep.
• Planned and facilitate lessons learned meeting and captured lessons learned at the close of each project phase and documented the project for appropriate knowledge transfer.
• Developed, monitored, and reported status using Earned Value Management.
• Mentored project team members on best practices, PM methodologies.
• Defined the scope, financial projections and Cost/benefit analysis. Progressed from Problem Statement to well-documented designs.
• Conducted JAD sessions, Document Analysis and Interviews with Stakeholders for requirements.
• Prepared Business Requirement Documents (BRD) and Functional Requirement Document (FRD).
• Decomposed BRD into User Stories by conducting story writing session with product owner
• Involved in facilitating scrum ceremonies such as Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective.

Confidential, Addison, TX

IT BI Project Manage r

Responsibilities:

• Created tables, indexes, constraints and Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Managed large teams of multi-disciplinary professionals (PMs, BAs, and development team members)
• Developed and documented PMO standards, practices and methodologies for project management and drove consistency and structure in project planning and execution by enforcing standards and best practices
• Assessed business process gaps and required changes to address gaps of fine tune existing processes.
• Identify and address operational impacts and post go-live support considerations
• Served as the liaison between the business units (their project sponsors, steering committees, risk & IT professionals, legal, compliance, tax, business managers), subject matter experts and the technology teams to maintain all cross-functional communication related to tasks and project rollouts.
• Worked closely with developers through all stages of a project development life cycle, tracking progress and making tradeoffs in line with priorities and complexities.
• Prepared, or assisted in the preparation of financial models and competitive analyses for projects.
• Identified key project objectives, risks, and drivers and create plans to manage these elements.
• Managed projects already planned against release dates. Track project interdependencies, milestones and deliverables to ensure successful project implementation and rollout.
• Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.
• Good experience on working with Extract, Transform and Load (ETL) tool.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
• Developed SSIS packages to extract and transform data and Involved in Scheduling SSIS Packages.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources using the concept of OLE DB.
• Developed SSIS packages and deployed into Dev, Test and Production Environments.
• Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
• Managing the use of disk space, memory and connections.
• Performed software installation and upgrade, capacity planning
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Eased administrative work through automatic script performing daily/weekly backups
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases.
• Performed DBCC checks which will helps to maintain physical consistency of the database.

Confidential, Irving, TX

IT Project Manager

Responsibilities:

• Responsible for Providing 24x7 fast paced DBA support for production, development and testing environment.
• Execute and maintain program management processes and disciplines in the areas of program schedule and quality management; communications management; human resource management; cost management; procurement management; risk / issue management and change management.
• Serve as a liaison and drive consensus among Sales, Product Management, Operations and Vendors to promote cross functional teamwork on product roadmap.
• Develop business plans; create project charter to ensure attainment of company goals and profitability using Microsoft Project.
• Create and execute project work plans and revise as appropriate to meet changing needs and requirements using Microsoft Project.
• Perform quality assurance and quality control to meet client deadlines and specifications.
• Responsible for program and portfolio management activities.
• Coordinate presentations to top management and other personnel offering alternative options to business solutions for effective service delivery.
• Provide timely updates and feedback to senior management.
• Establish priorities for key product deliveries, monitor and track work progress frequently using Microsoft Project and Excel.
• Responsible for creating, scheduling and monitoring SQL server agent jobs, alerts provide database maintenance process in production and internal environment.
• Worked with Client/Server tools like SQL Server Enterprise Manager and Query analyzer to administer SQL Server.
• Setup and maintain Transactional replication and Snapshot replication.
• Responsible for capturing and analyzing the long running stored procedures using SQL Profiler and tune the same to improve application performance.
• Involved in performance tuning of the database, troubleshooting, managing the use of disk space (capacity planning), memory and connections.
• Create jobs, alerts, logs to monitor the database errors and develop, deploy and maintain Reports using DTS and SSIS Packages.
• Updating with latest service packs and security patches for SQL Server 2005.
• Responsible for maintaining data load process, leads load process, implement new enhancements and provide production support.
• Created stored procedures to create dynamic SQL Queries to adopt dynamic environment.
• Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions.
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication.
• Designed and Deployed different reports in the Servers using SQL Server 2005 Reporting Services.
• Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.
• Performed DBCC checks which will helps to maintain physical consistency of the database.
• Actively involved in support for all major production releases.

Confidential

IT BI Team Lead

Responsibilities:

• Create and maintain various databases for Development and Testing Environment using SQL Server 2000/2005 and involve in actual Relational Database Design for high OLTP environment.
• Directed project management and project delivery resources and implemented a project management methodology, a Project Management Office, a collaborative workspace, training and coaching.
• Served as a member of the Governance Committee to select corporate projects
• Created corporate presentations for senior management and key facilitator of JAD sessions.
• Standardized best practices, installations, upgrades, patching instructions, guidelines, reports, spread sheets, deliverables, forms, RFPs.
• Involved in creating flows for Problem Management processes to resolve the root causes of incidents and thus to minimize the adverse impact of incidents and problems on business and coordinate with senior management on issues
• Demonstrated excellent organizational and administrative skills involving Technical Leaders in the WBS and SOW decomposition and evaluation, a new PMO initiative.
• Involved in Risk management defined processes for identification, assessment, and prioritization of risks followed by coordinated and economical application of resources to minimize or maximize the realization of opportunities to help the web and portal development.
• Defined Risk mitigation measures and evolved as an excellent decision maker in case of complex production related problems
• Involved in Contracts and Vendor Management for smoother contract development, negotiations, facilitations and execution.
• Experience with third party tools like Embarcadero, AR Remedy system to access the SQL Server.
• Created the Physical and Logical Model of the databases by using Erwin 4.0.
• Created scripts for tables, stored procedures, and DTS and SSIS, (SQL 2K5) tasks.
• Physical Implementation and application of Schema changes to SQL Server database using Power Designer View.
• Created tables, indexes, constraints and Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.
• Good experience on working with Extract, Transform and Load (ETL) tool.
• Exported data from different data sources like Excel, Flat File to SQL server 2005 using SSIS.
• Using Import/Export wizard to move data from flat files and Excel sheets to SQL Server using SSIS.
• Developed a Database Maintenance Planner for the Performance of SQL Server, which includes Re-indexing, Database Integrity Checks and Update Database Statistics.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
• Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
• Managing the use of disk space, memory and connections.
• Performed software installation and upgrade, capacity planning
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Eased administrative work through automatic script performing daily/weekly backups
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases.
• Performed DBCC checks which will helps to maintain physical consistency of the database.

Confidential

IT Team Lead

Responsibilities:

• Designing and creation of tables and stored procedures with E-R diagrams.
• Writing the stored procedures, checking the code for efficiency using T-SQL.
• Define system requirements; develop detailed functional specifications, processes and working parameters review Technical Spec, Test plan, Test cases etc.
• Coordinates activities within department and between organizations.
• Proficient with share point, Microsoft Visio and full understanding of the software development life cycle (SDLC).
• Creation, maintenance & communication of a detailed project plan (in Microsoft Project & Clarity) for each project.
• Interfacing with all key vendors to manage deliverables and Vendor selection and contract management.
• Provide successful focusing on process, tests and quality control for product development.
• Stakeholder communication and expectation management.
• Managed work assignments, performance assessment.
• Creation of user Databases and installation of MS SQL Server 2005.
• Created and maintained various databases for development and testing environment using SQL Server 2005.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers through query analyzer.
• Data Transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler and NT monitoring tools.
• Developed SSIS packages to extract and transform data and Involved in Scheduling SSIS Packages.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources using the concept of OLE DB.
• Developed SSIS packages and deployed into Dev, Test and Production Environments.
• Testing the stored procedures performance and its path of execution by using SQL Profiler.
• Trouble shooting and supporting all user problems by using SQL server profiler and network traces.
• Recovering the Backups of SQL Server production databases in test servers as part of regular maintenance activities.
• Developed SSIS packages to transfer logins from primary to secondary DB for log shipping for extracting data from various data sources like flat file, excel sheets.
• Used SQL Server Profiler for collecting traces and check performance.
• Responsible for checking databases, jobs, nightly backups on all servers and monitored system log, security log on Event Viewer.

Confidential

SQL Server DBA/Developer

Responsibilities:

• UpgradedSQL Server 7.0to SQL Server 2000 and migrated data from old systems to new systems
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training
• Actively involved in Normalization & De-normalization of database.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Configuring, tuning, and optimizing SQL Server 2000.
• Developed complex financial reports using Crystal reports.