We provide IT Staff Augmentation Services!

Business Intelligence Resume

5.00/5 (Submit Your Rating)

New York, NY

PROFESSIONAL SUMMARY

  • 10+ years of experience in application design, development and maintenance under Windows/Web environment, Client-server and N-tier using Microsoft Technologies.
  • Over 7 years of Comprehensive experience in .Net Environment using C#, ASP.NET, ADO.NET, Framework 4.0 Visual Studio.Net, Web Services, Window Services, WCF and WPF.
  • Exhaustive experience in MS SQL Server, Oracle, AJAX, COM/DCOM, IIS, TOAD, Crystal Reports and SSRS (SQL Server Reporting Services).
  • Extensive Experience in complete Software Development Life Cycle (SDLC), RAD/JAD and AGILE methodologies.
  • Well versed with Object Oriented Analysis and Design, Client/Server architecture, relational databases and writing business logic both at front-end and at back-end.
  • Expertise in implementing Multithreaded Windows VSTO applications, developed Internet based applications and Enterprise class systems, using Windows DNA based N-Tier web methodologies.
  • Experienced with XML related technologies such as XML, XSL, XSLT.
  • Expertise in databases like Oracle 10G, SQL Server 2005/2008.
  • Involved in developing client server reports using reporting tools like SSRS 05 and 08.
  • Very Strong in backend programming, SQL Server Jobs, XML Enabled SQL, Transact-SQL, MDX and Oracle PL/SQL.
  • Excellent analytical, problem solving. Communication and interpersonal skills with high level of adaptability.

TECHNICAL EXPERTISE

Operating Systems:Windows 9x/NT/2000 /XP/2003/7, Unix

Programming Languages:C#, VB.Net

Web Technologies:HTML, DHTML, ASP, ASP.NET, XML, XSL, XSD, CSS, Web Services, UDDI, SOAP, WSDL, AJAX, VBScript JavaScript, SharePoint 2007

Software:Visual Studio 2008/2010, MS SQL Server Management Studio

Technology:.Net Framework 4.0, WPF, WinForms, WCF, WP, LINQ, MS runtime scripting, COM and COM+

Source Control:Visual Source Safe, TFS, Star Team and Tortoise

Databases:MS SQL Server 2000/2005/2008, Oracle 8.0/9i/10G and Sybase

Database Connectivity:ADO.NET, ADO, RDO, DAO, ODBC and OLEDB

Tools:TOAD, VSS, JIRA and Microsoft Visio 2003/2007

GUI:DevExpress 10.1/11.1, Infragistics 9.1/10.1/11.1

Web server:IIS 4.0/5.0/6.0/7.0

Methodologies:Unified Modeling Language (UML) and SCRUM methodology

Reporting Tools:Reporting Services (SSRS), Crystal Reports 4.6/8.0

EDUCATIONAL QUALIFICATIONS:

  • Master in Computers, Confidential University.

CERTIFICATIONS:

  • Certified Technology Specialist (MCTS): (70-511) Windows Application Development .net Framework 4.0.

PROFESSIONAL EXPERIENCE:

Client: Confidential, New York, NY Sep 2009 – Present

Project: Risk Management Reporting 
Part of the team to develop a Hybrid VSTO reporting solution using .NET technology. The principal idea is provide the user with the flexibility of creating the reports based on his own Building blocks that were created on the Pivot data and create report templates with appropriate Business Hierarchy (Equity/FICC etc) where templates can be scheduled/Run to produce desired reports. 
This is a Business Intelligence Solution for Risk Reports like Equity and Derivatives which have numerous reports running on cube and Oracle.
Responsibilities:

  • Coded required classes and GUI code as required using C#.
  • Developed MDX queries that are required by the reports.
  • Developed Oracle Stored Procedures/ SQL queries as necessary.
  • Developed and deployed SSRS reports.
  • Coded for Middleware application.
  • Participated in testing and bug fixing during QA.

Environment: Visual Studio 2010, DevEx, SSRS 2008, .Net 4.0, C#, SQL Server 2008, TFS and WPF.

Client: Confidential, Morristown , NJ Feb 2009 – Aug 2009

