SUMMARY

• 10 + years of experience in SQL, ETL, analysis, design, development of Database, Web based and Client/ Server applications and working in Agile Environments.
• Highly proficient in using Excel to create Pivot tables, and accessing multidimensional cubes from Excel.
• I am Detail Oriented, Self Motivated and Flexible at work
• I possess good soft skills like honesty, sociability, leadership and negotiation skills
• Good working knowledge of Data warehousing concepts and OLTP
• Good working knowledge of VMware environment and Windows Clusters on Windows 2000, Windows 2003 and Windows 2008.
• Strong SQL Server 2000/2005/2008 Developer Skills including writing stored procedures, user defined functions, views, query writing.
• Develop ETL procedures using DTS/SSIS tool and ability to analyze complex data from multiple heterogeneous sources.
• Data warehousing design and development and star/snowflake schema data modeling.
• Experience in Transform data from one server to other servers using Tools like SSIS and DTS.
• Extensive experience SQL Server Integration using Service Broker (SSB) Services
• Good Knowledge in MS SQL Server suite of products like SSRS, SSIS and SSAS.
• Trouble shooting and tuning of exiting Business Object Reports and schedule jobs and monitor reports from broadcast Agent.
• Experienced in installations, Data loading using PL\SQL Scripts, performance tuning, creating new database, creating and modifying tables, optimization and Data Modeling.
• Excellent analytical, inter - personal and communication skills with clear understanding of business process flow.
• Good knowledge of Batch Processing and scripting.
• Thorough knowledge of XML and working with XML in SQL Server 2005/2008.
• Good working Knowledge of Access, My SQL and Excel
• Experienced in used of T-SQL commands in SQL management studio likes Stored Procedures, User Defined Function, Views, Trigger, Cursors etc.
• Experienced in creating SSIS packages which can be transported and used across multiple servers.
• Experienced in use of different Transformation in SSIS packages. Transformation Likes Audit, Multicast, Conditional split, Aggregation, Pivot, Raw sampling, Percentile sampling, etc.
• Experience in Microsoft SQL Server Database Administration including planning, implementing, backup using 3 rd part tools like LiteSpeed, Idera, Red Gate
• Experience in extract data from access, excel, flat file and different database and load this data in SQL database using SSIS packages.
• Good Hands on skill in IIS, Apache, ISA, Team Foundation Server and Feedback server
• Experienced in designing and developing reports in SQL Server 2005/2008 ReportingServices by gathering business requirements and translating them into technicalSpecification and creating reports with respect to business requirement.
• Experienced in working with SSAS, MDX scripting, MOM, SSB, SQL Server Profiler, SQL Server Configuration Manager and SQL Server Surface Area Configuration, Visual Source Safe, SQL Mail, Database Mail and CDOSYS
• Excellent communication, analytical and inter personal skills and ability to learn new concepts
• Implemented a well-planned backup and restore strategy protects databases against data loss due to damage caused by a variety of failures.
• Implementation and maintenance of security integrity controls (logins/roles) of applications and security groups.
• Working knowledge of JavaScript and Perl

TECHNICAL SKILLS

ETL Tools: SSIS (SQL Server Integration Services), DTS

Reporting Tools: SSRS (SQL Server Reporting Services), Business Objects XI

Databases: SQL Server 2000/2005/2008/2012/2014, MYSQL, DB2 and Oracle

Programming Languages: SQL, TSQL, C#,ASP, Perl

Data Modeling Concepts: Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension Tables

Tools: & Applications: TOAD,VB.net, SQL Server Management Studio, SQL Server Enterprise Manager

Operating Systems: MS-DOS, HP-UNIX, MS-Windows 95/98/NT & 2000, Virtual Machines

Others: SSAS, SQL Profile, Erwin, LightSpeed, Red Gate, SQL Server Configuration Manager, SQL Server Surface Area Configuration.

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Sr SQL Consultant / Data Analyst / SQL DBA / Developer

Responsibilities:

• Worked in the agile environment as Database Administrator\ Developer to analyze the call data.
• Hands on experience in working with SQL Server writing TSQL code in scripts, views and procedures.
• Good Expertise in working on SSIS (SQL Server Integration Services) to build ETL processes.
• Work on analyzing the call data in the I3 data (Interactive Intelligence).
• Good Experience with Dimensional Modeling for reporting and Data Warehousing.
• Mentor Other Developers involved in Performance tuning and design reviews.
• Perform and interpret data studies and product experiments for existing data sources.
• Develop prototypes, proof of concepts, algorithms, predictive models, and custom analysis.
• Working knowledge of JavaScript and Perl
• Hands on experience in working with ORSYP automation tools ( UniViewer 6.2 )
• Hands on Experience in Migrating Unica IBM Campaigns to SSIS.

