OBJECTIVE:

Implement and further extend my technical & leadership skills that I have gained over 11 years of professional experience . 

SUMMARY:

• Extensive knowledge of Microsoft SQL Server, writing T - SQL statements, developing complex to simple reports using SSRS, SSIS, DB Reporting using ETL(SSAS) and MSBI
• Experince in SQL Profiling for Debug T-SQL statements, stored procedures and monitor the performance of an instance of the SQL Server Database Engine
• Experience in creation of SSIS packages for ETL(Extract, Transform and Load) to be used in data migration from other source systems.
• Database tuning and performance monitoring; Physical Server Level, Database level (Database settings and options) and query tuning
• SQL Data Integration for SAP and Fastreact using SQL Server Agent.
• Extensive experience in working with customers to define/ refine requirements, writing scenario based functional specs, working with the team to come up with estimates and execution plan (project plan)
• Dedication to delivery of exceptional customer experiences, with strong customer and team management background
• Executed projects under hybrid agile (scrum) (‘WaterScrum’) and Waterfall methodology
• Implement and maintain database security
• Sound knowledge of the ASP.NET, C#. NET and Object Oriented methodologies
• Strong experience in Software Documentation
• Extensive knowledge of Problem Management/Incident Management
• Working with the UI team to create mock-ups and wireframes
• Extensive experience in creating/managing ERP solutions including database reporting for various clients

PROFESSIONAL EXPERIENCE:

Confidential 

SQL Developer/Analyst/Project Manager 

Responsibilities:

• Managing and designing SQL Database
• SQL Performance tuning, query optimizations and troubleshooting in prod environment
• SQL Reporting using Data Source Views (Analysis Services) & Report Model (.smdl)
• Database Recovery Management
• Providing demos to the customers and interested parties to increase adoption of the application
• Cross group co-ordination with upstream and downstream systems
• Responsible for allocating, tracking of work and also ensuring that the quality bar is met.
• Conduct Bug Triages and Daily Scrum
• Contribute components towards common framework to be used across organization
• Own creation of documents such as Functional Specs, Test Plan, Test Cases, Deployment Document, UAT Scripts, UAT Plan, FAQs, Tip Sheets, etc.
• Understanding Customer Business Requirements with help of functional and business owners. Study Business Requirement Document, which includes Business Description, Functional Requirements, Technical Modifications, DB Requirement, Impact analysis etc
• Integrate different modules or functionality in a single unit to meet requirements, including integration test as needed.
• Involved in discussions with the business and coming up with features
• Detailing features to other PMs, Dev and Test group and scoping them based on the time and cost constraints
• Working with the team to prioritize & schedule new features
• Participate in daily triage to discuss and prioritize bugs logged by the test and dev team
• Source code maintenance with VSS (Visual Source Safe).
• Code Reviews.

Confidential 

Responsibilities:

• Strategic thinking and implementation around the future of the system. Conceptualizing & presenting multi-year roadmaps to the senior management.
• Interact with the business group and customer group to gather requirements and create detailed user scenarios
• Creating detailed functional spec, project plan and project related presentations
• Manage project execution (assign tasks to Dev and Test, drive cost estimations of features)
• Providing demos to the customers and interested parties to increase adoption rate
• Working with the team to prioritize & schedule new features
• Conduct and Participate in daily triage to discuss and prioritize bugs logged by the test team
• Manage end-end project execution (Milestone creation and management)
• Handling localization and globalization aspects of the application and dealing with external vendors.
• Being a central hub to communicate with various groups like DEV, TEST, Implementation, Sales team to ensure smooth functioning of the project.
• Managing and designing Database
• Performance tuning, query optimizations and troubleshooting problems in prod environment
• Implementing and managing Database security

Tools & Tech: SSRS, SQL Server 2008/2012, DB Reporting using Data Source Views (Analysis Services) & Report Model (.smdl), Java Script, HTML & Ajax, C#.NET/VB.NET

Confidential 

Responsibilities Included:

• Interact with the business group and customer group to gather requirements and create detailed user scenarios
• Creating detailed functional spec, project plan and project related presentations
• Preparing Time/Effort Estimation for various applications/modules.
• Providing demos to the customers and interested parties to increase adoption rate
• Working with the team to prioritize & schedule new features
• Participate in daily triage to discuss and prioritize bugs logged by the test team and UX
• Handling localization and globalization aspects of the application and dealing with external vendors.
• Being a central hub to communicate with various groups like DEV, TEST, Implementation, Sales team to ensure smooth functioning of the project.
• Managing and designing Database
• Performance tuning, query optimizations and troubleshooting problems in prod environment
• Implementing and managing Database security
• Front end and back end code development ( writing Procedures, Functions, and Triggers along with web Code)

Tools & Tech: C#.NET, Infragistics Webgrid Control, SSRS, SQL Server 2008/2005,Java Script, HTML & Ajax

Confidential 

Responsibilities:

• Involved in understanding of requirements and creating a questionnaire for PMs and Implementation team.
• Interact with other developers for laying out requirements and thrashing any issues and acts as a point of contact with various extended teams
• Participating in daily SCRUM meetings (Monthly Sprints).
• Attend meetings with the test team to walk-through test cases for various modules undergoing conversion process.
• Creating unit test cases and test modules against those before releasing them to test team.
• Perform code reviews according to standards laid out
• Involved in Database designing
• Analyze Business Requirements and transform them into technical design, preparing Technical Design docs
• Assess risk and impact on the existing system that may arise due to any requirement or functional change, preparing Impact Analysis (IA) doc
• Front end and back end code development (writing Procedures, Functions, and Triggers along with web Code)

Tools & Tech: C#.NET/VB.NET, SSRS, SQL 2008/2005, Java Script, HTML & Ajax

Confidential 

Responsibilities:

• Involved in understanding of requirements and creating a questionnaire for PMs and Implementation team.
• Interact with other developers for laying out requirements and thrashing any issues and acts as a point of contact with various extended teams
• Participating in daily SCRUM meetings
• Attend meetings with the test team to walk-through test cases for various modules undergoing conversion process
• Creating unit test cases and test modules against those before releasing them to test team
• Perform code reviews according to standards laid out
• Involved in Database designing
• Analyse Business Requirements and transform them into technical design, preparing Technical Design docs
• Assess risk and impact on the existing system that may arise due to any requirement or functional change, preparing Impact Analysis (IA) doc.
• Front end and back end code development (writing Procedures, Functions, and Triggers along with web Code)

Tools & Tech : C # .NET/VB.NET, SQL 2008/2005, Java Script, HTML