Sql Server Design
Resume:
Shalini Mehta
******.***@*****.***
Overview:
Lead data architect with 15 years of experience in software development,
architecture and consulting. Proven leadership and strategic thinking
capabilities. Proven ability in designing, implementing and optimizing
databases.
Summary of skills:
. Over 13 years of leadership experience, including hiring, supervising
and mentoring team members
. Over 10 years of expertise in developing Database systems, from
conceptual design to the physical database implementation
. Leading the data architecture for Enterprise level applications which
includes influencing design direction across cross-functional groups
in the organization
. Enforcing the database implementation to be in compliance with the
architectural standard and guidelines that help the organization
achieve its strategic goals
. Extensive experience creating optimized SQL stored procedures,
indexes, and triggers
. Expert in Extraction, Transformation and Loading (ETL) process using
DTS, SSIS, XML application tools between homogeneous/heterogeneous
systems as a part of integration between systems
. Full life cycle experience in Data Warehousing, Data Modeling, Data
Integration, and Master Data Management
. Evaluate third party tools for 'Build vs. Buy' decisions
. Liaison with third party vendors to integrate,package, and distribute
custom reporting software
. Excellent work ethic and initiative, highly motivated, reliable, and
able to work under pressure
Career history:
Duration: October 2000- Present
Title: Lead Data Architect
Company: BlueCross BlueShield of Illinois, Chicago, USA
. Responsible for the data analysis and design of relational databases
that support the high profile business applications like the Producer,
Provider, Employer and Member web portals (ERWIN, Visio, Microsoft
SQL Server, DB2, IBM WebSphere 6.1, RAD 7.0, IBM Workflow Process
Server,IBM MQSeries,SOA)
. Lead for creating, maintaining and optimizing database objects like
tables, stored procedures, views, triggers, constraints (SQL Server
Management Studio)
. Design and develop ETL processes to support critical, time sensitive
functionality like monthly capitation reports, Portal usage and
Actuarial adjustments (DTS,SSIS,XML,SQL Jobs,SQL Alerts)
. Support production environments by performing optimization tuning
(SQL Profiler, SQL Query Analyzer,Index tuning wizard)
. Track and promote changes through various environments to support
development, User acceptance testing, production and training (
Redgate, proprietary tracking processes)
. Implement and maintain security integrity controls (logins/roles) of
applications and security groups (SQL Server Management Studio)
. Experience in implementing disaster recovery and high availability
solutions using database mirroring, clustering and log shipping
(Microsoft SQL Server)
. Trace all deliverables, change requests, enhancements and
issues throughout the development and testing processes (Rational
ClearQuest)
. Provide volumetric and usage projection in order to determine the
infrastructure procurement
(Microsoft Office Applications-Word, Excel, Access, PowerPoint,
Project)
. Collaborate with Enterprise Architecture teams to ensure compliance
with the design standards
. Participate in analyzing business requirements to enable creating
robust and scalable database design as the industry adapts to changes
(Rational RequisitePro)
. Serve as a liaison between the business experts/users and the project
technical team to ensure the users requirements are understood and
interpreted correctly by the technical team
. Create design deliverables including Data Models and data dictionary
. Contribute in building an application DBA team that is focused on high
quality delivery (hire, supervise and mentor)
. Define/refine processes as the team and the projects evolved in
visibility and priority to the organization
Duration: May 1995- September 2000
Title: Team Leader - Application Development
Company: FreeBalance Inc., Ottawa, CANADA
. Design, develop and implement new functionality and enhancements for
major functional releases of the public financial management solution
(Uniface)
. Design and support bi-lingual,customizable features (Oracle,Microsoft
SQL server, Sybase)
. Perform requirements analysis and created traceability matrices
. GUI design, wireframes, requirement documentation and prototyping
Education:
Master's Degree in Computer Applications
Bachelor's Degree in Physics [pic][pic]
Contact this candidate