Environment: Microsoft SQL Server 2000\2005\2008\2012\2014, SSIS, SSRS, Windows 2003/2008/2012, Visual Studio 2005\2010\2012\2013, Business Intelligence development studio 2005\2008, BizTalk SharePoint 2010/ 2013 .

Confidential, Addison, TX

Sr SQL DBA / Developer

Responsibilities:

• Worked in the agile environment as Database Administrator\ Developer to perform the tasks required to administer, develop, maintain and monitor all enterprise databases.
• Good hands on experience in Installing, Upgrade and Migrating SQL 2005, 2008, 2012 and 2014 Databases.
• Perform T-SQL code reviews during key points of the SDLC and enforce compliance with T-SQL coding standards.
• Created, develop, and maintain Microsoft Visual Studio SQL Server Database Projects.
• Perform SQL code releases in conjunction with the release of application code by Release Management team
• Hands on experience in the migration of SQL Server from and also DTS to SSIS 2014 using Project parameters.
• Hands on experience in Migrating SSRS 2012 from one server to another using RS.exe
• Work on Automation of Deployment for SSRS Reports and Database Projects using TFS, Devenv and RS.exe.
• Enhance schema to support customer data security policies using encryption, views and other techniques to minimize the profile of highly sensitive data either static in data stores or while in transit

Environment: Microsoft SQL Server 2000\2005\2008\2012\2014, SSIS, SSRS, Windows 2003/2008/2012, Visual Studio 2005\2010\2012\2013, Business Intelligence development studio 2005\2008, Biztalk Sharepoint 2010/ 2013 .

Confidential, Tampa, FL

Sr SQL DBA / Developer

Responsibilities:

• Worked in the agile environment as Database Administrator\ Developer to perform the tasks required to administer, develop, maintain and monitor all enterprise databases.
• Good hands on experience in Installing, Upgrade and Migrating SQL 2005, 2008 and 2012 Databases.
• Good Hands on experience in migrating to AWS all internal HI Servers.
• Good expertise in implement database designs and data access requirements and also in resolving database performance, database capacity planning, replication, and other distributed data challenges.
• Good Knowledge of Data Modeling and use of tools like ER win and Visio.
• Developed and Maintain Data bases, stored procedures, Views, Triggers, Logins fixing the orphaned users, Linked Servers, Jobs, Alerts, Maintenance plans and Database mail.
• Involved in the development of SSIS and SSRS in both 2005, 2008 and 2012 environments
• Good Expertise in SQL 2000/ 2005 and 2008 in Production and other environments on both Standalone and Windows 2003/2008 Cluster.
• Experience in Implementing assignments through Track- it and Jira.
• Good experience in implementing Microsoft Recommended Best Practices.
• Expertise in Business Recovery, Disaster Recovery and High Availability for all HI Databases.
• Work on Backup strategy with low disk space by copying backups to NAS and run Validation scripts.
• Hands on experience in data architecture design and planning for the physical structure and implementation of data warehouses and data marts
• Involved in Evaluating and Install Service Packs for SQL 2005 and SQL 2008.
• Good hands on experience in Mapping and back filling of various systems for Confidential systems.
• Experience in working with applications like CCMS, Case Tracker, I3, SharePoint, BizTalk, Incedo and Sales force using DB Amp.
• Develop CISCO phone reports by connecting to Informix using SSIS and SSRS.
• Experience with Working with BizTalk 2009 and 2013 and working close with BizTalk Administrators / Developers on 834/837 and 278 files.
• Hands on experience in working with SharePoint and PowerShell.
• Worked on extracting data from Sharepoint Lists (Sharepoint 2013) using SSIS and SharePoint List Source / Destination Adaptor.
• Worked closely with SharePoint Administrators(SharePoint 2013) and Incedo ( Healthcare Management System )
• Good hands on experience in working independently and with other Developers on Member \ Provider \ PCP files \ Claim\ Reponses \ Roster for various clients and then loading the Data to Data warehouse and data marts.
• Hands on Experience in migrating to AWS cloud and also working with Hadoop.
• Mentor Other DBA and Developers and involved in Performance tuning and design reviews.

