SUMMARY

• Dedicated and Strongly Motivated technical professional with 9+ years of IT experience, involved in the area of project initialization, Execution and Implementation with key emphasis on Analysis, Architecture Design, Development, Integration and Unit testing.
• Strong Experience in Developing the Web Services Using WCF and Rest Services using Asp.Net Web API
• Strong Experience ins Writing Unit Test for Web services and Web API Services
• Expertise Knowledge in developing and hosting the applications on cloud in Windows Azure.
• Expertise Knowledge in using Service bus Queues and Topics in Windows Azure.
• Expertise Knowledge in Front end technologies like HTML, Java Script, JQuery, Knock Out, AngularJS
• Expertise Knowledge in Designing Single Page Applications using Angular JS and Durandle Frameworks
• Expertise knowledge in Designing the work Flows using K2 Black Pearl
• Working experience in database design, database programming and testing using SQL Server 2012/2008R2/2008/2005 for OLTP/OLAP/ETL environments.
• Designing and implementing systems ensuring proper database architectures, data modeling, coding standards, and quality assurance policies and procedures.
• Strong Experience in writing T - SQL queries (DDL and DML), Stored Procedures, Functions, Triggers, SQL Scripts for data loads and upgrades for data migrations and data validations.
• Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered/Non-clustered Indexes and Efficient coding standards.
• Strong experience in working with Microsoft BI suite of products.
• Extracting, transforming and loading data (ETL) between various Homogenous and Heterogeneous data sources usingSQL Server Integration Services (SSIS).
• Implementing database security using SQL Server Certificates and Keys.
• Implementing SQL Server messaging and queueing using Service brokers.
• Creating business reports using SQL Server Reporting Services (SSRS).
• Good understanding of SQL Server Analysis Services (SSAS).
• Experience in Data Modeling skills using MS Visio.
• Solid experience in evaluating Code coverage for SQL applications.
• Strong understanding of Power Pivot, Power BI and other Microsoft Office data analytics capabilities.
• Knowledge on Open Data Protocol (OData).
• Strong Experience in Test Automation with Automation Frameworks (Coded UI, Edison, Selenium)
• Expertise in Creating and Testing Standalone applications and Web Based applications using .Net framework and C#.
• Expertise in using the SPEC flow tool to bind the business requirements to .Net code
• Have been instrumental in establishing an effective interaction with the client on various forums to discuss the Project status, Test metrics, and extrapolate risks, mitigation plans, Test Planning, Test Strategies.Experience in demonstrate traceability of derived Tests to Business Requirements / Functional Designs.Ability to perform root cause analysis for errors / defects and understand standard Defect reporting/ management concepts.
• Troubleshooting high priority issues and business impact analysis.
• Performing root cause analysis on data quality issues and identifying approaches to resolve.
• Interpreting and analyzing business requirements, change requests & functional specifications and participating in creating application architecture document.
• Participated in project planning, budgeting, task estimation, and requirement analysis.
• Managed client engagement services and solution implementations.
• Creating team building activities that included focus group meetings and brainstorming sessions, program reviews, increasing team involvement in development and implementation process.
• Conducting status call and Triage with the project stakeholders and delivering project status.
• Strong customer empathy, good at understanding customer requirements and can transfer such knowledge into the engineering process.
• Capable to work independently with minimal supervision.
• Strong analytical and problem solving skills with ability to clearly articulate solution alternatives.
• Extensive Exposure with AGILE, Scrum, Waterfall development and project methodologies and have extensive experience in sprint model development.
• Excellent domain knowledge in the areas of Incentives Program, Capital Market, Oil and Marketing.
• Experience in leading and mentoring a team, performing code reviews as per the best practices and coding standards.
• Coordinating the Offshore/ On-site development team to complete task in time.
• Excellent interpersonal skills, effectively communicating to Clients and business teams for gathering the requirements, status updates and issue handling.

TECHNICAL SKILLS

Programming languages: T-SQL, C#.NET, ASP.NET, MVC, Web API, WCF Services

Front End Technologies: HTML5, CSS3, JavaScript, JQuery, AngularJS, KnockJS, Durandle JS.

RDBMS: Microsoft SQL Server 2012/2008R2/2008/2005, MS-Access

Tools: /Utilities: Microsoft Visual Studio, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Data Tools (SSDT), TFS, Microsoft Management Console, Microsoft Visio, Rational Rose, Power Pivot, Power BI, Microsoft Test Manager (MTM), SPEC flow, Crystal Reports,K2 Black Pearl

PROFESSIONAL EXPERIENCE

Technology Lead

Confidential

Responsibilities:

