PROFESSIONAL PROFILE:

• I’m specialized in building Web base, On Demand BI applications, ranged from web portal to on premise application development, mainly using not only heterogeneous like Microsoft plus IBM but also homogenous like Microsoft technology, Cloud technology and Big Data.
• I’m confident ith my 20 years cross - functional, and industrial experiences in various industries like Manufacturing, Financial Institutions, Healthcare, Pharmaceutical, Insurance, Investment, Public Sector and Professional Services, and can-do attitude can build management and stakeholders a 360 degree overview of its business and operations, sale performance and budgeting.
• Through my expertise in SDLC processes, I can assist management not only explore the prospect to optimize their process, product, service, and the cost associated in their ecosystem but also explore potential opportunity and various business scenarios in advance.
• Years of engagement works for multiple industries in, helps me to stay on the top of technology and gains insights from different perspectives. One of my fortes is to deliver an end to end enterprise reporting system to enable all personnel, both internal and external customer, in whole organization to use, agree and well communicate on a single version of business facts. Only though that tactics and protocol, gives management not only the leverage but 360 degree overview for entire operation, plus provides management a contour to drive progress and measure performance. In addition to that, organization can plans ahead for next phrase, and makes forecast, execution and provision more realistic.
• As BI believer, I promote the interest using data warehousing and takes the rest 99% effort to make it work. I am accustom to IBM Cognos 10 .2 BI suite from technical architecture, performance tuning, solution architecture, report and dashboard design, and metadata modeling, for both relational and OLAP reporting. All that assets are just to ensure my value to deliver right information to the right people Confidential the right time. Ideally, the return on asset in words will be information delivered, decision made, action taken, result assured, and expectation met.
• OBJECTIVES:
• Redefine Business Intelligence, combine industry experience, data availability and IT investment in legacy applications or transactional data or ERP (SAP, Siebel, Oracle Finance), and turn these data into valued-added business intelligence, that is actionable reports.
• As subject matter expert, led the effort to close the gap between business sponsor and data owner, help management to gain insight to their products, customers, services, channels and costs and to optimize their process for better outcome. Provide internal and external customers 360 degree and near-real-time business overview in forms of intuitive reporting GUI.
• Assist and support my corporation to be ready for globalization, and stand ahead in this digital and information revolution era through solution engineering and new technology research and innovation.
• Simplified and right-Sized Cognos v10 Analytic tool and TM1 cube development, data mart deployment into fewer development phrases, from raw data to data mart, into model, cube, report and to BI through POT and POC (- proof of concept) under time constraint.
• Lead the effort in data preparation, modeling and data schema for Big Data project, participate in one of most important aspect in linking mixed of product/product groups to customers/customer groups, adding complexity in time factors, making the response output a better engine to increase Confidential least just 1%, in which it means 100% growth in total revenue from ecommerce from its previous state.
• Lead the effort to explore in-memory (OLTP) and column based technology (Vertica) in Business Intelligence, Big Data, and IBM SPSS technology.
• Architect a data-secure DW application to explore these hidden opportunity assets in all business functions, LOB, and regions performance, compare actual vs budget, to aid variance analysis, budget review, risk identification, performance review and revenue realization through dashboards, drill through, Business analysis, data loading, better schema and OLAP models, meantime, enabled colleague to take advantage of all mobile features in the Cognos BI 10 suite, including make it available in mobile-handheld device.
• Specified in building access management, identity management, directory management, SSO, role based access system setup, configuration, application development and automation
• Working knowledge in Payroll, Balance Sheet, Financial Statement, Business Operation
• Working Knowledge in DW migration, development, deployment, architecture, MDM and multi-servers installation, tuning and administration
• Working Knowledge in Oracle Finance, SAP, Lawson and Ross
• Working Knowledge in DW, BI, ETL, Kimball and Inman
• Working Knowledge for Cognos 10, Cognos Insight, SSDT, Framework Manager, MDX, TM1, Transformer, Report studio, and Tableau.
• Working Knowledge in requirement gathering, solution architect, OLAP modeling, cube building, migration, conversion and automation, with best practice in mind.
• Years of industries exchangeable Experience among manufacturing, Consulting, healthcare, retail, insurance, ecommerce, transportation, public and finance sector.
• Year of business function experience IT, Design, Quality, Procurement, Accounting, Logistic, and international business
• Align corporate objectives though requirement gathering, roadmap, resource management and communication
• Model TM1 cube, turbo processor/ and distribute web sheet, centralize data entry for budget and critical update.
• Migration/Integration/Installation/configuration to Cognos 10.2 environment
• Migration of Series7 Access Manager security to Cognos 10 LDAP (MSAD)
• Integration of TM1 and Cognos 10.2
• MDX Function/SQL/TOAD/Cognos 8 Go Office/ XML/ JQUERY/ JAVA/ ERD (Entity Relational Diagram)/Process-Data Flow/Cognos Metric Manager/Performance Applications/Oracle/SQL/Teradata/DB2/Scorecard/Framework Manager
• Installation/configuration/customization/tuning in n-tiers server installation and migration to different LDAP environment from previous version.
• Interrogated/investigate multi-level system detail in ERP for BOM reports
• In short, skillful in architect of complete BI solution in short time frame, build fool-proof working model and minimize total cost of ownership in various critical and business-dynamic function areas like GL, IS, Consumer Profiling and AR, by translating business requirements to technical requirements, team building, rapid application development, deployment, user security, requirement gathering, system analysis, administration and implementation, migration, conversion.
• Assisted senior management to refine strategy, build team, define the process, determine the web contents in hope to grow the network and life, close the gap between the reality and the goal, promote our products, connect all parties like members, payers, hospitals, pharmacy store and physicians, refine tactics to increase website visit, including tagging traffic to boost our brand, acceptance, reputation, recognition and popularity, plus developed programs to support each business initiatives, and further its implementation and maintenance.
• Assisted in selection and development of cloud system and the balance between the cloud and on-premised applications.
• Led and architect data preparation and data warehousing works in Big Data project to streamline and to classify the patterns among thousands of products, services, customer profiles, procurement data, and consumer behavior through real time data analytic engine plus statistical modeling.
• Familiar with IBM Cognos BI suite10.2.1 and Performance Management suite (TM1), SSIS and SSDT and SPSS modeler.
• Advised management the best practice to build a full life cycle BIDW from datamarts using SSIS to using BI suites to support Cognos artifacts, package, reports, mobile reports and dashboards.
• Led the effort to build a robust end-to end processes to build big data engine that makes sense and generate a better hit rate and recommended engine over time.
• Familiar with Oracle Finance, SAP and Lawson BI application integration.
• 17 years of exchangeable experience working in various industries, including Consulting, Automotive, Manufacturing, Pharmaceutical, Marketing, Telecommunication, Hospitality, Transportation, Equipment Rental, Healthcare, ROI Service and Insurance industry and public sector
• Strong in Executive, AR, GL, SL, Marketing, IT, process and Payroll Dashboard’ requirement gathering and Scorecard application development.
• Familiar with a wide range of progressive Information Technology applicable to business functional areas, such as procurement, sale, finance, supplier chain, consumer, accounting and production through responsibilities like solution architect, installation, configuration, infrastructure, system analysis, application development and deployment, documentation, coding, testing, data migration, conversion and implementation.
• 10+ years of Data warehousing experience using Cognos BI tools to develop and deploy 360 degree operational overview and Business Intelligence using Cognos Bi 10.2 and 8.3/Report Studio 8.3, dynamic cube, Transformer 8.3, Access Manager, Cognos connection and Cognos Go office.
• 10+ year’s extensive experience in leading a successful data warehouse project (transportation). Including winning award from public magazine, proven BI acceptance in real time business application.
• 15+ years overall experience in the application development using Cognos BI.
• 10+ years designed, developed and successfully deployed reports on Intranet/Internet using Impromptu Web reports and multi-dimensional cubes using PowerPlay Transformer.
• 10+ years in data mart, star schema, snowflake schema, data requirement analysis, design, development, data quality, documenting and implementation of business applications.
• Excellent communication, presentation, project management plus hand-on skills.

