SUMMARY

• 25+ years of gathering business requirements, modeling data, reporting data, testing data, and creating reports and dashboard visualizations.
• Creating complex queries and stored procedures needed to create custom ETL packages to move data from many disparate sources to cloud/local databases and data warehouses.Qualifications Summary
• Demonstrated strengths as a BI Lead/Architect, Data Architect/Data analyst/database Developer in Business Intelligence, Data Warehouse, Databases and Data Insight/Analytics projects.
• Experienced developing complex business Intelligence applications supporting multiple business functions including Finance, Sales and Marketing, and Supply chain in multiple industries including Insurance, Healthcare, Government Consumer Products, Financial Services.
• Solid understanding of data warehousing concepts and ETL processes.
• Competent with rational and start schemas, facts, dimensions, measures, primary and foreign keys, data marts, and joins.
• Experienced in Data Analytics and Business Intelligence and skilled in BI administration and development (Cognos Tableau and Power BI), data warehousing (i.e. star schemas), SQL Server and Confidential databases, software documentation and training, process improvement, and data analysis

PROFESSIONAL EXPERIENCE

Sr. Project Lead

Confidential

Responsibilities:

• Daily responsibilities include: Developing metadata models, cubes, dynamic cubes, reports and dashboards, testing Cognos content and providing end user training in a small environment as part of a large group.
• Experienced in creating dynamic subsets using mdx in dimension editor and also in turbo integrator scripting for loading cubes from database, creation of dimensions etc. And experienced in Cognos Report Studio, in creating different types of reports using Prompts, Drill - through, master-detail query relationships, conditional formatting, grouping and sorting features of Report Studio to generate efficient and user-friendly reports.
• Over 18 years of experience in Confidential Cognos BI 11.0 and 11.1.x, administration, installation, data security, server configuration, and technical support.
• Experienced in analysis, design and development of Business Intelligence applications using tools like Confidential Cognos Analytics V11.1.7, Data Module, Dashboard, Data Set, and COGNOS BI 10.2/8.4/8.1/ReportNet 1.1 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Connection), Cognos Series 7.3 MR2 (Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay Transformer, PowerPlay Enterprise Server, PowerPlay Web, Access Manager, Server Administration, Report Administration).
• As a Cognos expert consultant, effectively supported enterprise reporting infrastructure, provided continuous support to business users in leveraging self-service reporting infrastructure and enhanced reporting applications & processes for automation & productivity improvement.
• Expert in building models & publishing packages in Cognos Framework Manager to the Report Net server.
• Created Dimensional Modeling using Framework Manager, organized into Dimensions, Hierarchies, Levels and Measures to enable Drill functionality in reports and also able to analyze Dimensions with hierarchies and levels to work in Cognos Analysis Studio.
• Experienced in Deployment (Export, Import) in Cognos Administration and Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Responsible for the development of reporting and analysis for internal and external clients using tools that include Cognos (Framework manager, Report Studio, Power Play Transformer), and SQL Server data base.
• This includes creating new KPI's, reports, dashboards to monitor health and performance, extracting and analyzing large amounts of data to help the company make strategic business decisions. Worked as a Report Developer, Analytical Developer, Dashboard Developer and BI Developer.
• And actively contributing to the evolution of best practices, standards & procedures for enterprise Cognos BI reporting applications.
• Over 15 years of experience in TM1/Planning analytics and worked on, Application support, Infrastructure and development areas. Cognos TM1/Planning analytics full life cycle implementation of Budgeting, Forecasting, Operational Expense and Sales Forecasting models with requirements, development, production support and maintenance using Confidential Cognos TM1/PA Applications (Architect, Perspectives, CAFÉ, PAW, PAX and Turbo Integrator).
• Over 12+ years of Experience with Tableau in Designing, Analysis, Management in the Business Intelligence Data warehousing. Experienced in complex BI Reports, Dashboards, Project Management, Change/Incident management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management. Worked on different Tableau versions (Tableau 2020.x,2019.x/ 2018.x/10.x/9.x/8.x).
• Experienced in developing Business Intelligence applications and data analytics products at various phases of SDLC. Involved in full Software development lifecycle (SDLC) using Agile methodologies and other traditional methods to produce high quality software model.
• In Power BI using (Power Query, Power Pivot, Power BI Pro, Power BI Desktop) and working with DAX Expressions. Extensive experience in Confidential stacks of BI solutions SSRS, SSIS and SSAS with MS SQL 2008/2008R2/2012/2014/2016.
• Over 5 years of experience using data visualization and Dashboard reports in design, architecture, support, and implementation of applications on the cloud and experienced in developing scripts in Python, Java, and Confidential App Script to aid business teams in day-to-day tasks.
• Worked with the on-site Solutions Architect to develop multiple prototype projects on the G Suite platform.
• Provided consulting services for business teams such as requirements gathering, technical feasibility analysis, and technical solution design for new application code to be developed. Worked with Confidential Cloud Platform with features included: Stackdriver (Monitoring / Logging / Error Reporting), App Engine, Compute Engine, Container and Networking, storage related Bigtable/SQL, Confidential Cloud Platform related API Manager, Cloud Launcher and IAM & Admin activities. BigQuery, Dataproc, DataFlow and Genomics from the BigData implementation of data migration activities.
• Experienced Data Migration/Conversion with more than 19 years global rollout experience with a proven track records driving data team for successful project delivery.
• Experienced in end to end data migration roles including leading, designing, developing and executing data migration projects.
• I defined data migration approach and strategies, provided detailed data load plans for all objects, sequences, systems and responsibilities and lead data migration activities, facilitating data mapping, data cleansing, data harmonization/consolidation and data validation.
• Lead the implementation of JDA-WMS8.2 to run the warehouse operations in the distribution center. Worked cross-functionally with the business team to ensure the highest quality and most efficient logistics operations, document the requirements, develop the proper solution to handle all the workflows for receiving, putaway, order management, and picking and shipping process.
• Designed and created a manual Shipments upload ABPP workflow to allow the users to upload and create the Shipments in the TMS.
• Successfully constructed, socialized, and delivered a roadmap for Supply Chain Systems and Analytics to support best in class processes for Demand and Supply Planning. Designed and developed a Supply Chain Data Warehouse to support descriptive and predictive analytics.
• Established Business Analyst with 10+ years success analyzing financial data, IT systems, and business processes to identify areas for improvement. Excellent ability determining requirements, formulating improvement strategies, and implementing change to achieve company goals.
• Experienced using industry standard methodologies (SDLC, PMM, SEM, Agile)
• Proficient in Confidential Dynamics, JIRA, Confluence, Confidential Project, Confidential SharePoint, Confidential Office Professional (Outlook, Word, Excel, Visio, Access, PowerPoint)

