SUMMARY:

• Over 12 years of full stack development experience with PL/SQL, MSSQL, MSBI, and ASP.net with C#, Ajax, JavaScript, CSS and HTML.
• Extensive knowledge and experience with PL/SQL, MS SQL and MSBI.
• Extensive experience in ASP.Net with Visual Studio, C#, JavaScript, Ajax, CSS, HTML and IIS.
• Expertise in efficient SQL Query writing and SQL Performance Tuning.
• Expertise in BMC Control - M scheduling.
• Extensive experience with AGILE development methodology.
• Proficient in creating/managing database objects like Tables, Views, Indexes, Synonyms, Procedures, Triggers, Functions, Materialized Views and Sequences.
• Worked extensively on stored procedures, user defined functions, analytical functions, exception handling and triggers.
• Worked on creating/managing database instances, Data files, Table spaces, DB links, Roles and access privileges.
• Excellent Technical, communication and interpersonal skills with strong customer orientation and client interfacing skills.
• Primary responsibilities include estimation, design, development and maintenance of applications.
• Expertise in working with global and distributed project teams.
• Proficient in PL/SQL and MSSQL programming.
• Extensive experience on MS SSIS2016 and MS SSRS2016.
• Proficient in ASP.Net with Visual Studio and C#.
• Proficient in SQL programming in MS SQL.
• Expertise in efficient SQL Query writing and SQL Performance Tuning.
• Proficient in creating / managing database objects like Tables, Views, Indexes, Synonyms, Procedures, Triggers, Functions, Materialized Views and Sequences.
• Worked extensively on stored procedures, user defined functions, analytical functions, exception handling and triggers.
• Worked on creating / managing Database instances, Data files, Table spaces, DB links, Roles and access privileges.
• Database tools like Toad 12.6, PL\SQL Developer, and SQL Server EM.
• Visual Studio 2017.
• SSIS2016 and SSRS2016.
• Version control and content management using VSS, Star Team and Atlassian Source Tree and GIT.
• Defect management using RALLY.
• Scheduling tool BMC Control-M 7.0.
• Microsoft Server IIS.
• Expertise is working with global and distributed project teams
• Proficiency in creating business and technical project documentation
• Project Resource planning and allocation
• Ability to work as a strong team leader to ensure quality and timely project execution

TECHNICAL SKILLS:

Operating System: Win XP/10, Win Server.

Databases: Oracle 11g, MSSQL 2016.

Database Languages: MS SQL, PL\SQL.

Program Language: Asp.net, C#, JavaScript, CSS and HTML.

Tools: Toad, PL\SQL Developer, SQL* Plus, SQL Server EM, Visual Studio2017.

Version Control: VSS, Star Team, Atlassian Source Tree and GIT.

Scheduling: Control M 7.0

ETL Tools: SSIS2016.

Reporting Tools: SSRS2016.

Defect Management: Rally.

PROFESSIONAL EXPERIENCE:

Confidential

Technology Specialist

Responsibilities:

• Data Migration:- Migration of Clients from legacy system which also known as Trust to new platform (SWP)
• Writing procedures, cursors, functions, M Views, Triggers for loading of data from files using loader programs to staging tables .
• Creating database objects, Tables, Constraints, Functions, Packages, M Views, Synonyms, Triggers, Cursors, Sequences and Control Files.
• Maintaining ASP.Net based client applications using C#, JavaScript, CSS Ajax and HTML.
• Creating C# based utilities for client applications.
• Creating data utilities using SSIS.
• Support and maintain/enhancement reports using SSRS.
• Writing procedures and packages for migration of data from staging tables to the Target tables.
• Writing of reverse loader procedure for populating the Configuration tables.
• Writing of wrapper procedure for execution of all the loader procedures in sequence.
• Creating and maintaining documents for knowledge sharing and future reference.
• Interacting closely with Business Users and the Data Warehouse team to gather requirements and help with the data modeling effort.
• Primary responsibilities include estimation, design, development and maintenance of applications
• Delegating the tasks accordingly to the offshore counterparts and getting it done.
• Defect handling on Rally.

Environment: Oracle 11g PL\SQL,TOAD,MSSQL2016,SSIS2016,SSRS2016,ASP.Net,JavaScript, C#, Packages, Views, M Views, Triggers, Synonyms, Analytic Functions, DDL scripts, DML Scripts, PL/SQL Developer, Control-M 7.0, Atlassian Source Tree (GIT), RALLY.

Confidential

Sr. Software Engineer

Responsibilities:

• Maintaining ASP.Net based portfolio management websites and applications.
• Enhancement of ASP.Net based portfolio management and portfolio rebalancing services and applications using C# and JavaScript.
• Creating SSIS 2008 ETL and scheduling of invocation and educate users to use this services.
• Creating reports using SSRS 2008 and educate user to use this reporting services.
• Involved in identifying the procedure bottlenecks and replace with the efficient.
• Environment Setup.
• Application Maintenance and development.
• Involved in SQL tuning using explain plans and driving table concepts.
• Written MSSQL stored procedures, functions and triggers.
• Involved in monitoring the SQL performance by the gradual increase of data load in the respective tables and modified the necessary MS SQL queries.
• Helped team to write unit test cases and made sure that all test cases are covered.
• Primary responsibilities include estimation, design, development and maintenance of applications.
• Documented the impact analysis.

Environment: MS SQL2008, MS EM, SSIS 2008, SSRS 2008, ASP Dot Net 2.0, JavaScript, C#, AJAX, HTML, CSS, stored procedures, functions and triggers, VSS.

Confidential

Application Developer

Responsibilities:

• Developing customized web based applications using ASP.Net 2.0 and C# 2.0.
• Developing web pages and deploying on IIS 7 server and end to end testing of functionality.
• Developing business login using C# 2.0 and create DLL to support business requirement.
• Developing web based applications and web forms using Visual Studio 2005.
• Developing Procedures, Functions, views and Triggers etc. using MS SQL 2005 and MS EM 2005.
• Maintain existing programs and Procedures by making modifications as required by the Users.
• Creating View and procedures on Production environment.
• Troubleshooting the Software and Database related problems faced by the User community.
• Creating Users, Roles, Triggers, Tables, and Indexes etc.
• Loading of Data in database from backup file using MS SQL loader.
• Export and Import of the database, user and tables.
• Creating Partitioning of tables and Indexes.
• Writing SQL query for reporting purpose.
• Creating objects like tables, views, indexes etc.
• Testing and debugging the existing programs and packages.
• Export/Import of SQL database, users and tables.
• Maintaining physical database e.g. data files and log files.
• Taking Offline backups of the database and restoring if needed.
• Creating builds and deploying on IIS server and support users after deployments.
• Query optimization using SQL profilers.
• Organizing demonstrations of newly developed websites and applications and educate end users to use the product.

Environment: ASP.Net 2.0, MS SQL 2005, C# 2.0, Java Script, AJAX, HTML, CSS, IIS 7.

Confidential

Application Developer

Responsibilities:

• Developing customized web based applications using ASP.Net 2.0 and C# 2.0.
• Supporting ASP.net based web application.
• Creating procedures, Functions, Views, Tables, Indexes for web based application.
• Maintain database backups.

Environment: ASP.Net 2.0, MS SQL 2005, C# 2.0, IIS 7.