Database Architect / Senior Development Manager

VIJAYA SARADHI PRASADAM

Mobile: +91-789*******

E-mail: ***********@*****.***

DATABASE ARCHITECTURE PRODUCT DEVELOPMENT PROJECT MANAGEMENT

DATABASE ADMINISTRATION-SQL SERVER ALL VERSIONS

SENIOR IT PROFESSIONAL

~Expertise in Database Architect, Database Administration and leading Project Management activities including project scoping, planning & estimation, management of risks, finalization of technical & functional specifications, resource planning and quality management for the products~

Technocrat with over 16 years of rich & extensive experience, Database Architecture and Database Administration with Database modeling, development, optimization, and High availability technologies

CORE SKILLS

Product Development

Project Management

Onshore/Offshore Management

Software Development

Application & Web Development

Client-Server Integration

Database Administration

Technical Architecture

Stakeholder Management

Product Support & Maintenance

Client Relationship Management

SLA Management

Team Building & Leadership

PROFILE SUMMARY

Experience in developing project baselines; monitoring and controlling projects with respect to cost, resource deployment, time over-runs and quality compliance to ensure its satisfactory execution

Impressive fast track career driven by challenges and desire to be successful; experience in leading multiple projects; successfully completed various projects

Rich experience in developing & delivering reliable & scalable systems in areas like Integrated Land Information Systems, Property Management Systems, Business Intelligence, Price Optimization and Central Reporting

Resourceful in managing SQL Database Management, Database architecture, Optimization and Development using development on SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012 and migrating to SQL Server 2016

Directing technology planning & direction, strategy development, leadership & implementation, business & operational transformation execution, business solution delivery

Expertise in mapping client’s requirements, custom designing solutions and troubleshooting for complex information systems management

Capabilities in monitoring project operations with key focus on defining SLA’s & SOP’s as well as interacting with prestigious clients, business partners, industry leaders & other key stakeholders

A strategic planner with proficiency in accelerating employees’ strengths and building powerful teams that can conquer any obstacles

An effective communicator with relationship management skills; capacity to work under tight deadlines and execute projects satisfactorily

AREAS OF EXPERTISE

Database Architecture, installation, configuration, Database modelling and administration in MSSQL Server all versions

Capacity Management (Load balancing)

Security Management

High Availability Management

Backup and Recovery Management

Performance Tuning

Process Improvements

Daily, Weekly and Monthly maintenance

Installations / Upgrades / Patching

Health Checks / Report Analysis

Skilled in SQL Server tools, including Enterprise Manager, Management Studio, Performance monitor, Profiler, SQL Server Agent, DTS, SSRS and SSIS

Strong working knowledge of high availability SQL Server solutions, including SQL Server clustering, SQL server replication, database mirroring, database Snapshot and SQL Server Log shipping

Capable of SQL programming concepts, physical database design, SQL Performance tuning and replication

Managed high-volume databases ranging from 300GB to 2TB and supported more than 500 hundred production SQL server instances in Property domain

Experience in monitoring and troubleshooting SQL server related issues

Developed query execution plans and index tunings wizard for query and server optimization

Migrated SQL Server 2000 to SQL Server 2005/2012/2016 (Side by Side)

Experience in VMware® vSphere Client, skilled in creating & managing virtual machines, storage moves and monitoring infrastructure

WORK EXPERIENCE

Since Jul’07 Realpage India Pvt Ltd., Hyderabad

Key Result Areas as Senior Product Development Manager / Database architect:

Heading a team of 25 direct reportees of multiple Product Development Teams for the division

Collaborating with teams located offshore in US & Philippines

Leading product development involving various technologies –C#, ASP.net, PHP, Selenium, JavaScript, jQuery, Java MYSQL, PostgreSQL, SQL Server and Oracle

Managing all aspects of resource management including technical talent acquisition, resource planning, allocation, Quarterly and yearly performance evaluation, training & development and mentoring/coaching

Following new processes/tools like SAFe agile, Azue and 100% adherence to logging effort in Orbs/Launch

Ensuring:

oTeams understand the process of zero net new defects, addressing within same sprint and release

oActive team in agile ceremony like sprint planning, grooming and retrospective

Working with Developers, QA and Devops on pod improvement and imparting angular training to the teams

Chairing scrum meetings to identify impact on existing code and duplicate efforts

Creating SBA dashboard for each sprint providing sprint progress overview to next level management

Recording sprint demo's, conducting retrospective meetings and listing corrective actions for better planning future sprints

Recognizing early risks and escalating to business to take quick action for resetting priority

Liaising with Services team to understand the expectations of RealPage clients and how to add value to their business

