ASIF SAIYED

• Environment : Informatica, Python, Oracle, UNIX, Linux, Control M, IBM JCL, IBM Optim, IBM DB2 Database, ICEDQ and Delphix
• Highlights: Leading Data Governance and Data Masking project by hands on working and collaborating with team of consultants, vendor and employee to mask sensitive client information and data
• Data Masking is done through Informatica and IBM Optim
• Project involves Data Modeling and data to understand the level of granularity of data available in Mainframe and DB2 database
• Provide direction on future state technical and operating model roadmap
• Participating in development, deployment and auditing of masking workflows within Informatica
• Communicate Audit and Masking Results to other groups (Development Teams, ISO, Environment Engineering and Service Desk) as required
• Report status identify issues/ risks proactively and provide alternative plans for recovery to project manager
• Develop Informatica Mappings Pipeline to extract data from IBM mainframe, Oracle, SQL Server and flat files
• Provisioned and Configured Virtual Database using Delphix
• Automating ETL Data Comparison and Data Validation using ICEDQ
• Migrating Data to Nextgen Cloud Platform
• Configuring ICEDQ on AWS
• Managed the data warehouse architecture and data integration processes for multiple clients on AWS Cloud Platform
• Advise and implement ‘Best Practices' for ETL in complex and multi-developer system including processes for code migrations and configuration controls
• Taking care of Data governance initiatives and Data Masking
• Documenting the stories and plan the sprints to complete the development.
• Collected data from wide-ranging sources
• Optimized BI reporting capabilities for secure server environment
• Maintained proficiency with latest database technologies
• Created data analysis tools to allow teams to query acquired information for unique details
• Developed intelligence-sharing dashboards, providing company-wide access to collected data

• Steered wide-scale initiatives in Implementation, Integration and Upgrade of Siebel CRM Sales and Marketing module for Consumer health to enable new functionality for ease of business and stake holders, this upgrade helped to enabled Customer-oriented reforms and Digitization
• Prepare architecture documents for projects assessed by peers and architecture review boards, comprising physical, logical, data, sequence and integration diagrams
• Stakeholder interaction and management for business design document
• Manage Team size of 4 resources of multiple skill sets
• Design and mitigate risks involved with the migration and upgrade
• Product and license procurement for the business needs.
• Updating and Integrating Siebel Interfaces.
• Integrating CRM with Business Intelligence Reporting.
• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding on boarding processes
• Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence
• Created data analysis tools to allow teams to query acquired information for unique details

• Leading engagements for Education clients with a team of consultants to perform and Develop solutions for
• School reporting, designing and development of Reports, Visualizations and Dashboards
• Develop Reporting Solutions for K12 School Reporting
• Lead the project to provide Production Support incidents on User day to day support needs
• Lead the team for flow of data from source to target for historical reporting
• Building Data Warehouse to Analyze Data to enable better business and strategic decisions
• Integrating Oracle E Business Suite with Oracle BI Apps
• Taking care of Business Requirements.
• Developed and implemented data governance policies and procedures
• Developed data mining algorithms to identify and classify patterns in data
• Updated and developed scripts and queries to extract and analyze data from multiple sources
• Created data models to support decision-making processes
• Developed complex dashboard and reporting tools to track business performance metrics
• Utilized data visualization tools to effectively communicate business insights

