SUMMARY:

• 8+ Years of experience in analyzing, designing, tuning and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using MS SQL Server 2008R 2/2008/2005/2012/2000 DTS/SQL Server Integration, Reporting & Analysis Services.
• Extensive SQL Development experience in Banking, Infrastructure and Telecommunication industries with a strong understating of data & analytics.
• Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL server 2008/2005
• Experience in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules
• Experience in Upgrading of SQL Server 2000/2005 databases to SQL Server 2005/2008.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Hands on experience on various SQL Server Services like Integration Services (SSIS), and Reporting Services (SSRS).
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Experience in migrating DTS packages, reports and analysis services projects from SQL server 2000 to SQL server 2005.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience with logical and physical data modeling and database design using Erwin.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Effective interpersonal, conflict resolution skills. Team oriented, technically motivated and creative.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS:

SQL Server and Database Tools: Business Intelligence Development Studio (BIDS), Enterprise Manager, Profiler, Query Analyzer, Storage, Data Mining Models, Bulk Insert and BCP, Export & Import (DTS), SSIS, SSRS, SSAS.

RDBMS: MS SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access

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

Languages: Transact - SQL,PL-SQL, MDX/DMX, HTML, DHTML, XML, VB.Net, C and C++

Reporting Packages: SSRS (SQL Server Reporting Services), Import Export Data, MS Excel, Power BI, Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Lead SQL Developer

• Analyze the requirements provided, Designed and Developed Integration Packages as per the business needs and automate them.
• Worked on SQL server 2012 to make changes to the existing stored procedures to handle the business logic more effectively.
• Worked on SQL server 2012 to enhance the existing SSIS package and changed most of the connections dynamic.
• Worked on performance tuning existing SQL codes and stored procedures.
• Worked on building SSIS packages to monitor all the failed jobs and send reports to business.
• Worked on documenting and helping the team with better ideas to enhance the existing and newly SSIS packages and also the stored procedures that are used in the packages.
• Worked on generating adhoc reports, slicing and dicing the data to make it presentable for the manager.
• Worked on parsing huge XML’s data using stored procedures.
• Used Power BI to demonstrate the team new forms of Data Visualizations and advanced reporting methods.
• Been part of all the team meetings and added value by providing effective solutions and also implementing them.

Environment: MS SQL Server 2008, 2008R2, 2012 and 2014,MS office 2012,T-SQL, SQL Server Query Analyzer, Microsoft SSMS, Data Transformation Systems, Visual studio 2013, Power BI, Team Foundation Server etc.

Confidential

SQL Developer

• Analyze the requirements provided, Design and Develop Integration Packages as per the Clients request and Automate them
• Wrote Complex queries to in corporate the business logic and retrieve all the Certification and Candidate details for further reporting purpose.
• Worked on SQL server 2016 and Visual Studio 2013 for building SSIS packages for data importing from multiple sources to multiple destinations dynamically and ensuring that an email notifications are sent on Success/Failure of the package.
• Worked on building SQL queries for Data manipulation and for also creating DQL objects like tables, triggers, stored procedures, views and more.
• Worked on adding more data integrity check to the existing database and for the newly added SQL objects.
• Been part of Power BI trainings and actively created reports and Dashboards using Power BI Desktop.

Environment: MS SQL Server 2014, MS SQL Server 2016,MS office 2016,T-SQL, SQL Server Query Analyzer, Microsoft SSMS, Data Transformation Systems, Visual studio 2013, Visual studio 2016, Power BI, Team Foundation Server etc.

Confidential

Team Lead /Lead SQL support

• Analyze the Application Support documents and Service Level Agreements to ensure that we support Business without breaching the agreed SLA’s.
• Develop and maintain new documentation in the process of bug fixing and Enhancements to all the applications that are part of support responsibilities.
• Maintain reports accounting the number of issues, incidents and bug fixes completed by our team monthly and with a detailed breakdown of no of issues solved by a team member and no of hours spend on support, Maintenance and Development activities.
• Developing, Modifying & debugging the existing SQL scripts to ensure that they meet business needs.
• Worked on applications and/or interfaces that utilize Mainframe and AS400 to make sure that all the business rules are in sync across all the platforms that we support.
• Created SSIS packages to make sure that Item rename data is refreshed daily and all the orphan records are cleared.
• Mentor new members that get into the team with all possible Best practices.
• Worked on building SQL queries for Data manipulation and for also creating DQL objects like tables, triggers, stored procedures, views and more.
• Worked on adding more data integrity check to the existing database and for the newly added SQL objects.
• Participate in weekly meetings with business users to gather information about the Enhancements/Updates/Changes that need to be made to the applications that are part of support and also provide technical and functionally effective ideas/suggestions as per the Business needs.
• Worked on creating new SSIS packages to Import/Load data and archive the files on success.
• Worked on creating Common Table Expressions to identify the duplicates and dynamically clear them as part data validation.
• Presenting a well-documented explanation for Bugs/Issues to Business, Project Management Team so that they can educate the Sales reps accordingly.
• Work closely with QA team and make sure they validate out Unit Test cases before the developed rules and Database Objects moved to QA/Production system.
• Providing assistance to business users to help them understand the functionality of the newly made enhancements to the Applications.
• Develop and execute test cases and test plans for Functional testing needs.
• Create scripts for test cases in Development and QA environments and make sure that the test results are as expected according to the Business Requirements Document/Functional specifications.
• Review and provide feedback on project deliverables, Capacity Maintenance and Weekly status updates to Team and Business.
• Participate in weekly team leads meetings and provide the new strategies and ideas that are implemented as part of
• Practice improvement in the team.
• Perform knowledge transfer to team and Business users as well.
• Ensuring delivery of bug free code to User system.

