Sohail Rasheed
Associate Director
Old Bridge,New Jersey
Summary
Talented Assistant Director with over Twenty-Six years of IT experience, more than 20 years of experience in Data Governance, Data Quality Management, Analytics, Management Information Systems, Data Modeling, Data Migration, Data Integration, Analytical Development & Business Processes and System solutions. Specialize in developing Business Intelligence and Data Analytic & Integration strategies to improve data quality, reliability and end-user adoption in Manufacturing, Supply Chain and Finance area. Experience in the Pharmaceutical, Banking and IT Industries.
Overview
27
27
years of professional experience
5
5
years of post-secondary education
Work History
Associate Director
Bristol-Myers Squib (Celgene Corporation)
2014.09 - 2023.11
- Govern end-to-end critical data process and support integrity of data
- Work with business and IT team for managing and monitoring data quality using data quality dashboard on TIBCO Spotfire platform
- Ensure that dashboard is measuring updated data standards and business rules created by data owners
- Coordinates efforts with other Global Process Owners and concepts to employ consistent data governance across BMS
- Devise strategies to transform data from disparate data repositories into information to meet GPS’s strategic data, reporting, and analytic needs Design future-state Data Governance and Management program and assist in development of overall Enterprise Data Strategy
- Support Product Master Data Integration process with Global Product Data View (GPDV) for identifying and migrating enterprise level information from Oracle to GPDV and from GPDV to SAP S4
- Work with Global Supply Planning for providing best analytical solution to business using OBIEE and Tableau
- Collaborating with Analytics Team to develop, support, and align strategies in business intelligence and analytics design and development solutions using cloud based and server-based tools
- Work with BMS Data Architecture and Governance, SAP IBP and Rapid Response teams for business operations management from heritage Celgene processes and systems to BMS processes in Product Master Data, Demand Planning, Inventory, Supply Planning and Manufacturing areas
- Work with Business Analysts, BI IT Team, and other systems analysts to analyze business requirements and translate them into Data Warehouse/Business Intelligence (DW/BI) and cloud-based solutions
- Support hCelgene data migration process to AWS S3 Data Lake as subject matter expert
- Deliver business intelligence solutions utilizing various BI tools like OBIEE, Tableau, Business Object
- Design, develop, and implementation of DW/BI solutions using: Informatica, OBIA (ODI), OBIEE RPD business models, and OBIEE dashboards
- Work with business units and IT Analysis team for gathering business requirements and define business and functional specification documentations for IT and DBAs
- Responsible for directing and managing technical team for migration of various Business Object reports to OBIEE platform
- As Oracle Release Manager and Business Process Owners, directs, manages, leads and coordinates all software releases according to system release plan
- Analyze and discuss Data model, data flow and data mapping with OBIEE IT and EBS DBA teams and make sure that standards for technology and business process are established
- Manage weekly, monthly, and quarterly business reporting, working across multiple teams to identify and present high-level analytics to key-stakeholders and executives.
- Assisted senior leadership in managing all aspects of operations
- Communicated all capacity, sourcing and technology gaps with upper management
- Support continuous process and performance improvement for manufacturing issues, robustness and compliance
- Planned, created, tested and deployed system life cycle methodology to produce high quality systems to meet and exceed customer expectations
Assistant Vice President
Lloyds Bank USA
2013.11 - 2014.10
- Responsible for directing and managing technical team as well as working with end users on Business Intelligence and Data warehouse requirements and its best solutions.
- Attended weekly meetings and special sessions of Leadership and Executive Leadership Teams and contributed to major administrative initiatives, policies and decisions
Lead OBIEE Developer
GFI Group LLC
2002.04 - 2013.10
- Developed OBIEE Repository as per user requirements and available information in Data Warehouse
- Analyzed and validated business model in OBIEE Administration Tool and also validated repository level calculations done in business model layer
- Worked on metric dashboards to show KPI for different business users
- Recommended enhancements in ETL processes and Business Models to suite user requirements
- Assembled subject areas and created execution plan and accommodated new Informatica mappings
- Monitored Incremental & Full load through DAC
- Implemented Data Warehouse and Data Mart solutions for GFI trade capture systems
- Used BI Publisher to analyze and develop interactive reports for Marketing department
- Interacted with Business Users for gathering Reports / Dashboards requirements and to define business and functional specifications.
- Analyzed existing systems and databases and recommended enhancements to solve business needs
Consultant
Prudential Financial Inc.
1998.10 - 2002.03
- Participated in analysis, design and development of application that provided for smooth workflow and user-friendly graphical interface
- Responsibilities included designing workflow, developing design elements like forms, views, agents and script libraries
- Implemented security using access control list (ACL) and agents
- Coded different scheduled agents using Lotus Script
- Provided help desk support more than 600 users
- Analyzed and designed entire system workflow with minimum supervision and without team support
- Involved in analysis, design, development, testing and implementation of application
- Coded heavy LotusScript programming in agents and form events for system workflow
- Interacted with client, at all levels, in order to discuss and decide on requirements of client
- Designed prototype before going into full-fledged development.
Consultant
Lucent Technologies
1997.09 - 1998.09
- Member of development team responsible for designing, enhancing, testing and maintaining OMS databases globally
- Deployed both domestically and internationally
- Responsible for analyzing and developing design elements, including but limited to forms, reports and agents according to system enhancement requirements for application
- Coded LotusScript in agents and form events for system workflow
- Created data exchange activities between Lotus Notes to Lotus Notes using Notes Pump (LEI)
- Coded different scheduled agents using Lotus Script and provided help desk support to more than 200 users.
Consultant
Earnst & Young LLP
1997.05 - 1997.08
- Lead, coordinated and supported with a team of OBIEE developers to support BI users on 24 hours’ basis.
- Setup, installed and configured of complete Analytics platform environment OBIEE, Informatica and DAC and required connectivity for seamless integration with data warehouse.
- Analyze and create entity relational & dimensional relational data models with Dr. Ralph Kimball Methodology.
- Analyze Design, and Develop OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
- Created several financial reports using BI Publisher. Use various templates to publish reports as per user requirements.
- Implemented Financial Analytics, Procurement and HR Analytics, integrated data from Finance and other enterprise systems (EBS R12) and transform data using Informatica (ETL).
- Interacted with Business Analysts and Users for gathering and analyzing Business Reports Requirements.
Consultant
IBM
1996.09 - 1997.04
- Participated in analysis, design, development and maintenance of databases for purposes of creating questionnaires, auditing and performing accurate and timely lookups of relevant information pertaining to Ernst & Young’s business clients
- Created and implemented strong security in database
- Developed 'Bug Database' in Notes 4.0 environment for testing team that helped to communicate testing team with Notes developers about application bugs and errors
- As team member, worked for second version of application in Visual Basic
- Wrote customized code to automate transferal of information from MS Access databases via Lotus Notes mail
- Worked on Crystal Reports to generate reports for different audit sections
- Designed and developed Notes database that allowed users to attach and detach all Visual Basic and MS Access files from Lotus Notes server to local hard drive.
Education
Master of Science - Management Information Systems
University of Baltimore
Baltimore, MD 1994.09 - 1996.05
Bachelor of Science - Management Information Systems
Goldey-Beacom College
Wilmington, DE 1990.09 - 1994.05
Skills
- Data Governance
- Data Quality Management
- Data Analyst
- Data Integration
- Analytic Development
- Business Intelligence
- Programmer
- Project Management
- Agile
- Systems Design & Development
- Database Management
- Analytical Thinking
- Process Improvement
- Database Coordination
- Database Development
- Integration Strategies
Tools
- OBIEE
- Tableau
- TIBCO Spotfire
- Business Object
- COGNOS
- Power BI
- Work Day HCM
- Informatica
- HP ALM
- JIRA
- ServiceNow
- SQL
- PL/SQL
- JavaScript
- Java
- Python
- XML/XSD
Databases
- Oracle
- SAP HANA
- MS Access
- Lotus Notes
Timeline
Associate Director
Bristol-Myers Squib (Celgene Corporation)
2014.09 - 2023.11
Assistant Vice President
Lloyds Bank USA
2013.11 - 2014.10
Lead OBIEE Developer
GFI Group LLC
2002.04 - 2013.10
Consultant
Prudential Financial Inc.
1998.10 - 2002.03
Consultant
Lucent Technologies
1997.09 - 1998.09
Consultant
Earnst & Young LLP
1997.05 - 1997.08
Consultant
IBM
1996.09 - 1997.04
Master of Science - Management Information Systems
University of Baltimore
1994.09 - 1996.05
Bachelor of Science - Management Information Systems
Goldey-Beacom College
1990.09 - 1994.05
Similar Profiles
ALBERT NEGRONALBERT NEGRON
C&Q Consultant at BRISTOL MYERS SQUIBC&Q Consultant at BRISTOL MYERS SQUIB
TIESHA DIMAGGIOTIESHA DIMAGGIO
OCM Lead at Bristol Myers SquibOCM Lead at Bristol Myers Squib
Anthony OnuohaAnthony Onuoha
Senior Quality Manager II at Celgene/ Bristol Myers SquibbSenior Quality Manager II at Celgene/ Bristol Myers Squibb