SUMMARY

• +11 years of experience in IT industry with prime focus on Database& Software development, Data Modeling, BI & Reports Development, Technical & Team Leadership, Project Management, Customer Relationship Mgmt., Onsite Coordinator (Onsite - Offshore model), and Implementation Analyst.
• Experience of +6 years in Database Development, Data Modeling and Reports Development expertise using SQL Server 2000/2005/2008/2012/2014 , Oracle 9i/10g, SQL and PL/SQL, SSRS, SSIS, SSAS, and Crystal Reports.
• Experience of +5 years in Financial Services (Prepaid Card and Payment Processing), +4 years in ‘ Confidential & Gas’ Industry, and 1 year in Telecom domains.
• Technical expertise of +7 years in .Net/C#, WCF, ASP.Net, MVC 2.0 applications development.
• Experience of +5 years in Project Development Management & Leading, Onsite & Offshore Coordination, Technical Support Mgmt.
• Experience of +4 years playing Scrum Master Role.
• Experience of +6 years in Agile Project development methodologies.
• Experience of +8 years in Team Leading and Project Leading.
• Experience of +6 years in Client-facing and Client relationship management
• Experience of +5 years in all phases of Software Development Life Cycle (SDLC).
• Experience of +6 months in SQL Server Test Automation.
• Proven skills on developing Function Requirement Specification (FRS), System Requirement Specifications (SRS), Use Cases, and User Stories
• Strong Analytical Thinking, Problem Solving, Learning and Communication skills
• Experience of +1 year in Arc Object (ESRI ArcGIS technology) application design & development.
• Thorough knowledge on Small world CST 3.3 & 4.0, worked on Power On (3.2 / 3.3), Design Manager 4.0, and PNI 4.0.

TECHNICAL SKILLS

Languages & Technologies: C#, VB.Net, ASP.Net, MVC 2.0 using Microsoft .NET Framework 1.1/20./3.5/4.0/4.5 , SQL & PL/SQL, WPF & MVVM, WCSF(Web Client Software factory), MVP, LINQ, Multithreading, MSMQ, N Service Bus, NHibernate, Spring.Net, Dependency Injection, VB 6.0, Arc Objects (ESRI ArcGIS 9.2), Small world CST 3.3/4.0, Magic.

Scripting Languages: Java Script, VB Script, J-Query, JSON (JavaScript Object Notation)

Designer/Editors: Visual Studio 2005/2008/2008/2010 , SQL Server Data Tool, SQL Server Management Studio, Toad

Databases: SQL Server 2000/2005/2008/2012/2014 , Oracle 10g/9i/8i, DB2, MS Access, Data warehouse

Web Technologies: HTML, XML, XSLT, Web Services, WCF, Azure, Ajax

Database/BI Tools: SSRS, SSIS, SSAS, Power BI, Power View, Power Map, Power Query, Power Pivot, FME, Crystal Reports, SQL Server Data Tools. SQL Server Test Automation, Test Community Framework for Database Test Automation.

Web Servers: IIS

Documentation Tools: MS Office, Visio, MS Project, Robo Help X5, Adobe Page Maker

Source Code Mgmt.: Microsoft TFS, Visual Source Safe, SVN

Agile Project Dev. Tools: Rally, TFS, Jira

Big Data (Beginner): Microsoft Big Data, HDInsight - Hadoop on Cloud using Windows Azure, Hive, Pig, Catalog, Ooziest, Sqoop.

Others: Futurex Hardware Security Modules (HSM), RSA Token Web Service, Windows Mobile 5.0 Smartphone Emulator, Dependency Injection using Spring.Net, MSMQ, NHibernate, Microsoft GDI+, Trimble® GPS Pathfinder® Tools Software Development Kit (SDK), Rational Rose.

Platforms: Windows 7, Windows XP, Windows Server 2003.

PROFESSIONAL EXPERIENCE

Software Development Engineer

Confidential, Redmond, WA

