PROFESSIONAL PROFILE:

Confidential is a data analyst / consultant with experience in Data Analysis, Data Migration, and Visualization. He is well versed with several different tools and technologies including SAP Business Intelligence product suite, Tableau, Microsoft BI and other ETL tools.

SUMMARY:

• IT professional with strong concepts and experience in Data Warehousing, Database Analysis, Enterprise Data Management, Business Analysis and Project Management.
• Well - rounded experience in architecture, administration (management), development of SAP Business Objects Product Suite.
• Experienced with analysis and migrating data using cloud and on-premise databases like MS SQL Server, Oracle.
• Experience in Microsoft Power BI Dashboard development and creating visualizations with Tableau.
• Well versed in data integration and migration strategies using SAP SSIS, Informatica Power Center and SQL.
• Proficient in requirements gathering, systems design, user-interface design and system architecture.
• Ability to work independently, and within a team environment.
• Excellent written and verbal communication, documentation skills, team player and the ability to work across organizations to achieve results with minimal handholding.
• Working knowledge of Agile and Scrum Methodologies.
• Exposure to several industry verticals including government, investment banking, finance, mortgage, wealth management, government, accounting, energy, manufacturing etc.
• Strong customer focus and relationship management skills. Strong leadership and project management skills.

TECHNICAL SKILLS:

Business Intelligence and Analytics tools: Industry Leading BI tools like SAP Business Objects, Microsoft Power BI, Tableau

SAP Business Objects: SAP Business Objects Universe design and development, Report development, Administration, Migrations SAP Business Objects Dashboards using XCelsius, Dashboards 4.1, Lumira

Tableau: Data visualizations and dashboards

Microsoft BI: Microsoft Power BI, Azure Analytics (Power BI + Azure Data Services), Azure Data Factory, SQL Server SSIS - SSRS,SQL Server Analysis Services

Data Integration, Data Engineering and ETL tools.: Informatica, SAP Data Services, Microsoft SSIS, Informatica Power Center

Databases: Relational - Oracle; MySQL, MS SQL Server, DB2, Cloud-based - Azure (MS SQL Server and Cosmos DB)

Programming Languages: SQL, TSQL

Project Management and Process Control: Project Management Professional (PMP)

Data Management and Metadata management: Data Modeling tools - Toad, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Senior Consultant: Data Analysis, Data Migration and Business Intelligence

Responsibilities:

• Presently working on a long-term contract developing the Integrated Transportation Information Platform (ITIP), a virtual data warehouse and data visualization that incorporates a variety of reporting and analytical functions pertaining to the data maintained in multiple core FHWA source systems including National Bridge Inventory, Highway Performance Management System, and Financial Management Information system.
• Utilize ETL tools like MS SSIS, Informatica PowerCenter for migration of data to the ITIP system.
• Lead technological advancement and initiative, ITIP 2.0 to upgrade the systems underlying data services (interfaces) to Informatica PowerCenter and other related tools. Also, lead development effort for migration of the ITIP platform to Microsoft Azure cloud.
• Subject Matter Expert (SME) for ITIP 1.0 and 2.0 processes, architecture and engineering.
• Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
• Developed the ITIP platform and dashboards using advanced T-SQL, SAP Business Intelligence product suite, stored procedures, functions involving complex business logic and large volume structure and non-structured data sources.
• Develop business continuity plan, including monitoring system, capacity planning, disaster recovery plans, database architecture etc.
• Translate business data needs into creative visualizations in BusinessObjects Dashboards, and Microsoft Power BI.
• Work with cross-functional teams on the day-to-day execution of data & analytics projects and initiatives.

Confidential, Washington, DC

IT Consultant: Data Analysis, Business Analysis, Business Intelligence

Responsibilities:

