SUMMARY:

• Technical Specialist at Confidential (a Capgemini Company) with 7+ Years of Information Technology experience in the field of software design, development & maintenance
• Good Working knowledge in the Database MSSQL Server, SSIS, SSAS and SSRS.
• BI applications based on MSBI using BIDS 2010/2008 on SQL Server 2012/2008 R2 and Oracle 10G, designing and building SSIS packages and SSRS reports for many projects for addressing business needs
• Windows and web based applications developed on Visual Basic 6.0, .NET 4.0 and SQL Server as back end database, J2EE platform with MySQL and MS Access as the back end databases
• Microsoft Certified Technology Specialist: SQL Server 2008, Business Intelligence and Maintenance, MCP ID# 6538833
• Sun Certified Java Professional - Sun Certified Programmer for the Java 2 Platform, Standard Edition 5.0, since June 2009
• Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research
• Proven flexibility to work on cross platform delivering high quality deliverables on time with full efficiency as independent or as team
• Worked for prestigious client ALTRIA, Black & Veatch and The largest organization of independent financial advisors in the United States
• Proven ability to identify problem, analyze possible solutions and determine best course of action to meet objectives
• Quick Leaner and easily adaptable, good in research and development in any given technology, can module myself from novice to expertise in short time
• A team player and lead with excellent Interpersonal, Communication, and Presentation skills
• Extensively worked in the areas of Business Process Study, Analysis, implementation, customization and Support of Microsoft applications
• Excellent knowledge and experience on .Net, SQL Server, IIS
• Proven experience in leading and development of applications using ASP.NET, C#, HTML, CSS, JavaScripts, JQuery, XML, Entity Framework and MVC
• Working knowledge of AngularJS
• Have H1 VISA extension till Dec 2016 and approved I-140

TECHNICAL SKILLS:

MSBI Integration Services (SSIS) Analysis Services (SSAS) Reporting Services (SSRS) SQL Server (2012,2008 R2,2008,2005,2000) Oracle 10G MySQL 5.0 MS Access .NET 4.0 C# .NET ASP .NET VB.NET Business Intelligence Development Studio (2010,2008) Visual Studio (2012,2010,2008,2005) JDBC, ODBC, ADO.NET, OLEDB UML(Use cases,Class Diagrams, Sequence Diagrams) Data Warehousing MVC SharePoint 2010 Java 5.0 J2EE (JSP 1.2 Servlet 2.2) Struts 1.2 JSP XML 1.1 HTML JavaScript JQuery CSS Ajax Open XML PHP IIS 7.5 Apache Tomcat JBOSS Windows VBA MS Office MS Excel PowerPivot PowerView Eclipse Editplus Notepad ++ Tableau Matlab TFS VSS Domains Worked Finance, Manufacturing, Logistics, Retail and Education

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA, USA

SSIS & SSRS Consultant and SQL Server Programmer, Team Lead

Environment: SSIS, SQL Server, SSRS, BIDS, SSMS, MS Access, VBA, .NET, Oracle 10G, SM9, TFS

Responsibilities:

• Gathering the requirements and analyzing them, for all advisory databases\applications
• Understanding and re-designing Code & Logic in existing MS Access applications and convert them into SQL Server Logic or SSIS or SSRS or Stored Procedures
• Advise design, data and functional changes on Oracle server as per business needs
• Attending daily Stand-up\Scrum calls, identifying daily tasks, addressing\resolving issues
• Co-ordinate with application development team in using the correct tables as per existing business and logic
• Handling release management tasks, like creating RFCs, CCs, CABs, QA & PROD validation, Dev Signoff and obtaining QA & UAT signoff on time and Post Migrations SQL Server performance issues
• ETL architecture design, implementation and leading for data loads back forth from Oracle Server to SQL Server
• Identifying PII data and obfuscating them in Dev and QA environments
• Mentoring\training\assisting non-technical business users in using the new applications\processes
• Re-Designing Launchpad application architecture from SharePoint and MS Access to SQL Server and NET
• Estimating the metrics of the change requests
• Setup the DevOps process for the current project and fellow team’s projects
• Documented how to and the benefits of migrating MS Access to SQL server using SSIS for future teams reference and guidance
• Lead and Co-ordinate Offshore and Onshore Teams
• Interviewed candidates for IGATE\Capgemini
• Created many proposals for IGATE and Client Projects
• Automating Weekly, Monthly and Yearly Status Reports

Confidential

Team Lead, DWBI Analyst, TFS Admin

Environment: SSIS, SQL Server, SSRS, BIDS, SSMS, SharePoint & Dundas, Oracle 10G

Responsibilities:

• Administrating TFS, Configuration Management
• Building of BI solutions for Analytical Reports using SSAS
• Create Functions, Stored Procedures, SQL Queries, User Defined Table Types, Triggers, SQL Agent Jobs, Roles and many more in advanced database programming
• Creating the SSIS packages for importing data from different sources onto SQL Server using MSBI
• Deployment of the application in SIT, UAT and Production environments
• Designing, developing, testing and supporting applications using computer languages and operating systems such as .NET 4.0, SharePoint, Visual Studio, SQL Server, Open XML, Microsoft Office, Windows 7
• Documenting, designing and Mentoring Teams in all phases of SDLC
• Ensure that performance analysis is done using cubes and performance is maintained
• Estimating the metrics of the change requests, projects and proposals
• Identifying the technical and business challenges for different projects and designing the framework in .NET, SharePoint and MSBI technologies
• Implemented Data warehouse, SSAS cubes, SSRS Report, SSIS Packages as ELT between OLTP and DW
• Integrating MSBI with .Net and SharePoint applications
• Leading and coordinating multiple teams like Oracle, PeopleSoft and BizTalk teams for ETL specs and implementations
• Managing users and permissions on various database objects, analysis services and reporting services
• Migrating and upgrading the existing traditional system to higher versions and automating them
• Multilayered Architecture Design of the application using MVC framework and traditional 3 tire
• Providing training the users on the various newly built applications
• Review the applications built on Microsoft technologies
• SharePoint Pages design and development
• Support Dundas Development team in understanding and implementing the business using cubes
• Technical support to Team and Projects involving MSBI, .NET & SharePoint applications

Confidential, Richmond, VA, USA

Developer

Environment: Adobe Lifecycle Designer 8.0, JavaScript, Teradata, Unix, SQL Server

Responsibilities:

• Client Meetings
• Creating and modification of Sales Application reports
• Deployment and production moves
• Design & Development of Adobe forms
• Development & Unit Testing
• Enhancing the application by adding new functionalities
• Involved in testing
• Ownership of complete project as a single resource from offshore
• Query tuning of existing Stored Procedure, optimized the application code for Performance gain
• Requirement Analysis & Design of New Screens
• Requirements gathering
• Training
• Training Users on the new features of the application
• Unit Testing