OBJECTIVE:

To build cost - effective, robust software systems using appropriate technology and increase customer satisfaction.

SUMMARY:

• Overall 18 years of experience in Software engineering, Confidential, System architect & information processing and .NET 4.5/ 4.0/ 3.5/2.0/1.1 . Experience in complete software life-cycle development from project inception to delivery and maintenance.
• Over 10+ years’ experience as Web Application Development Manager/Technical Project Manager. Extensively used methodologies like RUP, XP, SCRUM Agile and MSF.
• Managing diversify on & Offshore teams at different geo locations.
• Solid hands-on experience in enterprise Web strategies, B2B, B2C, MVC 6/5/4/3/2 Design, Entity Framework (EF), NHibernate, Razor view, JSON, LINQ, Angular JS, TDD, C# . NET 4.5/4.0/ 3.5/2.0 on ASP.net/windows form, jQuery, classic ASP, WCF/REST/Web API 2, SSIS, client/server, Intranet, and Windows based application development using n-tier, systems design, programming and product delivery, VB6, COM/COM+/DCOM, ADO.NET/ ADO 2.7, LDAP/ADSI, HTML, VB Script, Java Script, AJAX, JQuery, XML, XSLT.
• Database design as well as programming experience using MS SQL Server 2014/2012/2008R2 & 2005, SSIS, BI Studio 2010/2008/2005, MySQL & Oracle. Writing complex T-SQL Stored procedures, cursors & views in big scale databases.
• Design, Develop & Implementation experience of ERP modules Financial, Fixed Asset, Inventory & Payroll.
• Keeps up-to-date with the latest tools, technology trends, methodologies and best practices through continuous training and courses enrollment
• Ability to interface effectively with co-workers, executives as well as end-users
• Proven ability to excel in pressure situation and deliver result

TECHNICAL SKILLS:

Languages: C# .Net 4.5/ 4.0/ 3.5/2.0/1.1 on ASP.net/Windows Form, MVC 6/5/4/3/2 Design, Entity Framework (EF), NHibernate, Razor view, JSON, LINQ, Angular JS, TDD, XML/XSLT, SOAP, WCF, classic ASP,DOM, HTML/DHTML, CSS, jQuery, AJAX, JavaScript, VBScript, VB 6.0/5.0/4.0, ActiveX, COM+/COM/. NET dll.

Data Access & SQL Skill Set: ADO .NET/2.7, OLEDB, ODBC, T-SQL, PL/SQL, SSIS, SSRS

Database: MS SQL Server 2014/2012/2008R2/2005/2k /7.0/6.5, MySQL 5, ORACLE 10g/8i /7.x on Windows, MS Access 2007/2000/97.

Operating Systems: Windows Server 2012/200 R2/2003.

Software/Tools: Visual Studio 2015/2013/ 2010/2008/2005 /2003/6.0/, IIS 7/6, Visual InterDev, MTS, MS Office 2000, Crystal Reports 9/7, Erwin, Visual SourceSafe and MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential,NJ

Technical Project Manager/SSIS Lead

Responsibilities:

• Developed SFTP & data feed component to download Schneider Electric, Gas & Regional weather data feeds, parsed, transform and consume daily data into raw database.
• Developed SSIS packages to fetch Forecast & Observation data feed using SOAP service (forecast data) and JSON format (Observation data) from National Weather Service. Load, Parsed, transform and consume daily into raw database.
• Developed SSIS packages to fetch Observation data in JSON format from Earth Network. Load, Parsed, transform and consume daily into raw database.
• Developed SSIS packages to Extract & massage data into hourly, daily, weekly & monthly view.
• Developed SSIS packages to implement contingency & scoring formulas to calculate hourly, daily, weekly & monthly Scoring for various dimension i.e. Temp, Wind, wet bulb, wind gust score.
• Developed SSIS package to BULK Import existing historical scoring data.
• Designed & developed desired CSV reports.
• Developed front end application to setup weather regional weather station to pull data for and mapping with forecast, input TV7 forecast.
• Environment: MS BI Studio 2010, SSIS, SQL Server 2014, MVC 5, Entity Framework 6, JSON, JQuery, AJAX, C#, .Net framework 4.5, TFS 2012

Confidential,NJ

Technical Project Manager

Responsibilities:

• Analysis and Conversion for Confidential ’s FoxPro based “Add-Ons” Reporting System.
• Responsible to design enterprise application architecture. Involved in database designing.
• Involved in developing application core classes. Used modernizer scripts to perform browser compatibility.
• Worked as team player to increased productivity and shorter turn-around times
• Migrate VFP database into SQL Server 2012.
• Design & developed reports in SSRS.

Environment: C#, ASP.Net 4.5, Visual fox pro 9, TFS 2012, SQL Server 2012, SSRS, Windows 2008 R2 Server

Confidential

Project Manager

Responsibilities:

• Responsible to design AFA Customer Relation Management system architecture and business process using MVC 5, Entity Framework 5 & Razor view engine.
• Design the Confidential data model as per catered CRM requirement.
• Involve in developing CRM core controller and Model classes and views.
• Developed files upload & mailing component.
• Developed core ACL based user registration module.
• Involve in writing the Entity Framework Lambda based query over expression queries.
• Designed and Created Data services using SQL Server to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components.

Environment: C#, ASP.Net 4.5, MVC 4, Entity Framework 5, Identity framework, JQuery, TFS 2012, SQL Server 2012, Windows 2008 R2 Server

Confidential

Project Manager/ Sr. Data Architect SSIS

Responsibilities:

• Developed SFTP & data feed component to upload & download nightly marking data feeds, parsed and consume Historical data in database.
• Developed SSIS packages to create data input feed to run thru AccuZip to validate postal address, calculate street and high rise building addresses, Person moved. Identify and retrieve Address moved forward/PO Box. Read and consume Accuzip output in historical database.
• Developed SSIS packages to generate refresh Mail marking data for monthly/bi-weekly Mail publishing.
• Developed SSIS package to BULK Import existing Users data and transformation into potential lead.
• Designed & developed desired CSV reports.

Environment: MS BI Studio 2008, SSIS, SQL Server 2008 R2, C#, .Net framework 4.0, TFS 2010

Confidential

Product Manager/Sr. MVC Developer

Responsibilities:

• Develop Confidential Rewards Club application using MVC 4 & NHibernate to allow members to submit their purchased invoices and redeemed their points for thousands of online retailer gift cards.
• Dynamically serve regional based online promotions for more than 300,000 North American postal codes
• Responsible to design Rewards Club application architecture and business process using MVC 4, NHibernate & Razor view extension.
• Design the Rewards Club database model according to internal and third party design.
• Involve in writing application core controller and Model classes.
• Developed SFTP & XML component to upload & download nightly xml files and parsed and consume User Points Transactions, Daily Points History, New Rewards Club Members and Cashed-out/Redeemed points into user bank data.
• Developed Single Sign on (SSO) component and Implemented TripleDES Vector based & SHA256 Encryption for SSO to get authorize by Identity provider.
• Involve in writing the nHibernate Lambda based query over expression queries.
• Designed and Created Data services using SQL Server to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components.
• Developed SSIS package to BULK Import existing Users and their Year-End Points Balance History data into Rewards Club DB using SSIS controls.
• Utilized Collections Objects and wrote type safety compliance code to manage run-time errors or performance issues.
• Designed & developed desired CSV reports.
• Write & Perform TDD unit tests to anticipate 150,000 visitor influx and increase performance through development of caching layer
• Co-ordination with client and business analysts’ team for understanding of requirements.
• Follow the prioritized SCRUM backlog, Two weeks Sprint iteration and deployed the final code at each sprint end.
• Actively work as team player and provide support to team in technical difficulties and explaining business processes during development of project.

Environment: C#, ASP.Net 4.5, MVC 4, NHibernate, Razor Views, LINQ, jQuery, TDD, Visual Studio 2012, TFS 2012, SSO, XML, T-SQL, IIS 7.5, SQL Server 2008R2, Windows 2008 server

Confidential

Technical Project Manager

Responsibilities:

• Detail study of business process & departmental activities
• Correspondence with client. Business requirement gathering and convert into technical artifacts.
• Measure & calculate Effort Estimation. Establish a complete project plan from WBS to scheduling and controlling.
• Manage resources, Assign task to team, Involved in day to day activity with team. Conduct weekly status meeting.
• Responsible to design enterprise application architecture for all tier.
• Involve in database & architecture designing.

Environment: Java, J2EE, Struts, iPlanet (6.0) web server, WebLogic (9.2) as Application Server, Oracle 10g, Solaris 8

