SUMMARY:

• Client - focused software consultant with extensive experience in software development and project management, specializing in delivery of data warehouse and business intelligence solutions, systems development, as well as customer management, ERP, and management information systems. Proficient in enterprise data integration, database design, ETL processing, data architecture design, requirements gathering, dimensional modeling, system architecture, OLTP/OLAP systems, data marts, metadata management, performance tuning, operational data stores, data profiling, data analysis, source-to-target mapping, BI dashboards, developing best practices, reporting and analytics on multiple RDBMS platforms. Skilled in use of star schema, logical and physical design, Kimball and Inmon methodologies, data warehouse granularity, partitioning, indexing & aggregation strategies and hierarchical relationships.
• Capabilities extend to collaborate and work with executives & business users, on-site/off-shore teams to ensure deliverables on time and within budget, project management, process management, software development, and data warehouse strategic planning and resource management across public sector, retail, airline, manufacturing, human resources, and finance industries. Expertise and core competencies include:
• Software Development
• Project Management
• Client Relationships
• DW & BI Solutions
• Mentoring & Leadership
• Data Architecture
• Process Management
• Technical Expertise
• Problem Analysis & Resolution

TECHNICAL SKILLS:

Operating Systems: DOS, MS Windows 95, MS Windows NT/XP, UNIX, Novell Netware, Sun Solaris System V, Sun Solaris 8, OS400, VM, Linux

Programming: SQL, PL/SQL, Visual Basic, Clipper, Java, C, PL/I, PRO*C, PRO*PL/I, REXX, RPG/400, Unix Shell Scripts, Python

Software Tools: Informatica PowerMart/PowerCenter, Datastage, SQL Server (2000, 2005, 2008, 2012) - SSIS, SSAS, SSRS, Visual Studio, Microstrategy, Cognos ReportNet, Cognos Series7, Erwin, Developer 2000 (Forms 4.5 & Reports 2.5), Forms 3.0, SQL*Loader, Oracle Designer-2000, Silverrun Data Modeling Tool, AQT, Quest Central, Event Coordinator, Teradata SQL Assistant, MySQL Workbench, PowerDesigner

ERP Application: PeopleSoft Financials 7.5/8.0, PeopleSoft EPM 8.0/8.8

Databases: Access, Oracle, Informix, IBM DB2 UDB, Teradata, Netezza, SQL Server, AS/400, MySQL, Greenplum, PostgreSQL

PROFESSIONAL EXPERIENCE:

Team Leader/Solution Architect/Delivery Manager

Confidential

Responsibilities:

• Managed team of onsite and offshore members in conducting design, development, and testing of business intelligence implementations and solutions.
• Partnered with business teams on defining reporting requirements, and performed as SME for store loyalty program reporting.
• Conducted sessions and mentored team members. Developed BI best practices.
• Entrusted with client management and responsible for project planning, estimations, management and delivery.
• Worked with Teradata Team in migrating the complete reporting database between Teradata platforms
• Provided Subject Matter Expertise (SME) on behalf of reporting team in migrating the application from Netezza to Teradata platform
• Re-engineered the existing Datastage ETL process and optimized the process to reduce the processing time by 30%
• Designed ETL specification and coordinated with development team in developing ETL mappings and packages
• Implemented several BI reporting projects such as Inventory management, Loss prevention analysis, Loyalty program analytics, store reporting, customer analytics, weather reporting, vendor onboarding, Home Services
• Worked with the Hadoop team to generate the data for Analytics
• Standardized the integration process for building the SSIS packages
• Developed Dashboard reporting for Sales, Marketing and Inventory metrics
• Re-wrote the SSIS packages to optimize and reduced processing time by almost 60%
• Built SSRS reports for store reporting and analysis

Environment: SQL Server (2005, 2008, 2012) - SSIS, SSAS and SSRS, Visual Studio, UNIX Shell, MySQL, DB2, Netezza, Teradata, MS Access, Greenplum, PostgreSQL, SQL Assistant, Microstrategy, Python, Control-M, Power Designer, DatastageMahesh A. Patil, Page 2

Data Analyst/Project Lead/Manager

Confidential

Responsibilities:

• As On-Site Project Lead/Manager, supervised team of eight offshore and five onsite personnel.
• Established and managed onsite/offshore model team, and translated client needs into functional requirements for implementation.
• Managed client relationship and updated status to management.
• Mentored and trained team members.
• Responsible for data integration strategy, requirements and business rules documentation, business metrics definitions, data sourcing and quality assurance.
• Created subject area data marts based on functional requirements and designed the ETL process for Cognos reporting
• Conducted technical code reviews for Informatica ETL and Cognos Cubes and reports.
• Implemented several projects like Client Profitability, Global Business Information System, Financial Data warehouse, productivity, Cash flow, Billing, Revenue and time analysis reporting
• Customized the Informatica mappings for sourcing data from peoplesoft ERP system into Informix system.
• Built code to process dimensions and fact for Financial data mart

Environment: Sun Solaris 8, UNIX Shell, Informatica Powermart 4.7/6.1, Informix, Cognos Series 7, Erwin, IBM DB2 UDB, PeopleSoft 7.5, PeopleSoft EPM 8.0/8.8

Sr. Software Engineer/Team Lead

Confidential

Responsibilities:

• Design and Development of Oracle Procedure and functions for the Extraction, Transformation and Loading of Data.
• Development of SQL*Loader scripts for Data Migration
• Develop and test the Database Triggers
• Review the Code, Test Plans
• System Test Planning and Integration testing at Client Site (London, UK)
• Worked on the migration of data from MV/Oracle 7.x to Solaris/Oracle system.

Environment: IBM 3090/VM, Windows-95, EXTRA Mainframe Client 4.2, ORACLE 7.2, Forms 3.0, PL/SQL, PRO*PL/I, REXX, Sun Solaris/UNIX System V, Oracle 7.3, PL/SQL, SQL*Loader, PRO*C