SUMMARY:

• Microsoft .NET & ITIL Certified Professional with management skills having extensive experience in Software analysis and Development, Data warehouse and Business intelligence
• Around 12 years of IT experience in System Analysis, Design, Development and Implementation of various enterprise e - business solutions and n-tier architectures for various business domain like Banking, Energy, Public service, Ecommerce, Manufacturing, Healthcare
• Experience in N-Tier Distributed architectures, Client-Server, Object-Oriented and Service oriented architecture styles
• Creating document using appropriate graphical & textual techniques, including use cases, diagrams, process models, wireframes, functional and technical specifications
• Making logical design of the system with the technical team, including screen design and specifications, data modeling, and documentation of logical processing flows
• Experience in Data warehouse architect, development, testing, implementation and support of enterprise data warehouse
• Using Kimball Data Warehouse Methodologies in data modelling
• Experienced in development of ETL mapping and scripts
• Experience in large-scale integration projects using WCF/Web services, database and file exchange
• Team leadership experience in large scale implementations
• In-depth knowledge and experience in software design methodologies, software design patterns and object oriented design.
• Experience with Service Oriented Architecture (SOA). Experience in developing Web API / WCF / Web Services
• Experience in Traditional & Agile Software Development Methodologies
• Project management experience including planning, execution, monitoring and closure
• Worked with pre-sales team on new project proposals
• Experience in stakeholder management (client, vendor, onsite-offshore and multiple internal teams)
• Expertise in managing projects in Confidential and Onsite/Offshore delivery model
• Experienced in MS SQL-Server 2005/2008/2012 (T-SQL) Database design, Development, Data modeling in data warehouse, writing queries, Constraints (Domain and Entity), Indexes (Clustered and Non-Clustered), Views, Stored Procedures, Extended Stored Procedures, LINQ to SQL, SSIS Packages, Cursors, Triggers, User Defined Functions, Migration from MS-Access.
• Expertise in analysis of current Business Practices and Analysis of current IT Systems and Procedures and Documentation of workflow and Business Process Reengineering
• Ability to handle projects as t eam player and an individual contributor with steep learning curve and in on application architecture design, assist in developing project plans, and good interpersonal skills.
• Good knowledge of ITIL processes.
• Effective communicator adept in delivering superior customer service and bridging the business and technical communities
• Very Good in Team work

TECHNICAL SKILLS:

BI / Data Warehouse: - WhereScape Red 6.2, Tableau 9.x, Qlik Sense 2.2, SSIS, SSRS, SSAS

.NET: - Framework 2.0/3.0/3.5 / 4.0, WPF, WCF, Web API 2.0,XAML, ADO.NET, Win Forms

Frameworks: - Entity, MVC 3,4,5, IBatis, Dot Net 4.0

Languages: - C, C++, C#.Net (4.5/4.0/3.5/3.0 ), VB.NET (10.0/9.0/8.0 ), HTML, Unix Shell Programming

Modeling Methodology: - UML, Rational Unified Process (RUP), MS Visio 2010/2007

Web: - XML, XSLT, XSD, ASP.NET 4.5/ 4.0/3.5/3.0/2.0, HTML, JSP, HTML, CSS, ASP.Net, IIS, HTML, DHTML, SOAP, AJAX, WPF, Silver Light (4.0/3.0), VB Script, JavaScript, AJAX, JQuery, Bootstrap, OBOUT & Telerik controls.

Middleware: - WCF, ADO.NET 4.0/3.5/3.0/2.0, MSMQ, Web Services, Enterprise Library 5.0/4.0/3.1

Database: - ORACLE 11i, SQL Server 2012/2008/2005/2000, MS Access, LINQ, Stored Procedures, triggers, ADO.Net, SSIS Packages.

Operating Systems: - UNIX Sun Solaris, Red hat Linux, Windows 95/98/2000/7/8, DOS

Tools: - MS Office 2016, Visual Studio, SharePoint 2013, NUnit, Crystal reports

PROFESSIONAL EXPERIENCE:

Confidential

Tech Lead Analyst

Technologies: C#.NET 4.0, LINQ, SSIS, SSRS, Visual Studio, MVC 4.0, ASP.NET, Web API 2.0, XML, SQL 2012, IBatis, TFS, PDFLib, Issue Net, ITSM, Remedy, RUP

Responsibilities:

