PROFILE SUMMARY

• 13 years of IT experienceencompassingawiderangeofskillset, rolesandindustryverticals.
• 8+ years of experience in Application Development using variousMicrosoft technologies.
• Excellent analytical, problem solving, decision - making and translating business requirements to technical requirements and architecture.
• Strong database skills, Object Oriented Programming and development noledge
• Has experience in Analysis, Application design, Database design, coding and testing.
• Extensive experience in developing .Net (web and windows) applications using VB, C#, ADO.NET, WCF, WPF, LINQ to collections.
• LINQ data classes, T-SQL, JQuery, Ajax, XML, JSON, MVC/MVC4 Mobile App and Entity Framework.
• 4+ years of experience in Microsoft Business intelligence
• Expertise in SSAS Cube development, deployment, partitioning and security implementation
• Extensive experience with OLTP data hub design from various data sources using DTS & SSIS.
• Experience with SQL profiler and tuning adviser.
• Expertise in MSBI stack including SSAS (MDX), SSIS and SSRS
• Followed data warehouse designing rules using Kimball methodologies. Expertise in star schema and snowflake design methodologies for cube.
• Experience in building reports and dashboards using SharePoint Data visualization tools.
• Proficiency in building and deploying SSIS packages.
• 1+ years in Configuration Management Automation
• Has good experience in writing scripts for source control, file system, build & deployment.
• Expertise in Software Configuration Management automation process.
• Has experience in defining teh configuration process (Repository structure, build, packaging, staging, deployment and branch merging process)
• Strong skills in working with version controlling tools using SVN, VSS, ClearCase and Harvest.
• Experience in leading and managing teams. Handled multiple roles - Developer, Project Lead, DBA and Configuration Manager.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Developed automation tools and customized business components
• Ability to learn new technologies and challenging concepts quickly and implement them.

TECHNICAL SKILLS

Programming Languages: C++, VB6, VB/C#.Net, ADO.Net, SQL, T-SQL, LINQ to SQL Classes, MDX, vba, vbScript, JavaScript, worldml, MVC/MVC4 Mobile App, Entity Framework

Web Technologies: HTML, ASP.NET, Ajax, WCF, WebServices, CSS, JavaScript, JSON, JQuery, Infragistics

Frameworks: .Net 1.1, 2.0, 3.5, 4.0 (Visual Studio 2003/2005/2008/2010)

RDBMS: Oracle 8i/9i, SQL Server 2000/2005/2008, MS Access and DB2

Operating Systems: Windows NT/2000/2003/2008 Server, XP

Business Intelligence: DTS (SQL Server 2000), SSAS, SSIS & SSRS (SQL Server 2008)

Configuration Tools: MS VSS, SVN, ClearCase, Harvest, Build Forge, CruiseControl & Task Atomizer

Other Tools: Visio, NUnit, CA Wily, MPP, HP QC, HP SC, ARGO, Confidential ’s QMS, and RPM

PROFESSIONAL EXPERIENCE

.Net Tech Lead

Confidential

Responsibilities:

• Analysing various Projects in ChannelLink workstream and providing teh automation solutions to teh projects using latest technology.
• Designed automation solution to teh configuration process using .Net 4.0 winforms.
• Designed and developed framework pages, scripts using CSS, JavaScript and JSON for Teller application.
• Used JQuery to make it easier to navigate a document, select DOM elements, handle events, and develop Ajax applications.
• Analysed exiting ASP.net project files and identified teh unused code files in teh project.
• Involved in designing teh MVC4 Mobile app for application health check.
• Implemented Ajax components to get teh latest status of teh tasks without refreshing teh page.
• Responsible for environment setup (installation, database setup, IIS setup, and COM+)
• Writing automation scripts for configuration tasks (Build, Package, Staging, Deployment and validation)

Technology Used: VS 2010, C#.Net, Batch/Ant scripts, BC scripts, Harvest, Ajax, JavaScript, JQuery, JSON, MVC4, SQL Server 2005/2008/Compact.

MSBI Lead/.Net

Confidential

Responsibilities:

