SUMMARY:

• 13+years of experience(Onsite/Offshore) with Microsoft Certified Professional (MCP) in Microsoft Technologies.
• Worked more than a year in United Kingdom on client location for development and implementations.
• Big achievement on Process optimization on complex project from 21 hours to 30 Minutes.
• Excellent back end skills in creating SQL objects such as Tables, Stored Procedures, Views, Indexes, Triggers, defaults, Optimization, SQL Profiler and user defined data types and Functions
• Hands - on experience in SSRS, SSIS package/ DTS creation and deployment, and maintaining, modifying, and optimizing MS SQL Server databases
• Worked as SQL DBA as well for 2 years in Production support.
• Hands experience on Power BI with DAX and Data analytics with various sources
• Certified on Power BI with DAX(70-778)
• Hands on experience on Business Analysis, Database Design, Development and Implementation.
• Hands-on experience in data modeling (logical and physical design of databases), normalization, and building referential integrity constraints.
• Having good experience in agile work model along with JIRA, Cherwell and Version One system.

TECHNICAL SKILLS:

Databases: MS SQL Server 2000/ 2005/2008/2008 R2/2012/2016, Oracle 11g, HP Neoview

Languages: C++, C#, .NET, Visual Basic 6.0, HTML, XML

Internet Technologies: ASP.NET, ADO.NET, HTML

Operating Systems: Windows 2007 Pro/ 2000 Advanced Server/ XP/ windows 10

Front-end Technologies: MS Visual Studio.NET 2003, MS Visual Basic 6.0

Tools: DTS, SSIS, SSRS, Power BI,DAX, Crystal Report, QlikView,Cherwell

PROJECT EXPERIENCE:

Confidential

Responsibilities:

• Worked on report migration from SSRS and Cognos to Power BI.
• Writing SQL development coding and deliver end to project. I.e. stored proc, Function, Tables, Views etc.
• Contributed towards technical and functional documentation, implementation, application support, and client interaction
• Working on Complete solution on from design to implementation.

Confidential

Responsibilities:

• Understanding the Business requirements, worked on MS SQL Server 2008 R2, Design Report designing.
• Replication setup, Unit Testing Creation of database objects like tables, stored procedures and Deployments along with New Changes Request Planning and developments.

Confidential

Responsibilities:

• Engaged in team handling, performance and process optimization, database support, and programming
• Contributed towards technical and functional documentation, implementation, application support, and client interaction
• Engaged in severity work assignment and database migration (SSIS/ DTS)

Environment: MS SQL Server 2008 R2, Dot NET, DB2, Oracle

Confidential

Responsibilities:

• Engaged in database Programming, SSIS/ DTS development, and support
• Involved in database migration from existing database to new database (MSBI), client interaction, and SSRS

Environment: MS SQL Server, DB2, Java

Confidential

Responsibilities:

• Engaged in DTS/ SSIS package, database programming, process design, and various job creations
• Contributed towards data extraction from legacy system, SSRS generation, and loading XML wrapper

Environment: MS SQL Server 2005, XML

Confidential

Responsibilities:

• Designed database, and defined business logic
• Engaged in log shipping, and created/ maintained jobs, and optimized SQL
• Wrote complex queries, functions, views, and triggers

Environment: Visual Studio.NET, MS SQL Server 2005

Confidential

Responsibilities:

• Maintained and upgraded database, partition tables, and replication (snapshot and transactional/ merge)
• Engaged in coding for various stored procedure, triggers, and views and performance tuning for reports
• Engaged in various daily jobs activities and deployment of production releases
• Involved in backup/ restore of database, database migration, SSIS package with DTS, and supporting of job monitoring

Environment: Visual Studio.NET, MS SQL Server 2005