PROFESSIONAL SUMMARY:

• Lead Business Intelligence developer /Architect with 17+ years of versatile experience in software industry. A unique experience including BI Development, Design, Architecture, Consulting, Team lead, Onsite/Offshore coordination and Product development with strong focus on customer BI needs. Proven experience in implementing enterprise level Data Warehouse, BI /Reporting and Data Visualization solutions globally.
• Solid experience with IBM Cognos BI Tool suite, TIBCO Spotfire 6.x,7.x and Tableau 8.x,9.x/10.x with a profound understanding of MS Power BI, Microstrategy 9.x and SAP Business Objects.
• Proven experience in Business Intelligence, Data Visualization and Analytics (Operational, OLAP)
• Capturing the requirements for Reporting and Analytics projects and documenting them
• Develop BI prototypes and mockups of Reporting/Analytics requirements
• Design the semantic data models (ERD) designed to meet large scale enterprise Data Warehouse design
• Advanced SQL and Database programming skills using RDBMS (SQL Server, Oracle, IBM DB2, Sybase) and Postgres databases (MySQL, Amazon Redshift)
• Profound knowledge of statistical Analytics solution (Artificial Intelligence) and its integration with BI
• Design/Document the test cases and overall testing plan for reporting solutions
• Extensive communications abilities & Team building skills
• Managing Onshore/Offshore Development teams
• Driving enterprise BI Architectures/Technology upgrades and infrastructure

TECHNICAL SKILLS:

BI/Visualization: IBM Cognos BI Suite, Tableau (8/9/10), TIBCO Spotfire 6.x,7.x, QlikView, Microstrategy 9.x, MS Power BI and SAP Business Objects

ETL: Informatica, SQL Server SSIS, Alteryx

RDBMS: Oracle 8i/9i, SQL Server 2008/2012,Teradata 12/13, Sybase 12.0., Amazon Redshift, MySQL

Data Modelling: Erwin Designer 3.5/4.0,Embarcadero E/R Studio 9.1

Languages: SQL, PL/SQL, UNIX Shell Scripts, HTML,R,Python

Scrum Tools: Rally, Mingle

Cloud: Amazon Web Services (EC2,QuickSight,Redshift )

CRM: SalesForce, Zuora (Billing)

Customer Care: Zendesk Support

PROFESSIONAL EXPERIENCE:

Business Intelligence Architect /Lead Developer

Confidential, Houston TX

Responsibilities:

• Lead role in customer interaction on reporting /BI product requirements, development planning and Documentation
• Develop BI prototypes and mockups of Report/ Dashboard requirements
• Design the semantic data models (ERD) designed to meet large scale enterprise Data Warehouse design
• Define and lead the development of Tableau / TIBCO Spotfire based Dashboards and interactive reports
• Sole owner of corporate financial/product metrics (TIBCO Spotfire and Tableau based dashboards) delivered to the CEO and other A - Level Executives
• Lead role in BI architecture /governance and data infrastructure on AWS based databases (MySQL, Redshift,Teradata) / SaaS products
• An integral technology leader, pushing both strategic and operational aspects of the business and ensuring monthly, quarterly and yearly targets are met
• Lead role in designing /documenting the test cases and overall testing plan for reporting solutions
• Product & Release announcements internally and with end customers

Business Intelligence Architect /Lead Developer

Confidential, Houston, TX

Responsibilities:

• Sole owner of MS SQL Server Data Warehouse Data model and design (ERD)
• Lead role in customer interaction on reporting /BI product requirements and development planning
• Develop and deploy working prototypes of Cognos reports and TIBCO Spotfire dashboards for development team
• In charge for technology roadmap, infrastructure and upgrades (MS SQL Server and IBM Cognos)
• Lead the development team for BI (ETL and reports) for direct customers
• Sole owner of corporate financial/product metrics (TIBCO Spotfire based dashboards) delivered to A-Level Executives
• Lead role in BI architecture /governance and data infrastructure on web based products (self-hosted and Customer on-prem)
• Managing & Overseeing Global Agile/Scrum development team (product owner role)
• Driving enterprise BI Architecture, Product Roadmap & Strategy
• Design/Document the test cases and overall testing plan for reporting solutions

BI Architect & Team Lead

Confidential, Richardson, TX

Responsibilities:

• In-charge of Production Rollouts and Production Builds ensuring the proper documentation, versioning and all other pertinent details for the build
• Gathering the requirements for Reporting and Dasboarding projects and documenting them
• Develop BI prototypes and mockups of Reporting/Analytics requirements
• Design the semantic data models (ERD) designed to meet large scale enterprise Data Warehouse design
• Data modeling (ERD), ETL Mappings and Database design
• Lead Joint Application Development (JAD) activities, including requirements gathering and analysis, specification development, and solution design.
• Owned the design and development of Enterprise Marketing Scorecards and Dashboards for top executives

Senior BI Consultant & Onsite Team Lead

Confidential, Dallas, TX

Responsibilities:

• Responsible for Onsite-Offshore Global Delivery Management
• Design/Document the test cases and overall testing plan for reporting solutions
• Develop and deploy working prototypes of Cognos reports
• Ensuring report deliverables are consistent with business requirements and are on time.
• Training/Coaching offshore reporting team on Advance concepts in Cognos reporting, organizational standards, and development processes and procedure.
• Responsible for managing product related issues with Cognos support team

BI Consultant & Onsite Coordinator

Confidential

Responsibilities:

• Coordinated the development work with other modules leads and developers.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Reporting System using Cognos EP Series7.0.
• Data Transformation and loading using PL/SQL in Sybase 12.0.

Lead Software Developer (BI)

Confidential

Responsibilities:

• Lead Cognos Developer involved in Design of Cognos Impromtu Reports using Cognos EP Series 7.0.
• BI offshore report developer/Module lead using Cognos 6.x/7.x & Oracle 8.x/9.x
• Database development using Unix Shell scripting and Oracle 8.x
• Involved in testing and delivery process
• Received training on CMM 5 and Six Sigma

Software Developer

Confidential

Responsibilities:

• Enhancement and Development of PayCalc (Centralized Payroll System)
• Product development, Unit Testing and Debugging using Visual Basic 6.0 and Oracle 8i.
• Enhancement of Paycalc system for modules like IT FORM-16, Non-JV Earnings and Employee Settlement.
• Involved in development of database objects mainly Functions and Procedures using PL/SQL.