Environment: Microsoft SQL Server 2000\2005\2008\2012, SSIS, SSRS, Windows 2003/2008, Visual Studio 2005\2010, Business Intelligence development studio 2005\2008, Biztalk Sharepoint 2010/ 2013 .

Confidential, Clearwater, FL

SQL DBA / Developer / Analyst

Responsibilities:

• Worked in the agile environment as Database Administrator (DBA) to perform the tasks required to administer, develop, maintain and monitor all enterprise databases.
• Good hands on experience in Installing, Upgrade and Migrating SQL 2005 and 2008 Databases.
• Good expertise in implement database designs and data access requirements and also in resolving database performance, database capacity planning, replication, and other distributed data challenges.
• Good Knowledge of Data Modeling and use of tools like ER win and Visio.
• Good expertise in Merge and Transactional Replication in SQL 2005 and 2008 databases.
• Good hands on experience in database backups using Native and LiteSpeed and monitor jobs.
• Developed and Maintain Data bases, stored procedures, Views, Triggers, Logins fixing the orphaned users, Linked Servers, Jobs, Alerts, Maintenance plans and Database mail.
• Good Expertise in SQL 2000/ 2005 and 2008 in Production and other environments.
• Experience in Implementing assignments through Track- it.
• Good experience in implementing Microsoft Recommended Best Practices.
• Expertise in Business Recovery, Disaster Recovery and High Availability for all UAMC Databases.
• Working knowledge in Loan Origination systems like Destiny and Empower.
• Experience in setting up Linked Servers to DB2, Lotus Notes Databases using NoteSQL driver.
• Involved in Evaluating and Install Service Packs for SQL 2005 and SQL 2008.
• Good hands on experience in Mapping and Back population of various systems and also across the loan origination systems.
• Good expertise in using LiteSpeed and Red Gate.
• Good Experience in interacting with Lotus Notes, FoxPro, Business Objects, .Net and Silver light Development Teams.
• Hands on experience in working with I series and AS/400 DB2 data from SQL Server using IBM Client Access.
• Communicated effectively in oral and written communications with all levels of personnel at UAMC.

Environment: Microsoft SQL Server 2000\2005\2008, SSIS, SSRS, Windows 2003/2008, Visual Studio 2005, Business Intelligence development studio 2005 and DB2 8.

Confidential - St Louis, MO

SQL DBA/Data Analyst

Responsibilities:

• Worked in the agile environment Involving Administration, Documenting, Development, and Maintenance and involved in meetings with Cross functional teams.
• Involved in maintaining and developing high transactional databases for Confidential Purina plants.
• Good Knowledge of Data Modeling and use of tools like ER win and Visio.
• Hands on experience with Database mail and table audits
• Migrated Data bases, stored procedures, Views, Triggers, Logins fixing the orphaned users, Linked Servers, Jobs, Alerts, Maintenance plans and Database mail.
• Good experience in Performance tuning of procedures and data loads to other SQL Server databases and DB2.
• Good expertise in working with SSRS and validation reports
• Hands on experience in working with SSRS and SSIS 2005 interconnectivity across SQL and DB2
• Good expertise in implementing Microsoft Recommended Best Practices.
• Experience in working closely in team of Oracle DBA’s, SAP administrators and good experience in interconnectivity between SQL,DB2 and Oracle databases
• Good expertise in loading data into SAP for all data loading from the data collection tool to DB2.
• Set up Linked Servers to Oracle and DB2 databases in both 64 bit and 32 bit environment.
• Good hands on expertise in Architecture, Development of SQL Databases and Applications
• Mentor Other DBA and Developers and involved in Performance tuning and design reviews.

Environment: Microsoft SQL Server 2000\2005\2008, SSIS, SSRS, Windows 2003/2008, Visual Studio 2005, Business Intelligence development studio 2005, Oracle 10 G and DB2 8.

Confidential, Earth City, MO

SQL DBA/Data Migration Consultant

Responsibilities:

• Worked in the agile environment Involving Administration, Documenting, Development, and Maintenance and involved in meetings with Cross functional teams.
• Involved in the Planning, Estimation, Design and Architecture of the SQL Server on Windows Cluster
• Installed MS SQL Server 2005 and Tools on Windows Server 2003 along with Business Intelligence Tool like SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS) and SSIS in a Clustered environment.
• Installed and Configured SSRS and SSIS in a clustered environment.
• Good Knowledge of Data Modeling and use of tools like ER win and Visio.
• Good expertise in working with Log Shipping, Database Mirroring, Replication
• Hands on Experience in Database Snapshots in SQL 2005
• Migrated Data bases, stored procedures, Views, Triggers, Logins fixing the orphaned users, Linked Servers, Jobs, Alerts, Maintenance plans and Database mail.
• Installed and Configured SQL Server, SSIS, SSRS and SSAS in both a clustered environment and stand alone system.
• Good experience writing SSIS packages and DTS packages and Scheduling them using SQL Jobs in both 32-bit and 64-bit environment
• Setting up of Log shipping and alerts using Database Mail and CDOSYS in SQL 2000/2005/2008.
• Good Experience in setting up of Centralized Monitoring System of all SQL Servers 2000/2005/2008 in the Company.
• Developed an Application using SSRS 2005 to show all Production SQL Server Job Results, Failed Job Reports and Backup information.
• Good expertise in implementing Microsoft Recommended Best Practices.
• Expertise in doing Side by Side and In place upgrade of SQL 2000 to SQL 2005 Servers
• Experience in working closely in team of Oracle DBA’s, SAP administrators and good experience in interconnectivity between SQL and Oracle databases
• Set up Linked Servers to Oracle databases in both 64 bit and 32 bit environment.
• Good hands on experience in architecture of Applications and Databases.
• Good experience in Implement assignments through BMC Remedy and Patrol.
• Experience in setting up JDBC connections and working with Java Developers.
• Hands on Experience in working with various applications like Share Point, Web sense, VMware virtual Center, Data Protection Advisor, EPO, Black Berry Application (BES Upgrade)
• Mentor Other DBA and Developers and involved in Performance tuning and design reviews.

Environment: Microsoft SQL Server 2000\2005, SSIS, SSRS, Windows 2003/2008, Visual Studio 2005, Business Intelligence development studio 2005, Oracle 10 G and 11 G .

Confidential, Berlin, VT

Production SQL DBA/Data Analyst/Developer

Responsibilities:

• Worked in the agile environment Involving Administration, Documenting, Development, Maintenance and involved in meetings with Cross functional teams
• Involved in the installation of Active\Active SQL 2005 Cluster on windows 2003 Enterprise version and Configuring SSIS in an active\active cluster which used Static Ports.
• Installed and Configured SQL 2008 and all the components on Windows 2008.
• Good experience in working with DTS, SSIS and SSRS and writing stored procedures and UDF’s
• Expertise in Maintaining and troubleshooting web applications
• Worked with Microsoft Dynamics Solomon for Project management and accounting system for BCBSVT
• Involved in Disaster Recovery Strategies and Capacity Planning. Good experience in performance tuning of indexes and stored procedures.
• Experience in Business Objects XI and Crystal reports 2008 as part of generation of Correspondence Letters for the Business.
• Experience in working with Data Mirror as part of doing daily net changes and refreshes from huge PHMS 4.7.3 and 7.0 tables.
• Good experience in supporting EDI applications which used X12 standards with applications like Web methods and Edifecs.
• Experience in working with backup tools like Tivoli, Commvault and Red gate tool belt. Good experience with SQL Response from Red gate and SQL heartbeat from SQL Solutions.
• Good experience with Transactional Replication and Database Snapshots.
• Hands on experience in working with I series and AS/400 DB2 and Oracle. Involved in Performance tuning of indexes in Oracle was used for See beyond system which was part of the Protected Health Information (PHI) for member as per HIPPA.
• Good experience in working with VB scripting, Lotus Notes, VBA and Access as part of Data Remediation and working with SharePoint Server.
• Good experience in working with DB2 databases by using Control Center as part of data analysis for getting the Data to SQL 2000 and 2005 databases.
• Involved in working closely with DB2 Team and has good understanding of DB2 and was involved in development of DB2 data marts as part of performance tuning of databases.
• Experience in working with Business Users and setting Linked tables to access.
• Mentor Other DBA and Developers and involved in Performance tuning and design reviews.

Environment: Microsoft SQL Server 2005/2008, SSIS, SSRS, Windows 2003/2008, Visual Studio 2005, Business Intelligence development studio 2005/2008, DB2

Confidential, Commack, NY

SQL DBA/Data Migration Consultant

Responsibilities:

• Worked in the agile environment Involving Administration, Documenting, Development, Maintenance and involved in meetings with Cross functional teams.
• Involved in the Planning, Estimation, Design and Architecture of the SQL Server on Windows Cluster
• Installed MS SQL Server 2005 and Tools on Windows Server 2003/2008 along with Business Intelligence Tool like SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS) and SSIS in a Clustered environment.
• Installed and Configured SSRS and SSIS in a clustered environment.
• Migrated Large data bases which are up to 2 Terabytes of size.
• Migrated Data bases, stored procedures, Views, Triggers, Logins fixing the orphaned users, Linked Servers, Jobs, Extended stored procedures, Alerts, Maintenance plans and Database Mail.
• Good experience with Disaster Recovery, Replication, Mirroring and Log Shipping.
• Experience in migrating DTS to SSIS packages
• Good expertise in VB scripting, Extracting data from different Data sources like Access, Oracle, Excel, Flat files, Dbase, Unix and Fox Pro and loading to SQL Server.
• Good Expertise in improving the efficiency of Data base maintenance Plans and SQL tuning
• Installed and Configured SQL Server, SSIS, SSRS and SSAS in both a clustered environment and stand alone system.
• Good experience writing SSIS packages and DTS packages and Scheduling them using SQL Jobs in both 32-bit and 64-bit environment
• Experience in working with OLTP and OLAP systems
• Installed and configured Reporting Services in a SharePoint Integrated System
• Experience with working with DTSx Change and Profiler
• Migrating of Cubes from and SQL 2000 to SQL 2005 and MDX scripting

Environment: Microsoft SQL Server 2005, SSIS, SSRS, Windows 2003/2008, Visual Studio 2005, Business Intelligence development studio 2005

Confidential, Bloomfield, CT

SQL DBA/Data Migration Consultant/Data Analyst

Responsibilities:

• Worked in an Agile environment Involved in Analysis, Documentation, Development and Maintenance of Systems and involved in meetings with Managers, Business Users, Cross Functional Team Leads in developing technical specifications and built efficient systems
• Installed MS SQL Server 2005/2008 and Tools on Windows Server 2003 along with Business Intelligence Tool like SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS) and SSAS
• Hands-on participation in retrieving, transforming and deploying data in an enterprise-wide OLTP, Data Warehousing environment and Data marts of DB2 and SQL Databases.
• Participate in code reviews and recommend enhancements, as needed, to achieve compliance with development standards
• Assisted in the development of Project Plans using MS Project 2007
• Analyze and develop solutions using Access and Excel for process and report automation. Strong experience with excel spreadsheets and access databases and Visual Basic Applications(VBA)
• Involved in creating test plan and wrote test cases based on Requirement Specifications and Design documents using Excel
• Hands on experience on Configuring and Optimizing IIS, Creating App Pools, configuring .net web Apps, access rights and permissions configuration knowledge. Fine tuning IIS for performance, scaling and extensibility.
• Hands on skills in migrating SQL Server 2000 and 2005 to SQL 2008. Migrating from Oracle and DB2 to SQL 2005 by the use of SSIS
• Developed new objects (i.e. tables, views and stored procedures) in SQL Server 2005/2008 and performed tuning on it
• Create store procedures and user defines functions to supports efficient data storage, manipulation and reports. And also Performance testing on stored procedures, indexes, and triggers.
• Transformed various text based files, using pivot tables, Excel spreadsheets, and Access to SQL Server databases using SQL Server Integration Services (SSIS) by overcoming the various constraints.
• Create new SSIS Package and also Migrated DTS packages to SQL Server Integration Service (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Scheduled and maintained routine SSIS Packages, and alerts using Event Handler in SSIS and SQL Server Agent.
• Generated, Developed, and Scheduled variety of Reports like List, Matrix, and Chart and Sub Reports etc. and Standardized company reports by implementing SQL Server 2005 Reporting services (SSRS) and Crystal Reports.
• Check the performance of each and every query using SQL Profiler, Index Tuning Wizard and Estimated query plan optimize the performance tuning of Complex SQL queries and stored procedure.
• Responsible for the developing successful implementation, adoption and maintenance of a unified XML data model.
• Good hands on experience with XML, X Query, and XML content stores
• Experience with working with SSAS and developing OLAP cubes. Good Knowledge of MDX scripting
• Automate and enhance database maintenance procedures and administrative tasks
• Provide support, administration and enhancement of complex databases and the database services environments
• Primary responsibilities include application database design and installation of all SQL servers, backup and recovery management, disaster recovery administration, performance analysis and optimization
• Developed a Logical and Physical database design in support of HIMSS applications.
• In-depth understanding of the effective use of transaction logs (i.e., sizing, truncation, etc.) as one aspect of an overall database recovery mechanism. Developed highly available systems

Environment: Microsoft SQL Server 2005/2008, SSIS, SSRS, Windows 2003, Visual Studio 2005, Visio.