RELEVANT TECHNICAL SKILLS:

IBM Cognos BI: Cognos 10.2/9.5/8, TM1, Cognos Insight, Cognos Express, Framework Manager, PowerPlay, Transformer,SSIS, Data Manager, Access Manager, ReportNet, Dynamic Cube.

System: Cloud development and migration.

Database: Teradata, SQL Server, Oracle, DB2, Database Design and PL/SQL Development

Operating Systems: All Windows Desktop/Server, Linux, UNIX

Programming Languages: web Query, Python, Java, JavaScript, jQuery, SQL, HTML/CSS, PHP, UNIX Shell Scripting, Perl, Cognos Mashup Services, Cognos SDK.

EXPERIENCE:

Confidential, Southfield, Michigan

Data Architect/Project/Resource Manager

Responsibilities:

• Assisted senior management to define best strategy to define the process, grow the network and life, close the gap, promote our products, connect all parties like memebers, payers, hospitals, pharmacy store and physicians, refine tactics to increase website traffic to boost our brand, acceptance, reputation, recognition and popularity, developed programs to support each business initiatives and further its implementation and maintenance.
• Assisted in selection and development of cloud system and the balance between the cloud and on-premised applications.
• Architected a physical and logical model to address a need on HPD system covered physician, physician network, hospital, pharmacy, insurance, payer, insurance products and their members/ patients(life),
• Contributed to overall data architecture strategy through system analysis, design and creation for the EDW/DM/BI
• Designs, implements and maintains moderately complex databases includes ETL
• Acted as technical resource to address data-related problems of systems integration, compatibility and multiple-platform/DBMS integration
• Performed feasibility analysis(POC/POT) on potential future data implementations
• Led implementation of data warehouse and related data marts (e.g., staging and production, table development, extranet, transfer and load processes, and aggregation processes and data validation).
• Ensured that data projects follow prescribed development life cycle and meet quality standards (VISIO).
• Monitored database performance, recommends tuning/redesign activities and resolves complex issues.
• Kept current with database, data modeling and data warehousing trends and technological innovations in the banking and IT industry, and makes appropriate development recommendations

