SUMMARY:

• Analytical approach toward problem solving, strong SQL development background with expertise in web based applications, three tier client - server systems using Confidential technologies with distributed application development.

TECHNICAL SKILLS:

• ASP.Net 4.0/4.5
• MVC
• C#
• DB2
• SQL Server 2000-2008
• Oracle
• HTML/XML
• VBA
• Java Script
• AJAX
• Unix limited Java
• JSP
• MS Visual Studio
• DB Studio
• Alteryx
• Informatica
• Tidal Scheduler and Cognos Reporting tool
• Management tools like Rally.

PROFESSIONAL EXPERIENCE:

Confidential,Piscataway, NJ

Application Development/Lead Manager

Responsibilities:

• Over 15 years of experience developing front-end three tier sites using C#, ASP.net/MVC with rich content Web-Forms, Win-Forms, Web User Controls (ASMX), Server Controls (Telerik), Windows Service and WCF/REST Web Services API.
• Experienced in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Debugging, Testing, Deployment, Maintenance of business applications.
• Over seven years’ experience of managing Sr. application developer and working with them for translating business processes and end-user requirements into functional system requirements that improved productivity and simplifies the development efforts for development team.
• Experienced in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Debugging, Testing, Deployment, Maintenance of business applications.
• Having core background application development experience allows me working with development team to make sure the proper solution is implemented.
• Deep technical implementation knowledge of working with front-end three tier applications as well REST Full and WCF services.
• Created and optimized application coding techniques, balancing and query performance.
• Implemented SSO functionality to connected with third party vendor application.
• Identified solution of the business requirement for development implementation.
• Helping the Product Owner get the backlog in good shape for the next Sprint.
• Developed architecture and solutions application work flow process for all projects related to front-end development work.
• Excellent skills with working with development team to make sure that project completed on time with efficiency.
• Able to express ideas and communicate with non-technical users as well as hardware/software technicians.
• Assigned, monitored and prioritized the work systems analysts and developers while providing technical and administrative support.
• Successfully managed more than 35 projects, 26 applications and relationships with stakeholder managers.
• Worked as subject matter expect (SME) to transform business requirement into technical system requirements.
• Work with QA Testing Coordinator and project staff to ensure test cases and scenarios provide test coverage for all requirements; assist with the authoring and development of test scenarios
• System requirements demanded less than 3 second response time for queries on various project implementation.
• Extensive work with configuration design, implementation, testing application support and maintenance.
• Continuously adjusted priorities and addressed issues to improve efficiency. Achieved committed product content and quality goals on time after staff reductions and increases in content.
• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
• Worked with very tight deadline to achieve the goal and support client’s demanding request.
• Coordinated project progress and reported status to the executive management team for their weekly progress meeting.

Marketing/Financial Application Developer

Responsibilities:

• Strong web application development experience using ASP.Net 3.0/3.5, Visual Studio 2010, C#, SQL Server, web services, and other web development technologies. Responsible for designing, planning, and/or implementing, managing project for current industrial approaches.
• SQL server Developer 2000-2008 with seven Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2005/2008, SSIS and SSRS.
• Experienced in client requirement Analysis, Physical, Logical design, development (SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, DTS, SSIS, and SSRS 2005/2008.
• I have developed various web pages using C#, VB.NET with rich content Web-Forms, Win-Forms, Web User Controls (ASMX), Server Controls (Telerik), Windows Service and WCF Web Services.
• Experience with Data Accessing including using DataAdapter, DataReader and DataSet in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation. Experience developing complex user control using ASP.Net and ASP.Net MVC.
• Experience with UML (Unified Modeling Language) and OOP/OOD(Object Oriented Programming and Design) Software Design Patterns in 3-Tier and N-Tier Applications.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins. Optimizing the queries by creating various clustered, non-clustered indexes and indexed views. Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert. Excellent used of various ETL tool like Alteryx and Informatica. I have used these tools on daily basis on my past and current position.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Additional responsibilities included developing/prototyping functionality that was implemented in various pages by other members of the team.
• Worked with very tight deadline to achieve the goal and support client’s demanding request.
• Coordinated project progress and reported status to the executive management team for their weekly progress meeting.

Financial Application Developer

Responsibilities:

• Strong web application development experience using ASP.Net, C#, HTML, XML, AJAX and other web development technologies.
• Strong knowledge of .Net technologies. Extensive knowledge of ADO.Net. I have developed various web pages using C# with .Net technologies.
• Strong knowledge of Reporting Services 2005 and Report Viewer control using ASP.Net 2.0. Created Ad-hoc and daily batch report process for Brokerage Accounts using Report Viewer Control.
• Responsible for development of the new eligibility screens including all design changes to the Oracle database, coding of presentation in ASP.Net, client side editing with Javascript, and HTML files.
• Responsible for designing a relational Oracle database schema in new system and analyzing, inserting and deleting data from the Oracle database using PL/SQL queries.
• Strong knowledge of Informatca 7.0 for ETL processing, and Tidal scheduler.
• Strong Knowledge of Oracle and SQL database using PL/SQL queries.
• Created common classes for report viewer control to generate reports in PDF.
• Created validation class to validate business errors, also used validater controls to validate user input errors.
• Extensive use of Source Safe, Graphics/Image Editors and Confidential Excel.

Financial Application Developer

Responsibilities:

• The Orion is an Intranet application written using ASP, Java, HTML, JavaScript, and VbScript . The application allows agent to create an account, provide various module, rate of return, and generate an Excel reports in VBA according upon investment report. My primary responsibilities at Smith Barney are developing new functionality for Orion, Portfolio Designer and Research Authoring application systems.
• Strong web application development experience using ASP, HTML, XML and other web development technologies.
• Good knowledge of .Net technologies. I have developed web pages using C# with .Net technologies. Ability to convert web pages from existing ASP application to ASP.Net.
• Responsible for development of the new eligibility screens including all design changes to the database, coding of presentation in ASP, client side editing with Javascript, VBscript and HTML files.
• Developed pages that allowed user to select multiple reports and submission of application in ASP. I also developed pages that allowed user to select multiple items and view it in Confidential excel/word using ASP. I also developed pages that upload or download files to client machine or on web server using ASP objects.
• Strong knowledge of VBA coding. Created different templates in VBA to display client reports (Graphs, Tables, Charts, Calculating numbers) in Excel.
• Responsible for designing a relational database schema in new system and analyzing, inserting and deleting data from the DB2 database using SQL queries.
• Created SDLC standard technical documents and test cases for projects.