Confidential

Technical Project Manager

Responsibilities:

• Co-ordination with client and business analysts’ team for understanding of requirements.
• Create a prioritized SCRUM backlog, Sprint planning and decide the implementation way, Asses daily SCRUM progress. Lead the Sprint review at each sprint end.
• Measure & calculate Effort Estimation. Establish a complete project plan from WBS to scheduling and controlling.
• Responsible to design enterprise application architecture, Involve in database designing.
• Manage resources, Assign task to team, Involved in day to day activity with team. Conduct weekly status meeting.
• Provide support to team in technical difficulties and explaining business processes in development of product.
• Involve in configuration management. Using VSS to make builds and releases.
• Developed WCF REST- API based web service to consume data by client. Implemented provider based services.
• Implemented SAML services for SSO to get authorize by Identity provider.
• Designed and Created Data services using SQL Server to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components.

Environment: C#, ASP.Net 2.0, Visual studio 2008, jQuery, XML, XSL, IIS 7.0, SQL Server 2008R2, Windows 2008/2003/XP

Confidential

Data Mining Analyst

Responsibilities:

• Involve in database, data mart & architecture designing.
• Performing the analysis of the data by using SSAS.
• Use the Multidimensional query language (MDX) to generate analysis reports.
• Use the OLAP system to analyze and summarize the data by creating the cube.
• Designing and generating the various types of reports by using SSRS.
• Created the cube browser using SSRS.
• Develop the ETL packages using SSIS.
• Developing automated package to Encrypt & Decrypt data files, import & export data to & from Database using SSIS.

Environment: C#, ASP.Net 3.5, MVC 3, EF, VS 2008, WCF REST- API, SSIS, SSAS, SSRS, IIS 7.0, SQL Server 2008R2, Windows 2008/2003/XP

Confidential

Technical Project Manager/ Architect

• Responsible to design enterprise application architecture using MVC 2. Involve in database designing.
• Involve in writing application core controller and Model classes. Used modernizer scripts to perform browser compatibility. Used MVC designs approach to produce high efficiency.
• Writing complex T-SQL Stored procedures, cursors & views in big scale databases.
• Worked as team player to increased productivity and shorter turn-around times
• As a future expansion developed assemblies to compatible with a wide variety of Instruments and LIS Vendors.
• Allows the user to select the best instruments to meet their needs.

Environment: C#, Win Form .Net 3.5, MVC 2, XML, XSLT, VS 2008, MySQL, T-SQL, Windows 2003/2000/XP

Confidential,NJ

Solution Architect/PM

Responsibilities:

• In a capacity of Solution Architect, responsible to design enterprise application architecture for all tier.
• Involve in database & architecture designing.
• Correspondence with client. Business requirement gathering and convert into technical artifacts.
• Measure & calculate Effort Estimation
• Manage resources, Assign task to team
• Development platform is ASP.net 2.0, MySQL, GSM based SMS Communication to retrieve data and apply algorithm to store and display on presentation Layer.
• Involve in configuration management. Used VSS & change management software to make builds and releases.

Environment: C#, ASP.Net 2.0, Visual studio 2005, XML, XSL, IIS 6.0, MySQL 5, Windows 2003/2000/XP

Confidential,NJ

Technical Project Manager

Responsibilities:

• Create a prioritized SCRUM backlog, Sprint planning and decide the implementation way, Asses daily SCRUM progress. Lead the Sprint review at each sprint end.
• Measure & calculate Effort Estimation. Establish a complete project plan from WBS to scheduling and controlling.
• Responsible to design enterprise application architecture for all tier.
• Involve in database designing.
• Co-ordination with client and business analysts’ team for understanding of requirements.
• Manage resources, Assign task to team, Involved in day to day activity with team. Conduct weekly status meeting.
• Provide support to team in technical difficulties and explaining business processes in development of product.
• Involve in configuration management. Using VSS & change management software to make builds and releases.

Environment: C#, ASP.Net 2.0, Visual studio 2005, XML, XSL, IIS 6.0, SQL Server 2005, Windows 2003/2000/XP

Confidential

Manager Projects Enterprise Solutions

Responsibilities:

