We provide IT Staff Augmentation Services!

Technology Specialist Resume

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.

Hire Now