PROFESSIONAL SUMMARY:

• Over 7+ years of strong experience in design, development, implementation and administration of database systems using MS - SQL Server 2012/2008 r2/2008/2005 for both OLTP & Data Warehousing Systems applications in Finance, Retail, Ecommerce and Health care Industries.
• Expert in Extracting Data from disparate Data sources using SSIS and Designing ETL Solution Using Microsoft SQL Server Integration Services.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Extensive experience in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Proficient in development and deployment of reports, report subscriptions and data driven subscriptions using SSRS
• Hands on experience with Data visualization techniques using tableau
• Experienced in creating Jobs, Alerts, and SQL Mail Agent, Scheduling SSIS packages.
• Strong interpersonal and communication skills and a committed team player. Independent and self-motivator. Comfortable working with end users and business analysts, interpreting business specifications and creating technical specifications.
• Experience with capacity planning and designing high availability/disaster recovery solutions in SQL Server using Clustering, Always on, Replication, Logshipping & Mirroring.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003/2008/2008 R2, Linux

Databases: SQL Server 2000/ 2005/2008/2008 R2/2012, MS Access

Programming language: T-SQL, Perl, XML

Business Intelligence tools: Business Intelligence Development Studio (SSIS/SSRS)

Data Visualization: Tableau

SDLC tools: Perforce, Team foundation Server (TFS)

Other skills: Photoshop, MS office, MS Visio, Microsoft Projects

PROFESSIONAL EXPERIENCE:

Database Developer/Administrator

Confidential

Responsibilities:

• Managed clustered database environment involving SQL Server 2005/2008/2008 R2 to ensure 100% uptime.
• Applied Services packs & hot fix on SQL Servers
• Monitored database server performance for scalability & Reliability
• Provided 24X7 database support and on call support
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Wrote T-SQL procedures/Triggers/Views to facilitate data access for a web based applications written in C#.Net
• Designed, reviewed, and created database objects such as Tables, views, indexes based on logical design models and user requirements
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008. Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS. Created reports to retrieve data using Stored Procedures that accepts parameters and provided data visualization using Tableau.
• Used SQL Server profiler for auditing and analyzing the events, which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in preparing document for application development and QA/UAT teams.

Database Developer/Administrator

Confidential

Responsibilities:

• Aggregating large volumes of POS data to summarize and define KPI's for measuring business growth.
• Analyzing POS (point of sale) information and build future requirements thereby planning for warehouse inventory well ahead of time.
• Writing reports and automating tasks for Category & product managers, thereby helping them make informed decisions using SSRS.
• Being the liaison between IT & Business to write requirements for in house applications.
• Write TSQL programs (Stored procedures, Triggers, Views, Functions) for in house applications
• Designing data models & databases for scalability.
• Writing BI packages to load data from multiple data source using SSIS.
• Experience in creating package configurations likeXML, SQL Server Configurationsand logging using text, XML and Windows event log.
• Maintained the database environment and performed DBA activities.
• Designed & Developed a data driven solution for a business to consumer system to process orders from multiple retailers
• Designed a HA/DR solution to ensure 24X7 availability
• Implemented Replication to move data from production servers to a data mart for reporting.
• Managed Database Servers in a clustered environment to provide 100% availability as part of the database engineering team.
• Defined policies to manage the database environment effectively.
• Designed an ETL solution to migrate data from legacy DB2 systems to SQL Server using SSIS.

Database Developer/Administrator

Confidential

Responsibilities:

• Refactored poorly performing SQL queries to improve application performance.
• Troubleshooting and Monitoring Database server environment.
• Monitoring Replication latency on SQL servers for enhanced reporting experience
• Writing TSQL stored procedures, Triggers, Views as per client requirements
• Managing Security and performing clean up tasks on the server.
• Testing, customizing SQL Scripts and deploying over Pre-Production servers, Production servers.
• Coordinating with peer groups for Network, Infrastructure and Data center Operations.
• Analysis & Resource scoping for new upcoming applications & providing systems engineering
• Finding solutions for critical problems and writing knowledge base articles
• Handling Change management operations from off shore location as the primary contact DBA.
• Regularly applying Service packs and Hotfix on SQL Servers.
• Used SSIS to load data from multiple SQL Server sources to a denormalized set of tables for analysis.
• Built SSRS report to support reporting needs.

Database developer/Administrator

Confidential

Responsibilities:

• Involved in all Database Design/Architecture meeting/discussion and was instrumental in designing the database from scratch
• Writing TSQL Procedures/Views/Triggers.
• Writing database programs that would analyze billions of records and aggregate the data suitable for reporting
• Performing Change control on the production database server.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Maintaining development database environment by doing periodic refresh from production
• Applying Service packs and hot fixes on SQL Servers.
• Performing capacity planning and performance tuning on the Database server.
• Monitoring the database server for 24X7 availability.
• Identifying and fixing performance issues on the database side.
• Monitoring Replication and Log shipping latency used for high availability.
• Working with Data analyst in helping them to report the right data and understanding needs for future enhancements to the application.
• Writing SSIS packages to load DNA information from flat file to SQL Server
• Designed an ETL solution to load 8371, 837P information from various healthcare institutions to our central database. This was later used to build SSRS reports delivered to various stakeholders.
• Built a scalable Reporting solution and developed several reports as per client requirements
• Helped perform data analysis to drive research initiatives
• Have experience in tableau data visualization