• In a capacity of Manager Projects in integrated solution department, I directly report to VP Software Development.
• My responsibilities are to fulfill complete SDLC in all running projects using RUP & XP methodologies.
• Measure & calculate Effort Estimation
• Create Project Baseline & WBS Plan
• Identify Milestones & Deliverables
• Correspondence with client
• Manage resources, Assign task to team
• Requirements gathering
• Weekly Status Meeting & Compiling Status Report
• Involve in projects from Initiation Phase till Implementation & Maintenance Phases as well as technology point of view, Business Domain & Architecture designing, and Data Modeling.
• Managing team to get into correct path to get deliverables on time with interaction of QA team regarding unit Load & Functionality test cases.

Environment: Java, JSP, Struts, Eclipse, Microsoft Analysis Manager, MSXMLA 4.0, Visual Basic 6, COM, LDAP, ADSI, XML, XSL, Tomcat Apache, SQL Server 2005, Oracle 8i, T SQL, PL/SQL, Windows 2000/XP/ 2k Advance server.

Confidential,NY

Lead Architect

Responsibilities:

• Design website content search using MS Index Server, create catalog, directory structure and set scope for catalog content and presentation tier architecture, wrote middle tier COM+/DCOM component to transform XML into XSL/XSLT, re-designed Pressroom & Press Release section web pages, use MS SQL Server 2000 to fetch data to presentation layer.
• Designed XML schema and wrote XSL and transform on ASP page.
• Design & write ASP pages for user profile management, logon/Authentication, forget password and Contact Media relation routines.

Environment: ASP, Visual Basic 6.0, VisualInterDev6, COM, DCOM, XML, XSL, IIS, MTS, SQLServer2000, TSQL, Windows NT/2000/XP

Confidential,NJ

Team Lead Web Application Development

Responsibilities:

• Designed, implemented and administrated an n-tiered database driven company website, corporate intranet application, and portal.
• Developed architecture as a 3-tier model with Web Service that talks to mainframe and SABRE to provide real time inventory prices to online customers.
• Designed website middle-tier and presentation tier architecture, wrote middle tier COM+/DCOM component, designed web page flow diagram.
• Developed web service using C# to assign and display ad on Liberty and GOGO website.
• Involved in understanding the business requirements and leverage the technology to meet business requirements and goals.
• Taken hands on decisive role in designing the solution architecture, development standards, database interaction optimization, user security and authentication and performance monitoring.
• Extensive development work done on ASP.NET user front end enabling several business rules by developing Custom User Controls,
• Developed Data access components in VB 6 using Microsoft Data Access Application Block Component to connect to SQL Server database and isolated data access logic from business layer and front end by defining several strongly typed data structure.
• Implement XML & XSL interface on presentation layer.
• Analysis & designed architecture of GOGO Link partners website and enabled with booking engine.
• VSS was used for source control management and synchronizing with VSS solution.
• The role also includes writing stored procedures, views, and triggers, testing and deployment of the application on the server.

Environment: Visual Basic 6, c#. ASP.Net, .net framework 1.0, ASP, Visual studio 7, Visual InterDev6, COM, DCOM, LDAP, ADSI, XML, XSL, MTS, IIS, SQL Server 2000, Oracle 8i, T SQL, PL/SQL, Windows NT/2000/XP

Confidential,NJ

Sr. Application Developer

Responsibilities:

• Design website middle-tier and presentation tier architecture, wrote middle tier COM+/DCOM component, designed web page flow diagram, wrote application tier Database connectivity COM+ to make connectivity b/w application layer to data layer(MS SQL Server & Oracle) and fetch data to presentation layer in form of Array, record set, XML string and XML physical file.
• Designed and written Liberty Travel/GOGO Booking engine Package, Flights, Tours and complete booking process COM+.
• Design & write security layer using LDAP/ADSI to authenticate, set permission and create/delete user in Active Directory DB.

Environment: Visual Basic 6, c#. ASP.Net, .net framework 1.0, ASP, Visual studio 7, Visual InterDev6, COM, DCOM, LDAP, ADSI, XML, XSL, MTS, IIS, SQL Server 2000, Oracle 8i, T SQL, PL/SQL, Windows NT/2000/XP

Confidential

Programmer Analyst

Responsibilities:

• Worked on internal Marketing purpose login based web application.
• Involved in designing of Analysis, Architecture, Database model, Admin module, create page flow design, write packages using PL/SQL in Oracle Application Server for dynamic Pages and write PL/SQL package to implement business logic.

Environment: Oracle Application Server-PL/SQL-IIS- Windows NT