• Perform and document data analysis, data validation, data mappings, by accessing multiple sources.
• Involved with development, testing and performance tuning key components of the SAP BusinessObjects system.
• Lead development team to Extract, Transform and Load (ETL) to the PHIS database.
• Instrumental in securing the initial contract for Confidential and subsequently, in extending the project for five-year.
• Work involved development and creation of SAP BusinessObjects Web Intelligence reports, Dashboards, Universes.
• Provide SAP BO training to users and maintain operations documentation.
• Maintain day-to-day operations of the reporting environments. Resolve assigned Level 3 tickets on Business Objects issues in BI 4.0/4.1 production, test and development environments within defined SLA's.
• Work and partner with government clients and IT teams to develop reports or address data needs.
• Synthesize and translate Business data needs into creative visualizations in SSRS, Tableau and Power BI.
• Develop, maintain and manage advanced reporting, analytics, dashboards and other BI solutions using mainly Tableau but not limited to it, which includes other reporting tools like Business Object, and BI tools etc.

Confidential, Owings Mills, MD

IT Consultant: Data Analysis, Business Analysis, Business Intelligence - Visualization, Database migration

Responsibilities:

• Worked on the several project initiatives including the GISbusiness intelligence project and the data architecture team.
• Developed multiple executive dashboards and several Web Intelligence Reports for the GIS team using SAP Business Objects XI R3 toolset.
• Involved with day to day administration and management of the SAP Business Objects consolidation project.
• Develop dashboards and reports that represent business (Wins, Losses, Opportunities, Trends over years, Assets under Management) through various dimensions so that the executives can better evaluate their clients and business.
• Involved with development of GIS data martin a fast pace Agile Scrum development environment.
• Created and documented multiple Web Intelligence reports, dashboards and Universes.
• Created and troubleshoot complex Web Intelligence reports and SAP BusinessObjects Dashboards
• Create ETL jobs using Informatica PowerCenter.
• Perform and document data analysis, data validation, data mappings, by accessing multiple sources.

Confidential, Exchange Place, NJ

Business Intelligence Consultant: Data Analysis, Dashboard Development

Responsibilities:

• Worked as part of the IT Finance group developing a strategic BusinessObjects reporting platform called STRATA.
• Involved with several small and large size SAP BusinessObjects projects initiatives working in different capacities including developer, architect, administrator and technical co-coordinator.
• Act as a liaison between the core BI Technology team (maintains BOE infrastructure) and end users, coordinating migrations and other technical issues.
• Spec and design complex universes and reports in close coordination with an International user group.
• Interface with the International support team (Singapore) for troubleshooting Business Objects technical issues.
• Performed administrative tasks - security, access control, monitoring, report automation and troubleshooting.
• Involved with higher level decision and strategic planning for the STRATA environment. Implemented the architecture and guided the low-level design and specifications of the SAP Business Objects Enterprise platform.
• Participated in change control and provide impact analysis for any change requests.
• Developed complex OLAP universes and WEBI reports for the GMIS Initiative.
• Designed and developed a strategy for archiving and retrieval of legacy Lehman PeopleSoft data

Confidential, Washington, DC

Lead Consultant: BI Development, administration and architecture

Responsibilities:

• Worked as senior consultant developing reporting solutions using BusinessObjects Enterprise XI.
• Interface with the data services (Data warehousing) and infrastructure team in Tarrytown NY for data and infrastructure requirements.
• Exhibit strong knowledge of SQL and Oracle 10g.
• Required to wear several hats at the same time, including BusinessObjects XI report designer, universe designer, administrator and Architect.
• Conduct training session, demo and workshops for technical as well as non-technical users.
• Involved in Architecture, design and implementation of BO XI reporting solution for Confidential eTIMS ticket processing system. The system processes over 16 million parking, moving and photo tickets across multiple US cities.
• Conducted JAD sessions with end-users from different law enforcement agencies like MPD (Metropolitan Police Department), DPW (Department of Public Works) and DDOT (District Confidential ) in the Washington DC area to gather reporting requirements.

Confidential, New York, NY

Lead Business Objects Administrator / Developer

Responsibilities:

• Implement several projects in different capacities (SAP BusinessObjects technical architect, administrator, report developer and universe designer) for the Global Wealth Management Division of Confidential .
• Involve with all aspects of software development lifecycle including architecture, development, migrations, upgrades, troubleshooting and maintenance of the BOE XI R2 platform. Designed the BusinessObjects self-serve universe in coordination with the data modeling team.
• Support and interact with business users and other developers in a team lead capacity.
• Conduct Business Objects training and workshops.
• Perform project management and coordination tasks in conjunction with the delivery managers.
• Work with the business users and silos to gather reporting and universe development requirements.
• Design and coordinate the development of the self-serve and canned universe and reports for the revenue reporting and assets reporting project.
• Coordinate development efforts with onshore and offshore (TCS) development team.
• Involved in design of logical and physical data model, data acquisition and data validation.
• Involved in detailed discussions and decision of Teradata Semantic Layer development efforts.