Responsibilities:

• Database development and enhancements based on Release plan
• Performance improvement
• Test case creation, Automation, and Execution. Maintaining Test cases in TFS and MTM
• SIT Environment setup
• Functional, System, and Integration Testing
• Testing various Transformations of data at different stages of Acquisition, Integration, and Distribution, to meet Technical requirements using SQL.
• Involve in Team support and resolving problems.
• Support and Prepare release deployment Build.

Environment: SQL Server 2012/2014, .NET, C#, SSIS, SSAS, Power BI, Power View, Power Pivot, Data Warehouse, SQL Server Test Automation, Test Community Framework for Database Test Automation, Microsoft Test Manager (MTM), TFS Agile Hybrid Methodology.

Associate Solution Architect and Development Lead

Confidential, Montvale, NJ

Responsibilities:

• Playing a role of Onsite Project Manager, Solution Architect, and Technical Lead.
• Daily Scrum standup call with Team.
• Efforts estimation, Tasks creation and allocation, and Project progress monitoring.
• Understanding BRW's (Business Review Worksheet), BRD’s (Business Review Documents) and Preparing Technical Design Documents (HLD & LLD).
• Creating ETL Package using SSIS and CUBE using SSAS. Generating Adhoc reports using Power View.
• Involved in WBS (Work Break Structure) and Estimation using FPA (Function Point Analysis).
• Handling a Team of 6 people, Providing Solutions & Development approaches, architecting their product for South West Border (US).
• Involved in UI design using WPF and designing the WCF Contracts.
• Involved in Production Support and resolving problems.
• Handling Builds to UAT and Production Promotions.

Environment: .NET, C#, WCF 4.0, LINQ, TFS, SQL Server 2012, SSIS, SSAS, SSRS, Power BI, Power View, Power Map, Power Query, Power Pivot, Data warehouse, IBM DB2, Multithreading, Agile Scrum Hybrid Methodology.

Project Development Manager, Scrum Master, Onsite Coordinator, and Sr Database Developer

Confidential, Austin, TX

Responsibilities:

• Product/Sprint Backlog Items Prioritization with Business Users and Product Owners.
• Sprint Pre Planning, Planning, Retrospective meetings, and Scrum Standup call with Team.
• Realistic & Effective Tasks estimation using Story Points (using T-Shirt Size style), Project progress communication, Resource planning, Right time escalation
• Discussion with Business Analyst and Business Managers understanding requirement.
• Data Analysis based on business requirements and preparing Technical Design Document including Data Model if Database changes are required
• Review Technical Design Document with Project Managers and Database Architect
• Identifying and Allocation of Tasks based on Team Members interest and skills set
• Establishing effective communication with Team and Stakeholders
• Managing Knowledge Transfer, Technical Support, Mentoring, Training including cross-functional
• Establish an open discussion in Team for decision making
• Ensure all team member understand the mission, scope of work
• Eliminate disagreement between Team Members
• Timely Recognition & Feedback to Team
• Database Tables creation and Queries development to verify results and performance tuning
• Development of ETL Packages using SSIS, Stored Procedures, Functions to generate and deploy reports on Unix Shared directory
• Writing Scripts to clean Staging and Test environment based on Tables relationships/dependencies
• Performance testing on staging environment and Peer Code review
• Sharing Sample reports with Business Analyst and Business Managers for review and signoff
• Preparing release for Code changes and Configuration scripts for deployment in Production.
• Daily standup call for progress update, requirement/queries clarification
• Release Management and Production Support
• Development of Database Tools to automate Code changes testing.
• Weekly meetings with End Users (Banks) for clarification and project’s status.
• Reports demonstration to Business Managers and End Users (Banks)

Environment: SQL & PL/SQL Oracle 10g & SQL Server 2008/2012, SSIS (ETL), Power BI, Power View, Power Map, Power Query, Power Pivot, Data warehouse, Agile Methodology, Jira.