Confidential

Sr Consultant

Responsibilities:

• Served as a member Confidential Program level to support all portfolios requirements in each spring under agile(VersionOne)
• Made joined decisions and test tagging specifications for all the application platforms, including Iphone, Ipad-mini, Android, Apple tv, and websites which directly impact and drive corporate revenue and fiscal target(click, view, impression).
• Supervised and coordinated all the support functions to mobile applications, including web analytics information, dashboard, and end to end tagging specification and architecture.

Confidential

Sr BI Consultant

Responsibilities:

• SOW, Requirement Gathering, Gap Analysis, MDM, EDW design/validation, data loading, model development, report development, data validation, strategic modeling and tool selections. Specialized in End to End, full BI lifecycle application development to ensure successful customer and consulting engagement though committing to build an intangible asset and continuality of long term business relationship.
• Strong knowledge of TM1 Rules and TM1 processes Experienced using TM1 in conjunction with ODBC
• Develop TM1 Applications/Cubes.
• Understanding the business requirements and designing applications to meet their needs
• TM1 Administration Activities like creating/maintaining TM1 servers. Monitoring the performance of servers
• Maintenance of TM1 objects.
• Resolve all the issues faced by the users while using TM1

Confidential, ATLANTA, GA

Telecommunication - Solutions Architect

Responsibilities:

• Served as standalone PMO, deployed a full lifecycle BIDW application through managing various BI step stones and milestones like team build, BI roadmap, skillset, mockup reports, requirement gathering, recourse planning, mitigation, implementation, setting schedules and expectation, and meeting budget
• Define and extract datasets from business units and automate the process to build functional data marts and deploy distributed Cognos portals to build Cognos artifacts using SSIS, decision stream and Cognos BI suites 10.2.
• Master Data management and preparation for statistics modeling (SPSS). Applications include sales performance management dashboard, customer profiling.
• Using SSIS’s Control flow and data flow, loading dimensions and fact tables in SQL server, modeling business data in FM, and transformer, deploying package, building reports to build a best in class BIDW

Confidential, ATLANTA, GA

Consulting - Solution Architect

Responsibilities:

• Led and architect data preparation, and data analysis efforts, in Big Data project to streamline and to classify the patterns among thousands of products, services, customer profiles, procurement data, and consumer behavior through real time data analytic engine plus data and statistical modeling.
• Familiar with IBM Cognos BI suite10.2.1 and Performance Management suite(TM1), Dynamic Cube, and SPSS modeler.
• Led the effort to build robust end-to end processes to build a big data engine that logically, technically, and business-wisely makes sense and generate a mo hit rate with recommend engine that can progressive and grow over time.
• Big Data (Stream, SPSS, Hadoop, Cognos, Teradata)
• Predictive forecasting model (SPSS)
• IBM Cognos Deployment (Cognos 10.2)
• Data Warehousing (Full by Text-Enhance">Life cycle)
• Data Modeling (Erwin)
• Familiar with Window and Linux
• Over 18+ years Industrial exchangeable experience
• Cognos BI10.2, Cognos Mobile, Cognos Insight, TM1, Business Intelligence, SPSS
• Prepared profiling “data” which has direct impact to marketing efforts, matched profiled customers to right products.
• Designed an architect, right-sized and optimized in each and every BI layers and levels of details plus security to support multiple millions transactions, budget in millions, and rapid changing dimensions environment, transformed data centers into information providers.

Confidential, NASHVILLE, TN

Sr Solution Architect

Responsibilities:

• Led on application migration from Microsoft technology to IBM technology in all aspects.
• Led three junior developers to deploy Cognos enterprise solution through data loading strategy, OLAP modeling, model design, and cube development and requirement gathering.

Confidential, HARTFORD, CT

Sr Solution Architect

Responsibilities:

• Loaded knowledge in Rick Control in Engineering, Job cost and other domains.
• Architect a BI solution on a transaction based VLDB for risk control, minimize loss for business and risk for claims, turned relational data to OLAP model, linked engineer, job, site and cost together and empower users to self-serve to their business need, make risk control operation valued-added BI providers, and more transparent to claim units and underwriting unit.

Confidential, ATLANTA, GA

PM, Lead, Architect, Developer, and Analyst

Responsibilities:

• Advised project management the best strategy to ERP integration, data migration, MDM, solution architecture, DW schema development, dashboard design, and security implementation plus best practice using IBM BI suite,10.2 toolset and TM1
• Worked with business analysts and IT management to fully understand business and resource requirements.
• Leverage technology to create solutions that satisfy the business requirements in a reasonable amount of time.
• Served as a technical leader to help define, estimate, and propose solutions for business opportunities.
• Provided critical architectural inputs during financial integration process.
• Created architecture and technical design documents to communicate solutions that will be implemented by the delivery team.
• Developed proofs-of-concept and prototypes to help illustrate approaches to technology and business problems.
• Prepared visual diagrams of system architecture, functionality, and process flows.
• Worked with development, infrastructure, test, and production support teams to ensure proper implementation of solution.
• Educated organization on available and emerging toolsets.
• Presented solutions to clients, project teams, and other stakeholders adapting style to both technical and non-technical audiences.
• Worked efficiently in a fast paced, complex, and high demand environment.
• Required no oversight and review of deliverables.
• Identified and resolve potential risks and issues. Worked with team to implement mitigation plan.
• Built and delivered phase exit review items and works with team members to follow CCIT processes and practices for project delivery.
• Demonstrated a deep understanding of the solution delivery life cycle.
• Developed solutions according to specifications and applying CCIT standards.
• Responsible for managing the maintenance and development activities for the BI group.
• Developed project plan, monitor and manage project schedule, operation issues, project report status, meeting agenda.
• Work with data analysts and architects, consulting group for ADW project
• Influence the DW and reporting architecture.
• Hands on development, Cognos/Java/Sql.

Confidential, ATLANTA, GA

Healthcare, Solution Architect/Cognos Admin

Responsibilities:

• Responsible for managing the maintenance and development activities for all projects, dashboard reports related to scorecard, payroll, IS and AR.
• Develop project plan, roadmap, activity, resource plan, metrics for payroll project, monitor and manage project schedule, operation issues, project report status, meeting agenda.
• Identified critical paths (data loading, query turning)/ elements (business rule, naming strategy) to the success of IS/AR/Payroll/Scorecard project.
• Optimized the use of de-normalized data(flat file) and normalized star schema with fact/Dimension design by followed Ralph Kimball Data Warehousing Principle.
• Troubleshoot all the BI layers from Administration/Security/Dashboard/data source /report/cube/ IQD/ datamart/source/MDX.
• Work around and implement those insufficient data in the processes.
• Built a very cost-effective, resource-minimum, well-design Scorecard applications while met business demand in very short time-frame. (Weeks not years )
• Architect payroll and scorecard project from data to OLAP datamart to multi-dimensional cubes to reports with minimum resources yet still met business demand resource/time/function).
• Turn business requirements to technical specification.
• Personalized Dashboard for Executive Management, VPO and DMO, enhanced internal user experience, increased Cognos visibility and acceptance within the internal organization.
• Created reporting system which valued added to our legacy system (Lawson system) since Lawson lack of reporting system and engine.
• Bridged business expectation, data guru, time constrain, reality, performance and IT culture together and bridged the differences between business sponsor and IT sponsor.
• Refined and defined valued added reports with business units including AR, GL,OPS, located the data, identify process flow and data flow, develop data dictionary and ERD

Confidential, LOS ANGELES, CA