Project: Risk Reporting
A Portal in SharePoint, an integrated solution provided to MetLife. This site contains various Sub sites among which Investments is one of the site where my time has been spent during my tenure in this project, this has a Business Intelligence Solution with integrated SSRS reports, this contains various Reports and a Dashboard to show investment related gauges like Portfolio positions, Roll Forward, Activity and Credit Rating. These gauges are interactive which provide the detail drill thru various levels. There are several reports which show various levels of hierarchies and provide drill thru to the detail level report. 
Responsibilities:

  • Involved in gathering Business Requirements.
  • Developed store procedures and functions as necessary.
  • Designed and developed SSRS reports.
  • Deployed SSRS reports to SharePoint site.
  • Participated in testing and performance tuning of the reports.
  • Modifications and bug fixing during QA, and responding to the required ad hoc changes.

Environment: Visual Studio 2008, SSRS 2008, .Net 3.5, C#, JavaScript, SharePoint 2007, SQL Server 2008, Star team and TFS.

Client: Confidential, Secaucus, NJ Sep 2007 – Jan 2009

Project: WIN
WIN (Workflow Integration Network) is a web based application related to Confidential (Financial Print Company) internal workflow which comprises of various modules like Customer service, Pricing, Sales, Distribution, and Shipping. WIN stores Confidential\'s jobs related to Financial printing which pass through various stages of workflow like Customer Service, Pricing, Distribution, Shipping etc. Customer Service Module accepts jobs and creates work orders, once a job is created and processed it passes to pricing module where the job is invoiced and upon completion.
Responsibilities:

  • Involved in gathering Business Requirements.
  • Worked in developing customized controls in C# ASP .Net 2.0 used in WIN application.
  • Worked on presentation layer in developing UI using Web Forms and customized exception handling.
  • Developed Business Layer for Win using WCF (.Net 3.0 Framework.)
  • Involved in Deploying application in web server (IIS).
  • Worked on Data Access layers and Dot Net Components for database access with ADO.NET.
  • Involved in developing Web Services for integrating with other applications.
  • Involved in writing Stored Procedures in Oracle 10G for business logic.
  • Involved in developing reports using SQL Server Reporting Services.
  • Preparing design docs, test plans, release notes, requirements reviews.
  • Debugging and troubleshooting application.

Environment: .Net 3.0, WCF, ASP.Net , C#, ADO.NET, Infragistics, SQL Server , Oracle PL/SQL, IIS 5.0, JavaScript, CSS, MS Visio, SSRS and TFS.

Client: CONFIDENTIAL, Warren, NJ Jul 2005 – Sep 2007

Project: MYSTIC
Converting existing classic ASP applications to .Net, applications include BCS (Budgetary Control System), MYGTS (Global Transaction System) MYSTIC (Web Publishing Tool), SQAw(Software Quality Analysts Workspace) and EMS(Executive Management System). Re-designed GUI part, re-wrote the business logic and Data logic layers, database objects optimization, have re-wrote Sql-Server stored procs to Oracle PL/SQL for some applications. Interacted with the business users during the process of enhancements. Worked with a big team of testers who helped in successful deployment of the applications. Production Support for the Application called PLANVIEW down the line.
Responsibilities:

  • Business process reengineering with help of UML.
  • Redesigned class and component documents.
  • Coded existing Classes and Interfaces using VB.NET.
  • Created User Controls for existing Web forms.
  • Coded for Excel reporting.
  • Enhancements for User Interface for ASP.NET Web forms.
  • Created and modified Stored Procedures in SQL Server.

Environment: .Net 2.0, 1.x, ASP.Net , VB.NET, ADO.NET, SQL Server, Oracle PL/SQL, IIS 5.0, JavaScript, CSS, MS Visio, VSS, PVCS.

Client: Confidential, Boston, MA Mar 2005 – Jul 2005

