We provide IT Staff Augmentation Services!

Developer / Support Lead Resume

Chicago, IL

SUMMARY

  • 10 +years of experience in building Forecasting/Budgeting applications and Business Intelligence on multiple domains.
  • Experience in installation of Planning Analytics 2.0.9 local server BigFix 9.5.13, ILMT 9.2.19. and PAW administration.
  • Experience in migration of applications from TM1 to PA.
  • Trained end users on PAX, created support documents.
  • Experience in building Forecast and Budget - FTE, Non-FTE, Capital, Income Statement, Balance Sheet and Reporting planning tools.
  • Experience is building applications in TM1 web, PAW and Perspectives (TM1 combined with VBA).
  • Created worked books using advanced virtual dimension concepts in PAX.
  • Expertise in creating Dimensions, Cubes, TI processes and business rules in PA.
  • Created regularly scheduled automated jobs to load TM1 data structures and managed TM1 data through Excel and Spreadsheets
  • Experience with Cognos Tools such as Cognos BI 10.1/8.4 Suite, Cognos TM 1 9.5/10.1/10.2 and Analysis Tools such as Cognos Transformer & Power Play.
  • Experience on Installation & Configuring the Cognos 10.1 BI Environment. Worked on Migrating reports from Cognos 8.4.1 to Cognos 10.1 series
  • Hands on Experience with Framework Manager Modelling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
  • Expertise in developing Database Schemas such as Star Schema and Snowflake Schema, which are used in relational, dimensional and multidimensional modelling.
  • Experience in maintaining Cognos enterprise planning (EP) environment for Forecasting and Budgeting life cycles.
  • Worked on creating packages in MSSQL Server Business Intelligence Studio 2008.
  • Experience in various industry sectors such as Taxation, Pharma, Manufacturing and Retailers.
  • Involved in Performance Tuning, Developed Stored Procedures, Functions and Packages.
  • Worked on Cognos 10 TM1 Insight and Performance Modeler for building Applications, Cubes, Dimensions, Replications, Processes and Models.
  • Knowledge on Power BI (Design and Development).
  • Strong problem-solving skills, ability to develop strategies for clients, and provide detailed documents to clients.
  • Extensive experience in Multiple Relational Databases including SQL SERVER, ORACLE, TERADATA.
  • Deploying Models and reports from Staging to Production and administering users/groups/roles.
  • Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.
  • Excellent Team coordinating Skills with the Development Team and Deliverable dates.
  • Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem-solving skills.
  • Day to day oversight and prioritization of the work of L1/2 Production Support teams
  • Coordination of activities with Infrastructure teams for applications owned by Enterprise Analytics
  • Assist the Enterprise Analytics Support Manager to establish and maintain all corporate policies and programs to assure a safe working environment
  • Assist in the onboarding of new Analytics applications (development/testing of application security, setting up of support structures)
  • Participate in DR (Disaster Recovery) tests and maintain DR documentation for Analytics applications
  • Responsible for analysis of current system including performance, diagnosis and troubleshooting of problem programs and designing solutions to problematic programming.
  • Extensive knowledge of Data Warehousing, BI and OLAP concepts.
  • Acting as a liaison between Business Groups, Architect and Design teams and the Development/Support team.

TECHNICAL SKILLS

DWH/BI Tools: PA 2.0.9, PAW 2.0.49, TM 1 9.5/10.1/10.2 (Performance Modeler, TurboIntegrator, Architect, Perspectives), Cognos EP 8.4(Analyst & CAC),Cognos 8.4/10.1/10.2 Suite (Reports Studio, Analysis Studio, Workspace Insight, Workspace Insight Advanced, Framework Manager, Transformer),SQL Server Business Intelligence studio, Agile, GIT, Fusion

Databases: SQL Server 2000/2005/2008 , Oracle 9i/10g/11g, Teradata, IBM DB2, SAP, SOX.

Operating System: Windows 2008 R2/2003/98/95 and MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Developer / Support Lead