TECHNICAL SKILLS

Database / Systems: DB2/400, Confidential 10, 11, 12, Confidential, SQL, SQL Server, Confidential, DB2, UNIX, Linux, Windows, Confidential, Confidential, Guidewire, Bigtable

Development: RPG, CLP, COBOL, C/C++, JAVA, DOJO, JDA(Blue Yonder) Applications, Visual Basic 6.0, SYNON/2E, Perl, Sabre Central Command, WebSphere, Linux Administration, Datastage, DataCap, FileNet, SharePoint, Confidential, Command Line, SSH, HAML, SCSS, dojo, JScript, .net, SharePoint 2013, JavaScript, Ruby on Rails, Service Now, Confidential, AWS, Azure, FileNet P8 Suite Confidential Datacap, Content Navigator, Content Engine

BI: Cognos 11.1.x Analytics, Cognos Planning Analytics, Power BI, Qlikview, Qlik Sense, Cognos 10.x.x, Transformer, Web Reports, Access, Cognos Disclosure Management CDM, Visualizer, Architect, ReportNet, Data Manager, Decision Stream, Confidential Cognos, Enterprise Planning Series 7.3, 8.3, 8.4 Scorecard, Brio, Confidential DataStage, Cognos 8.4, 10.1, 10.2, Controller 10.2& 10.3 Varicent 7.x and Confidential Cognos, ICM 8.x, Cognos Planning TM1, TM1 Admin, TM1 Developer,TM1 Trainer, TM1, 9.5.1, 9.5.2, 10.2.1 & 10.2.2, 11, Cognos Adaptive Warehouse, Cognos Analytic, Application, Cognos ICM, SPSS, SAS, Tableau 2020.x,2019.x/ 2018.x/10.x/9.x/8.x, Qlikview, Micro strategy, Confidential SSRS/SSIS, TIBCO Jasper, Tableau

Tableau: MySQL, Confidential, Confidential, Qlikview, Informatica, Tableau 2020.x,2019.x/ 2018.x/10.x/9.x/8.x JBA, JD Edwards, Lawson, Deltek Costpoint, Confidential, Sabre Central, Command, Confidential DataStage, Netezza Data Architect, Confidential

DW: Cognos, ETL, Informatica 8 9, 10, Business Objects, SAP, SQL, DB2, Datastage

Confidential Software: Cognos, TM1, Planning Analytics, SPSS, Datastage 7x, 8x, 9x, 11x, Curam, Coplink, and CFM

Cloud: Apache Kafka, Confidential gRPC, Confidential TensorFlow, Confidential GCP Cloud Functions, Confidential Kubernetes) Point-of-Transaction Microservices Edge-Cloud/Cloud Solutions Architect/CTA** (Linux, CoreOS rkt, Confidential GCP)