Highlights:? Technical lead with 7 plus years of experience in database analysis, design, development, and performance tuning ? Hands on experience in SQL programming, developing complex code units as well as on No-SQL database. ? Experience in query optimization and performance tuning using SQL profiler and execution plans ? Proficient in data modeling, data loading, data retrieval, SSIS, analysis and modification indexing ? Experience with data flow diagrams, data dictionary, database normalization theory techniques, entity relation modeling and design techniques ? Worked on document based database MongoDB including database design, script coding. ? Experience in SQL Server Management Studio 2005/08, BI Studio, Visual Studio 2008/10, SSIS, SSRS, Robomongo. ? Good exposure in web related technologies like ASP/ASP.NET with code behind languages like C#/VB.NET for debugging ? Experience in using version control tools like VSS & TFS along with workflow automation tool Rational ClearQuest ? Experience in working at client premises for database development, migration, implementation, maintenance, extraction and transfer of data to other integrated systems ? Experience in interacting with business analysts, clients and users for requirement gathering and analysis ? Capable of leading and working along with a team to attain desired results ? Good understanding of all phases of software development life cycle including design, development, implementation and maintenance of software application ? Experience in creating test cases for unit, integration and system testing

Skills:SSIS, Performance Tuning, T-SQL, Crystal Report, SQL Server

Goal:To take up a challenging assignment on database part to play a significant role by plunging hardcore technologies in an innovative, competitive and creative way so as to achieve organizational goals and objectives.

Certification:MCITP 1255 MCTS 1270

Technical Lead 08/2012 - 03/2015
Object Frontier Software, Chennai, Tamil Nadu India
Worked on T-sql programming, performance tuning, data migration using SSIS
• Work as Technical lead and lead the database development team and coordinate the projects among the developers. • Provide support to the production ETL, analysis, and solution of data issues by interacting with end users. • Develop SSIS packages for optimal performance. Data is being extracted through mappings from different sources like relational database tables, flat files and XML files. • Use various transformations including source qualifier, expression, aggregator, joiner, filter, lookup, and update strategy for designing and optimizing. • Create test cases and test scripts to validate data. • Work with cross functional teams along with interacting with clients directly to understand requirements/issues. • Involve in the defect analysis along with users to understand the data and to make any modifications to code. • Analyze and fix existing schema along with tuning of stored procedures and scripts. • Create indexes on the tables for faster retrieval of data to enhance database performance. • Design and implement logical & physical technical architecture of database. • Write scripts, stored procedures, triggers, user defined functions. • Create customized scripts for creating the base data for application to facilitate early deployment. • Coordinate with the front-end design team to provide them necessary logical blocks and insight into the data. • Conduct code review to ensure that the outcome was in line with the objective and all standards are followed. • Debug various defects related to implementation of business logic.--
Lead Development 08/2009 - 07/2012
Talisma, Bangalore, Karnataka India
Industry: IT
Worked on SQL Server t-sql, performance tuning, Crystal report
• Worked as Development Lead and led the development team and coordinated the projects among the developers. • Analyzed the requirements and wrote functional specifications by discussing with business user groups. Translated the business requirements and documented databases changes and report’s functionalities. • Made database the logical & physical database layout changes as per the requirements. • Created numerous simple to complex queries involving self joins, correlated sub-queries, CTE and XML techniques for diverse business requirements. • Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies. • Implemented best practices in creating a complete schema including tables, relationships, synonyms, stored procedures, views, indexes and triggers • Created new and modified existing reports using Crystal report. • Worked on Standard, Cross tab as well as Drill down reports. • Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code. Performed root cause analysis and resolved complex issues--
Senior Software Developer 03/2007 - 08/2009
NIIT Ltd, New Delhi, Delhi India
Industry: IT
Worked on SQL Server and Crystal report
Works on SQL-Server and Crystal Report. Interaction with client for requirement gathering and design walk-through. Interaction with application team. Mentoring new team members--
Software Engg 07/2006 - 03/2007
Advanced Computer Engineering Services, Gurgaon, Haryana India
Industry: IT
Worked on MySQL, MS Access and SQL Server databases
--

Sant Longowal Institute of Engg & Technology 08/1999 - 05/2003
Sangrur, Punjab, India
Degree: Bachelor's Degree
Major:Bachelor of Engg
Minor:Computer Science
Bachelor of Engineering in Computer Science from Sant Longowal Institute of Engineering and Technology

SQL Server Developer SQL Server, T-SQL. SSIS, Crystal Report