SUMMARY

• Senior level IT Professional with 14 years of experience and proven track record of applying appropriate practical technology/mix of technologies that meet business needs while minimizing risk.
• Motivated achiever with demonstrable ability to recommend enhancements to business process.
• Extensive experience as Project Manager, successfully leading internal and offshore cross - functional team to deliver results. Also coordinates communication, information and highly skilled professionals to meet technology needs and evaluate progress while assuring smooth, efficient project and activities.
• Strong interpersonal, written and verbal communicator, who can deliver effective presentations, consult on technological projects and maintain collaborative relationships.
• Performed Business process enhancements and provide recommendations
• Evaluate new tools / technology, recommend solution for migration, and upgrade projects.
• Experience in Requirement and Gap Analysis
• Prepare Design Specification document
• Develop traceability matrix, prepare Test plan strategy document, and ensure Quality assurance on project deliverables.
• Draft and distribute deployment notices, release notes, and other communications.
• Proficient in mentoring and collaborative team driving towards successful deliverables and good planning and co-ordination.

TECHNICAL SKILLS

Methodologies: Solution Delivery Methodology and Agile.

Design Tools: Microsoft Visio, Erwin (for Data modeling)

PM tools: Clarity, Rally

ETL Tool: Informatica Powercenter 8.x /9.x

Data warehouse Models: Star Schema, Snowflakes, OLTP, ODS, OLAP and ROLAP & MOLAP designs, Hadoop architecture (Emerging technology)

Emerging Tools: R Programming

Reporting Tool: Microsoft Power Excel, Business Objects

Web Technology: XML, HTML 4.0, Java Script, Macromedia Flash Script, ASP

Languages: PL/SQL, Unix, SQL, XML, JavaScript

Databases: Oracle 9i,10g, Microsoft Access, Oracle Vehicle Configurator (OCD)

GUI: Oracle9i Forms & Reports, Macromedia Flash and Dreamweaver

Languages: Java (JDK 1.5, 1.6, 1.7, 1.8), C, C++, Objective C, Swift and SQL

Modeling Language: UML

PROFESSIONAL EXPERIENCE

Senior Business System Analyst

Confidential

Responsibilities:

• Build trusted client relationships through proactive account management and effective project delivery.
• Establishes knowledge of client business challenges and priorities to translate into opportunities.
• Collaborate with the Product Manager to inspect and create epics, features and stories for the product backlog.
• Act as the go-to-person for answering questions the team has about business rules and product behaviors
• Communicate team deliverables and sprint outcomes to stakeholders
• Lead and facilitate short-term and long-range grooming sessions with the development team
• Be a champion for the product direction and vision during product planning and throughout the life of the project
• Detailed study on the current and Future state of application architecture, collaborate with technical teams to prepare project life cycle budgets.
• Maintains regular client communication and satisfaction, addressing opportunities and challenges in a timely manner.
• Helps deliver presentations to clients and management teams.
• Contributes to project discoveries, kickoff, prepare proposals and statements of work following company standards.
• Translate clients business needs into detailed business requirements documents; use cases and systems interaction diagrams.
• Works with customers to establish approved wireframes and mock-ups for solutions.
• Assists project team to establish high, mid, and micro level plans for project team.
• Helps to establish critical path, milestones, delivery dates, and review client deliverables to ensure they meet client acceptance criteria.
• Provides leadership throughout the lifecycle of a project, guiding the project team have through design and development to meet project requirements.
• Helps establish project test strategy, methodologies, test plans as well as assist with test execution.
• Instills team commitment to company delivery methodologies and practices.
• Initiated Joint Application development sessions (JAD) and increased the development cycle.

Tools: and Technology: SDM and Agile Methodologies, MS Excel, MS Visio, MS Project plan.

Senior Analyst

Confidential

Responsibilities:

• Maintained and provided assessments of architecture, technology, and industry trends relate to the overall systems architecture, and correlates to the applicability of the overall IT strategy.
• Accountable to identification & mitigation of project risks towards Data integration process.
• Contributed to efforts sizing estimates and developed project development plans and provided technical solutions aligned to business requirements.
• Designed mapping template for common business rules.
• Designed ETL and reporting architecture and data flow.
• Holds JAD sessions in order to determine and document stakeholders' objectives and needs.
• Documents requirements, defines scope and objectives, and formulates systems to parallel overall business strategies.
• Prepared documentation including detailed technical designs, system use cases, system flow charts, data models, screen mock ups, and system interface descriptions outlining systems capabilities and processes.
• Defined project tasks and estimate level of effort to achieved project deliverables and goals.
• Contributed to and worked to meet project schedules by providing accurate estimates of effort required for systems analyst deliverables, by also providing updates on project progress to team members, project management and project personnel, and by escalating issues that might affect project success to management.
• Interacts regularly with Business Stakeholders, Business Analysts, Architects, Developers and Software vendors to meet project objectives

Tools: and Technology: Waterfall Methodologies, MS Excel, MS Visio, MS Project plan.

Project Lead

Confidential

Responsibilities:

• Executed project management processes and methodologies within the project framework to ensure project release plan are delivered on time, within budget, adhere to high quality standards and meet customer expectations.
• Conducted impact assessment and determine size of effort based on requirements.
• Established best practice and standard for ETL process documents.
• Designed ETL architecture and architecture documents.
• Defined and implemented ETL development standards and procedures.
• Troubleshoot and implement existing code.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and XML.
• Prepared Metadata modeling using Framework Manager.
• Developed standard and re-usable mappings using various transformations to load data into GVC product.

Tools: and Technology: Oracle Vehicle Configurator, ETL process for data integration, Unix Shell Scripting, Edit plus, Microsoft Project. MS Visio, MS Project plan.

Regional Project Lead

Confidential

Responsibilities:

• Proposed & implement solution, which eliminate Data Delivery System (DSS), which is residing in Oracle database through MVC architecture and introduce XML data source to LAAM and GMME region for Dealer Locator, Showroom components.
• Introduce a single JSP action form, which caters for all GM brands without changing the business logic.
• Introduce single XML data source and build “Build your Own” component in JSP and Macromedia Flash application, which reduce huge costs to Confidential B2C websites and increase more web traffic.
• Prepared Project plan & Effort estimation for all releases.
• Conduct UAT with business users
• Track & Close the UAT issues and Conduct Tollgate review meetings with GM stakeholders.
• Responsible for reviews, testing, implementation, and post implementation support for the product.

Tools: and Technology: JSP, Struts, Oracle PL/SQL, Actionscripting, Dreamweaver, XMLSpy, Javascript, Edit plus, Microsoft Project, Interwoven, JSP & Struts

Module Lead / Project Coordinator

Confidential

Responsibilities:

• Conduct initial product research for CD-ROM project and lead overall design.
• Involved in Database design in Microsoft Access application.
• Assist in the full life cycle of Internet based development efforts including: Domain Creation, Database design, Architecture design.
• Script.
• Write real time programming using ASP for confidential with a set of server-based objects like CDONTS & SMTP
• Performed in integration testing.
• Responsible for reviews, testing, implementation, and post implementation support for the CD-ROM and web based application product.
• Supervise testing and beta phases, and move finished product into manufacturing process.

Tools: and Technology: Microsoft Access, Adobe Photoshop, Macromedia Flash, Director & DreamweaverASP with Microsoft IIS technology