SUMMARY

• 11 years BI consultant in Data warehouse/ETL/ Business Intelligence and testing methodology, Data Modelling, DQM, Data Analysis, and OBIEE administration.
• 8+ years of Project Management in a matrix organization structure, strong experience in all phases of SDLC using Waterfall, Agile/Scrum methodology.
• Product Management, Sarbanes - Oxley Governance narrative and implementation for Data technology platform.
• Constantly learning and leveraging emerging technologies with key skills and expertise in:
• Quickly learner and Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.
• Highly proficient in project planning, project management, project execution, budgeting, and resource allocation
• Proven experience with development methodologies (e.g., Waterfall, Agile Scrum, SDLC)
• Implemented DW-BI projects for various clients in the O&G, Healthcare, Retail, Telecom and Insurance domain.
• Experience in Requirement gathering, Business analysis and change management
• Data Model Design - Logical (Star Schema, Snowflake Schema) and Physical Data models for ETL Implementation
• Ability to create dashboard solutions to provide key BI and Analytics capabilities using Business Intelligence / OLAP tools, Design and develop intuitive dashboard for data visualization of various organizational metrics and presentation to the stakeholders using industries standards and best practice.
• Able to work flexible hours, including hours beyond the normal schedule when necessary.

TECHNICAL SKILLS

ETL Tools: Informatica 10.1, TDM, DDM

BI Tools: OBIEE 11.1.1.7, SAS Base V8.2, Tableau 9.0, Incorta BI, Logi Analytics, Domo

HDFS, Database: SPARK 5.4, Vertica, Teradata V2R15, Oracle 11g, SQL Server 2008/2012

PM Tools: MS Project, ITG-PM, Visual Source Safe, MS office

Design Tools: Erwin, MS-Visio

Languages & S/W: SQL, PL/SQL, SQL Loader, Toad, Unix scripting

ERP: PeopleSoft 9.2 HRMS, OracleEBS, Customized Applications

Operating Systems: Linux RHEL 5.5, Sun Solaris 2.x/7, Mac, Windows

PROFESSIONAL EXPERIENCE

Confidential, NJ

ETL Project Manager

Responsibilities:

• Involved in Initial scoping and estimating the resources for the CPPR Informatica ETL implementation.
• Involved in created the requirement documents for the various modules.
• Created the project implementation plan and developed the stories in Jira.
• Developed ETL Mapping for migrating data from various transactional source data.
• Involved in the ETL process for exporting the data from the legacy systems using Informatica.

Environment: Linux, Informatica 10.1, MySQL 5.6, SQL Server 2012, Visio, Jira Agile

Confidential, San Jose

Product Manager

Responsibilities:

• Involved in design and developments for various Products of Data Finance & Technology - FRAMe, WATCH (Web enable portal with anomaly detection and smart system health alerting capabilities), NEST(Hadoop Data Migration for Funding Cost)
• Regulatory Reporting Solutions from MSTR/Teradata for Various Audit Teams as per adhoc requests on frequent basis which included XOOM and VENMO data Integrations.
• Worked with internal/External audit team to role-play audit scenarios. Narrated the SOX process for the owned product deliverables with Audit teams (EY / PWC / Confidential ITGC Teams).
• Led design initiative for Teradata to Hadoop data migration solution by SPARK, Hive and Teradata SQLs.
• Identify, communicate and manage project issues and risk, notifying and/or escalating appropriately to the customer or internally.
• Ensured thatsystem Integration(SIT) and user acceptance testing’s(UAT) accomplish change managementprocedures, followed with an ability to prioritize and manage multiple tasks with effective time management skills, and precisely documented all data for further reference.

Environment: Linux, Teradata V2R15, Informatica 10, SPARK, Hive, Visio, HP ALM 12.0.

Confidential, Sunnyvale

DWBI Project Manager

Responsibilities:

