Project Manager
Resume:
Sara Sundar
SUMMARY
Areas of focus: Team Lead, Database Design/Architecture/Implementation, Application Development,
Team Lead. Process Improvement, Implementation of standards, Project Management, Business Analysis,
Software development and Data migration using ETL tools.
Toolsets: Microsoft SQL server 200 8/2005, SSIS, SSRS, Cubes, MySQLl,.net/JAVA, Microsoft Project
2000, Visual Basic, Epic systems, Crystal Reports, Oracle SQL/PLSQL, SQL Server, ASP, Platinum,
Visual Foxpro, all standard office tools: Excel, Access, Word, etc.
Past and present contracting successes include HealthCare Partners, RAND, Baxter Bioscience,
Countrywide, Hewlett-Packard, Account-A-Call Corporation, and MetLife.
PROFESSIONAL EXPERIENCE
HealthCare Partners – Los Angeles, CA March 2012 -Present
Team Lead/DBA - SQL Systems.
Production DBA, supporting 24/7 terabyte SQL database. Monitor daily Jobs with alerts, perform
maintenance tasks (backup, update statistics, truncate logs etc.). Install SQL Clusters. Install Service
Packs, most of all our production servers are clustered. Create jobs that generate slow processing queries,
tasks. Periodically study trends and remove or add indexes. Implement procedures, policies, standards for
the team for coding and naming. Create and implement security policies by creating groups, so one
individual has access to modify production DB. Create SSIS packages to import and export data from
vendors to merge with our patient data and also import and export data from our mainframe for our Data
Warehouse. Create SSRS reports to for several internal teams. Support new application implementation
(EPIC). Install SQL Clusters. Install Service Packs. Train team members. Also work with Application
team to design and recommend appropriate database design. Recommend new storage ideas based on
application need (EMC, VIOLIN, SAN
Perform Clarity ETL batch operations from the Epic Chronicles to Clarity relational data base. In addition
perform additional ETL procedures to extract data and clean the data, to conform the data is production
ready. Responsible for SU/EPIC upgrades.
Key Accomplishments:
• Install clusters, define hardware requirements, migrate production and QA systems successfully
to meet goals.
• Exceed expectation as a support team that is critical to the company in all areas from finances to
high traffic client facing applications.
• Worked efficiently in completing California Medical Association – Meaningful Use project.
• Installed clusters and moved our large databases to high availability hardware platforms.
• Added additional space to ever growing DB’s when needed.
• Results include creating a supportive relationship with all divisions within the company and
deliver excellent customer service to all HealthCare Partners.
• Worked with data warehouse Director to support new systems, and completed several pending
projects which enabled Healthcare Partners for CMS grants.
SourceLink (Client BMW) – Los Angeles, CA Oct 2009 - March 2012
Team Lead - Senior Database Engineer – Database Group
Managed collecting, analyzing and exploiting prospect and customer data. Responsible for data gathering
and monitoring campaigns, integrating different company data sources, and improving data quality. Deal
Page 2 of 4
with suppliers, define correct targets for marketing campaigns and the most effective actions required to
reach targets, and satisfy information needs of sales and marketing groups.
Key Accomplishments:
• Results include a significant performance improvement (+50% of improvement in data delivery
time ) in the effectiveness of direct marketing and marketing communication actions, with a 20%
management cost reduction in two years, by automating processes..
• Successfully migrated SQL servers to new versions, both outbound (emailing, mailing blast, list
sponsorship) and inbound (survey, landing pads, follow-up).
• Contributed to European marketing data structure definition, used afterwards as a source for
CRM products.
RAND Corporation – Santa Monica, CA March 2009 - Sep 2009
Sr. Consultant – SQL Database Development
To enhance and maintain the Data warehouse for RAND, Which includes their help desk and change
management, using SSIS and SQL. To make schema changes, write Stored procedures, views, optimize
tables, searches to the projects database, to fit the business needs. This projects database supports ARMY,
AIR FORCE, EDUCATION, Institute for CIVIL JUSTICE and others that RAND does business with. To
modify all Transact SQL stored procedures and rewrite custom reports for performance and efficiency.
Upgrade and migrate to SQL 2005/SQL 2008. Most of all work with dynamic group of elite researchers to
be their trusted partner for their business needs. In this organization requirements change more than other
institutions. IT at RAND is a support organization to the business, we always have to make our clients
right.
TheMLS.com – Beverly Hills, CA May 2008 – March 2009
Sr.Database Engineer
To modify all Transact SQL stored procedures and rewrite custom reports for performance and
efficiency. Support a team of twelve .net and CF programmers by writing and modifying stored
procedures, creating DTS/SSIS packages. Create coding standards for SP, User defined functions. Create
maintenance jobs for databases. Upgrade and migrate to SQL 2005. Eliminate the need for dynamic SQL
from application layer. Develop function to be reused. Modify existing SQL code for enhancement.
Manage contractors to work on specific projects. Existing code was modified to ensure database uptime.
Davita Inc. – El Segundo, CA May 2005 – March 2008
Sr.DBA/Database Developer
My Database management expertise combined with business analysis skills lead to responsibilities of
Scoping, building new architecture, enhancing existing architecture, creating schema diagrams, creating
work flow diagrams, optimizing process, automating tasks, writing complex stored procedures, triggers,
constraints and approaching the respective teams to resolve bottle necks for dialysis patient – registration,
treatment, scheduling, clinical information, demographics, flowsheets, billing with private commercial
and Medicaid and Medicare insurance and reporting on various information as like patient specific, work
flow specific, load balance specific for the largest dialysis system in the country. This application was
developed with SQL 2000, Cold Fusion, HTML, Crystal reports and hardware is on 64bit titanium
processors.
Baxter BioScience -- Westlake Village, CA Jan 2004- Jul 2004
Project Coordinator
Page 3 of 4
Project management expertise combined with business analysis skills lead to responsibilities of
Scoping, Budgeting, creating requirements document, creating and maintaining project databases,
creating work flow diagrams and approaching the respective teams to resolve bottle necks for unique
Healthcare applications used by health care professionals & patients for two disease states in six
languages and used in fourteen countries. Any Enhancement to the application required wide knowledge
of compliance issues in different countries. This application was developed with J2EE, Oracle, Html,
XML. Project Management tools include Office 2000, eRoom and Project 2000.
EdgeSoftInc -- Santa Monica, CA 2003-2004
Project Manager
Edgesoftinc is a software service provider for several fortune 500 companies. Worked as the Project
Manager, main duties include coordinating the multiple development teams including overseas operation.
Responsibilities include budgeting, project Main duties include database designing, Performance fine
tuning, database analysis, reverse engineering, configure SQL servers for non clustered and clustered
environments. Worked on data integrity issues, bottle necks, page locks, table corruption and
normalization.
Metlife – Los Angeles, CA 2001-2003
Manager – Information Systems
Project management expertise combined with business analysis skills lead to responsibilities of collecting
business requirements, creating requirements document, creating and maintaining project databases,
creating work flow diagrams and approaching the respective teams to resolve bottle necks.
Tools used where Microsoft project, Excel 2000, Microsoft word and others.
Key Achievements:
• Assumed leading role in production support, maintenance and DBA for this 24X7 production
environment, interfaced with IBM-DB2 mainframe.
• Managed the 401K/403B loan data migrations from SQL Server to IBM/DB2.
• Wrote Stored Procedures and automated functions for emergency software change requests to
resolve production issues.
• Managed change control procedures for software change requests from assignment, development,
testing and deployment into production systems.
• Established working relationships to support project deployment with contracted service
providers, business analysts, software developers, project managers and system administrators.
• Prepared and conducted presentations to IT staff, management, and executives.
• Mentored data architects and database administrators for development of SQL Server stored
procedures and server configuration and optimization.
Computer Sciences Corporation, Los Angeles, CA. 1998-2001
Senior Member Technical Staff – Sr. Consultant
Lead role on development of three tier and Web applications using MSSQL server, VB ASP HTML This
involved managing a team of developers, designing the database, being the bridge between users,
developers and upper management.
Lead role as the Data Architect and lead for development team for Bank of America lockbox payment.
Database administrator for all SQL servers.
Managed: Year 2000 Enterprise Integration Testing. Involved more than 20 critical applications.
Account-A-Call Corporation, Irvine CA. 1993 -1998
Technical Consultant
Page 4 of 4
Responsibilities include designing, testing and coding of a billing system and integration with ACCPAC
accounting software using FoxPro, and crystal reports. Also provide maintenance and use support.
Key Achievements:
• Conversion of the Billing System from Dbase to Foxpro.
• Developed Additional features to generate invoices and default letters.
• Integrated the Billing to ACCPAC accounting package to automate AR/AP/GL balance sheet.
• Created reports from FOX report writer to show Balance and Gross summary statements.
Hewlett Packard, Sacramento CA 1997-1998
Technical Consultant
Audio Conferencing Call Booking System – This online system was used by 50-60 HP locations for
Audio Conference Hall booking this system was done using Access/VB was a successful project on
budget and time. Responsibilities include design and development of the system using Visual Basic and
Crystal Reports.
Countrywide Funding Corporation, Pasadena, CA 1995 -1997
Sr. Programmer Analyst
Key Achievements:
• Designed and developed the Home equity functionality. Which was widely used by the industry
since.
• Managed the loan processing support issues for 500 locations.
• Created procedures for efficient Amortization calculation.
• Created subroutines and functions for peers.
EDUCATION
California State University Northridge, CA - Graduate Studies in Computer Science
University of Madras, TN India - BE, Electronics & Communication Engineering
SSRS and SQL Training
‘C’ & ‘C++’ programming languages from UCLA
Advanced VB programming, QuickStart Technologies
Microsoft SQL server/Oracle administrator Course, QuickStart Technologies
Time Estimation Course for Project Management
Contact this candidate