SUMMARY:

• Over 12.0 Years of experience with IT industry in Utility (Nuclear), financial, insurance and retail companies with Confidential.
• 12 years of experience in .NET programming experience.
• Extensive knowledge of Object - oriented programming (OOP) concepts and design patterns
• Experience in web application development using ASP.NET web Form (Master page, user controls, validation controls) and ASP.NET MVC (Razor view engine, View, partial view, models and layout view), Web services, Windows communication foundation (WCF) and ASP.NET Web API
• 12 years of solid database experience on MS SQL, Oracle 11g/9i, PL/SQL, PostgreSQL, Physical database design, Logical database design, Data Modeling, Data Mapping, Cleansing, Data Exports & Imports, Inbound/Outbound Interfaces,
• Specialized in Application Support, Performance Tuning & Optimization, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning.
• 12 years of Oracle PL/SQL experience with emphasis on back-end programming experience using PL/SQL, SQL, MS SQL, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• 4 years of experience in leading the team to investigate, analyze, and resolve complex technical problems. Identifies and manages interfaces, service levels, standards, and configurations.
• 12 years of expertise in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types.
• 6 years of expertise in developing applications based on iterative design approaches, specifically Agile Software Development.
• 6 years of Experience in Oracle Development experience including analysis, modeling, design, and coding, testing, administration, maintenance of Oracle Database systems on Windows, UNIX and NT platforms.
• Having intensive experience in translating business requirements to Database Objects.
• Proactively identifies opportunities for improvement and recommends technical solutions.

TECHNICAL SKILLS:

Databases: SQL Server 2008, 2012 and 2015, Oracle 9i, 10g, 11g and 12C

IBM Tools: FileNet P8 5.2, Application Engine, Process Engine, Content Engine, FEM, IBM Websphere 7.1, FileNet API, VB Script, XML, CSS, Content Navigator, EMC Centera, KOFAX, JAVA Script

Business Intelligence Tools: SSRS, .NET framework Data Reports, Crystal Report 12

ETL Tool: SSIS (MS SQL), SSRS

Web Application Server: VB.NET, C#, .NET Framework 3.5 4.5, MVC 4.0, Boot strap, CSS, JAVA Script

Frameworks: .NET 4.5, ASP.NET MVC, ADO.NET, Web services, WCF, Web API, Entity Framework

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr Software Developer

Responsibilities:

• Administering and supporting IBM FILENET, Fusion, Vision and Decision Support System, Security Screening information system to day-to-day monitoring, problem resolution and root cause analysis.
• Objectstore design, Document Class, Property templates, work queues, Roster, Event logs
• FEM administration, Content Engine Administration for using NSeries storage, Daily Health Check. FileNet system recycling, FileNet API development, Trouble Shooting production problems, maintaining Production system, Creating PMR and working on PMR with IBM for resolution, Space monitoring
• FileNet and CENTERA configuration
• Developed and deployed content migration solutions for about 35 million old documents from old system
• Verity Content search solution configuration and deployment, Space monitoring
• IBM Content Collector experience in configuration and deployment for batch ingestion of documents from File Folders
• Search Templates development and workplace configuration for access roles
• Developed Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes and designed to ensure the integrity of the application environment
• Defined strategies and solutions to improve the performance and access of imaging/workflow applications.
• Monitor Remedy and Service now Tickets, analyze tickets and provide resolution as per the service level agreements SLA. Tracks status of client inquiries coordinates appropriate response and follows up to ensure client satisfaction
• Worked closely with SAP Interface and PADS team to Extract, Transformed and Load data from multiple data sources using SQL SERVER R12 (SSIS ETL Tool).
• Releasing the work items which are stuck in error queues following the stack information.
• Application Engine Administration using Workplace
• Defining search templates for business units using the Workplace Search Designer.
• Responsible for maintaining and resolving ongoing FileNet and Kofax related issues
• Content Engine Administration using Enterprise Manager, Define Object Stores, Document Classes, Choice Lists Property Templates.
• Developed new procedures for requirements gathering, needs analysis, testing, scripting and documentation to strengthen quality and functionality of business-critical applications.

Environment: ASP.Net, .Net Framework 3.5, 4.5, Oracle PL/SQL developer, SQL Server 2000, SQL Server 2012, ASP.Net, C#, Framework 3.5, 4.0

Confidential, WI

Sr. Software Application Support / Developer

Responsibilities:

• Worked on new enhancements Bizfiling application, Fixing the production defects like Customer reporting issue and application performance tuning.
• Creating and maintaining the DB views, queries, procedures, views and optimizing the existing queries.
• Production support for many other applications (BOS, MOS, TDC, TNC, CTProComply)
• Gathered the user’s application (Bizfiling, BOS, MOS, TDC, TNC, CTProComply) requirement and created the document for it.
• Modified the applications which are coming in partially converted and not converted categories.
• Mainly participated with the users in the UAT phase and solved many of the user’s issues.
• Developed Standards Documents, Creation and Maintenance of Change Control Documents and User Guides.
• Analyzed the requirement for customer business reports and performing enhancement.
• Skilled in Management of performance tuning activities to improve system performance.

Environment: ASP.Net, .Net Framework 3.5, SQL Server 2008, Crystal Report 11, .NET Data reports.

Confidential

Software Application Support

Responsibilities:

• Requirement Analysis from Business Client and Analysis feasibilities and Impacts for PPS application.
• PPS application Page Designing, Coding and QA testing.
• Writing complex SQL Scripts and providing the optimized solutions using the pl/sql queries.
• Confidential - Premium Processing System Application Enhancement
• Troubleshooting complex DB scripts and VB queries in the Confidential - Premium Processing System.
• Tuning of complex DB scripts using the parameters, indexes, MA Views, Stored procs, functions.

Environment: VB 6.0, SQL Server 2005, Crystal Report

Confidential

Sr. Tech Associate

Responsibilities:

• Built application logic using Infragistics tools and various proprietary systems and tools
• Ability to plan logical solutions for programming challenges
• Provided expertise during client project planning meetings
• Created Electronic Commerce Deals to assure proper product fulfillment
• Supported and managed all recording requests between internal departments and external clients
• Requirement gathering from Business Client and Built the HR modules, Maintenance, Back office module are Integrated
• Develop the Front desk module and integrated with other modules screens.
• Introduced metrics classes into booking API calls using generics.
• Created different reports for management, marketing and development department needs.

Environment: VB.NET 2008, Infragistics tools and MSSQL 2005, Crystal Reports 11, .NET Data Report

Confidential

Sr. Tech Associate

Responsibilities:

• Developed the application security management and end user screen design.
• Developed customized HR departmental report development for each customer perspective.
• Created Electronic Commerce Deals to assure proper product fulfillment.
• Worked with high-level requirements and leverage relationships and domain knowledge to translate into concrete requirements.
• Translated those requirements into technical designs.
• Implemented procedures for detailed analysis, designing and development of content management services.
• Requirement gathering from Business Client and Built the HR modules, Maintenance, Back office module are Integrated
• Created different reports for management, marketing and development department needs using Crystal report tool.

Environment: VB.NET 2008, Infragistics tools and MSSQL 2005, Crystal Reports 11, .NET Data Report