Sharing business updates during scrum meetings and checking on how to achieve RP goals

Conducting:

oDaily status meetings to track bottlenecks & showstoppers and later discussing with US counterparts to get more information to address the defects/tickets efficiently

oOne-on-One meetings with team and Reporting Managers (US) to understand issues to maintain strong collaboration among onshore and offshore

Attending weekly development, leading daily status meetings with US counterparts to understand process flow and business knowledge

Supporting team by sharing product knowledge to address the defects efficiently within a timeframe

Working towards team’s career growth along with their performance review, showing right direction for their growth and ensuring 100% SLA adherence and owning to successful end-to-end service delivery

Tracking progress to ensure completion of project milestones on time, on budget and with the desired results

Defining processes and tools best suited to each project; adapting Agile & Waterfall approaches depending on project specifics, creating detailed project road maps, plans, schedules and work breakdown structures

Building credibility, establishing rapport, and maintaining communication with stakeholders at multiple levels, including those external to the organization

Facilitating delivery excellence through process improvements, quality assurance checks of critical deliverables, internal audits & identification of risk/issues

Driving excellence in service delivery execution; resolving project issues; taking ownership and continually improving delivery methodologies for cost reduction

Enabling teams to mature their agile practice through consistent and timely coaching; working with new agile teams intensely to ensure adoption of excellent practices and principals

Delivering trainings & teaching valuable skills that lead organization-wide adoption of Agile & Scrum methodologies

Preparing design specification plans as per customer requirements and providing enterprise solutions for architecture

Performing installation & migrations of various technology solutions within network; developing architecture plans

Analysing customer requirement for advance service products, coordinating with business firms and developing appropriate solutions for customers

Key Result Areas as Scrum Master:

Shared business priorities for PI planning meeting, managed all user stories independently, planned capacity of the team, resulting in successful PI Planning

Collaborated for business updates/priority during scrum meetings

Recommended various trainings to team/colleagues in RP helping them in their day-to-day activities

Directing post PI planning, coordinated with the team and delivered the user stories as planned

Supported team to identify any bottlenecks and provided solutions in a timely manner

Managed story point estimations, team retrospectives and provided feedback on team's performance

Chaired scrum of scrum meetings to identify impact on existing code and duplicate efforts

Undertook brainstorming sessions along with the team to prepare unit testing framework which can be used across Pods

Highlights:

Pivotal in reducing:

oDuplication of code by delivering common & reusable components and unified approach

oUDS/Central defect count with comparing previous years; acknowledged by clients for immediate resolution of issues

Effectively managed Raul pov2 application and upgraded it to the latest version of angular

Worked on back-end services and fixed bugs whenever needed Worked on adhoc tickets based on business priorities

Project Managed:

Title: Business Intelligence & Central Reporting & Price Optimization

Client: RealPage, Inc

Applications: jQuery, Cognos, SQL Server 2012 and 2016

Description: RealPage is leading global provider of software and data analytics to the real estate industry. Client’s uses platform to improve operating performance and increase capital returns. Founded in 1998 and headquartered in Richardson, Texas, RealPage, currently serves nearly 12,200 clients worldwide from offices in North America, Europe and Asia.

Title: Business Intelligence

Description: RealPage Business Intelligence accelerates profitability through increased revenue and reduced expenses. Gain valuable insight & clarity into performance across your portfolio. Identified risk & opportunity, access contextualized analysis impacting the metrics that drive performance from customizable dashboards, custom reporting and foundational reports to actionable scorecards, checked answers when needed and to maximize your returns.

Title: Price Optimization

Description: Price Optimizer weighs a much more robust set of data, “It used MPF™ market data to track the submarket’s conditions more accurately, and it focussed on property’s internal fundamentals, like leasing velocity, current and future availability, and the rents which was actually achieved on new leases & renewals.

oIntegrated with all major operating systems

oThousands of KPIs

oFlexible customizable dashboards

oDaily updates

oCustom reporting with the most comprehensive and easy-to-use custom report writer in the industry

oDrill-down capability, transaction-level granularity and integrated external data

o360-degree insight into key metrics including operational, marketing, demographic, facilities, screening, accounting and affordable compliance

oCovers Conventional, Student, Senior and Affordable assets

Dec’04-Jun’07 Speck Systems Ltd., Hyderabad

TECHNICAL SKILLS

Languages C#, Java (Framework) .NET Framework 2.0 & 4.0

Web Related ASP.NET, ASP, JavaScript, Jquery, XML, XSLT HTML, DHTML and XML

RDBMS SQL Server 2000, 2005, 2008, 2012 & 2016

Reporting Tools SSRS, SSAS & COGNOS

Open Source MySQL & PostgreSQL

