SUMMARY

• 8 - 1/2 years of IT experience in Consulting, Business Analysis, Program/Project Management, Data Analysis, and experience in SDLC cycle ( Confidential, Confidential and Agile): managing scope, tasks and deliverables to client specific requirements in Healthcare, Energy and Banking industry.
• Contributed to various transition programs for leading Healthcare and Energy companies in their rationalization and transition from legacy applications.
• Contributed in various phases of Software Development Lifecycle from Requirement Gathering, Analysis, Design, Implementation, QA testing, Production support, Maintaining and Enhancing Enterprise Applications.
• Contributed in object oriented design and relational database management development and maintenance.
• Contributed as Business Analyst and involved in learning Business processes along wif Business Users, evaluating feasibilities of teh requirements, creating several Documentations including Business Requirements, Functional Specifications and Test Cases.
• Experience in Pre-sales activities, involved in building Project Estimations and addressed many winning Project proposals.
• Executes projects in DPMM prototyping and Agile development methodologies.
• Extensive working experience in onsite/offsite model
• Experience working in a multi team/vendor environment coordinating wif various team on day-to-day basis and execute tasks.

TECHNICAL SKILLS

Languages: Oracle SQL, PL/SQL, MS SQL, SSIS, SSRS, SSAS

Web Technologies: HTML

Database Environments: Oracle 11i/10g/9i/8i, SQL Server 2008/2005/2000, IBM DB2, PL/SQL, My SQL, JDBC, ODBC, MS-Access, SQL Loader, SQL Plus

Programming Languages: TSQL, PL/SQL

Reporting Tools: SQL Server Reporting Services, MS Excel, Power Pivot

Analytical Services: SQL Server Analysis Services 2005/2000

Integration/ETL Services: SQL Server Integration Services (SSIS)

Operating Systems: Windows 2008/2003/2000/ NT/98, UNIX and LINUX.

Tools: Microsoft Project, Microsoft Visio, Rational Rose, HP Quality Center, IBM HPSD, \ Toad, SQL Developer, SQL Loader, Microsoft Business Intelligence Development Studio, Power Pivot, Cisco WebEx, IBM Same time, Microsoft Lync, Citrix, Share Point

Project Methodologies: DPMM, Agile

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst/Data Analytics

Responsibilities:

• Identify teh Business Processes and understand teh existing Customer's business processes and needs for teh new solution.
• Gather, consolidate and prioritize teh requirements from teh different Business stakeholders and work wif Business users.
• Analyze teh Business Requirements, conduct fit-gap analysis, feasibility study and estimate teh time by working in conjunction wif teh IT Development team.
• Build mockups using Balsmiq tools and MS PowerPoint for visualizing teh future of teh product.
• Responsible for identifying teh data source(s) for all teh requirements including information from third party sources and other departments.
• Initiated and conducted Data Migration Activity from Legacy system to a new structured DWH platform.
• Developed logical and physical data models that capture current state/future state data elements and design data flows diagrams.
• Perform data analysis on report requirements and recommended solutions for development using SSIS and SSRS.
• Conduct UAT, Regression Testing, Functional validation and Quality testing of teh Application
• Facilitated teh Weekly Status Meetings, UAT Meetings and Workshops as part of Requirement Gathering
• Prepared ad-hoc reports and dashboards for teh Business meetings using Power Charts and Power Pivots

Confidential, Atlanta, GA

Senior Database Developer

Responsibilities:

• Creation of intermediate database, DB objects to update and scrub teh old data.
• Define ETL Process for purging data from old system and loading only useful data into teh new system
• Writing PL/SQL Scripts for data modification and conduct check for data anomalies.
• Wrote medium to complex stored procedures based on teh business rule.
• Data Validation and performance tests to check teh efficiency of data
• Performed database optimization and focused on stability and execution plan, which TEMPhas resulted up to 45% increase in performance of numerous modules.
• Mapping users to their roles and control database accesses
• End to end testing Support (UAT, Functional, Performance, Access controls)

Confidential, Atlanta, GA

Business Analyst / Onsite coördinator

Responsibilities:

• Facilitated teh Joint Discussion Sessions for Requirement Gathering and identify Problem Areas.
• Executed teh project in Agile methodology and worked on Sprints that lasted 3-4 weeks.
• Conduct detailed Functional Analysis and Feasibility Study as well as work wif Technical Team on understanding teh timeline and estimates for Product development and enhancements.
• Conduct Risk Analysis and prepare mockups for future state of teh product and identify potential gaps and process failures.
• Developed a backup plan to ensure teh smooth delivery of teh project,
• Conducted workshops wif GE Managers and Business teams to validate teh developed solution, functional validation and unit testing of teh Application
• Prepared and maintained a traceability matrix recording and mapping teh requirements to teh test cases and teh final work product
• Ensuring Knowledge Transfer to Support teams on teh new product development.

Confidential

Senior Database Developer

Responsibilities:

• Initiated teh need for a new Database and successfully created them.
• Identified teh different modules in teh new application and designed teh Database model and teh associated risk and data anomalies
• Performed feasibility study for data migration from various systems and created a ETL DWH model.
• Developed teh database objects for interacting wif teh web based application for retrieval, modification and display of data
• Created daily/weekly data feeds using ETL tools to feed into teh ERP system.
• Facilitated System Testing, Integration Testing and Performance Testing.

Confidential

Project Leader

Responsibilities:

• Analyzing teh Business Domain Architecture and Design of teh client applications.
• Responsible for Knowledge acquisition and repository management from previous vendor.
• Delivered Environment Set up at offshore location for remote support.
• Conduct tests and analyze teh underlying issue behind data anomalies and tract defect to close.
• Bug fixing wif major and minor enhancements to teh database system and user interface.
• Effort Estimation, Analysis, coding and testing of teh enhancements.
• Database Maintenance and task force activities.
• Analyzed teh new requirements define teh scope and prepare teh Document of Understanding.
• Monitored teh batch details every morning for any failure of teh letter generation.
• Performed teh data corrections and modifications.
• Testing - unit testing & integration testing.
• Worked on fixing teh tickets related to Insurances - Lending
• Delivered one of teh most important Projects NIPPO, that had changes in three systems applications - INSYS, Mass printing and Pan Credit.