• Developed the Asp.Net web API Services using c#.net.
• Developed Controllers and Actions Methods for Calculation Module using ASP.net MVC
• Developed Angular JS UI and Services for showing the data in UI
• Migrated the On Premise Services onto the Azure.
• Developed the WCF Services for Admin Module End to End using ASP.NET
• Automated the Test Cases using Microsoft Codedui and Selenium test Frameworks
• Extracting, transforming and loading data (ETL) between various Homogenous and Heterogeneous data sources usingSQL Server Integration Services (SSIS).
• Using Control flow tasks especially For loop, For Each Loop, Sequence Containers, Execute SQL Task and Script Task.
• Created master and child packages, package configurations and logging.
• Usage of various SSIS components like Dynamic Variables, Dynamic package configuration and Error Handling etc.
• Usage of Integration Services Catalog for SSIS Project deployment and scheduling SSIS using SQL Agent jobs.
• Tuned Performance for Stored procedure and TSQL queries using SQL Profiler, Estimated and actual query plans and database engine tuning advisor.
• CreatedClustered and Non-clusteredIndexesforQuery Optimizationbased on the analysis on query pattern used in the application.
• Involved in design and validation of the data mediation layer (DML) components.
• Designed database objects as tables, views, synonyms, stored procedures, user defined functions, common table expressions (CTEs) and triggers to facilitate efficient data manipulation and data consistency.
• Implemented the grouping of database objects in business specific database schemas to maintain the proper readability and access.
• Extensively used Joins and Common Table Expressions (CTE) to simplify complex queries involving multiple tables.
• Generated Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Developed SQL scripts to Insert, Update, Delete and Merge data in the database tables along with SQL Joins.
• Created Views and Synonyms to reduce complexity of code development.
• Created Certificate and key to encrypt and decrypt High Business Impact (HBI) data.
• Created RDL reports using SQL Server Reporting Services (SSRS) based on business requirements.
• Usage of DACPAC/ISPAC for SQL Server Database/SSIS Project deployment using VSTS.
• Using Excel Power Pivot and Power query to analyze the huge volume of data while connecting to SQL Server source.
• Troubleshooting issues and Impact analysis on the bug fixes.
• Performing data quality analysis after retrieving data from internal and external systems and ensures accuracy through the development of reports for reconciliation.
• Performed root cause analysis on data quality issues and identifying approaches to resolve.
• Developed, managed, and tracked the activities needed for data quality improvement efforts.
• Provided expertise to other teams including data administration and source based data analysis.
• Prepared impact analysis document of proposed functionality on existing systems.
• Involved in application design discussion with client and business team based on User stories and User scenarios.
• Participated in creating application architecture document to provide deliverables in line with architectural requirements.
• Conducted system analysis, defined technical architecture with detailed technical specifications.
• Participated in test strategy preparation and execution to ensure the quality of product/application.
• Communicated intensively with clients, sub-contractors and vendors to establish cordial/effective working relationship.
• Responsible for cross team collaboration to integrate the application modules and integration testing.
• Co-ordinated with offshore team to meet the deliverables based on the requirement provided by business.
• Encouraged collaborative efforts and camaraderie with onsite and offshore teams.

Senior SDET

Confidential

Responsibilities:

• Developed WCF services for Calculation Engine to calculate the incentives using ASP.NET WCF Services
• Managed all areas of Quality Management: processes, test plan and test case creation, bug tracking lifecycle, functionality testing, user acceptance testing (UAT) coordination, oversight of test automation and performance testing.
• Effectively represented SQA in Customer project planning, analysis & requirements meetings.
• Worked effectively with development and Build Engineering teams to identify, isolate, prioritize, and fix software defects.
• Reviewed the project scope, determine test team assignments, new test and modified programs, and reviewed the work of others on the team.
• Led the successful execution of automated test case for RP Releases that facilitated a significant reduction in testing time.
• Participated in triage meetings with PM/DEV team(s).
• Developed different SQA tools for quicker testing, which reduced time for quick ad-hoc/functionality testing.
• Development ofMVC Views, Partial Views.
• Developed Internal SQA tools for test management activities. It helped team as a central repository to track the AI’s. Features like (Actual Vs. Planned reports, Downtimes tracking, code coverage results tracking, project reports, action items tracking etc.)
• Automated key integration scenarios and reduced test life cycle time and process.
• Designed test plan/test cases for User Acceptance Testing and performed Code review.
• Designed new BVT automation suite and integrated to Lab Manager (MTM).
• Supported during Sprint- Build, SIT & UAT phase to Business and SD teams in giving the overview of the platform program.
• Provided production defect research and root-cause analysis to investigate the root cause and preventive steps to take in further programs/releases.
• Handled change requests and its impact to SQA testing, risk analysis and measurement.
• Coordinated and executed deployment test and support tasks for system releases.
• Involved in integration testing of the Application in Development environment and helped DEV team to identify the issues.
• Proven strong debugging skills, issue identification and resolution. Provided extended support during UAT and post production for issue resolution.
• Worked with functional managers to obtain necessary resources to support the team's requirements.

Software Engineer

Confidential

Responsibilities:

• Development of User Interface of Vessel Lifting pattern in the Prepare offer Module of Castrol Marine using VS2005, C#.net and ISP tool.
• Development of windows Service for data Load to process the Cogs, Products and Freights data for the Castrol marine.
• Creating of PPM Reports using crystal reports 11.0 to display the KPI of the Sales Executive.
• Creating of SQL stored Procedure for the Pricing Performance monitoring to bind the data with Reports.
• Writing the Unit test scenarios and Execution of Unit test cases for the Modules Vessel Lofting pattern and Data Load windows service.

Software Engineer

Confidential

Responsibilities:

• Gathering the Requirements from PM
• Analyzing the Requirement and Tasking it
• Development of Filter ribbon in the External User in C#.NET 2.0 using Visual Studio 2005 frame work
• Designing the structure of Reports using Crystal Reports 11.0 for showing the KPI of Day to Day Bitumen Business.
• Writing SQL queries and Stored Procedures to bind the data with the KPI Reports for Different Business units and Users