• Developing / Modifying the existing application in 3-Tier architecture like Business Layer and Data Layer
• Followed the Agile programming methodology throughout the entire project life cycle
• Followed the SCRUM Methodology for small progressive iteration development
• Analysis of the programs in the existing system
• Responsible for creating unit, integration, system and user acceptance test plans
• Involved in reviewing the test cases with the testing coordinators and performing the quality checks
• Responsible for documenting the defects and assigning the defects to the responsible people
• Was also involved in tracking the status of the defects on a day to day basis to provide an update to the testing coordinator and the project manager.
• Preparing technical documents
• Using the various XML schemas for the interfacing data requirements of the application for transferring information between different teams
• Creating database objects and modifying them in sql server.
• Performing program modifications and enhancements with minimal direction
• Providing impact analysis of proposed business changes on the application, in terms of development effort and processing time.
• Making business documents like use case scenarios, models, conceptual design diagrams, and user stories to support iterative development
• Designing, developing and coding for old or new projects in .Net technologies like Confidential (Alberta Mineral Information System), LAMAS, MOGIS, CARS, Foundation, ETS on various issues.
• Performed Annual Disaster Recovery tests and compiled the results for various projects for analysis.
• Facilitating requirement meeting for proposed changes with business users
• Performing detailed analysis of proposed application changes
• Providing solution to problems arising in the production version of the application

Confidential

Data warehouse Tech Lead

Responsibilities:

• Analyze the requirement analysis done for the project.
• Using Kimbell methodologies to design data warehouse DWH and different data marts to support dashboard
• Using WhereScape Red to create data warehouse
• Develop the data models to support the data warehouse
• Designing data marts
• Developed Stored Procedures and SSIS packages to import data from third party solutions to internal data warehouse
• Created Unit Test cases for various package and test them.
• Implemented CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data
• Setting security for data warehouse
• Developing ETL processes
• Coordinating in testing and implementing the project in 3 phase

Confidential

Qlik Sense Tech Lead / Administrator

Technologies: Qlik Sense 2.0, C#.NET 4.0, LINQ, Visual Studio, SSIS, SSAS, SSRS, XML, SQL 2012, and TFS

Responsibilities:

• Analyze the requirement analysis done for the project.
• Develop the data models to support the Qlik Sense Interfaces.
• Developed Stored Procedures and SSIS packages to import data from third party solutions to internal data warehouse
• Designing the QVDs for the Qlik Sense
• Developing the graphical objects for the users in Qlik Sense
• Setting security for QVDs
• Managing QlikSense QMC experience including installation and upgrades of the Qlik Product
• Managing QlikSense deployments from QA, UAT and Production
• Modifying and and maintaining of QMC Security rules and Load Balancing rules
• Administrating QlikSense multi node environment
• Coordinating in testing and implementing the project in 3 phase
• Creating rules and managing virtualization Streams.
• Managing with QlikSense Confidential and License monitors.

Confidential, Minneapolis

Computer Systems Analyst

Technologies: C#.NET 4.5, MVC 4.0, LINQ, Visual Studio, JQuery, XML, Telerik, SQL 2012, Web API, CSS and TFS

Responsibilities:

• Analyzing, designing and developing the web application in 3-Tier architecture.
• Designed the ETL processes and procedures
• Developed Stored Procedures and SSIS packages
• Created Unit Test cases for various package and test them.
• Implementing CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data
• Coordinating with other developers

Confidential

Computer Systems Analyst

Technologies: C#.NET 4.5, MVC 4.0, SSIS, LINQ, Visual Studio, XML, SQL 2012, TFS, SSRSResponsibilities:

• Analyzing the requirement and designing the requirements for Data movement between different entities
• Developed Stored Procedures and SSIS packages
• Created Unit Test cases for various package and test them.
• Assisting other developers

Confidential, Minneapolis

Systems Analyst

Technologies: C#.NET 4.5, MVC, LINQ, Visual Studio, JQuery, XML, SQL 2012, ASP.NET, Web API, MVC, AJAX, WCF, WPF, TFS, SSRS, Issue Net, ITSM

Responsibilities:

• Designing the business requirements for HPA and translating them to technical documents.
• Making use cases, diagrams, process models, wireframes, functional and technical specifications.
• Using Entity Framework
• Creating Unit Test cases for various waterfalls and test them.

Confidential

Designer, Developer

Technologies: C#, ASP.NET, WCF, JavaScript, SQL 2008, SSIS, SSRS, LINQ, XML, AJAX, HTML, TFS, Crystal Reports

Responsibilities:

• Design, Construction & Maintenance of various modules, reports, forms in the existing system
• Designed and implemented a front end using ASP.NET and C# & VB.NET using Visual Studio 2010/2008 Framework. Involved the usage of ASP.NET to display data from the backend SQL Server Database
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Responsible for setting and execution of Service Oriented Application systems by following standard testing methodologies
• Developed and consumed Web Services in C# used for authentication of user.
• Incident and Problem management
• Detail Design Documentation for the processes and development for any changes in the existing system.
• Preparing Task Work Plan, System Enhancement, Client Management, Technical Documentation, providing direction and implementing Application Design changes, Data Preparation & Migration
• Creating and modifying database objects in sql server.
• Developing and executing test cases and scenarios and documenting expected and actual outcomes.
• Designing the various XML schemas for the interfacing data requirements of the application
• Performing all the possible enhancements and performance analysis

Confidential

Designer, Developer and Administrator

Technologies: ASP.NE, LINQ, VB.Net, Java Script, Silverlight, XML, Sharepoint 2010, SQL 2008, AJAX, Entity Framework, HTML,Crystal reports, TFS, NUnit, SSIS, SSRS, Web API

Responsibilities:

• Involved in requirements gathering, system analysis, design and development of a custom 3-tier web based system for an validation of sponsorship debt system using ASP.NET, C#, VB.NET, SQL Server, XML, JQuery, JavaScript, XSLT, XPATH.
• Coding for the e-VOSD Web Front End & e-VOSD Data Loader
• Responsible in full development life-cycle using Object Oriented Programming (OOPS) concepts. Project plan is done in Microsoft Project Professional 2010.
• Designed and implemented a front end using ASP.NET and C# $ VB.NET using Visual Studio 2010/2008 Framework. Involved the usage of ASP.NET to display data from the backend SQL Server Database
• Implemented validations using the ASP.NET Validation Controls
• Used SSIS to perform ETL operations for Master Data Management (MDM) needs as well as auditing reasons.
• Extensively Involved in WinForms coding and implementation phase using C#.
• Involved in designing and development of SOA services using Web Services/ WCF. Consumed and exposed WCF services by deploying in IIS.
• Conversion of window based application to Web based Application in .Net
• Design, Construction & Maintenance of input/output Client/Server & Web Interfaces using Menus, Forms
• Analysis of the programs in the existing system
• Preparing technical documents
• Detail Design Document for the Confidential Web Front End & for the Confidential Data Loader
• Creating and modifying database objects in sql server.
• Preparing Task Work Plan, System Enhancement, Client Management, Mentoring, Technical Documentation, Technical Support, Providing Direction and Implementing Application Design changes, Data Preparation & Migration
• Providing production and testing support on rotational basis.
• Developing and executing test cases and scenarios and documenting expected and actual outcomes
• Design, Construction & Maintenance of input/output Client/Server & Web Interfaces
• Designing the various XML schemas for the interfacing data requirements of the application
• Performing all the possible data validations like operations related to checking dates, checking for valid numbers, out of range values etc.
• Designing, developing and coding for old or new projects in .Net technologies like Confidential (electronic Validation of Sponsorship Debt) which was to be converted from windows.net to ASP.Net
• Using knowledge of software development life cycle (SDLC) methodologies, systems analysis, design coding, testing and implementation
• Supporting MECA (Managing enforcement thru Computerized Assistance) by analyzing various problems, upgrade or maintenance of the same

Confidential

Technical Lead, Systems Analyst and Developer

Technologies.: C#, ASP.NET, MVC, SQL 2008, Sharepoint 2010, XML, LINQ, WCF, AJAX, Crystal Reports, TFS, NUnit

Responsibilities:

• Project Planning and Effort Estimation, Structured Systems Analysis & Design, Data Modeling, Process Modeling, Data Migration, Query Performance Tuning, SQL Loader, Functional Specifications and Technical Specifications
• Designed and implemented a front end using ASP.NET and C#.NET that involved the usage of Visual Studio 2005 Framework
• Implemented forms authentication or administration of role based security using Active Directory.
• Played a major role in production of SSIS jobs. Used custom .NET assemblies for Script Task in SSIS.
• Used JavaScript to highlight user selections in the data grid with Dynamic Controls and CSS
• Involved in Web parts development using HTML, XML, XSLT, and classic ASP and create and process XML documents, including using XML Serialization
• Written SQL Queries, Stored Procedures, Triggers, Database restoring, Defining roles, creating users, Assigning Roles to users and relational database design(RDBMS) in SQL Server 2005
• Involved in the development of module using Object Oriented Methodologies like UML.
• Involved in the deployment of the entire application using Microsoft Internet Information Service (IIS). Involved in EDI process of file transfer between clients
• Extensively involved in creating the Ajax components fo r multiple updates in datagrids. Used other AJAX library such as Update Panel and Model Popup Extender within some web pages.
• Performed Unit testing by using Nunit 2.4 Beta1 version and performance tuning of the application by populating and creating indexes in the database.
• Extensively Involved in WinForms coding and implementation phase using C#.
• Extensively involved in .Net exception handling management, debugging, user controls in GUI.
• Prepared project plan using Microsoft Project Plan 2003 and Function Point Analysis
• Involved in designing and documentation of flows and functional diagrams using Visio 2003
• Responsible for configuration management (Configuring the Project in VSS, Taking VSS backup)
• Done unit testing, integration testing and regression testing.
• Implementing DB issues with regards to Server & Application Tuning and Session Management.
• Extensively involved in creating the Ajax for making smaller, faster and user friendly web-page application.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using Crystal reports.
• LINQ technology was used for all database queries. LINQ to SQL and LINQ to XML
• Followed the extreme/agile programming methodology throughout the entire project life cycle
• Designed applications using UML - Modeling by applying Object Oriented Analysis and Design (OOAD)
• Involved in Unit testing and Integration Testing for the entire system
• Extensively involved in developing components for Business and Data tier using VB 9.0, ADO.Net
• Extensively involved in the creation of User Controls and reusable components
• Written SQL Queries, Stored Procedures, Triggers, Database restoring, defining roles, creating users, Assigning Roles and relational database design (RDBMS) in Microsoft SQL Server 2008
• Involved in preparation of Cascade Style Sheet (CSS) files
• Involved in Code review phase
• Maintained the version of the project by using module developed with latest version in TFS
• Involved in designing and documentation of flows and functional diagrams using Visio 2010
• Testing of database, queries optimization
• Developed an XML- Web Services using RPC
• Construction and Bug-Fixing Windows Forms, Reports, Menus and Sql Modules
• Providing impact analysis to management of proposed business changes on the application, in terms of development effort and processing time

Confidential

Technical Lead, Systems Analyst and Developer

Technologies: c#, ASP.NET 3.5, MVC, Java Script, HTML, IIS, SQL Server, SSRS, Crystal Reports, TFS

Responsibilities:

• Involved in the design and development of the ASP.NET Web Forms using HTML, JAVA SCRIPT, ASP.NET Server Controls, AJAX Control Toolkit and TELERIK Controls
• Used partial-page update support to a Web page by using Microsoft ASP.NET 2.0 AJAX Extensions server controls: the Script Manager control and the Update Panel control to remove the requirement to refresh the whole page with each post back, which improves the user experience
• Involved in calling WEBSERVICE methods from client side by using AJAX concepts
• Worked on WinForms
• Worked to Retrieve Data from XML File by using XML Reader and DOM methods
• Extensively worked on User Controls to create Widgets used on the Web page and the Widget Settings can be changed by Edit Click by using User controls.
• Involved in database design and developed Complex Queries, Stored procedures and Triggers in SQL Server.
• Worked on Developing Data Access Layer by using C# and OOP Concepts
• Extensively used ADO.NET with the SQL Server Database
• Worked on Application, Session Objects and View State
• Worked with ASP.NET Server Controls, Validation controls and with Data Controls
• Used .NET remoting to transfer data between different
• Prepared Test Plans at Unit level and System level
• Analysis of the existing system and Preparation of analysis and technical specification documents
• Conducted Load Testing and Performance Testing before major website/database updates
• Directions, presentations and Discussions with the Client Technical Authority regarding the Project Architecture, Project Standards, Project Plan and Project Progress
• Structured Systems Analysis & Design, Impact Analysis, Data & Process Modeling, Data Migration, Effort Estimation, Query Performance Tuning, Interface Development, Migration of Users, Privileges and Profiles
• User Requirement Analysis, Impact Analysis, Design, Development, Modification and Performance Tuning of existing application), Warranty Support, Application Support, Project Management, Business Development and Client Management
• Design, Construction & Maintenance of input/output for Client/Server & Web Interfaces using Menus, Forms & Crystal Reports.
• Preparing Task Work Plan, System Enhancement, Client Management, Mentoring, Technical Documentation, Technical Support, Providing Direction and Implementing Application Design changes, Data Preparation & Migration
• Creating and modifying database objects in SQL server.

Confidential

Technical Lead, Systems Analyst and Coding

Technologies: C#, ASP, .NET 3.5, Java Script, HTML, SQL Server, Windows 2000, TFS, Crystal Reports, NUnit

Responsibilities:

