Post Job Free

Resume

Sign in

Manager Data

Location:
Southport, CT
Posted:
February 17, 2021

Contact this candidate

Resume:

Robert Watcke

Southport, CT

adj83w@r.postjobfree.com

203-***-****

Summary:

I have over 25 years IT Project Management and Architure/Development experience which includes over 18 year in database and business intelligence and analytics. Accomplished project manager with experience and expertise in product development, project management, business/system analysis, e-commerce, and risk management. Proactive IT professional who bridges the gap between business goals and technology with real-world experience in managing products/projects across industries.Accomplished project manager with experience and expertise in product development, project management, business/system analysis, e-commerce, and risk management. Proactive IT professional who bridges the gap between business goals and technology with real-world experience in managing products/projects across industries.

Extensive experience as Senior Blue Yonder JDA RedPrairie WMS consultant, Solutions Architect, BSA, Data Analyst, Data Modeler, Business Analyst and reports developer using Business Intelligence tools.

Experienced in application/software development lifecycle methodologies(Agile/Waterfall) and project management methodologies.

Technical Skills:

Certified as a IBM Cognos Developer

Certified as a IBM Cognos Controller Developer

Certified as a IBM TM1/PA Developer

Certified Qlik Developer

Database/Systems: DB2/400, Oracle 10, 11, 12, PeopleSoft, SQL, SQL Server, Microsoft, DB2, UNIX, Linux, Windows, Teradata, Salesforce, 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, JSON, Command Line, SSH, HAML, SCSS, dojo, JScript, .net, SharePoint 2013, JavaScript, Ruby on Rails, Service Now, Google, AWS, Azure, FileNet P8 Suite IBM 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, IBM Cognos, Enterprise Planning Series 7.3, 8.3, 8.4 Scorecard, Brio, IBM DataStage, Cognos 8.4, 10.1, 10.2, Controller 10.2& 10.3 Varicent 7.x and IBM 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, Qlikview, Micro strategy, Microsoft SSRS/SSIS, TIBCO Jasper, Tableau

Tableau: MySQL, Teradata, Oracle, Qlikview, Informatica, Tableau 6.0, 7.0, 8.0 and 8.1

ERP: JBA, JD Edwards, Lawson, Deltek Costpoint, PeopleSoft, Sabre Central, Command, IBM DataStage, Netezza Data Architect, Teradata

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

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

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

My Last Several Projects(Cognos/TM1/PA, Tableau, Power BI):

Cognos Analytics and BY JDA Upgrade - Lead/Sr. Architect/ Sr. Developer August 2019 – Current

Dollar General

Interacted with Customers for requirement gathering, effective analysis to migrate custom report in Blue Yonder JDA software and using JDA data tables…

JDA to AWS Cloud migration, configuration and deployment

Lead technical architect for entire JDA TMS suite – including TMS and Business Analytics to encompass Cognos Reporting and Informatica ETL integration.

Consult on best practices in relation to data access, data mining, archiving, reporting, and delivery to end user as it relates to the TMS solution suite

Lead team of 3 developersto change 50 plus reports

Upgraded JDA from onprem version to the current cloud version.

Worked with business users to test and signoff tasks

Worked in Agile Scrum Environment and Created Tasks in JIRA for Time Tracking.

Worked or Testing and QA with the Business to get ready for go live.

Upgrade the current model in cognos 10 (JDA 8.3) to Cognos 11 (current version of JDA on the cloud).

Tuned Model to speed up reports.

Lead Cognos/Tableau Developer July 2019 – Current

AEO

Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training on new Cognos 11 features.

Analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements.

Upgraded Cognos 10.2.2 to Cognos 11.1.4 Test environment had 6 servers and Production had 16 servers

Installed and Configured Cognos 10/11, Framework Manager, and Transformer.

Migrated Cognos reports/models from version10 to 11.

Automated the cognos reports migration testing from version 10 to 11 using MotioCI.

Creating, enhancing, and maintaining metadata Framework Manager Models to support business requirements.

Developed interactive dashboards in Cognos analytics.

Implemented and maintained cognos security.

Performed Cognos server troubleshooting and other administrative functions such as Set up new user groups, Permissions for Groups and Users in all Environments (Dev, UAT and Prod), Set up Dev and UAT and Migration folders for each project in all Environments, Set up Database connections in all Environments (Dev, UAT and Prod), Coordinate with DBA's on all database Connection issues, Meet with Project Teams on all Issues, Back up / Recovery. Migration/Deployment of developed objects across different environments.

Worked on scheduling and monitoring jobs.