Responsibilities:

  • Worked with end users to gather requirements, analyze, and provided estimations.
  • One point of contact for all TM1 work: Design, Development, Support and Administration.
  • Installed PA and PAW local on windows 2008 R2 and Hyper V servers. Migrated application from TM1 to PA.
  • Developed Balance Sheet, Income Statement, Reporting, Backlog and Bookings TM1 applications.
  • Created processes to extract hierarchies to Reporting dataset for downstream applications.
  • Created process to load data from different sources, archive versioning, open and close forecast cycles.
  • Worked on creating process to identify missing master data in reject tables and send email notification to users.
  • Worked on applying business rules for TM1 cubes, and to transfer data between different cubes to Reporting cube.
  • Acting as a liaison between Business Groups, Architect and Design teams and the Development/Support team.
  • Act as Operational Lead of L3 Production Support team for Enterprise Analytics (managing work assignments and priorities for on- and offshore team members)
  • Day to day oversight and prioritization of the work of L1/2 Production Support teams
  • Coordination of activities with Infrastructure teams for applications owned by Enterprise Analytics
  • Assist the Enterprise Analytics Support Manager to establish and maintain all corporate policies and programs to assure a safe working environment
  • Worked closely with clients on daily basis in Requirements gathering, Design Reviews, peer reviews, Defect calls, FRD calls and effort Estimation
  • Provided knowledge sharing sessions within project team and across the organization.
  • Involved in Staffing of Cognos resources to various Projects.
  • Creating TS & FS design documents for model and reports based on the functional documents
  • Coordinate the review, presentation and release of design layouts, drawings, analysis and other documentation
  • Working with large sets of data, multi-dimensional data sets

Confidential

Computer Programmer/Analyst

Responsibilities:

  • Develop BI and reporting solutions that includes Analyze, design, coordinate and supervise the development of software systems based on business requirement.
  • Giving user support, maintaining reports, models and structure.
  • Responsible for analysis of current system including performance, diagnosis and troubleshooting of problem programs and designing solutions to problematic programming.
  • Maintain positive client interactions
  • Automate excel, foxfro reports in report studio and in Cube.
  • Utilizing the report studio to develop analysis types of reports such as list reports, cross tab reports, chart reports, and master detailed reports.
  • Manage operations of the engagement.
  • TM1 Administration - security, clients’ installation, configuration, migration, modification
  • Partner with other team members in the technical design of various TM1 applications.
  • Developed Reports of list, chart, crosstab, cascading, burst, Master - Detail, Drill Through in Report Studio
  • Doing data visualization in Active Report and in Workspace-Advance.

Technical Environment: TM1 (9.5, 10.2) Architect, Café, Cognos BI 10.2.1.1, Framework Manager, Report Studio, Query Studio, Oracle, Tableau 10

Confidential

Assist Manger/Team Lead

Responsibilities:

  • Developed TM1 Rules, Turbo Integrator process, Dimension, Hierarchy and Dimension subset
  • Implementing TM1 Security, User Access on cube, users rights, Cube View, Core, Metadata
  • Integrated TM1 to cognos software
  • IBM Cognos TM1 10.2 Developer certified.
  • Creating Cubes in TM1
  • Understand and work with Turbo Integrator to load and retrieve data.
  • Experience in TM1 rules editor to create/update various calculations
  • Working with large sets of data, multi-dimensional data sets
  • Developing TM1 applications / cubes in support of business needs and develop TM1 processes and TM1 rules.
  • Responsible for implementation and development of IBM Cognos TM1 - planning, budgeting and forecasting solutions, as well as analytically and reporting applications
  • Acting as a liaison between Business Groups, Architect and Design teams and the Development/Support team.
  • Understanding the business requirements and translate that to technical processes.
  • Manage operations of the engagement.
  • TM1 Administration - security, clients installation, configuration, migration, modification
  • Partner with other team members in the technical design of various TM1 applications.
  • Developed Reports of list, chart, crosstab, cascading, burst, Master - Detail, Drill Through in Report Studio
  • Doing data visualization in Active Report and in Workspace-Advance.
  • Assign user security, user roles and responsibilities
  • Set up new database and audit database in Cognos configuration
  • Developed Dashboards in Cognos Workspace and Report Studio
  • Have Built Reports with various Conditional Styles and Render Variables.
  • Assisted Business users to create reports in Cognos Workspace Advanced
  • Working in Cognos Administration and Production support
  • Working knowledge of Cognos SDK
  • IBM Cognos BI solution design, administration, installation, server configuration, and technical support
  • Built Active Reports in Cognos 10.2 for Business Offline Reporting and Executive Demo presentations
  • Implemented complex data, object and package security filters within the IBM Cognos BI suite of tools
  • Creating dynamic cubes in cognos10.2
  • Built Complex Reports having child reports, HTML items in Report Studio
  • Assisted Users in Creating Custom Definition Groups for better presentation of Reports
  • Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio
  • Experience in creating Ad-hoc reports using Cognos Query Studio
  • Efficient in writing SQL Queries in SQL Server
  • Fine-tuned the reports, underlying queries and tables using indexes.
  • Worked on Production Support and fixing report/package/data issues.
  • Worked on Data Analysis, Validate reports and find data quality issues
  • Production Support which involves solving user problems and Provided End User Training and Support
  • Prepared User documentation to train users and functionality of each report

Technical Environment: Cognos BI 10.2.1.1, Framework Manager, Report Studio, Query Studio, Windows 7, Teradata, Access Database

Hire Now