Environment: MS SQL Server 2012, MS office 2010 T-SQL, SQL Server Query Analyzer, Microsoft SSMS, SQL Server Integration Services (SSIS), Visual studio 2010, object Scripter, Team Foundation Server, Mainframe, Visual Studio, AS/400 etc.

Confidential

SQL Developer

• Participated in Daily stand up call in a Scrum Environment and discussing about things to do and things completed so far in the present sprint.
• Participated in Backlog grooming and Sprint planning meetings.
• Assisted scrum master in sprint planning and support in scrum master responsibilities like performing capacity planning and monitoring the velocity of work being done in the sprint.
• Maintained the projects status and details on JIRA with hard dates and worked on troubleshooting the issues.
• Performed Pre-deployment Unit testing & Functional testing in DEV and TEST Environments.
• Worked as QA for other projects and helped in writing test cases and also worked on executing them by performing the functional testing for Pre and Post deployment cases.
• Worked on Project management by tasking the project to actionable sub-tasks.
• Worked on refining the spec features, business rule validation and refinement with Business Analysts.
• Worked on enhancing Ecommerce backend to support expansion of Godaddy in 42 international markets.
• Worked on enhancing databases to support flexible pricing for different regions/markets for Godaddy.
• Worked on production support by fixing the IRIS incidents and tickets.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Worked on SQL development like modifying complex SQL stored proc’s to accommodate the needed business logic and to make the proc’s work accordingly.
• Worked on SQL server batch updates on the production server and monitored the performance.
• Worked with SQL server profiler to trace out the stuff that is needed and helpful to figure out the flow and functionality of proc’s.
• Developed T-SQL Scripts to identify SQL Server objects without indexes and relationships and helped create clustered and non-clustered indexes for optimizing the database performance.

Environment: MS SQL Server 2012, MS office 2010 T-SQL, SQL Server Query Analyzer, Microsoft SSMS, SQL Server Integration Services (SSIS), Visual studio 2010, object Scripter, Team Foundation Server, Orion Tool, Product Creation Tools, Fraud Tools etc.

Confidential

SQL BI Developer

• Analyze the Business Requirements, Functional Specification, Use Cases and Configuration Spec Documents.
• Design Test Plan, Test Strategies, Test Scripting and Traceability Matrix.
• Writing & debugging the SQL scripts.
• Worked on applications and/or interfaces that utilize Eclipse to call the ant commands in a complete SQL Environment.
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.
• Mentor less Experienced Team Members on needy basis on Best practices.
• Maintaining test script relationship and assigning Requirement id for ease of traceability.
• Perform a functional testing of Quickcomm products and perform a test script audit of all documented test scripts to make an assessment related to test coverage.
• Representing the defect to the Defect Management Team, Business and Project & Development Management Team.
• Worked on building Complex SQL queries for Data manipulation, insertion, deletion and updates.
• Worked on Compatibility issues, Optimized long running Stored Procedures & cursors for effective data retrieval.
• Review of the Code to verify the accuracy, standards and optimizing the queries and minimizing the page upload times.
• Support issue resolution for emergency fixes.
• Consult with key business users and subject matter experts to gather information about Reporting needs, objectives, functions, features, input and output requirements.
• Reviewing HLD documents created by the Business Analysts and Test Plan, Test Strategies& Traceability matrix for Reporting Solutions.
• Developing automated Testing tools using XML, SQL server automated testing tools using XML, SQL Server
• Representing the defect to the Defect Management Team, Business and Project & Development Management Team.
• Perform Quality Assurance/Unit Testing before the developed rules and Database Objects moved to Production system.
• Provide assistance to business users to solve operating problems by recreating steps taken by them to locate the source of problem.
• Develop and execute test cases and test plans for Functional testing needs.
• Create scripts for test cases.
• Test front-end user interfaces and make usability recommendations
• Review and provide feedback on project deliverables.
• Perform knowledge transfer to end users.
• Ensuring delivery of bug free code to User system.

