SUMMARY:

• Over 12+ years of experience in analysis, design and developing of desktop, client - server and web applications.
• Proven ability to design & develop Windows/Web/VSTO/Client-Server applications using several .NET technologies and reports using Crystal Reports & SSRS.
• Worked in all phases of software development life cycle (SDLC) and Agile methodology, wif demonstrated ability to address and resolve performance issues.

TECHNICAL SKILLS:

Languages: VB, VB.NET, C#.NET, ASP.NET, T-SQL, PL/SQL, VB Script, Java Script, COBOL.

RDBMS: ORACLE 11g/10g, MS-SQL Server 2016/2012/2008, Sybase, MS Access, DB2

Database Tools: TOAD, SQL Server Management Studio, SQL Developer.

Integration Tools: SSIS (SQL Server Integration Services)

Database Warehousing Tools: SSAS (SQL Server Analysis Services)

SharePoint: Share Point Server 2010, MOSS 2007, Business Connectivity Services (BCS), SP Object Model, CAML.

IDE: Visual Studio, SQL Server Management Studio

Reporting Tools: Crystal Reports XI, Crystal Enterprise 9.0,JReports, SSRS

Tools: TFS, ServiceNOW, Clear Case, Quality Center, Multilizer, Visio 2010, MS Office (Word, Excel)

O/SYSTEMS: MS Windows, UNIX, MS DOS

Internet: HTML, XML, CSS, PHP, JavaScript, VBScript, ASP, IIS, ColdFusion, CGI.

PROFESSIONAL EXPERIENCE:

Confidential . Princeton,NJ

Sr. IT Developer / Analyst

Responsibilities:

• Played a key role in teh Application Production Support, addressing issues across many functional areas and resolving problems quickly and accurately.
• Extensively worked on VB.Net, C#.Net, ASP.NET, SSIS, SSRS, SSAS and Excel VBA.
• Designed and built Risk Dashboard, internal web based portal by using ASP.NET.
• Built various WinForms, console based, VSTO based applications and web services using VS.NET.
• Worked on CurveFeeds application; an in-house built .NET solution which acquires forward market prices for power, fuel and emissions from external sources and shape any missing price curves.
• Worked on replacing provider from LIM wif Globalview for pulling forward prices in Curvefeed application.
• Automated several regions for deals confirmation process.
• Supported and made several enhancements to VSTO excel based Price Template application.
• Used Service NOW for tracking application modify requests.
• Worked wif Control-M to setup new jobs and request manual running of jobs.
• Experienced wif developing Complex SQL and T-SQL queries, Stored Procedures, functions, CTE (Common Table Expressions) and designing SQL table/index structures.
• Expert in loading teh data from various source systems into data marts.
• Experienced in designing FACT tables and Dimension modelling
• Proficient in Data warehousing and dimensional and data modeling (t able/index structures).
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units.
• Created calculated measures in a cube by using MDX scripting; implemented Cube Security.
• Proficient in designing reports using SSRS and deploying them to reports server and scheduled them using subscriptions and other scheduling tools like Control M.

Environment: VB.Net, ASP.Net, C#, SQL Server 2016/2012/2008 R2, Excel VSTO, Java Script, WCF, SSIS, SSRS, SSAS, HTML,XML, Visual Studio, Visio, ALIGNE,.TFS, Control M, SharePoint.

Confidential, NY

Sr. Application Developer

Responsibilities:

• Created teh Procedures, Functions, Triggers, Views, Primary key, Foreign key and Import/Export master data scripts using teh SQL Server management studio 2008.
• Developed teh WCF services using Entity framework 4.0 and generated entities for SQL Server tables, views and stored procedures.
• Created SSIS packages to import teh summons from other sources and sync teh database.
• Implemented teh SharePoint 2010 Timer jobs to convert settlement offer to summons, stipulation to multiple summons and directive to summons.
• Created and configured different Sites and Sub-sites for different modules using SharePoint 2010.
• Used HTML for design teh user interface and JavaScript/JQuery for front-end validations
• Developed several custom web parts.

Environment:SharePoint 2010, SharePoint Designer 2010, InfoPath 2010, C# 4.0, SQL Server 2008, WCF, JavaScript, HTML, XML, XSLT, AJAX, JQuery, Entity Framework 4.0, Word Automation Services, Office 2010, LINQ, SSIS.

Confidential, NJ

Sr. Application Developer

Responsibilities:

• Worked on adding new features and fixing teh existing issues in AIR/AIQ web applications.
• Worked on supporting Audiolog related tools and applications. If their is a code fix then worked on fixing teh code and delivering it as a hot fix to teh customer.
• Worked on creating new reports by using Crystal Reports and integrated teh reports into AIQ web application.
• Used sub reports, bar & line graphs, cross tab & created several formulas in Crystal reports.
• Used Logmein/Gotomeeting sites for connecting to teh client machines for troubleshooting teh issues.
• Designed and developed user interfaces on web forms using ASP.NET/VB.NET.
• Developed various stored procedures, Triggers for data processing & selection.
• Designed & developed Win forms using VB.net and C#.Net.
• Created and used several COM components across all Audiolog components.
• By using Multilizer worked on localizing teh user interface and messages. Used Quality center for defect tracking and fixed teh issues accordingly and performed integration testing.
• Used VM ware virtual machines for running teh Audiolog in different OS’s and different versions of Audiolog.

Environment:Visual Studio.NET, ASP.Net, VB.Net, C#.Net, VSS, Clear Case, VB6, SQL Server 2008, SSIS, JavaScript, HTML, CSS, Crystal Reports, Quality Center, Multilizer, VM Ware, Safenet Sentinel.