Senior Software Engineer, Scrum Master

Confidential, Los Angeles, CA

Responsibilities:

• Discussion with Business Analysts and .Net Architects to finalize Technical Design Documents and Development approach.
• Product/Sprint Backlog Items Prioritization with Business Users and Product Owners. Sprint Pre Planning, Planning, Retrospective meetings, and Scrum Standup call with Team.
• Research on new tools like HSM, RSA Tokenizer to build WCF service wrapper using Tools development kit.
• Research to find better Design pattern for development of different WCF services for new Tools.
• Efforts estimation of User Stories and Tasks.
• Development of .Net WCF service using TDD approach, most of development was done using Factory pattern.
• Code refactoring of other developers code.
• Database Requirement analysis and Design specific to Prepaid Card domain.
• Development of ETL Packages to Load data from Transaction Processing System using SSIS.
• Mentoring and Technical Support.

Environment: SOA implementation with WCF Services using C#, ASP.Net, jQuery, Ajax, .Net Framework 4.0, TFS, Futurex Hardware Security Modules (HSM), RSA Token (Tokenization) Web Service, and Microsoft SQL Server 2008, N Service Bus, SSIS (ETL), Data warehouse, Agile Methodology, TFS.

Senior Software Engineer, Scrum Master

Confidential, Atlanta, GA

Responsibilities:

• Product/Sprint Backlog Items Prioritization with Business Users and Product Owners. Sprint Pre Planning, Planning, Retrospective meetings, and Scrum Standup call with Team.
• Object relational mapping using NHibernate for new security encryption module protecting sensitive data as per PCI compliance.
• Development of class library for Security Encryption.
• Defect fixing and enhancement in OLWS and W2 statement global website which was developed using MVC 2.0.
• Efforts estimation of User Stories and Tasks.
• Daily standup call and discussion with Project Manager for Code changes impact analysis.
• Database design for new Security Encryption module.
• Ensure timely and Quality of deliverables.

Environment: C#, ASP.Net, MVC 2.0, jQuery, Ajax, Dependency Injection using Spring.Net, MSMQ, NHibernate, Agile Methodology, TFS.

Project Development Manager, Scrum Master, Sr Database Developer, Data Analyst

Confidential, Las Vegas, NV

Responsibilities:

• Discussion with Product Owners and Business Analyst understanding requirement. Data Analysis based on business requirements and preparing Technical Design Document
• Product/Sprint Backlog Items Prioritization with Business Users and Product Owners. Sprint Pre Planning, Planning, Retrospective meetings, and Scrum Standup call with Team.
• Realistic & Effective Tasks estimation, Project progress communication, Resource planning, Right time escalation
• Identifying and Allocation of Tasks based on Team Members interest and skills set
• Establishing effective communication with Team and Stakeholders
• Establish an open discussion in Team for decision making
• Ensure all team member understand the mission, scope of work
• Eliminate disagreement between Team Members
• Development of Data Model using SSRS for Business Managers to build ad-hoc reports
• Development of Reports and Dashboard using SSRS and Deployment in Web environment & scheduling to run by SQL Server Agent
• Development of ETL package using SSIS, loading Flat files in Staging Database from Payment network VISA/Master Card/Pulse.
• Development of Cubes using SSAS, accessible for Business Managers by deploying in Excel
• Performance tuning of new & existing code. Interesting example, reduced execution time of ‘Monthly Card Statement Generation’ database process from +72 hours to 3-4 hours, which was one of the challenging projects.
• Developed Database Tables dependency diagram for whole ‘Car Management and Transaction System’, which was helping to build new test and staging environment. Writing Scripts to clean Staging and Test environment based on Tables relationships/dependencies.
• Development of User and Account Management module in ASP.Net using MVP pattern.
• Prepared Database coding guidelines and process documents for Offshore Team. Implementing best practices to achieve code optimization.
• Opportunity to manage 56 people at Offshore Team for +5 months in absence of other Project Manager.
• Managed +10 people offshore team for +1 year, and Responsible for enacting Scrum values and Practices.
• Reports demonstration to Business Managers and Business Analyst.
• Mentoring to Improve productivity of offshore development team.
• Helping team to remove impediments for delivering User Stories.
• Knowledge transfer sessions to other team members.
• Timely Recognition & Feedback to Team

