SUMMARY:

• An accomplished Certified Database and IT Professional with extensive experience architecture, designing, coding, testing and supporting next generation database solutions for development and production MSSQL Server environments. Proficient in an assortment of technologies, includes MS SQL Server 2012/2008/2005/2000 , SSRS, SSIS, SSAS, Oracle, DB2, Access, Visio, Erwin, TOAD, IIS, VB.Net, C#.Net, T - SQL, XML, Visual Source Safe, TFS, Windows and Linux.
• MSSQL Server Administration & Development ( 2012/2008/2005/2000 ), Performance Tuning & Capacity Monitoring.
• Data Security, Backup and Recovery processes, Trouble shooting and problem analysis.
• Well versed with all aspects of software development life cycle, requirement gathering and documenting business requirements.
• Experienced in Database and Software solutions architecture and design.
• Experience working with all aspects of in-house developed applications.
• Experience with full product life cycle for implementation and integration.
• Able to work with a diverse group to obtain clear business requirements while ensuring all parties understand all aspects of the requirements.
• Business process improvement, Planning and development of automated process for business requirements.
• Strong focus on high quality product development and process documentation.
• 12 years of work experience with Insurance/Healthcare/Retail domains.
• Work experience in various consultancy assignments with reputed companies.

PROFESSIONAL EXPERIENCE:

Confidential, Farmington, CT

Prod Support Consultant-SQL DBA

Environment: Microsoft SQL Server 2012, 2008 R2, SSIS, SSAS, SSRS, TSQL, MDX, Data / Dimension Modeling, DB2, IIS 7, Data Tier Applications, Spatial Key, SVN, Power Shell.

Responsibilities:

• Subject-matter expert, responsible for establishing and directing the enterprise-wide data/information architecture, data definition, data modeling, master data management and data quality standards.
• Responsible for developing and implementing an enterprise data architecture framework and data governance model, including an enterprise data warehouse and business intelligence system.
• Serve as the data architecture knowledge expert for strategic business initiatives, marketing efforts and training.
• Provide strategic direction, leadership and influence to senior-level customers for data analysis and business intelligence, ensuring accurate integration of data across multiple platforms, lines of business and organizational units.
• Provide knowledge of the standards for quality in the analysis, interpretation and trending of data to identify statistical patterns used to explore and develop business opportunities and data driven solutions.
• Work with business areas to support the development of business opportunities and data-driven solutions. Work as the thought leader for evaluating emerging data methods and determining their ability to be utilized in the existing architecture.
• Responsible for development and implementation and enhancement of Insurer Analytics in the capacity of a Technical SME on Analytics / Business Intelligence.
• Manage and plan regional adaptations, deployments, releases / builds.
• Engage clients to assist / recommend on environment and Infrastructure setup, configuration of ETL jobs, report schedules and subscriptions.
• Developed training program regarding Insurer Analytics, serving as regional expert regarding the product. Provide on-site training to regional Insurer Analytic customers as well as internal users/developers.
• Possess expert level skillset in Microsoft SQL Server 2008 R2 / 2012, SSIS and SSAS.

Confidential, CT

IT Consultant/Sr. SQL DBA

Environment: MSSQL Server 2012/2008/2005/2000 , T-SQL, VB.NET, C#.NET, SSIS, SSRS, Erwin

Responsibilities:

• Design and Implementing new technology policies, standards and procedures.
• Responsible for high level designs and oversees creation of detailed program specification for execution of software.
• Automating and streamlining business processes and jobs.
• Planning, re-design, migration of current application/solutions to new technologies.
• Managing, maintain production, test and development environments.
• Provide guidance and technical support to other team members.
• Responsible for ensuring availability of database and application online and performance monitoring and tuning.
• Responsible for design, development and implement Database ETL (SSIS/DTS) and processing solutions for Confidential application using MS SQL and ETL processes.
• Installations and configuration of MSSQL server and creation of databases.
• Coordination and Planning of database backup and recovery strategies, performance and storage monitoring.
• Managed and implemented Privacy components of the HIPAA Compliance Plan

Confidential, Hartford, CT

Consulting Database Administrator

Environment: MSSQL Server 2008/2005, T-SQL, TFS, VB, Erwin, SSIS & DTS.

Responsibilities:

• Enhancement and maintenance of Insurance product Policy Decision for reputed insurance.
• Designed and developed the City file maintenance application to replace the legacy base city file system. Creation of Service packs and supporting production migration process.Analyze client requests and review/develop technical specifications based on business requirements.
• Diagnose client SQL Server database performance issues.
• Code changes to Microsoft SQL Server stored procedures incorporating statutory requirements, problem fixes and/or enhancements.
• Compose complex ad-hoc queries to update and locate information in client databases.
• Develop and maintain internal utilities using Microsoft Visual Basic 6.0/.Net and SQL-DMO.
• Mentor less experienced staff members: coding style advanced SQL, tools, etc.
• Debug client problems via email, phone support, and remote WebEx sessions.

Confidential, Poolesville, VA

Consulting Database Administrator

Environment: MSSQL 2005 & 2000, AXAPTA, T-SQL, TARGIT, MS Analysis Server. Win 2003, UNIX, LINUX

Responsibilities:

• MS SQL Server and Microsoft Axapta Administration and support tasks.
• Establishing SQL Server environments for Production, testing and development environments.
• Coordination and Planning for database backup and recovery strategies.
• Responsible for Performance tuning and data storage monitoring activities. T-SQL database programming.
• Retail BI projects with TARGIT, Microsoft Analysis server, SQL server.
• ETL (SSIS/DTS) development activities for Data collection and loading from Heterogeneous production database systems to BI data warehouse systems using SQL Server technologies (Analysis Server) and TARGIT BI tools.
• Collaboration with IT infrastructure division to ensure smooth and reliable operation of software and systems for fulfilling business objectives and processes.
• Establishing appropriate end user database & Application (Axapta) access control levels.
• Monitor and resolve the issues with database maintenance & data extraction (DTS) schedules.
• Planning for database upgrade and conversion (MSSQL2000 to 2005) projects.
• Monitoring and applying SQL Server & Operating systems patches and services pack releases.