Confidential, Washington, DC and Reston VA

Business Intelligence Architect, Data Architecture

Responsibilities:

• Lead Business Objects development, migration and enhancement initiatives (projects) with a focus on administration and architecture.
• Successfully implemented several small and large BO projects from start to finish, in addition to performing the day-to-day operations of the BI team.
• Provided technical leadership and guided the Business Objects 6.5 to XI R2 migration project. Performed the following tasks as part of the BO XI R2 Migration effort
• Performed assessment (GAP analysis) of the current BO 6.5 environment and presented the findings to the management. Assessed architecture, upgrades, operations, contingency planning, and report delivery, regulatory compliances like SOX.
• Developed the overall technical and project strategy (approach) as a Business Objects technical architect.
• Performed the following project management related activities for other BO Enterprise projects.
• Developed and maintained project plans and schedules, scheduled status meetings in collaboration with the Sr. Manager. Maintained change control processes using Remedy. Maintained project documentation using Mercury Quality Center.
• Coordinate hardware and software acquisition and procurement.
• Developed project charters to include all elements ensuring that project scope, costs, resources and timelines are consistent within the overall planning mix.

Confidential, Baltimore, Maryland

Business Intelligence Consultant

Responsibilities:

• Lead developer in a project team environment with responsibility for directing the day-to-day issues and related activities of team members.
• Involved in day-to-day maintenance and operations of the SAP BusinessObjects Enterprise platform.
• Lead Business Objects developer implementing reporting solution for several high-profile projects.
• Implemented over 15 small, mid-size and large size BI (primarily Business Objects) initiatives and projects.
• Lead and executed the Business Objects upgrade initiative (Release 5.1.4 to 6.5.1). The scope of the upgrade included 70+ universes (applications) and over 600 WEBI and Full Client reports and over 2000 Users.
• Performed team lead role in the largest financial consolidation project within Confidential called “PYXIS”, spearheading the implementation of the core financial reporting requirements.
• Performed lead roles on several other projects including migrations from 5.1.4 to 5.1.7 and then from 5.1.7 to 6.5.1, PeopleSoft HRMS reporting project, Training Management Systems (TMS) project, Magic reporting project, and Mercury ITG reporting project.
• Worked with Oracle Applications 11 modules like Project Accounting (PA), Purchase Orders (PO), Accounts Payable (AP), General Ledger (GL), and Inventory (INV).
• Perform Data analysis and ETL mapping processes using PL/SQL.

Confidential, Riverside, CA

Lead Consultant: Business Analysis, Data Analysis and Development

Responsibilities:

• Provide technical leadership in system design and approach using BusinessObjects 6.5.1 / XI R2 toolset.
• Involved in planning day-to-day activities, mentoring development team and developing project plans for BO development efforts.
• Provide guidance for corporate wide BI strategy.
• Architect, designed and developed a corporate wide planning process dashboard using Business Objects Application Foundation 3.0, BusinessObjects Web Intelligence, Set Analyzer, SQL Server 2000, Oracle 8i and MS DTS. The Dashboard provides a real time view of critical key performance indicators (KPI’s) that help make informed decision in the planning process.

Confidential, Cincinnati, Ohio

Software Engineer

Responsibilities:

• Implemented Business Objects reports in Web Application using WEBI API/SDK.
• Designed, developed and maintained the BrandPulse product and other components in the Brand Pulse Framework using different web and component technologies like XML, XSLT, ASP, Visual Basic (VB 6.0), COM, DCOM, and COM+.
• Implemented reporting requirements using Business Objects 5i - report writing using Business Objects Full Client and Web Intelligence Ad hoc reporting environment, modeling the meta-data schema (Universe) using Designer; developing the security model using Supervisor; and customizing / embedding BO reporting into applications using the WEBI API.