Worked on administrating, managing, and supporting the AEO Business Intelligence platform, as well as in-depth knowledge on how to develop, implement and modify reports and dashboards.

Designed, developed and maintained interactive Tableau reports and dashboards.

Worked on unit testing by writing SQL queries against the database to validate reports.

Performed peer review of code and testing in order to detect and minimize application problems. Develop and provide training to team members on basic utilization and advanced proficiencies, up to and including training others to provide backup.

Production Support that involves solving user problems. Involved in a data migration process between 2 versions of Cognos.

Worked in Agile Scrum Environment and Created Tasks in JIRA for Time Tracking.

Scrum Master (Create, maintain, and organize backlog of features, epics, stories, and tasks in JIRA)

Lead on generating various dashboards in Tableau using various sources such as SAP, SQL Server/Teradata/Oracle analysis data for generated at different hubs and locations.

Experience in creating custom users access, groups, projects, workbooks and the appropriate permission levels and embedded them in few of the API’s filtering the relevant data to feed to the data filters and display only the relevant data to the particular Tableau user.

Monitored the server logons and reviewed the security checks.

Using different calculations levels, parameters, action filters, groups, sets, binary sets in Tableau.

Understood of the complex relational database structures and data warehouse structure to feed data continuously without and load failures to the Tableau reports.

Understood the project Tableau architecture, design, development and end user experience requirements.

Worked with the in various versions of Tableau 10.x+.

Involved in reviewing business requirements and analyzing data sources form Excel/Sybase Database/Teradata/Business Objects.

Designed, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Worked closely with business power users to create reports/dashboards using Tableau desktop.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Create Tableau TDs and trouble shooting. Any scheduler experience (Control-M or Autosys).

Worked on the development of SQL queries and PL/SQL code.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Administer user, user groups etc.

Created drill down and drill up functionalities in Tableau worksheets, an interactive dual-axis charts with multiple measures.

Created and monitored the report data refresh schedules on Tableau server and monitored data feed loads.

Wrote custom SQL queries with related joins and union functions to query data from database.

Excellent in debugging analytical and forecasting problem solving skills with strong ability to quickly adapt to business processes and effectively develop technical solutions to according to their requirement.

Cognos Analytics and IBM TM1 / Planning Analytics senior consultant at IBM office of the CIO Sr. Project Manager/Sr. Architect/ Sr. Developer Jan - 2018 to July 2019

Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.

Analyzed data flow and business requirements to create High Level Design document.

Analyzed the source data to resolve various BI reports issues and Involved in a data migration process between different versions of Cognos.

Involved in a data migration process between different versions of Cognos.

Worked in Agile Scrum Environment and Created Tasks in JIRA for Time Tracking.

Scrum Master (Create, maintain, and organize backlog of features, epics, stories, and tasks in JIRA)

Designed Relational and DMR Models Such as Base Shared, RCA Elements using multiple data sources and published packages to Cognos connections in Framework Manager.

Worked with Cognos Custom Java Authentication Services.

Defined the Data Level Security and Package Level Security for different User Groups in Frame Work Manager.

Worked with PL/SQL Functions and Stored Procedures In Cognos Frame Work Manager Models

Designed many Complex Reports as List, cross tab, drill through, master-detail, chart using Report Studio and Ad-hoc reports using Workspace Advanced.

Worked with Watson Analytics API's, in Data Upload and creating Story books.

Created complex Dashboards and Active Reports with Bar Stacked,Area Stacked,Column Stacked Data Visualizations.

Worked with Cognos API's for displaying and accessing Cognos Analytics Content in Custom Web Application(RCA).

Created Complex reports in Cognos including Drill Down and Drill UP reports from DMR modeled Frame work model.

Created Custom Prompt Pages in Reports using Java Script in Report Studio.

Created user groups and roles in Cognos Connection and applied data level and group level security for various entries.

Created Dynamic Cubes with complex calculations in Cognos Cube Designer.

Upgraded Cognos 10.2.2 to Cognos 11 on Development, Test and Production Environments.

Worked with Motio CI for versioning of Framework Models and Reports.

Worked with Security Administration within Cognos Connection in Defining roles and permission and matched them across all environments for multiple applications

Analyzed and mapped data from source systems to target to operational data stores and data marts (Data warehouse).

Worked on report performance Improvement found issues and fixed them.

Analyzed and validated the Analyst reports and performing data analysis with SQL.

Worked with different client teams to support Reporting issues and enhancing the existing reports.

Developed Technical Specification documents for all newly developed and modified processes.

Leading the IBM Cognos Planning Analytics and reporting.

Created Excel Based reporting using PAX

