SUMMARY

• Sr. IT professional with 16+ years of overall experience in leading application design, development & maintenance, production support, data/systems analysis, testing and release management in industries such as healthcare & insurance, retail, communication and information.
• Strong technical leader with extensive experience working on databases like Teradata, Oracle & DB2, ETL tools like Data stage, Informatica & Teradata Utilities, reporting tools like Cognos, BO, Spotfire etc.
• Extensive technical experience in Enterprise Data warehousing, ETL/Data/Application Architecture combined with strong leadership skills, earning a solid reputation for productivity, attention to detail and finding the best possible technological solutions for any given challenge.
• Highly skilled technical leader with outstanding organizational skills and excellent communication & Inter - personal skills.
• More than 10 years’ experience in leading complex IT projects with proven ability to TEMPeffectively co-ordinate across different teams involving customer, vendor, business, technical & PMO and with teams spread across the globe.
• Successfully led complex data warehousing development projects with 8+ million USD budget
• Experienced in complete SDLC life cycle from Requirements gathering till Product implementation and support
• Experienced in managing all project activities including requirement gathering, estimation, costing & scheduling, project status tracking, controlling & reporting, coordinating with Business, Testing, Vendor & PMO teams
• Experienced in team ramp up/down activities, recruiting FTEs/contractors based on the project requirements, building strong/high performance teams, conducting performance appraisals & providing feedback.
• Excellent Communication skills with great relationship building, interpersonal skills and people management capabilities

TECHNICAL SKILLS

Databases: Teradata, DB2, Oracle & SQL Server.

ETL Tools: Datastage, ETI *Extract, Informatica, Teradata Utilities

Operating systems: UNIX MP-RAS, Windows, MVS

Reporting tools: Cognos, Business Objects, Spotfire etc.

Other Utilities & Tools: Lotus Notes 4.5, Toad, ERwin, MS Office, MS Project, MS Visio, DB Visualizer, Queryman, PlanView, WebEx, Live Meeting, SharePoint etc.

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. Analyst

Responsibilities:

• EDW 2.0 Phase - II: Overall handling of Phase-II activities which includes driving Requirements gathering, Data modeling, Design, Development, Testing.
• Led teams consisting of ETL/Report developers, architects & testers in migrating Revenue functionality from EDW 1.0 to 2.0 as part of EDW 2.0 Phase-II.
• Involved in delivery & implementation of critical projects like EDW 2.0 Phase-me, C2C upgrades, supporting acquisition of AT&T CT, Verizon CTF conversions etc.
• Prioritized the work on various ISRs in addition to hiring, coaching and developing the team.
• Collaborated with business partners and vendors such as Teradata, Informatica, SQL Server etc. to assess the potential of new technologies & tools and to resolve technical issues during development/deployment activities.
• Initiated offshore development initiatives and forged efficient relationships with offshore contracting partners such as Teradata, TCS and Capgemini, ensuring a seamless match to onshore deliverables and reducing development costs.
• Participated in project planning sessions with program managers, business solution architects and data solution architects to analyze business requirements and outline the proposed IT solution design.
• Led the ongoing development process that involves design and implementation of multi-dimensional models adhering to waterfall and agile development methodologies.
• Established and helped enforce Industry best practices, appropriate tool selection and develop guiding principals around Data Acquisition and Data Quality.

Confidential, Basking Ridge, NJ

Development Manager

Responsibilities:

• Managed & coordinated the delivery of Reporting Data Store datamart and vendor feeds to downstream systems from new datamart. Planned and successfully executed various phases of the project delivering strategic insights, maintaining top-tier Quality standards and facilitating attainment of UHG's long-term goals.
• Liaised heavily with client, identified unique needs and successfully delivered projects like AXOLOTL, OptumRX, MEDCO, HealthAllies etc.
• Guided a team of 30+ developers & architects, spread across multiple geographic locations consisting of in-house staff and external consultants, on technical & functional areas to overcome road blocks and to achieve the end objectives of the project.
• Coordinated with different teams involving vendor, business, functional, technical & PMO groups
• Quickly adjusted to changing project needs, delivered regular status updates and contributed heavily towards improving processes & creating value addition
• Supervised Design, development and system testing to ensure that the deliverables adhered to project standards, performance criteria and functional specifications
• Proactively tracked and provided project progress reports and escalated issues to senior management.
• Provided recommendations for process improvement and process re-engineering.
• Involved in verifying change requests & defects, tracking test plans and reviewing test results, proactively identifying issues & taking corrective actions, identifying & mitigating risks.

Confidential, Minnetonka, MN

Technical Lead

Responsibilities:

• Responsible for planning, scoping, estimation, tracking and delivery
• Coordinated with Business, Functional, Technical teams and closely supervised requirements gathering, data modeling, design, development, testing and handing over the application to support team.
• Coordinated the efforts of various teams involved in life software development life cycle (like Development team, QA team, PMO, Customer/Business team) for the successful delivery of the project.
• Prepared project plans and monitored/tracked the progress of project/tasks as per the project plan, tracking issues to closure
• Managed scope, provided technical direction to all team members, and ensured on-time delivery
• Developed training program for new hires and ensured the team understands & adheres to quality processes & standards
• Involved in Resource procurement, deployment, allocation, management and career development of team members

Confidential, Kansas City, KS

Technical lead

Responsibilities:

• Involved in all phases of the project starting from Requirements gathering till support turnover
• Delivered and implemented the project as per scheduled milestones.
• Monitored project status and reported project progress to senior management.
• Involved in project assessment and in selecting appropriate technologies.
• Worked with Data Modelers and DBAs to create logical/Physical data models and designed ETL processes
• Designed and executed test plans and performed gap analysis to ensure that business requirements and functional specifications are tested and fulfilled

Confidential

Teradata DBA/Technical lead

Responsibilities:

• Performance tuning of Poorly performing Jobs (in terms of spool space & run time)
• Working with Senior DBAs during Teradata Software upgrade from V2R5 to V2R5.1
• Managing team of five to monitor the load on Teradata Warehouse and to tune poorly performing queries.
• Reviewing the code for newly developed applications before Production release.
• Helping OM team members in resolving the issues/job failures.
• Resolving the job failures during nights/weekends by providing oncall support.

Confidential, Kansas City, KS

Project Lead

Responsibilities:

• Extracting data from DB2 tables and other sources using ETI Conversions.
• Design and development of ETI Conversions for ETL process and for loading the data from the Warehouse to a data mart for reporting purposes
• Unit Testing & System Integration Testing
• Loading historical data from various source systems.

Confidential, Dayton, OH

Software Engineer

Responsibilities:

• Extracting data from DB2 tables and other sources using ETI Conversions.
• Development of an automated process for loading the data into the base tables in EDW (for ETL) using fast export, multiload, BTEQ utilities of Teradata. Preparing the design specs.
• Design and development of initial load, denorm & purge processes
• Unit Testing & CIT Testing.