Environment: SQL Server 2005/2008, SSRS, SSIS (ETL processing), SSAS, C#, ASP.Net, jQuery, Ajax MVP, TFS, Agile Methodology, Rally.

Technical Leader, Team Leader, and System Designer

Confidential

Responsibilities:

• Designing product development architecture and providing development solution.
• Preparing the delivery plan and other QMG related documents
• Understanding the requirements by arranging conference calls with customer/designer.
• Preparing Low level design documents.
• Development, Code review, and Efficient Code solution.
• Knowledge transfer sessions to other team members.
• Implementing best practices to achieve code optimization.

Environment: Windows XP, Arc Object (ArcGIS 9.2), .Net framework 3.5, ASP.NET, C#, Oracle 10g, web service, windows service, Microsoft practices.

Senior Developer and Team Leader

Confidential

Responsibilities:

• Understanding the scope and requirement of product
• Preparation of functional specification document.
• Product designer for UI.
• Development of functionalities according to functional specification documents.
• Implemented 100% Microsoft FxCop compliance for coding standard and optimizations.

Environment: Windows XP, .Net framework 3.0, C#.Net, SQL Server 2000, Windows Mobile 5.0 Smartphone Emulator, and Microsoft practices.

Onsite Technical Lead, Team Lead, Technical Support Manager, Implementation Analyst.

Confidential, Kansas, MO

Responsibilities:

• Define and state expectation with Team members
• Ensure all team member understand the mission, scope of work
• Evaluate results in timely fashion
• Timely Recognition & Feedback to Team
• Establishing effective communication with Team and Stakeholders
• Implementation & Configuration of Product for different clients.
• Architecture and Detail designing of Documents at client side.
• Technical Leader to support development for all modules.
• Writing FME scripts to upload data from session to enterprise database.
• Understanding the scope and documenting requirements for product releases.
• Development of functionalities according to the Use-case and FSD.
• Realistic & Effective Tasks estimation, Project progress communication, Resource planning, Right time escalation
• Interaction with Business Owner for status update and necessary input & clarifications.
• Implemented 100% Microsoft FxCop compliance for coding standard and optimizations.

Environment: Windows XP, .Net framework 2.0/3.0, C#.Net, Oracle 9i/10g, SQL Server 2000, MS Access, Arc Object (ArcGIS 9.2), Microsoft GDI+, FME, Microsoft practices.

Developer and Technical Writer

Confidential, Kansas, MO

Responsibilities:

• Understanding the scope and documentation requirements for product releases.
• System Designing Document.
• Development of functionalities according to the Use case document.
• Interacting with the Subject Matter Experts for necessary input and clarifications.
• Developing Online Help, User Manual.

Environment: Windows XP and Windows XP Tablet PC Edition, .Net framework 1.0, C#.Net, Oracle 9i, SQL Server 2000, MS Access, Trimble® GPS Pathfinder® Tools Software Development Kit (SDK), Robo Help X5, Adobe Page Maker, FME., Microsoft practices.

Developer

Confidential

Responsibilities:

• Developing Explorer Plug-in and customized Application.
• Data Model Creation and Testing the Data Model.
• Integrating of all the Plug-ins with the framework.
• Unit and Integration Testing.
• User, Installation and Configuration Documentation.

Environment: Small world CST 40 and 3.3, Magic.

Developer

Confidential

Responsibilities:

• Defects resolution and prevention analysis.
• Interacting with clients and their development teams.
• Documenting the design changes.

Environment: VB6.0, Oracle8i and PowerOn3.3, Magic.