SUMMARY:

• 12 + 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 Reporting Services by gathering business requirements and translating them into technical Specification 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/ Developer

Responsibilities:

• Strong experience in MS SQL Server and creating complex SQL statements, T-SQL programming such as, Stored Procedure, Functions, Triggers.
• Worked in the agile / scrum environment as Developer/ DBA to perform the tasks required to develop, maintain and monitor databases.
• Hands on experience in SQL Server 2014/2012/2008 for data tier like stored procedures, functions, locks and performance tuning .
• Worked on Database refreshes between various environments.
• Hands on experience in Developing and performance tuning SSIS 2014/2012/2008 packages and SQL Objects to move data between various databases using the Sync process by Analyzing the Execution Plans and Conflicting processes.
• Monitors the Production/ Development database and optimize stored procedures for better performance and resolve any conflicts and resource utilization issues
• Perform database maintenance tasks to support application changes and ensure integrity and efficient performance of the databases
• Formulate policies, procedures , and standards relating to database management, and monitor transaction activity and utilization.
• Research, review, and recommend relevant technologies and perform Proof of Concepts/Prototypes for application of such technologies to solve existing problems and future architectural enhancements
• Experience in loading Data from Sales force to Application and EDW databases.
• Experience with source control systems like TFS.
• Knowledge in AngularJS, Bootstrap and C#.

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 2009 /2013 SharePoint 2010/ 2013.

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).
• Hands on 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 Confidential 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 2009 /2013 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 2008 to 2014 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 2009 /2013 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 Confidential 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.
• Research, review, and recommend relevant technologies and perform Proof of Concepts/Prototypes for application of such technologies to solve existing problems and future architectural enhancements
• 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 Confidential 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 2009 /2013 Sharepoint 2010/ 2013 .