Sr Cognos Developer

Responsibilities:

• Framework Modeling for LA County Procurement Project, convert Lawson Database, procurement data to end users through Cognos Framework User Interface with team of 4 working together, embedded business logic and customized data into presentation level.

Confidential, SEATTLE, WA

Sr Cognos Developer

Responsibilities:

• Cash-on-Hand analysis and Asset under Management - Cognos Application Development
• Re-evaluate Strategy and Tactics in-house against Best in class Cognos practice.
• Consultant work - Rapid application development team
• Customized production reports thru Cognos user Interface by using various data prompting technique, including Java script and Cognos severlet.
• Led in infrastructure/ solution architect/ application development and deployment.
• Assisted in installation of Apache, SQL, ReportNet installations and configurations in Window and Unix environment.
• Led in ReportNet installation and configuration and report development.
• Assist in installation and upgrades of Cognos software across multiple environment: s.
• Report and resolve Cognos software bugs, provide on-call Cognos Support
• Troubleshoot issues with existing reports and cubes.
• Administrator application access directory and process requests for new accounts.

Confidential, NJ

BI consultant

Responsibilities:

• Sub-contract as Senior BI consultant to various internal customers like Siemens corporation Confidential PA, Altec Lansing Confidential PA, Oregano Confidential NJ, developed and deployed reports, cubes and drill through using Reportnet, CMM, Cognos Finance.
• My team/project is elected as one of Computerworld’s Premier 100 IT innovative projects for the Year 2004, which has demonstrated particularly striking business value from a leading-edge technology, particularly in Data Warehouse/ Business Intelligence.
• Leading the course from requirement gathering to system design, model development to cube deployment, BI implementation to automation, gives the management 360 degree overview of current operation and fiscal data in forms of multi-dimensional cubes, mainly Freight Bill, Lane, Expense, Margin, Revenue and Customer analysis.
• Turn Cognos BI suite and Reportnet tools to business user community in a professional, timely manner, including drill through from cube to cube and cube to report.
• Define BI to Agent Extranet requirement; ensure the successful launch of the phrase 1, requirement gathering, data infrastructure and reporting architect.
• Ensure Cognos application development infrastructure following best practice to support production, development and testing instances, and seamlessly working together to meet and exceed daily operation needs.
• Making it happened, identifying bottleneck and solution, switching between reactive and proactive mode between projects, coordinating preventative action among teams, are main responsibilities as lead person.

Confidential, Phoenix, AZ

Program Engineer

Responsibilities:

• Responsible from initial conceptual design, development, testing and deployment using Cognos tools on cubes vs. reports throughout all phrases.
• Designed, developed and maintained Cognos Suites and reporting solutions for Marketing, Finance and Operation (Reservation).
• Provided Cognos products and data warehouse expertise to System Development Group.
• Developed and implemented testing standards and guidelines for data loading in data warehouse and data marts.
• Developed and delivered Cognos product training sessions for clients and management coordinated all communications with vendor concerning application support issues, training requirements, enhancements and product purchases.
• Leads the architecture and design efforts through delivery and test phases.
• Develops technological road maps, while keeping up-to-date with emerging technologies, and recommends business directions based on these technologies.
• Provides technical leadership and responsible for conducting the overall systems design and management of Cognos architecture and application technical architecture.
• Interfaces extensively with application development staff and the infrastructure development project manager.
• Responsible for ensuring secure infrastructure interfaces.
• Develops security measures to safeguard infrastructure interfaces against accidental or unauthorized modification, destruction, or disclosure.
• Responsible for overall information design, balancing optimization of data access with resource utilization factors.
• Comfortable in developing requirements and design specifications for new and existing applications.
• Knowledgeable in all aspects of designing and constructing data warehouses, operational data stores, and data marts that enable informational, analytical management inquiry of well-integrated, subject-oriented historical data.
• Comfortable in rapid application development (RAD) techniques and in developing requirements and design specifications for new and existing data warehouses.
• Responsible for designing and architecting well-integrated and cost-effective solutions for internal and external Webs.
• Works closely with client project managers and technical leaders to understand the customer's business objectives and systems requirements.
• Provides recommendations for server operating systems, and hardware requirements for communications to and from secure servers.
• Designs and implements an intranet strategy for authorization of users to access controlled components.
• Provides technical advice and expertise to Webmasters and Web Developers in the installation, acceptance testing, and evaluation of newly released and beta software.
• Assisted and mentored business departments in the design and construction of their Web pages.