SUMMARY:

• Over 17+ years of progressive IT experience (Developer, Data Analyst, Solution Architect & Manager) with a background in data delivery business intelligence(BI) reporting and analytics, data governance (data quality, data completeness), Data Integration (ETL), Data Storage ( DW/ODS) with full life - cycle data warehouse and BI development & Production support. Capable of managing numerous projects while leading cross-functional DW/BI teams Confidential meet and exceed overall IT initiatives. I have the ability Confidential lead a group, take initiatives, make decisions, work and inspire a team Confidential meet deadlines, handle crises as part of team management skills.
• Overall 17+ years of IT experience which includes 14 years of experience in Data Warehousing & Business Intelligence (BI) solutions.
• 14 years of experience implementing DW/BI Reporting & Analytics experience handling different responsibilities as SQL Developer, BI Reporting Developer, BI Project Development Lead, DW/BI Production Support lead, BI Technical Architect, BI Solution Architect, BI Consultant during last 12 years for client Confidential & Confidential .
• 10 years of managing and leading offshore/onshore data warehousing and Business intelligence teams including ETL development team, MicroStrategy & Business Objects development & Production team, requirement team and database DBA team.
• 7+ years of data warehousing (DW) and Business Intelligence (BI) Solutions experience as Sr. Solution Architect / Sr. DW/BI Consultant / Sr. Technical Architect / Sr. Analytics and Reporting Architect
• Excellent analytical, problem solving, time management and organizational skills
• Hands-on development & Support experience
• 5 years hands-on development experience in Business Objects 5.x, 6.x, XIR2/R3/4.0/4.1
• 5 years hand-on production support lead managing Business Objects and MicroStrategy support teams.
• 5 years MicroStrategy Administrations experience as part of MicroStrategy platform support
• 5 years hand-on development hand-on experience in ETL tools like Datastage and BO Data Services
• 14 years of SQL Programming skills in Oracle 11g, Teradata 13x/14x, MS SQL Server
• 2 years of hands on experience in developing web based applications with ASP, XML,XSLT, HTML
• Hands on and Architecture Experience: RDBMS Oracle, Teradata, MS SQL Server, MicroStrategy, Business Objects, Tableau
• Architected and Directed Implementations:
• Business Intelligence: MicroStrategy, Business Objects, Tableau
• Data Warehouses: Oracle, My SQL Server, Teradata
• Data Integration: IBM Datastage and BO Data Services (BODS)
• BI Practice Development, Business Case Development, Mentoring and Team Development, Waterfall and Agile Management tool like CA Rally
• 5 years of experience in Big Data/Hadoop Data Platform data lake sources like Hive with Kerberos, Spark, Pig and Data Warehouse appliances data sources like Aster, Vertica, Netezza, Oracle Exadata and NOSQL Stack like Cassandra, MongoDB etc.
• Solid experience on writing proposals, presenting data warehouse solutions, developing BI strategies/Roadmap, Data Governance of Data warehouse/data marts and BI Tools/techniques
• Knowledgeable on new and emerging technologies and technical approaches (Big Data, Data Discovery, Data Visualization, Data Science, etc.

SKILLS HIGHLIGHTS:

• BI Solution Architect BI Development/Production Support IT Project Management
• Solution Architect BI Infrastructure Support and Administration IT Delivery Management
• Data Governance BI Strategy and Roadmap

WORK EXPERIENCE:

Confidential

Solution Architect / Sr. DW/BI Architect

Responsibilities:

• Providing technical leadership Confidential MicroStrategy platform team both production and non-production, Business Objects delivery teams including requirement, development, testing and support teams for Architecture Roadmap, best practices, processes and development standards
• Provides thought leadership on best practice data governance/ownership, data warehouse, data integration, data modeling, and BI analytics reporting methodologies and approaches
• Manages the development and operations of the firm's business intelligence architecture, operational data stores, and data warehouse. Provide technical oversight and guidance Confidential the various teams
• Recommends and implements delivery mechanisms that enable data analysis and reporting solutions Confidential facilitate business decisions
• Leads projects Confidential deliver new business intelligence capabilities Confidential the firm; manage project resources, timelines, issues, and risks
• Architecting MicroStrategy & Business Objects projects from end Confidential end using standard SDLC and Agile processes and standards.
• Engaging and reviewing deliverables from requirement team, development, testing and support team during various phases of reports, dashboard and scorecard solutions and implementation/support.
• Provides technical architecture support, Conceptual/Logical/Physical data modelling using Star Schema, Snowflake guidance Confidential MicroStrategy/ Business Objects delivery teams across multiple projects.
• Provide guidance, lead, mentoring and facilitate collaboration among DW/BI delivery team members.
• Ensure team follows best practices in report/dashboard development and implement standard security model across MicroStrategy/Business Objects platform.
• Provides day Confidential day guidance Confidential project teams Confidential capture effort estimation, envisioning, proposal development, and successful delivery within time, budget and quality.
• Leads projects Confidential deliver new business intelligence capabilities Confidential the firm; manage project resources, timelines, issues, and risks
• Management of vendors & external contractors including related budgets, timelines, deliverables, SLA’s, etc.
• Gather and analyze requirements for BI reporting projects and data requests in MicroStrategy/Business Objects. Define and initiate MicroStrategy/Business Objects requests for business stakeholders
• Assess and recommend data platform governance as data quality, metadata and performance management.
• Define & drive adoption of DW/BI standards, processes and best practices
• Develop prototypes and storyboards Confidential facilitate requirements definition
• Engage teams like ETL, Application Database DBA and Hadoop Data lake team for various reporting data sources needs like Confidential & Confidential Data Lake Hortonworks Hadoop Ecosystem for Hive, other data sources like Vertica, MongoDB, Oracle, Teradata, Aster, SQL Server, MySQL, Netezza etc.
• Facilitate Dev, QA and UAT, Prod activities with business and BI Delivery teams
• Partner with delivery teams for standard delivery documentation including requirement, design, development and testing, maintenance and procedure for support teams during each SDLC cycle or Agile Stories.
• Prioritize and validate all MicroStrategy/Business Objects requests with the business
• Ensure quality delivery of MicroStrategy/Business Objects deliverables (projects, tickets)
• Manage stakeholder communications, status, and expectations for MicroStrategy & Business Objects delivery

Environment: Reporting Tools: MicroStrategy 9.4.1 / 10.2, SAP Business Objects XI 4.1,ETL: SAP BO Data Services 4.1,IBM Datastage 8.7

RDBMS: Sybase 12.5, Oracle 11g, SQL Server 2008, Teradata 14.0, Aster 6.0NOSQL DB: MongoDB, Netezza, Vertica 7.2Big Data Platform: Hortonworks Hadoop Big Data Platform with like Hadoop Cluster, Hive, Kerberos, Hive, Spark, Red Hat Linux

Confidential

Sr. Technical Architect / Sr. Solution Architect / Sr. Reporting Lead / Sr. Project Development & Production Lead

Responsibilities:

• Facilitator Confidential Customer ( Confidential & Confidential ) as an interface between onsite and offshore teams of various sub-vendors and client stakeholders.
• Be an interface between offshore delivery team and customer ( Confidential & Confidential )
• Be responsible for customer signoff on end deliverables
• Support production releases during weekends
• Technical management of production and development teams Confidential provide BI Solutions delivery.
• Production support of reporting applications by providing ticket resolution and troubleshooting ongoing issues with user base of around users.
• Architect, design, implement end- Confidential end BI solutions and the required supporting architecture (DWH)
• Define technical solution approach and architecture for solving complex data management and transformation problems
• Ensure best practices and standards of DWH/BI solutions
• Conduct and lead white-boarding sessions, workshops, design sessions, and project meetings as needed, playing a key role in client relations
• Technically Managed and guided BI teams including teams like ETL, Reporting and QA with hands on SAP BO
• Ensure project deliverables in time and within budget during each project releases.
• Lead in on-going evolution, improvement, and automation of business intelligence solutions

Environment: SAP Business Objects XI 3.1, Xcelsius, MicroStrategy 9x, Legacy reports in ASP, VB Macro/Scripts., Oracle, SQL Server, Teradata, SAP BO Data Services 4.1,IBM Datastage 8.7

Confidential

BO Team Lead & Onsite Co-coordinator

Responsibilities:

• Facilitator Confidential Customer ( Confidential & Confidential ) as an interface between onsite and offshore teams of various sub-vendors and client stakeholders.
• Be an interface between offshore delivery team and customer ( Confidential & Confidential )
• Be responsible for customer signoff on end deliverables
• Participate in preparation of technical requirements, high level design and detail design of Confidential
• Involved in design and developments of Business Objects reports
• Develop Business Objects universes, reports development and enhancements.

Environment: Business Objects 6.5, Oracle 10g, Unix, Shell & Perl Scripting

Confidential

BO Lead Developer

Responsibilities:

• Leading and coordinating with client team Confidential gather the new requirements and working with existing issues.
• Lead BO development calls with project team, participate/review in SR and HLD documents review calls
• Create and develop detailed design document and review documents.
• Develop Business Objects universes, reports development and enhancements.
• Performed unit testing and support ST and UAT defects for universe, reports and security management.
• Developed universe user documentation guide for the end users reference.

Environment: Business Objects 6.5, Oracle 10g, MS SQL Server

Confidential

BI-DW Lead / ETL Developer / Sr. SAP Business Objects Developer

Responsibilities:

• Leading a team of 2 ETL developers and 3 Business Objects developers and coordinating with client team Confidential gather the new requirements and working with existing issues.
• Developed Datastage job/code in support of the data warehouse and Business intelligence initiatives
• Monitor the ETL daily loads and performance tuning of Datastage Jobs and BO Reports
• Contributed Confidential the design and development of the Enterprise Data Warehouse
• Designed, developed, migrated and deployed complex Business Objects Universes
• Design and development of Business Objects reports and dashboards using Xcelsius
• Monitor the ETL daily loads and performance tuning of Datastage Jobs and BO Reports
• Provided production support for Datastage applications and Business Objects Reports/Universes
• User CMC( Central Management Console) and Linux Confidential perform Business objects BI administration including managing universes, user/groups, reports and security model Confidential objects.

Environment: Business Objects 5.1.3, Datastage 7.5, Sybase 12.5, Oracle 9i/10g, Unix/RHEL Linux