• Initiate, organize, plan and lead enterprise level system development/implementation projects.
• Develop detailed project plan, project estimates, resource plans, and status reports; tracks key project milestones and adjusts project plans and/or resources to meet needs of customers.
• Use project scheduling and control tools to monitor projects plans, demand planning and resource loading.
• Identify, communicate and manage project issues and risks, notifying and/or escalating appropriately to the customer or internally.
• Participate in the presales process by reviewing project proposals, Statements of Work (SOW), assessing overall project structure, risk, staffing requirements in order to access project success.
• Involved in the Project Planning, Schedule/Effort Tracking, Delivery Management, Risk Analysis / Tracking & Project Closure
• Analyzed and provided gap analysis of conceptual, logical and physical data warehouse.
• Working closely with Architects for the applications assessment to all the Data Masking Team on Proxy server and proving support on the databases and applications
• TDM/ DM solution for PeopleSoft HCM v9.1 including combining TDM & DA solutions
• AppliedOptimization Techniquesusingcustomized SQL Codesin Vertica for the better performance of the reports.
• Good Knowledge onapplying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformationand loading into targets.

Environment: MS Project, SDLC, Linux, Informatica 9.6.1, Teradata V2R12, Tableau, Incorta BI Analytics.

Confidential

Techno Functional Lead

Responsibilities:

• Team management for onsite, offshore model teams including mentoring, performance tracking and technical support
• Oversee aspects of project life cycle, business requirements, conceptual, logical and physical database design, technical design, database schema objects and implementation phases for various impacted applications.
• Developed customreports/Ad-hocqueries usingOracle answersand assigned them to application specific dashboards.
• Interface and coordinate tasks with internal and external technical resources. Collaborates with project managers and technical directors to provision estimates, develop overall implementation solution plan, and serve as a lead as required, to implement the installation, customization, and integration efforts.
• Managing all documents as per standards and approaching for all the approvals with respective teams.
• Validating the dependency for availability of all business rules for starting the ETL design for upgrading source systems.
• Responsible for offshore deliverable for Teradata scripts using Multiload, Fastload, Fastexport, and Bteq.
• Coordinate with deployment and support resources to ensure the solutions get implemented smoothly into QA and Production environments and Provide knowledge transfer to support teams.
• Responsible for ensuring final test certificate and release the product to clients.

Environment: MS Project, MS Office, Pages, Teradata V2R12, Informatica 9.1, Linux, Mac OS, SDLC, Agile/Scrum.

Confidential, Houston

Project Leader

Responsibilities:

• Project planning and Monitoring & tracking Project Risks/Issues Tracker.
• Interaction with the customer for the business requirements/enhancement focusing on sales, supply chain management and customer Profitability modules.
• Build and maintain repository for deliverables, methodologies, and business development documents in formalized solution methodologies.
• Identify impact on existing model triggered by new/changed requirements.
• Developed Teradata scripts using Multiload, Fastload, Fastexport, Tpump and Bteq utilities.
• Designed and Tested Reports in OBIEEDashboardsfor theOracle Financial Analyticsmodules likeGL, AP, ARand created the Ad-hocreports.
• Identifiedissues,performancebottlenecks, and optimized the Business IntelligenceDashboardsand Reports.
• Involved in migration of Informatica 8.x to 9.x, Oracle 11g database from legacy system to TSG Centers.
• ImplementedSSO securityby authenticating against theLDAPandexternal table.
• Involved in building OBIEE11g in Linux for DEV / TST / PROD servers and migrating OBIEE RPD from Windows OBIEE10g from legacy system to Linux OBIEE11g in TSG Data Center.
• Coordinate with deployment and support resources to ensure the solutions get implemented smoothly into QA and Production environments.
• Responsible for conducting work product audits and review of project activities.
• Knowledge of Six-Sigma statistical techniques, root cause analysis, Pareto diagrams

Environment: MS Project, MS Office, Informatica 9x, 8x, Oracle 11g, EBS GL, AP, AR, OBIEE 11.1.1.7, Visio, Linux, Agile/Scrum.

Confidential

Project Leader

Responsibilities:

• Coordinating with team of developers and working in the different wings of projects.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
• Developed Teradata scripts using Multiload, Fastload, Fastexport, Tpump and Bteq.
• Coordinate with deployment and support resources to ensure the solutions get implemented smoothly into QA and Production environments.
• Responsible for conducting work product audits and review of project activities.
• Responsible for ensuring final test certificate and release the product to clients.
• Involved in estimation and analysis of support central tickets and creating the analysis and solution documents.