Converted business requirements into precise cubes, dimensions, hierarchies, and calculations using Planning Analytics Workspace modeling tools

Created Databases, CUBES, Dimensions, Rules, TI processes, Applications, User security and Reporting using Performance Modeler, Architect Perspectives, Active Reports and Insight.

Training users on how to use Cognos® TM1® Perspectives add-in for Microsoft Excel

Consolidating data between the models and providing it to downstream systems and Reporting.

Improved the environment by suggesting best practices like reducing the Application size and fine tuning the Process.

Interacted with IBM to improve the implementation and provided better solution.

Development of TurboIntegrator(TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.

Maintenance of TM1 users, roles, and security.

Created temporary Views, Subsets using Turbo Integrator.

Created Web Forms Using Infopath and Published using Enterprise Services Manager.

Scheduled Chores and Monitored Data Loads on timely manner.

Created TI Processes and Rules to transfer data.

Used TM1 rules editor to create and edit rule to create various calculations.

Reviewed Business Requirement Document (BRD) for Completeness, Gather and analyze requirements.

Performed Unit Testing and User Acceptance Testing

Environment: Cognos 11X/10.2.2, TM1 10.2.2, PA 2.0.6, PAX, PAW, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, WorkSpace Advanced, Work Space, Transformer, Cognos CubeDesigner, JavaScript, Cognos SDK,IBM Watson, Motio CI, Oracle,MS SQL Server 2016,Windows 2012.

Power BI/Tableau Developer Feb 2016 – Jan 2017

TekSystems

Gathering the requirements analysis with business users to identify and finalize requirements for Power BI solution

Provide Power BI support and training to users within Murphy globally

Built Strategic, Analytical and operational dashboards using Tableau

Handled Tableau admin activities granting access, managing extracts and Installations

Administrate for all Tableau administration activities, creating New User, granting permission for a particular Dashboard, Monitoring User and server Activity and job Scheduling.

Created complex calculation fields using Table Calculation, Date, Aggregate functions in Tableau.

Supported business users in realizing their needs for in-depth data analysis

Job scheduled on Tableau server to generate .PDF and .PNG file using TAB commands

Worked on source systems like Well View, Procount & Enersight.

Created design documents which Outlines the approach of the Power BI Implementation

Designed dynamic Spotfire visualization using Text Area, Input Field, Lists, Drop down lists, Document Properties, Information Links, Web Links as well as advanced Heat Map, Scatter Plots, Combinational Charts, Line Charts, Bar Charts, Cross Tables

Excellent Contact skills to work with highly analytical users as well as senior Murphy globally

Used Spotfire expressions and OVER statements for calculations

Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc.

Used data table properties, property controls, filters, joins and custom functions

Created Information links, parameterization, defined join rules in Information designer.

Created Personalized Information links for setting up row level security

Created Action Controls and wrote scripts using Iron Python. Performed several customizations using the scripts

Used Dynamic calculations based on the markings user selects in the visualizations

Designed and developed Power BI graphical and visualization solutions with business requirement document and plans for creating interactive dashboards

Writing complex DAX functions in Power BI

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning

Utilized Power Query in Power BI to Power Pivot and Un-pivot the data model for data cleansing and data massaging.

Maintained Power BI On-premise Data Gateway

Scheduling jobs and Altering using SQL Server Agent in Power BI

Set up Collaboration Platforms

Performed CRM reports, Funnel reports, Churn reports, Strategy reports, Supply chain reports, Sales reports, AR reports and Account reports from different data sources like Salesforce dot com (SFDC), Service Now (SNOW), SAP, Tera Data and SQL Server.

Applied best practices in dashboard design development

Used Multiple data sources for creating dashboards

Used Load on Demand and Caching to improve performance of DXP files

Created configuration blocks in Spotfire and set up guided analysis to carry the filter selections from one analysis to other

Migrated the code from Dev to test and to prod after testing. Tested for the Data counts, Data Quality, Spotfire Interface

Testing and dashboards performance testing

Environment: Salesforce (SFDC), Web player, MS SQL Server, Windows server, SAP HANA, Hadoop Hive, AZURE ODS, Power BI, Tableau 10.2 Desktop.

Tableau Lead Developer July 2015 – Feb 2016

TekSystems

Designed and published visually appealing and interactive Tableau Dashboards utilizing complex calculated fields, table calculations, filters, parameters, and actions, tool tip visualization

Interface with Senior management, analysts, various SMEs, and users to gather and document requirements

Manage development activities from gathering requirements and designing solutions, through developing code /reports, to testing, and release / deployment

Creates and use extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop

Develop and execute database queries using SQL to conduct analyses and validate report accuracy

Deploy systematic approach to improve dashboard performance and enhance stakeholders' experience

Utilized data blending and cross database joins to efficiently work with data from multiple sources

Experts in creating different types of charts including side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications

Create database views, stored procedures, stored functions shape data and improve performance and lighten the load on Tableau (using the right tool for the right purpose)

Developed macros for financial reports

Design and deliver end-user training and training documents such as user manuals, test documents, and design documents to efficiently navigate dashboards

Power BI Developer July 2015 – Jan 2016

TJX

Participated in sessions to gather requirements and outline functional requirements

Defined multiple constraints in logical phase of the data modeling life cycle.

Designed and created data mapping document (DMD) by analyzing data sources and mapping to data mart schema.

Created database objects such as tables, views, stored procedures, and triggers

Converted a complex business logic into SQL stored procedures and user-defined functions.

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using SSIS.

Developed ETL process using SSIS with various control flow, data flow tasks and stored procedures for work order validation process.

Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base

Extensively worked on ETL and data integration in developing ETL mappings and scripts using SSIS

Redesigned the architecture of the existing data model and added SSAS tabular cubes by writing DAX script to improve report performance.

Migrated existing Tableau reports to Power bi reports for different teams to analyze log information/ supply chain data.

Generated paginate SSRS reports and excel pivot tables get data from backend stored procedure for processor monitoring.

Created new ETL solution by using SSIS and T-SQL query to accomplish data transformation for Splunk migration.

Setting up Kerberos and creating PowerApps to duplicate dynamic parameters working model and writing back features.

Training clients to use PBI as a self-service tool.

Technical Environment: MS SQL Server 2017, MySQL, SSMS, SSIS, SSAS, SSRS, Power BI, Excel, Tableau, PowerApps

Client List (IBM, Mohegan Sun, MetLife, BofA, Hartford Stream Boiler, Cigna, Munich RE, WWE, AIG, Marriott, White Lodging, WL Gore, BCPS, WASPC, OCPS, TJX, NG, Atlas Air, Anagram, DTCC, TBC, Knight Capital, Pulte, L3, San Diego DHS, Arkansas DHS, Edlore, TERROS, CRN, White Head, Georgia Tech, LearnQuest, Accenture, JLL, Talus, Chateau, Diversicare Healthcare Services, IBM Safer Planet, MetLife, Alexander & Baldwin, TEKsystems, SACE, Citibank, Toyota NA, Pratt Whitney, Dollar General, American Eagle)

Professional Experience:

Solutions by SBS LLC Southport CT Specialty Systems Integrator Feb 2004 – Present

Sr. Project Manager/Sr. Architect/ Sr. Developer

Have (18) years of experience on Cognos Business Intelligence/Business Analytics software 8.4, 10.1 and 10.2 and Cognos Analytics 11. Developed metadata models, cubes, dynamic cubes, reports and dashboards, tested Cognos content and provided 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

Worked as a JDA WMS consultant in the implementation of the JDA-WMS2018 product to run the warehouse operation in the Distribution Center. Helped define the functional workflows for the new operations, came-up with Gap Analysis, Defined Solution, Helped with Configuration and Testing of the end-to-end system for all workflows related to Inbound and Outbound operation. Supported the operations teams during Go-Live, instrumental in troubleshooting from technical and functional aspects to keep the operations moving.

Lead the implementation of the JDA-WMS8.2 product to run the warehouse operation in the Distribution Center. Worked closely with the business team to analyze the requirements of the logistics operations, document the requirements, develop the proper solution to handle all the workflows for receiving, putaway, order management, picking and shipping process. Designed and lead the development teams to create custom modules to handle the Integration to Host system and special processing of sample orders to be shipped in high volume

10 years experience in IBM Cognos BI 11.0 and 11.1.x, Administration, Installation, Server Configuration, and technical support including all components of the IBM Cognos Business Intelligence suite of tools. Application Security integrating using Active Directory (AD), Lightweight Directory Access Protocol (LDAP), and Java Based Authentication. Experienced in developing and implementing complex data security, object security, and cube security and implementing best practices to model and develop Cognos Packages using relational, dimensional, data marts and transactional databases to support reports, score-carding, and analysis. Experienced using industry best practices to create Data Cube models with IBM Cognos Transformer 11.0 and 11.1.x using existing relational and dimensional data marts.

Around 8+ years of experience using SAS in providing innovative solutions for complex information. Experienced in using SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/SQL, and SAS ODS in Windows environment. Understanding knowledge in SAS Programming in creating, joining, merging, manipulating, and maintaining datasets using SAS/BASE and PROC SQL.

Experienced in preparation of SAS datasets, Tables, Listings, Graphs, Reports and Summaries according to the requirements.

7 plus years in Varicent SPM and IBM ICM 6.x, 7.x, 9.x and 10x experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse

Experienced in product life cycle management, excellent configuration skills, familiarity with administration and security controls, and amazing ability to aid technical team members, developers

and support teams, outstanding troubleshoot workflow issues and superior communication skills.

Involved in gathering and analyzing business requirements and documenting them into Functional and Technical specifications for new reporting requirements.

Worked on Framework manager to develop the metadata model, which suits the reporting Requirements.

Designed hierarchies for various dimensions using DMR modeling.

Implemented prompt validation and added various functionalities to prompt pages using JavaScript in order to extend and customize the reporting functionality, visualization and presentation experience.

Worked closely with business users in gathering new reporting requirements during the process of migrating the existing Business Objects reports to Cognos.

Analyzed the existing Business Objects Universe and Webi and Desktop Intelligence reports and recreated the FM Model and reports in Cognos environment.

Applied data level and package level security in Cognos Framework manager in a manner that only the relevant users could see the packages and run the run reports accordingly.

Worked closely with Business Users in sprint review sessions and gathering the feedback from review sessions.

Created Test cases and performed unit testing for the Reports using SQL queries and captured the testing evidence in HP ALM.

Worked with Business users during the UAT testing of reports and Ad hoc packages.

Worked on deploying FM Model package and Reports from Dev, UAT and Prod during various phases of the Project.

Created Change Requests in Service now for deploying the Reports and FM packages from UAT to Prod.

Involved in Upgrade of Cognos environment and reports from Cognos 11.1.5 to Cognos Analytics 11.1.7

Used Life Cycle Manager to validate the results between two environments during Cognos upgrade project.

Involved in the Production support activities and used ServiceNow for incident monitoring.

Worked closely with IBM support team to resolve the Cognos environment issues.

Participated in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings. 12 plus years with IBM Cognos Enterprise Planning, IBM Cognos TM1 10.2.2, IBM Planning Analytics Local 2.0.3

Have been a Trainer and Mentor in Cognos products Modeling, Reporting, Cubes and Tuning.

Have taught IBM classes in Framework Manager, Dynamic cubes, Reporting, and TM1 through Learn Quest an IBM Training Business Partner.

Architected and built out Supply Chain Systems and Analytics for a startup organization. Key Achievements were successfully built, socialized, and delivered a roadmap for Supply Chain Systems and Analytics to support best in class processes for Demand and Supply Planning. And designed and built a Supply Chain Data Warehouse to support descriptive and predictive analytics.

Have 12 plus years’ development experience building TM1 cubes and interfaces

Have 5+ years of architecture, design, implementation, and support of highly distributed applications on the cloud and using data visualization for Dashboard reports.

Developed various Dashboards using Tableau. Drill down, drill across Reports hierarchy oriented Reporting Structure was implemented.

Developed Tableau Report both on Live as well as Extract connections.

Implemented POC using Tableau and acquired many project to use Tableau as Strategic solution.

Created complex formulas and calculations within Tableau to meet the needs of complex business logic.

Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.

Developed Reports Using Cross Database Joins.

Created various Tableau reports using Data Blending for immediate Business needs.

Developed various data connections from data source to Tableau Desktop for report and dashboard development

Utilized almost all the functionalities in Tableau Ex: Stories, Dashboards, Ad-hoc, Sets, Parameters, Filters, Context Filters almost everything.

Worked on Performance Issues while dealing with huge Databases.

Involved in project planning, scheduling for database module with project managers.

Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.Responsible for the knowledge in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for IBM ICM Inbounds & Out-bounds using SQL Server Integration Service (SSIS) 2008.

Experienced technical/business Principal Consultant with a demonstrated history of working in the technical consulting industry. Skilled in Business Process, Microsoft SQL Server Database, IBM Incentive

Compensation Management, Database design, and SQL programming. Strong information technology professional with a focus in Sales Performance Management (SPM) and Incentive Compensation

Management (ICM).

Lead the ICM development team and I training and upskilling of clients technical resources with IBM ICM

Responsible for requirements, database design and ICM implementation for the Quota with the CenturyLink HR payroll managers and the calculation logic design.

Worked with team Configuring and Troubleshooting Cognos TM1, Pulse, Canvas and Planning Analytics local environment including data tier, application tier, and web tiers in AWS environment.

Designed ETL for client using ETL designer in Informatica for several clients over the past 10 years. ETL Tools Informatica mostly but also SSIS and DataStage.

Developed and test all



Contact this candidate