Project: RIS(Resident Info System)
This application is a conversion of intranet to extranet application. It was in Oracle forms which DOR (Department of Revenue) wants to make it internet application. This application deals assessment of residential types in 351 towns of Boston. This assessment is done on closing of every Fiscal Year, since it is a once a year process user will have to load data in Bulk (the no. of records may be in thousands) to the Database. For this bulk uploading users having data in Excel sheets which they upload to the database through the web interface.Responsibilities:

  • Designed Sequence diagrams in UML.
  • Designing the user interface according the specifications.
  • Designed and Coded Bulk Uploading screen and single record uploading screen.
  • Created User Controls to solve the purpose of both kinds of loadings.
  • Developed Business Logic Layer using C#.
  • Coding the data tier with necessary DML operations using C#.
  • Coded User Interface using C#.
  • Created stored procedures in Oracle using TOAD.
  • Created several Stored Procedures used Ref cursors where ever application demands.

Environment: ASP.Net, C#, ADO.NET, Oracle 9i, TOAD, Crystal Reports, IIS 5.0, JavaScript, CSS, MS Visio, VSS.

Client: Confidential, Seattle, WA Apr 2004 – Feb 2005

Project: Entellium
Enhanced CRM module like sales force which has been developed in ASP.Net and been used by several customers, eSalesforce deals with Lead Management, Contact Management, Opportunity Management, Activity tracking and Activity sets, Quotation Management, Pipeline Management, Forecasting and best visual interactive reports. eSalesForce keeps reps productive from the road with Voice Update, the easiest offline client in the business.
Responsibilities:

  • Leaded a team of 4 programmers.
  • Designed documents for OOAD using UML.
  • Implemented Proof of Concept (POC) methodology.
  • Designing the user interface according the specifications.
  • Extensively participated in coding the business tier.
  • Developed XML Web Services for Data Access Layer.
  • Created stored procedures in SQL Server.
  • Designed reports using Crystal Reports in Visual Studio.

Environment:ASP.NET, VB.Net, ADO.NET, Visual Studio.NET, Crystal Reports, Windows 2000 Server, MS SQL Server 2000, XML/XSLT, IIS 4.0,Visual Source Safe, MS Visio, COM+, VB Scripts, JavaScript.

Client: Confidential, New York, NY Aug 2003 – Mar 2004

Confidential, New York, (Residential Funding Corporation) is part of General Motors Family.

Project: RFC
RFC provides capital and liquidity solutions for residential real estate finance markets. This application takes Facility, Collateral and Amortization information for a deal and calculates risk rate. Based on the rating business executives in Commercial Finance division take decision to finalize the deal or not. This application is developed using CSLA (Component Based, Scalable Logical Architecture).NET frame work.
Responsibilities:

  • Learning and implementing risk rating methodology.
  • Participated in identifying and resolving different kind of production issues in existing application.
  • Developed and tested Risk Rating business logic using C#.
  • Developed user interface using ASP.NET.
  • Designing the user interface according the specifications.
  • User interface coding with C# including user controls.
  • Coding the business tier with C#.
  • Created reports using Crystal Reports.

Environment:ASP.NET, C#, ADO.NET, Visual Studio.NET, Crystal Reports, Windows 2000 Server, Oracle 8.0, XML/XSLT, IIS 4.0,Visual Source Safe, MS Visio, VB Scripts, JavaScript.

Client: Confidential, Detroit, MI Apr 2001 – Jul 2003


Project: ConfidentialCMS (Confidential Cash Management System)
CONFIDENTIAL is a business intelligence solution to optimize the cash flow of the ATMs, predicting the with-drawl amounts and amounts to be stacked in the ATMs Cartridges with the help of intelligent Forecasting system. CONFIDENTIAL is tightly integrated solution for small to mid-sized banks. The solution was designed in ASP where was migrated to ASP.Net in order to increase the performance and for supporting the concurrent users. 
Responsibilities:

  • Separation of client side code from server side code.
  • Created business tier after separation of in page coding.
  • Created stored procedures in SQL Server.
  • Designed and created reports using Crystal Reports.
  • Participated in user training.
  • Participated in user acceptance test.

Environment:ASP.NET, VB.Net, ADO.NET, ASP, Visual Studio.NET, Crystal Reports, Windows 2000 Server, MS SQL Server 2000, XML/XSLT, IIS 4.0, Visual Source Safe, MS Visio, COM+, VB Scripts, JavaScript.

We'd love your feedback!