• Analysis of the C# program in the existing system and Preparation of analysis and technical specification documents
• Used N-tier architecture for presentation layer, Business and Data Access Layers and were coded using C#
• Developed application logic using C#
• Designed and implemented a front end using ASP.NET and VB.NET & C#.NET.
• Involved in Screen Designing for Prototyping approvals
• Developed Web User Control, which can display Current Date, Current User in uniform way in all Web Forms
• Involved in Developing Business layer using C#.NET
• Extensively Used Grid View, Form View, Detail View Controls with Object Data Source Controls.
• Implemented Master Pages and Tree View Control with Site Map Data Source
• Implemented Data Access Layer in New Manner with Table Adapters
• Involved in writing Stored Procedures using SQL SERVER 2000
• Played a major role in developing SSIS jobs
• Used custom .NET assemblies for Script Task in SSIS
• Created prototype and production-level object-oriented application including design, modeling, coding, and testing
• Developed stored procedures, functions and triggers using PL/SQL in SQL Server
• As a member of the development team, I was responsible for executing the test cases and documenting the test results. Involved in maintenance and production support
• Structured Systems Analysis & Design, Impact Analysis, Data & Process Modeling, Data Migration, Effort Estimation, Query Performance Tuning, Interface Development, Migration of Users, Privileges and Profiles
• Creating and modifying database objects in sql server
• Extensive use of both Forward & Reverse Engineering (E-R Modeling, Server Modeling, Design Editor)
• Directions, Presentations and Discussions with the Client Technical Authority regarding the Project Architecture, Project Standards, Project Plan and Project Progress
• Preparing Task Work Plan, System Enhancement, Project Management, Client Management, Mentoring, Technical Documentation, Technical Support, Providing Direction and Implementing Application Design changes, Data Preparation & Migration

Confidential

Functional Lead, Tech. Lead, Module Lead and Code Developer

Technologies: C#, .NET 2.0, COM, Java Script, ASP, SQL Server, Windows 2000, Crystal Reports

Responsibilities:

• Created and maintained Databases, Table spaces, Data files, Redo Log Files, Alert Log files and Rollback Segments. Conducted Backup and Recovery and also constructed and managed the User Schemas
• Used N-tier architecture for presentation layer, Business and Data Access Layers and were coded using C#
• Developed application logic using C#
• Created prototype and production-level object-oriented application including design, modeling, coding, and testing
• Developed stored procedures, functions and triggers in SQL Server
• Followed Client IT Department’s Proprietary Structured SDLC Standards & Methodology, which was based on ISO Guidelines
• Enhancement (Effort Estimation, Work Plan Preparation, User Requirement Analysis, Impact Analysis, Data & Process Modeling, Development, Modification and Performance Tuning of the existing application), System Integration, System Testing, Application Support, Mentoring, Project Management, Business Development and Client Management
• Extensive use of Web Forms in both Forward & Reverse Engineering (DFD, E-R Modeling, Server Modeling, Design Editor)
• Preparation of Test Plans, Test Data and Test Cases for Unit, Integration, System and User Acceptance Testing
• Preparation and updating Functional and Technical Design Documents and also User Manuals
• Providing impact analysis of code changes on the application, in terms of development effort and processing time

Confidential

Functional Lead, Technical Lead, Code Developer

Technologies: VB, SQL Server 2000, Crystal Reports

Responsibilities:

• Creation of Application Schema, Application Database, Transaction Log, User Privileges, Database Backup, Database Recovery and Database Administration
• Used N-tier architecture for presentation layer, Business and Data Access Layers and were coded using VB.
• Requirement Analysis, SSAD, Data & Process Modeling, Construction, System Integration, Implementation,, Project Plan, Work Estimation and Client Management
• Designing and Coding the front end of the application
• Created prototype and production-level object-oriented application including design, modeling, coding, and testing
• Developed stored procedures, functions and triggers using SQL Server
• As a member of the development team, I was responsible for executing the test cases and documenting the test results.
• Involved in maintenance and production support
• Creating and modifying database objects and Data conversion done in SQL server.
• Providing impact analysis of code changes on the application, in terms of development effort and processing time

Sr. Programmer

Confidential

Technologies: VB, Oracle, Crystal Reports

Responsibilities:

• Analysis of the existing system and Preparation of analysis and technical specification documents
• Coding using VB, ORACLE
• Analysis of the reports generated in Business objects and Preparation of technical specification documents.
• Program Analysis
• Program Specification Document preparation
• Unit Testing

Developer, tester

Technologies: Visual Basic, Oracle, IBM Server, Windows

Responsibilities:

• Coding and modification using VB as front end and Oracle at backend
• Designing and Coding reports for the presentation purposes on a weekly basis.
• Preparation of Test Plans, Test Data and Test Cases for Unit, Integration, System and User Acceptance Testing
• Checking modules functionality