SUMMARY:

• 8 years of IT experience, focusing on Database Programming, Data Modeling, Data Integration, Data Migration, Data Conversion, Data Warehousing, ETL and Business Intelligence.
• Expertise in Data warehousing Projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS) and SQL Server Analysis Services (SSAS).
• Hands on experience managing, analyzing, design and testing databases and Data Conversion projects.
• Strong in architecture, design and development of applications using MS SQL Server.
• Extensive database programming Experience in writing T - SQL Stored procedures, User Defined Functions, Triggers, Constraints and Indexes using various DDL, DML, DCL, TCL and DQL commands.
• Extensive experience in database programming and ETL for product development in telecom and healthcare domains.
• Hands-on programming experience in DBMS with extensive experience in the full software development life cycle (SDLC), including requirements definition, prototyping, design, code implementation, testing and maintenance.
• Experience in implementing Agile Methodology for one of the project.
• ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Strong experience with ETL and business intelligence tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2008/8R 2/2012/2014.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Expertise in developing reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Broad experience in database development, including effective use of database objects, SQL Trace, explain plan, various optimizers, hints, indexes, table partitions, sub-partitions, materialized views, and global temporary tables.
• Experienced in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture and SQL Profiler
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in requirement discussions, database design phases, and project management.
• Good understanding in Oracle 9i/10g Database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Superior communication skills and strong decision-making and organizational skills along with outstanding analytical and problem solving skills. Able to work well independently and also in a team by troubleshooting technology and business-related problems.
• Good exposure to verifying and validating health & benefit-related business rules like agent commissions and bonuses. Domain knowledge in US healthcare insurance and telecom.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Server Profiler, Database Engine Tuning Advisor, SQL Server Data Tools (SSDT)

Development Tools: MSBI SUITE (SSAS,SSIS and SSRS)

ETL Tools: SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2000/2005/2008 R2/2012), MS Access, MS Excel, Crystal Reports 10,

Database: MS SQL Server 2014/2008 R2/2005/2000, MS Access, Oracle 9i/8i

Programming: T-SQL, PL-SQL, C, VB

Web Technologies: HTML

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, TOAD, TFS,SPLUNK

Operating Systems: Windows 2003/2008 Server, Windows XP, Windows Vista

WORK EXPERIENCE:

Role: Sr. SQL Server Developer

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Database Programming: Creating Procedures, triggers, functions, views etc.
• Collect, validate, Consolidate and load audit universes by every month.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Load CMS audit universes created by business to compare with audit data created by our team.
• Designed and developed SSIS Packages for CMS Audit universes project.
• Created 100+ SSIS packages for getting different sources of data, such as flat files, Excel sheets
• Worked database/ETL performance tuning
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Created Metric reports using Power BI
• Worked on data analysis and created views for KPIs and Metrics requested by business users
• Documentation of the new assignments, technical specifications and requirement documents
• Responsible for preparing test cases
• Performed unit testing, integration testing and system testing as part of application development.
• Administered the SQL database, backup and restored the database
• Created SQL Server Agent Jobs, Alerts
• Scheduled SSIS Packages and Backup/Restore of a databases

Environment: SQL Server 2012, SSIS, SSRS, TFS, MS VISIO and Power BI

Sacramento, CA 

Role: Senior SQL/SSIS Developer

Responsibilities:

• Involved in developing logical and physical data models using ERWIN tool.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS).
• Implemented SQL Server Analysis Services (SSAS) for building the data cubes.
• Developed relations between fact and dimensions of the tables.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
• Created queries for generating drill down reports in SSRS.
• Formatted the reports using the Global variables, expressions and Functions.
• Optimized SQL statements for customer summary reports.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• requirement documents
• Responsible for preparing test cases
• Performed unit testing, integration testing and system testing as part of application development.
• Administered the SQL database, backup and restored the database
• Created SQL Server Agent Jobs, Alerts
• Scheduled SSIS Packages and Backup/Restore of a databases

Environment: SQL Server 2014, SSIS, CA Erwin data modeler, TFS, Tableau.

 Dallas, Texas

Role: Senior SQL Developer

Responsibilities:

• Responsible for designing and developing stored procedures, user-defined functions, views, triggers, and indices.
• Involved in analysis of requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Worked on Data conversion project involving NT (National voice tables) in Oracle system with size greater than 3 TB to SQL server using SSIS (ETL) tool.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Designed, maintained and developed SSIS packages for PCAT and VQE (Product catalogue and Qualification) systems.
• Created complex SSIS packages using proper control and data flow elements.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Responsible for Database/ETL performance tuning
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Regular monitoring of a rapidly-changing 500 GB database
• Reduced total ETL package running time from 8 hours to 2 hours
• Scheduled the SSIS packages and Jobs.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc.) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Create Parameterized SSRS Reports and Power Pivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database.
• Configure SQL Reporting Services (SSRS), including data-driven subscriptions
• Documentation of the new assignments, technical specifications and requirement documents
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Worked on preparing test cases for all work requests in each deployment
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed unit testing, integration testing and system testing as part of application development.
• Helped Quality Assurance Team to generate Test Plans and Test Executions.
• Used TFS for file maintenance.
• Led the 4-member team and updated project manager on daily work progress
• Worked very closely with Business users, End users and resolved any business process related issues.

Environment: SQL Server 2008 R2 and 2014, SSIS, TFS and C#.NET

Milwaukee, WI

Role: Senior SQL Developer (Offsite from Hyderabad)

Responsibilities:

• Responsible for designing and developing stored procedures, user defined functions, views, triggers, and indices.
• Involved in analysis of Requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created a modularized model of procedures for complete VUE compensation product database.
• Converted long and complex procedures in to different modules as a part ease of access and performance tuning.
• Developed complex procedures related to the calculation of commissions & bonuses for insurance agents.
• Worked on a complex commission calculation procedures which involve multiple iterations of complex calculations based on user defined Templates.
• Designed, maintained and developed SSIS packages and SSRS reports.
• Scheduled the SSIS packages and Jobs.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Worked on series of procedures to reduce total run time from 4 hours to 30 minutes.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Build and maintain SQL scripts, indexes, and complex queries for Production deployment.
• Documentation of the new assignments, technical specifications and requirement documents.
• Performed unit testing, integration testing and system testing.
• Maintained databases, performed VUE software installations and upgrades, monitored Database Performance.
• Used TFS for file maintenance.
• Led the 3-member team and provided daily updates to the project manager.

Environment: SQL Server 2008, SSIS, SSRS, C#.NET and TFS.

Role: Senior SQL/SSIS Developer (Offsite from Hyderabad)

Responsibilities:

• Worked as onsite coordinator for the VUE Compensation Management System.
• Responsible for gathering requirements from clients and sharing the requirements with the off-shore team.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Optimized database queries and stored procedures.
• Reduced considerable amount of execution time on compensation procedure.
• Designed SSIS packages to extract data into VUE from various carriers.
• Designed and developed SSIS packages to load policy and premium data from source systems.
• Actively participated to resolve the production tickets.
• Maintained databases, performed VUE software installations and upgrades, monitored Database Performance.
• Used Visual Source Safe for file maintenance.
• Documentation of the new assignments, technical specifications and requirement documents.
• Performed unit testing, integration testing and system testing.

Environment: SQL Server 2008, SSIS, SSRS, C#.NET and TFS.

Confidential

Sunrise, FL 

Role: Software Engineer (Offsite from Hyderabad)

Responsibilities:

• Job responsibilities include involvement in SDLC, requirement gathering and understanding, documentation, application development and providing support for technology and functionality related bugs reported by client.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Created stored procedures, user defined functions for calculating commissions and payments in PL/SQL.
• Created batch processes and procedures for data export received in flat files.
• Created SQL load batch process for loading flat files to destination system.
• Coordinated with the team members to develop the application on time and in line with the quality requirements.
• Maintained databases, performed VUE software installations and upgrades, monitored Database Performance.
• Used Visual Source Safe for file maintenance.
• Documentation of the new assignments, technical specifications and requirement documents.
• Designed and developed applications including UI layer, business layer, data layer, and common layer in VB Programming language.
• Worked with Implementation team and closely moved with end users to implement/support production issues.

Environment: PL/SQL, Oracle, VB, C#.NET.