Environment: MS Project, MS Office, Teradata V2R6, Informatica 8.6.1, Oracle 10g, SQL, Erwin, UNIX.

Confidential

Sr. Associate

Responsibilities:

• Conducts risk assessments, facilitates communication across operational groups, and ensures compliance with the defined process and/or implementation.
• Full accountability for planning of resources for tasks, allocation, estimation, scheduling and risk management.
• Interacted with Business/Onsite coordinators and developers related to requirement to develop and present relevant reports on project progress throughout the project lifecycle.
• Developed Teradata scripts using various ETL techniques like Multi Load, Fast Load, Fast Export and BTEQ.
• Involved in development of ETL flow using AbInitio wrappers in UNIX.
• Providing technical support to team in offshore and client during UAT.
• Responsible for work product audits and reviews for project activities.
• Responsible for work product audits and reviews for project activities as SCM coordinator - Monitors periodical checks and DPM Coordinator - defined the scope of defects in the deliverables, periodically check for defects in the deliverables
• Facilitate to perform defect causal analysis. Co-ordinate defect prevention meetings on a periodic basis and analysis on RCA and provide regular periodical reports to Customers and Audits teams.

Environment: MS Project, MS Office, Teradata V2R6, AbInitio GDE 1.14.4, WinSCP, Unica, UC4, UNIX.

Confidential

Delivery Software Engineer

Responsibilities:

• Involved in large Enterprise Data Warehousing (EDW) development project.
• Responsibilities mainly includes from Requirement Gathering, Analysis, Designing, Testing and Implementation.
• Experienced in developing Teradata V2R5 scripts using various ETL Techniques (MultiLoad, Fast Load, Fast Export, TPUMP and BTEQ).
• Experienced in creating ETL graphs in AbInitio GDE 1.14.4.
• Involved in creating Visio Documents as per the user requirements.
• Responsible for system testing and captured results through HP Quality Control.

Environment: MS Office, Teradata V2R5, AbInitio GDE 1.14.4, Sun Solaris 2.x/7, HP QC, Visio.

Confidential

Analyst

Responsibilities:

• SAS Certified Base Programmer: SAS Base, Macro, STAT, Access, GRAPH, SAS Dashboard Development.
• Advanced SQL Query language, and query optimization Hands-On, detailed-oriented Data Analyst, SAS Developer, and Data Miner
• Monitored the SAS server for resource utilization and acted on incidents, Monitor loading of business data into data warehouse thru Maestro Scheduler.
• System Test results are executed and captured thru Mercury Quality Control.
• Trained business users in established standards and procedures.

Environment: MS Office, SAS Base, SAS Macro, SAS Graph, JIRA, TOAD, Excel, Crest, Huron, LDAP, Mercury, Scrum.

Confidential

Software Engineer

Responsibilities:

• Involved in various implementation with clients for development and testing to help them to verify the results of the parallel testing, understanding the acceptable differences and getting the sign offs.
• Preparation of detail charts and algorithms required for program development and involved in system study, understanding user requirements and writing of the functional specifications of the project.
• Learned development of VB code, VB scripts and use of objects while programming.
• Consult with the programmer analyst team and collect specifications for them Preparing controls and database development for the software systems.
• Code integration to ensure that the developed individual modules are working well, when integrated.
• Designed front-end VB forms, tested the application for Unit Testing and Integrated Testing.

Environment: MS Office, Visual Basic 6.0, SQL Server 2000, SQL* Loader, C, C++

Confidential

Systems Engineer

Responsibilities:

• Involved in supporting equipment in a Microsoft Windows environment, from design through implementation and support.
• Performed a wide variety of installation, configuration and upgrading of workstations, and provided investigation, diagnostic testing and repair/resolution of system, hardware, software and infrastructure.

Environment: MS Office, Visual Basic, C, C++, COBOL, dbase, UNIX, Adobe Photoshop 6.0