SUMMARY:

• 16+ years of professional experience working as Technical Specialist in the Information Technology industry with outstanding delivery record. Areas of expertise are client handling, requirement analysis, technical design creation, implementation, deliverable reviews process, technical troubleshooting and maintenance, application development, work with geographically dispersed teams and project management.
• More than 12 years of strong experience in developing and supporting applications allow perform financial & banking services, account services, wealth management, investment management, trade settlement, asset data management, mutual fund, portfolio, account transfer, cash services, income processing, capital market, equity, market risk, class action, corporate actions etc.
• 4 Years of experience working with Healthcare and Retail projects (including order management and manufacturing system).
• Knowledge of database development methodologies, design, engineering, and implementation of database system.
• Expertise in writing functions, procedures, packages, complex T - SQL/SQL, queries and working with triggers, views, indexes, types, objects, cursors.
• Proficient in creating ETL pipeline to transform the data using DTS, SSIS, and Azure Data Factory (Cloud).
• Optimize performance of many stored procedures, T-SQL queries to deliver big amounts of data.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues.
• Excellent background in developing applications using Visual Basic 6.0, COM, VB.Net, C#, WinForms, MS SQL Server, Classic ASP, JavaScript, MVC.
• Communicate and interact on a regular basis with business partners and development team during different stages of the project
• Experience in producing report/dashboard using Crystal Report, SSRS and Tableau.
• Coach and mentor other technical resources on the team.
• Excellent Analytical, debugging, trouble shooting and programming Skills.
• Actively participate, review, create QA strategy, test plan, unit test cases and review with business team.
• Capable of delivering success in a complex project with scope for learning and challenge
• Recognized for managing complex projects (with tight timelines), building and leading Teams, Cultivating, and nurturing relationships, and Critical Problem-Solving
• Experience in performing database administration activity like creating maintenance plan, disaster recover, implement security, deploy ETL packages/flow, create & monitor SQL agent jobs.
• Capable of managing clients for entire business practices and procedures.
• Expertise in analyzing client's business and requirements, suggesting, and implementing processes to deliver high quality business solutions and recommendations

TECHNICAL SKILLS:

Languages: C#, VB, T-SQL

Web Technologies: ASP.Net, Classic ASP, XML, HTML5, MVC, Web API, REST Web API

Scripting: Java script, VB Script

Database: Microsoft SQL Server, Microsoft Access 2003/2007/2010/2016

DW ETL Tools: SSIS, DTS, ADF

Designing Tools: MS Visio, Visual Studio .Net 2015/2015/2008/2005/2003

Version Control Software: VSS, SVN, TFS, GIT

Testing Tools: Load Runner, PVCS Tracker, JIRA, Confluence

Project Management / Methodologies: Microsoft Project Plan, Microsoft Office, Waterfall, Agile

DW Reporting Tools: SSRS, Crystal Report, Tableau

DevOps: SVN, TFS, Bitbucket, JIRA, Jenkins, Octopus

Other Tools: VMWare, Citrix Server, Janus Grid, Spread Grid, Cognos Reporting, Barcode software’s, File Net, Blaze Server, Group1 Address Verification, SQL Server Profiler, SQL Server Agent, Tomcat, Octopus, CICD (continuous integration and continuous deployment), Test Complete, CuteFTP, SOAPUI, Postman, SharePoint and Bloomberg Terminal.

PROFESSIONAL EXPERIENCE:

Technical Specialist

Confidential

Responsibilities:

• Coordinate with business and operation team to understand the business requirement and create functional specification document the same for further SDLC activities.
• Work closely with all stakeholder and business partners on estimation, budgeting and s.
• Coach and mentor other technical resources on the team.
• Actively participate, review and create technical design and architectural documents.
• Act as Subject Matter Expert (SME) for product functional and technical.
• Supporting first priority support teams at onsite for productions issues.
• Facilitate various code review meetings with onsite and offshore teams and make sure code is written as per in house coding guidelines.
• Working in Offshore onsite model, handling offshore queries, coordinating and explaining requirements, timely deliveries and able to manage round the clock support with offshore support.
• Writing (DDL & DML), troubleshooting, and debugging complex query, Stored Procedures, User Defined data types, Joins, Triggers, Views, Functions, Sub queries and Common Table Expression (CTE).
• Reviewing query performance via query execution plans and optimizing SQL code and creating table indexes to improve databases performance.
• Create Pipeline in Azure Data Factory using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Working with different data formats JSON, XML, Flat File, CSV and Excel.
• Extensively used SSIS transformations such as script component, Slowly Changing Dimensions, Pivot/Unpivot, Multicast, Derived Column, Data Transformation, Row count, send email task etc.
• Use SSIS script task, loop up transformations, and data flow tasks using T-SQL and C#.
• Creating maintenance plan, disaster recover, implement security, deploy ETL packages/flow, create & monitor SQL agent jobs.
• DevelopedMulti dimensional Objects(Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Create dashboard and report using BI Data visualization tools like Crystal Report, SSRS, Tableau
• Support SPTC project is a suite of multiple web-based applications architecture with ASP.NET, MVC, classic ASP. It also has backend processed that feed data through VB.NET/C#.NET agents and SSIS packages.
• Actively participate, review, create QA strategy, test plan, unit test cases and review with business team.
• Demonstrate the project enhancement to the client and business team using live session.

Technical Analyst

Confidential

Responsibilities:

• Interact with business via live meeting and voice call or some other mode to elicit the functional and nonfunctional requirements.
• Prepare design solution that satisfies and fulfills the requirement, preparing test cases, review the test case prepared by subordinates, coding, and review the code done my subordinates after following the coding standards and guidelines.
• Develop and maintain windows-based applications in C# utilizing .NetFramework 2.0.
• Involved in writingStored ProceduresandFunctions, Cursorsto handle database automation tasks
• Create ETL tool like SSIS packages to perform various activity like generate the SEI Asset Monthly reports; generate output for various clients like BMO, EJ.

Sr. Executive Development

Confidential

Responsibilities:

• To gather the requirements and documentation of the project.
• Write application logic code using VB.Net and perform unit testing of the enhancements
• Database design and development of various DBO’s procedures, functions, triggers & View etc. based on requirement.
• Create multiple reports using Crystal Report.
• Provide the demo about the release to end users after setup the voice call and live session.

Software Engineer

Confidential

Responsibilities:

• Visit client location to gather the requirements and document the same.
• Develop various DBO’s like procedures, functions, triggers & views based on change requirement as per business requirements.
• Create multiple user interface forms connecting with SQL database to retrieve and update data
• Create multiple reports using Crystal Report.