We provide IT Staff Augmentation Services!

Resume

Business Intelligence Architect Lead Developer Houston, TX

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.

Hire Now