Operating Systems Windows 95/98, Windows 10/2008 Server

Scripting Languages JavaScript, VBScript, jQuery, XML, XSLT

Packages Office 2003 and Office 365

Tools/Technologies/Utilities VSS6.0, TFS, Jira, GitHub

Design/Process SDLC: Agile methodology, Scrum framework (Scrum Master Role & Scrum Product Owner Role), traditional waterfall, iterative

Data Warehouse SSAS, Inhouse tool ETL Engine

Cloud Technologies Azure SQL Server and DevOps

x

Annexure

Projects Managed

Project 1

Title: Integrated Land Information Systems (ILIS)

Client: Government of Andhra Pradesh

Applications: ASP.NET, VB.NET 2005, SQL Server 2005

Period: Since Sep’06

Description: Under this project, working on mock-up database design for the system, conducting SDD discussions for various modules in the system and GUI form design discussions.

Project 2

Title: Cadastral Management Systems

Client: Speck Systems Ltd.

Applications: Windows 2000, Oracle 10g, VB.NET 2003, ArcGis, ArcSde

Period: May’06-Dec’06

Description: Under this project, provided a customized and rule-based environment for editing of data in the GIS Center’s GeoDatabase. It was used to integrate Cadastral data workflow with Land Department of Municipality, build security and integrity in workflows of various departments maintaining spatial data. The application had an administrator tool facilitating user interface and service customization supporting in ensuring data editor access to the required tools & functionality. Through this application, only Administrator were allowed to change the application’s interface. The project entailed an extensive validation mechanism to ensure integrity of data, which validated geo-database rules, topology rules and custom rules defined by the Administrator.

Project 3

Title: MTS (Main Technical Stores)

Client: Military College of Electronics and Mechanical Engineering

Applications: VB.Net, ASP.Net, SQLServer2005

Period: Feb’06-Dec’06

Description: MCEME was a training establishment controlled by headquarters and had a faculty to train senior officers, junior commissioned officers, etc. to impart training, MCEME authorized all the equipment & spares used by the Army. The software provided the institute an integrated material management functions with nodes at each faculty / wing, TSG, Accts Sec.

Project 4

Title: Storage Management System (Archival and Retrieval System)

Client: ARMY HEAD QUARTERS – MI-17

Applications: VB.Net, Oracle 9i and Windows 2000 Professional

Period: Feb’05-Jan’06

Description: The project aimed at providing a secured & centralized Database Management System through Multiple output stream and limited input stream. It was undertaken with a principle to get a backup of the images for the production, whenever required. The process had few modules like Archival module containing all information of the image (Image Date, Latitude, Longitude and Sensor) & Retrieval module containing the searching techniques that would retrieve the particular image while displaying image details & its thumbnails. The 3rd module was a demand module including details of the individual demanding image and sender. The 4th module was a Map View Search module including Geo-Referenced Map through which a user can click on that map and the process will display all the thumbnail images present in that particular Lat & Lon providing some additional features to it. The last module was Final Report Module generating reports for Archived Image Details, Demand Details, Log Data, etc.

Enhancements: Integrated with Fotorite Software, New Fotorite Module has been added to the system setting images to be printed in the job queue. The software helped in maintaining the various priority levels. After the printing, the A&R software was fired, after which the Archival module would store all the fotorite parameter and image details. This would saved image while placing it in the secondary device. The retrieval mode would retrieve the same image with archive fotorite parameter for re-printing. In this, security level has been given to different user, so that only authorized person can retrieve the image, administrator had all rights on the system where as other user has been restricted to certain level.

EXPRESSASIA.COM SDN BHD, MALAYSIA Dec’00-Aug’04

Project 1 www.expressasia.com

Client: expressasia.com Sdn Bhd.

Applications: VB.Net, ASP.Net, SQLServer2000

Role: Software Engineer

EDUCATION

LLB from Osmania University in 2018

MBA (Information Systems) from MS University, Tirunelveli in 2012

MCA from Andhra University in 2001

Diploma in E-commerce from New Era Software Technology in 2001

Diploma in Advanced Programming from New Era Software Technology in 2001

Bachelor’s degree Special English from Nagarjuna University, Andhra Pradesh in 1994

Microsoft Certified Professional; Database Administration in SQL Server 2005 & 2016

Brain Bench Certified Professional in ASP 3.0

PERSONAL DETAILS

Date of Birth: 9-10-1975; Languages Known: Telugu, English, and Hindi

Address: Flat No.201, Sri Ratna Vihara, Adjacent lane to Bus Body Building Unit, Near Nagarjuna Enclave, Miyapur, Hyderabad - 500049

Contact this candidate