• Business intelligence development solution for Large Hospital Network with Multiple Facilities and Units across Multiple Locations and Facilities.
• Provided Highly customized solution on Profitability and Professional Billing Analytics giving senior leaders to analyze financial statistics of hospital
• Also, project extended to rendered business specific KPI metrics for ED & pre-built data model that will serve all business and clinical units aims to crystallize KPI's in user friendly dashboards
• Data Model delivers enterprise level solutions that create daily awareness of trends and variances.
• By linking operations, finance, quality staffing, payroll, ED, productivity and core measures executives and leaders can now intervene with confidence on cost over runs, avoid bottlenecks and increase patient satisfaction and safety with increased though put
• Socialized and harmonized the target state architecture of data source by bringing consensus of various stakeholders from Program, Application, Technology, and Security executives
• Interacting with business stake holders for gathering requirements and delivering key metrics KPI
• Collaborated with the development team to design and implement custom data visualizations tailored to specific business needs
• Conducted data analysis to identify trends, patterns, and opportunities, resulting in optimized business processes and increased revenue by 15%
• Collaborated with cross-functional teams to identify data requirements and ensure data integrity across various data sources
• Developed Core Performance Metrics for ED and Emergency Dashboards
• Led the development and maintenance of Epic data models and reporting solutions, ensuring accurate and timely access to critical healthcare data
• Implemented and managed the Epic Clarity data repository, enabling efficient data extraction and reporting for various clinical and operational departments.
• Coached team members in techniques necessary to complete job tasks
• Designed strategic plan for component development practices to support future projects
• Developed monthly and daily production output plans to deliver on customer service and financial metrics
• Analyzed unstructured information to derive key insights.
• Reviewed program implementation plans to assess risk and feasibility.

• Documenting Business Requirements
• Develop BI Solutions
• Analyzed business requirements and functional specifications.
• Used Informatica Power Center 9.0.1 for extraction, transformation and load (ETL) of data in data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with logic embedded in mappings.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Data Modeling recommendations, methodologies and best practices
• Implement and Develop Business Intelligence Dashboard Report's User Authentications, Object Security and Data Security using Web logic Server and Security Manager.
• Prioritized projects and project tasks depending upon key milestones and deadline dates
• Developed custom solutions based upon clients' strict requirements
• Exceeded customer requirements with accurate and deliverable solutions

• Managing Cross-Functional Project Teams of Business and Technology.

• Involved in Data Modelling Activities and Data Profiling to design Target Warehouse using Erwin.

• Designed Dimensional Model of Fact & Dimensions through Data Modelling of source applications.

• Experience in Sizing and Capacity Planning. Ensure that BI system configuration, physical hardware, network, Database and BI Model requirements are sized properly.

• Review and obtain sign off on data models from architecture and other supporting organization.

• Designed and Tested Reports in Dashboards for Oracle Financial Analytics modules like GL, AP, AR and created Adhoc report according to the client needs to Support Liquidity Risk Reporting.

• Strategy & Balance Sheet Planning Liquidity Risk Management Framework.

• Liquidity Measurement - Management Metrics, Operational Limits, Fund Transfer Pricing, Cash Flow Forecasting.

• Analyzed problematic areas to provide recommendations and solutions
• Created monthly forecast templates and resource management allocations for approved projects

• Documenting requirements and implementing BI project for strategic reporting
• Requirement Gathering
• Building Dashboards and Visualization for strategic Reporting.
• Configuring Single sign on and LDAP
• Project Initiation and Planning.
• Data Extraction and Data Load.

• Taking care of Business Requirement for Stock Exchange Company and develop Business Intelligence Solutions for Reporting.
• Interacting with clients, Vice President, and sponsors.
• Handling and driving engagement of technical solutions team and stakeholders.
• Participated in DR exercise for couple of time as DR Manager / DR coordinator for multiple applications.
• Perform project initiation task which includes supporting/performing Risk Evaluations, Business Case development, and creating official Project Charter
• Handled massive quantities of business intelligence data, personally managing as much as 50 terabytes

• Taking care of Business Requirement for Business Intelligence Development Project.
• Developed Data Model for Strategic Reporting.
• Creating Enriched Visualizations.
• Monitor and Automate Data Loads.

• Taking care of documenting business requirement for Siebel CRM for Automobile manufacturer Tata Motors
• Taking Business Requirements pertaining to order Management.
• Integrated Siebel CRM for Reporting Needs.
• Implementing Siebel CRM at Dealer Network.
• Assessed data modeling and statistics to integrate high-level business processes with data rules
• Performed budget analysis to control expenditures and predict future budget needs
• Validated results and performed quality assurance to assess accuracy of data
• Conducted workplace compliance training to reduce liability risks and operate effectively
• Identified clear connections between policies and business results to eliminate or reduce confusion and help employees achieve goals
• Researched and adopted new technologies to add value to existing offerings
• Conducted system analysis and implementation to maintain and improve computer systems