• Analysing data warehouse requirements and designing teh data model (data hub) from various source databases.
• Creating mapping document between source databases and data hub.
• Reviewing teh design with DBA and receiving teh approval.
• Created stored procedures and user defined functions to sync teh columns data with other sources.
• Developed SSIS packages to transport teh data to Data Hub.
• Design and development of data marts (cubes) for reporting groups using MS SSAS.
• Responsible for managing scope, planning, tracking, change control, aspects of teh data hub project.
• Responsible for effective communication between teh data warehouse team and teh application team(s), Provide day to day direction to teh data warehouse team and regular project status to teh customer.
• Writing stored procedures, functions for teh application.
• Establish Quality Procedure for teh team and continuously monitor and audit to ensure team meets quality goals.
• Configuring teh SSRS and excel reports in SharePoint site

Technology Used: VS 2008/2010, C#.Net, SQL Server 2005/2008, DB2, SSAS, SSIS, SSRS with SharePoint and MS Visio

Tech Lead

Confidential

Responsibilities:

• Responsible for Analysis, design, development, Quality review, coding, testing and implementation of new/upgrades solutions for SunTrust Bank
• Work with Business Analyst in translating Requirements Document to Technical Design Documents
• Created .Net assemblies and command tools to simplify teh development process.
• Designing PDF report templates
• Developed DTS packages for protegent datamart (hub).
• Created automation tools for unit testing.
• Designed and developed pdf print spooler component to automatically generate and print teh pdf files on teh network.
• Designed and documented project management tool for Client and Confidential process

Technology Used: VS 2005, C#.Net, ASP.Net, SQL Server 2000/2005, DTS, JavaScript, Adobe Life Cycle, Harvest

Senior Programmer

Confidential

Responsibilities:

• Responsible for Analysis, design, development and implementation of customized Application for new Implementations and upgrades
• Worked as a VSS Configuration Management Coordinator to provide teh required access for new team members, writing build scripts, supporting build issues.
• Preparation of High Level Design, Low Level Design specification.
• Involved in Forms design, coding and unit testing
• Involved in SQL Server DBA activities like Updating statistics, Rebuilding Indexes, Backup & etc…
• Work with QA to create test scripts and scenarios, defect analysis and bug fixing for enhancements to teh core product
• Worked at client location (UK) for 6 months
• Designed and Implemented own Structured Query Language

Technology Used: VS 2003, C#.Net, VB.Net, SQL Server 2000

Senior Programmer

Confidential

Responsibilities:

• As a Senior Developer, I am responsible for Requirement Analysis, Preparation of Technical Design and Development.
• Writing stored procedures, functions, triggers for teh application.
• Analyzing migration issues with existing VB6 product
• Upgrading vb6 project to vb.Net projects.
• Written .net classes to support teh unmanaged code components.
• Designed abstract classes to support teh Indian Insurance Rules
• Involving in code review of teh team members

Technology Used: Windows, C#.Net, VB.Net, ASP.Net, VSS, Oracle 9i.

Senior Programmer

Confidential

Responsibilities:

• As a Senior Developer, I involved in requirements Gathering, analysis, Team Coordination, Task monitoring, Technical design, Database Design and Coding.
• Developed Data Access layer using ADO.Net.
• Created stored procedures and user defined functions.
• Performed DBA tasks (backup, troubleshoot, restore, access rights grant/revoke)
• Creating store procedures, triggers and views.
• Developed accounts modules customizable components.
• Writing stored procedures, functions, triggers for teh application with MS SQL Server 2000.
• Involving in unit testing of teh application.

Technology Used: Windows with c#.net & vb.net, ADO.Net, SQL Server 2000, and VSS

Developer/Sr.Developer

Confidential

Responsibilities:

• As a developer, I involved in requirements Gathering, analysis, Team Coordination, Task monitoring,
• Technical design, Database Design and Coding.
• Completed 6 months training course with different technologies like vb6, asp, oracle & etc..
• Designed custom business components.
• Developed customized solutions for banking reports
• Developed PL/SQL stored procedures and views
• Involved in writing unit test cases.
• Created parameter module project to change teh existing applications behavior without changing teh code.
• Developed Dynamic Reporting Tool to support teh end user requirements.

Technology Used: Windows with vb6, Web with asp, Oracle, and VSS