SUMMARY:

• Senior IT professional with more than 16 years of hands - on experience as “Technical lead” in designing and developing transactional and business intelligence solutions using Microsoft stack and Business Objects based technologies.
• Over 16 years’ experience in designing, developing, implementing and managing applications through all the phases of SDLC using Microsoft Technologies
• Have consistently delivered high quality applications within the allocated time and budget using different Agile methodologies like SCRUM and XP
• Extensive experience in designing and architecting enterprise-wide web applications using C#.Net, SQL Server, WCF, Web Services, Services Oriented Architecture, SSIS, SSRS, XML and XSL
• Managed projects with different industrial verticals (Banking, Financial, Healthcare, Non-Profit etc.) integrating various data sources from flat files to organized data such as SQL Server, Access, Excel and Flat Files using custom C#.Net modules
• Managed and Deployed projects with various configuration management techniques to ensure a high quality product is migrated across development / test and production environments
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2008/2005/2000 (DTS)
• Experienced Data Warehouse modeler with hands-on Business Objects development experience building Star /Snow Flake Schema, Data Models, Universes, retrieving data using Universes, Personal data files, Xcelsius dashboards and creating ad-hoc Reports using the Business Objects Web Intelligence modules
• Experience in Data Analysis, Dimensional Data Modeling, Data Extraction Transformation & Loading (ETL), Creating Metadata layer, End User Reporting, Web based Reporting & Implementation
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Experienced in setting up of Repository, creating, managing users and user groups and implementing Master Data Management (MDM)
• Excellent communicator and leader with reputation for forging strong client relationship, motivating cross-functional teams and mentoring the junior team members to succeed in achieving project goals
• Experienced developer with understanding of needs for process and documentation and has performed various compliance work including SEI CMMI Level 5 Quality Audits and SOX compliance across multiple projects

TECHNICAL SKILLS:

Languages: C#.Net, VB.Net, ASP.Net, XML, UML, SQL, HTML, Dexterity (Great Plains)

Operating Systems: Windows NT/2000, XP, 7.0

Database Environments: SQL Server 2008/2005, MS Access

Design Tools & Methodologies: Rational Rose, Visio, ERWin, Agile Scrum, XP

Developing Environments:: Visual Studio, Team Foundation Server (TFS),Visual Source Safe, Clear Case, CVS, LINQ, Clear Quest, Entity Framework, Object Relationship Mapping (ORM)

ETL & BI / Reporting Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Objects, Crystal Reports

Testing and Bug Tracking Tools: Mercury Test Director, Clear Quest

WORK EXPERIENCE:

Confidential

Senior .Net/ ETL Developer

Responsibilities:

• Working in an aggressive schedule to implement complex functionality within a short period of time
• Following the Agile-Scrum methodology
• Working with latest technologies like SQL Server 2012, VS 2012, MVC, WCF and Linq2SQL.
• Executing the packages by creating jobs and scheduling them in SQL Server to run on specific periods in a specific order
• Mastering the framework Confidential has put in place for executing the jobs
• Working with the business and QA teams to implement the functionality from requirements till deployment and post-production support
• Maintaining the web based portal developed in ASP.Net 4.0 with MVC, Linq2SQL, WCF, Entity Framework, JQuery, Json etc. for entering and managing the data for different tables. The jobs can be executed from the portal itself though it requires some configuration in the backend.

Confidential

Senior ETL Developer

Responsibilities:

• Have been involved from the design to implementation of a new Data Warehouse reporting layer for presenting data from different sources in a unified manner.
• Played a vital role in designing the database.
• Played a vital role in delivering a complex solution in record time.
• Created ETL packages using SSIS for sourcing data from different systems into the reporting layer.
• Mentored the junior team members (developers and testers) during all phases of the project.
• Interacted with business to gather requirements for data transfer and reports.

Tools: and Technologies used: SQL Server 2005, SSIS, Autosys Job scheduling, DOS scripting, Clear Case (version control), Clear Quest (bug tracking), Visio, MS Office suite. iWorks Corporation, Senior Technical Lead .

Confidential

Senior ETL Developer

Responsibilities:

• During the feasibility study phase of the project, analyzed the existing transactional system, worked with key business users to define the various key performance indicators
• Defined and developed requirements for implementing enterprise-wide data warehouse for Confidential .
• Created design documents, ER diagrams and modeled the database schema using SQL Server 2008
• Designed and Developed end-to-end ETL process in SSIS 2008 using custom C#.Net application code, adding necessary controls including error log, audit trail and checkpoints
• As a senior member of the team, guided the other members in understanding the existing transactional system as well as dimensional data warehouse solution
• Facilitated the meeting with the end users to identify potential tables and fields from the transactional database which had to be mapped into the ACRedit Data Warehouse
• Played the lead role in business/ client discussion, pro/con analysis on Data modeling the selected fields into a conformed dimension star schema for the Data Warehouse
• Decided on the server sizing for the Business Objects Edge Series on the corporate servers
• Designed a multiple-star schema universe, used aggregate awareness for lower grain objects, set up facts-based contexts and Derived tables.
• Analyzed the business process of Confidential and identified key reports which could be done in Business Objects
• Designed and maintained 24 Web Intelligence reports which comprised of Management, Organizational, Outcome and Operational reports
• Canned InfoView reports’ prompts were customized to also be scheduled on the first of every month for the previous month
• Trained the client team in Business Objects usage and ad-hoc report generation
• Designed, built and managed Universes, scheduled reports using Broadcast Agent and also involved in the administration part as a CMC/Supervisor in Business Objects.

Confidential , McLean, VA

Senior .Net Developer

Responsibilities:

• Integrated / enhanced and maintained the back-office suite of applications developed in different versions of ASP.Net using SQL Server 2005/ 2000, Web Services, Crystal Reports, SSIS and SSRS.
• Developed new reports for the Cisco Phone System using SSRS and Crystal Reports.
• Worked with the internal clients/ end users for new enhancements to different systems.
• Data from transactional systems were moved to a reporting database using SSIS packages.
• SSRS reports were generated from the reporting database and published to SharePoint server.

Confidential , McLean, VA

Senior Consultant

Responsibilities:

• Designed and developed Domestic Inspection, Export Application and Animal Disposition Reporting modules of the PHIS application.
• Created user controls to be used across various modules in the PHIS application as well as by other applications.
• Worked closely with the architecture team and other development teams to develop reusable components.
• Data was migrated between different databases for development and testing purposes using SSIS packages.
• Worked closely with the QA Lead in successfully triaging the defects
• Utilized Confidential (WCF) and delivered high quality code throughout the project.
• Mentored the junior members of the team on Linq2SQL and WCF components

Confidential , Atlanta, GA

Asst. Project Manager / Technical Lead

Responsibilities:

• Mentored the team on best practices and coding standards related to .Net and SQL Server technologies, taking an active part in code review and design review with the client teams.
• Managed a team of 31 offshore and onsite developers and testers simultaneously to implement multiple new and existing web applications using Agile methodologies.
• Developed an application migration approach to migrated application from .Net 1.1 to .Net 3.5. The approach was widely accepted across Confidential and was used as a best practice for various client solutions
• Mentored junior C#.Net developers and setup CMMI processes for projects and implemented SOX compliance for the projects at MetLife.
• Took active part in training the members of different project teams on various technologies like ASP.Net, ASP, SQL Server, XML and MS Access.
• Pioneered setting up prototype and rapid testing environments to facilitate testing environment at offshore locations.
• DTS packages were created and maintained in SQL Server 2000 for Rabobank.
• Confidential created in SQL Server 2000 were enhanced for different updates and new cubes created for generating reports.
• Coordinated and documented processes to transfer the knowledge from various vendors to the offshore team and subsequently leading the maintenance effort.
• Played a vital role in assuring that projects adhered to SEI CMMI Level 5 capabilities.
• Worked with the clients’ Quality Assurance teams to triage defects and reduce the count to zero or to single digit (took care of long pending defects that lay open for almost a year).
• Was instrumental in setting up the Agile XP lab in India to implement Agile projects in the onsite - offshore model.

Confidential

Project Leader

Responsibilities:

• Designed and developed applications in ASP and VB.Net 1.0.
• Responsible for both the front and back end development of my modules.
• Managed a team of developers in providing enhancements to the company’s intranet on time.
• Presented the company’s dash board in a nice way by implementing the traffic light to indicate the status of various projects.
• Trained and mentored the junior team members.
• Created a Web-service based application for proving the “Windows Explorer” functionality over the web for the “DeServe” project.
• Learnt Great Plains Dexterity in a short time.
• Created reports using Dexterity
• Implemented the “Generic Reconciliation System” for Confidential, for reconciling the positions file from various vendors like Bear Sterns, Merrill Lynch etc.
• Played a vital role in helping Fund Services to migrate from Windows 2000 to Windows 2003 server.

Confidential , Irvine, CA

Lead Programmer

Responsibilities:

• Developed applications in VB and ASP.
• Quick to learn and master ASP in a short span of time.
• Developed reports using Crystal Reports.
• Created the code reference manual for developer reference for the benchmark product of ATC.

Confidential , Atlanta, GA

Lead Programmer

Responsibilities:

• Involved in designing and developing the “Project Tracking” application for Scientific Atlanta.
• Developed the “Web-based Questionnaire” application for Confidential . Used for collecting various information related to the cable TV industry.