Environment: MS SQL Server 2005/2008/2008 R2, Windows 2003/2008R2 Server, MS office 2010 T-SQL, SQL Server Query Analyzer, Microsoft SSMS, SQL Server Integration Services (SSIS), Eclipse, Quick Report Pro, Quick Bill, JBoss Server, Microsoft Visio

Confidential

SQL BI Developer

• Developed SQL scripts to update and maintain the data on Daily, Weekly and Monthly bases through Autosys jobs.
• Developed Stored Procedures, Functions (UDF) and Views & Triggers to enforce the business rules.
• Performance tuning of existing stored procedures to improve the run time of a query.
• Worked on applications and/or interfaces that utilize Rapid SQL in a complete Sybase Environment.
• Worked on Bulk Copy Program to import the data from various CSV files into the tables in local servers.
• Used App Doc for assigning the jobs to be done in a schematic manner and later scheduled to run in Autosys Environment.
• Worked on developing new codes and modifying existing codes
• Optimized long running Stored Procedures & queries for effective data retrieval.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created Batch files to handle the whole migration process through Remote Desktop Protocol.
• Worked on large amounts of legacy ETL using Bulk Copy methods with stored procedures.
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Worked on multiple projects involving Informatica, MS Visio and Sybase.
• Documented the technical specifications and generated the reports for the implementation and testing of the application.
• Knowledge in maintaining security, backup and restore on MS SQL Server databases.

Environment: MS SQL Server 2005/2008 R2, Windows 2003/2008R2 Server, Trade Interface, T-SQL, SQL Server Query Analyzer, BIDS, Microsoft SSMS, SQL Server Integration Services (SSIS), Informatica, Microsoft Visio, Sybase 15, Autosys Graphical Interface

Confidential

SQL Server Developer/SSIS/SSRS

• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.
• Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from OLEDB Source, Excel Spreadsheet to SQL Server 2005.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Developed all the required T-SQl work using MS Management Studio.
• Experience in creating multiple reports (SSRS) in Drill mode (Drilldown and Drill through) and also Parameterized Reports.
• Worked on SSIS Packages, changed Structure of tables and created new Columns during transformation using SSIS packages.
• Developed reports using SSRS, Excel (Pivot) that could be used to send information to diverse groups.
• Strong knowledge on database design, Entity, Relation Model, database concepts.
• Excellent programming skills and experience with VB.Net.
• Developed stored procedures, triggers, views, and Indexes for a better performance tuning.
• Worked on Extraction, Transforming and Loading (ETL) data flows using SSIS and created mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Experience in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.
• Provided 24/7 production support for the production database and also to the code deployed in the production environment.

Environment: MS SQL Server 2000/2005, Windows 2000 Server, Windows NT Server, T-SQL, BIDS, Microsoft SSMS Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), MOSS 2007,VB.Net.

Confidential

Senior SQL Server Developer

• Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Experience in creating master and child packages, package configurations and logging.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Involved in developing logical and physical modeling of the database using Erwin.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Good experience writing C# and VB.Net.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: Microsoft SQL-Server 2000/2005/2008, Microsoft .NET Framework 2.0, Report Net 1.1, Windows Server2000/2003, DTS/SSIS/BCP, Failover clustering, SQL Diagrams, C#, MS Access, Microsoft Analysis/Integration/Reporting Services, T-SQL, Enterprise Manager/Query Analyzer/Management Studio, SQL-Profiler

Confidential

SQL Server Developer

• Designed and analyzed the SQL Server database and involved in gathering the user requirements.
• Responsible for pushing data objects across databases to different working levels: Development -Test - Production.
• Logical and Physical design of database for project based on user requirements.
• Created new tables, stored procedures for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Defined Check Constraints, Business Rules, Indexes, and Views.
• Coordinated with the front-end developer to put in the business rules. Created procedure to check some of the rules at the backend at the time of entering data.
• Created tables, Stored Procedures, views, triggers to facilitate the web application.
• Created look up tables to match the student’s login and the student’s password.
• Created jobs which will alert the librarian when the student does not return the book before the due date.
• Created stored procedures, which returns the information of the student based on his library card number.
• Migrated data from SQL server to excel files for reporting the data regarding the books available.
• Created and managed indexes, which will enable the students for fast search and retrieval of the concerned books.

Environment: SQL Server 2000, Microsoft Visual Basic 6, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, Windows XP, MS Excel, MS Access.