We provide IT Staff Augmentation Services!

Data Modeler Resume

Charlotte, NC

SUMMARY:

  • Technical Business Intelligence (BI) Professional with over 15 years of BI experience to help the business make data - driven decisions and unlock business value using IBM Cognos. Experience in various industries such as Research, Finance and Manufacturing.
  • BI Solution Architect involved with design, development, testing, administration, support and training.
  • Extensive experience in Software Development Life Cycle (SDLC) including requirement, analysis, design, development, testing and training using IBM Cognos tools
  • Built a solution using confidential to write back data to data warehouse and source systems on ad-hoc basis.
  • Successfully worked on multiple BI projects collaborating with various business units and users, collecting user requirements/problems and providing BI solutions
  • Strong Cognos metadata modeling skills using Cognos Framework Manager
  • Responsible for implementing different levels of Enterprise wide BI security through Cognos
  • Strong understanding of dimensional modelling of Star Schema, Snow Flaked Schema, Fact and Dimensional methodologies
  • Major areas of expertise in designing, developing and modifying different reports like List, Crosstab and Chart reports using Report studio
  • Complex Report building experience with Report Studio by using filters, customized prompts, conditional formatting, drill-through, Cross tab, bursting, Master/details queries
  • Good knowledge of creating data visualization using Tableau
  • Led multiple process improvement and problem solving projects using Xerox’s quality tools

TECHNICAL SKILLS:

Reporting (BI) Tools: IBM Cognos 10.2.2 (Query Studio, Report Studio, Analysis Studio, Event Studio, Framework Manager, Transformer, Cognos Administration)

ETL Tools: Data Manager

Modeling tool: Power Designer

Visualization: Tableau

Languages: Programming in C, HTML, Java Script, PERL

Databases: Oracle 9i,12, TOAD, MS SQL Server

Tools: Visio, Adobe Photoshop, Micromedia Dream Weaver, PaintShop, MS- Word, Excel, Power Point, Access, Avnet MetaManager, AutoVisn

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

DATA MODELER

Responsibilities:

  • Work with Analysts and Subject Matter Experts to identify and understand customer requirements for creation/modification of Enterprise Data environment
  • Develop logical and physical data models including star schemas, snowflake schemas, and highly normalized data models
  • Create detailed Data Flow Diagrams and Source to Target Mapping documents
  • Discussed the Data model, data flow and data mapping with the application development team.
  • Helped QA in Unit testing, resolved Post implementation issues. Provided Maintenance & Support of the existing applications.

Confidential

SOLUTION ARCHITECT

Responsibilities:

  • Created alerts through confidential when LPN parameters were incorrect/out of limit to avoid rejections from airlines
  • LPN data was pulled to DW and modeled along with item attributes to create report that compared actual item weights with the LPN weight.
  • Developed an ability to accurately report on resource planning to fulfill the demand
  • Exposed MRP Orders, Jobs, Routing and Routing Resources data in confidential.
  • Reports were created on past, present and future capabilities.
  • Created Cycle Count Entries and Adjustment Reports to monitor inventory accuracy
  • Exposed cycle count entries data in confidential and Cognos reports with customized fields were created to show mismatch.
  • Pick, Pack and Ship transactional data was pulled in the confidential and transformed to show streamline information for all the LPNs and deliveries for a sales order

Confidential, NC

DECISION SUPPORT SPECIALIST

Responsibilities:

  • Worked on multiple BI projects such as Accrual system, Quick Book, Presto Web, HIPAA System, Scientific Stature.
  • Built a solution using Cognos to write back data to data warehouse and source systems on ad-hoc basis.
  • Developed a solution in Event Studio to reduce scheduled report emails volume from 20 to 1.
  • Responsible for creating new Framework Manager (FM) models, updating existing models and publishing Cognos packages.
  • Implemented and responsible for designing data level security through Cognos.
  • Created and updated Cubes using IBM Cognos Transformer.
  • Responsible for Cognos Administration, Data source Connections, User Security, Creating and Deploying reports and packages, Managing users, groups and roles.
  • Worked on Cognos reports to improve performance from 15 min to a few seconds.
  • Helped power users to create data visualization using Tableau.

Confidential, NC

LEAD CONSULTANT

Responsibilities:

  • Provided production support during month end and on demand cube build cycles
  • Provided user support for reporting, Cognos environments, Access issues
  • Developed reports using report studio and query studio
  • Developed PERL scripts to automate support activities
  • Developed scripts and scheduled tasks for Cognos services
  • Performed Cognos administration tasks
  • Documented and trained the monitoring team to support Cognos jobs

Confidential, NC

COGNOS REPORT DEVELOPER

  • Interacted with the business users about business analysis and reporting needs and documented the requirements.
  • Designed solutions based on user requirements.
  • Worked with QA team to design the test plan.
  • Used Framework Manager to build models, packages and publish packages.
  • Provided the mockup reports to help the developers.
  • Developed List Reports, Cross-tab Reports, Charts, Summarized Reports and Drill through Reports Using Report Studio.
  • Created Cascading prompts, Calculations, Conditions, Filters, Using Report Studio.
  • Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Crosstab, multi-query reports, charts.
  • Created top or bottom performance, Ranks, Filters, Calculations using Analysis studio Reports
  • Customized the reports by adding calculations, conditions and functions.

Confidential, NC

COGNOS REPORT DEVELOPER

Responsibilities:

  • Gathered user requirements
  • Used Framework Manager to build models, packages and publish packages to the Report Net Server. Modified existing packages in framework manager.
  • Designed the Dimensional Models for transformer
  • Developed professional looking multi-query reports with conditional formatting to emphasize exceptional values
  • Developed complex reports using various Prompts, Cascading Prompts, Filters, Summaries and Calculations
  • Created various reports in analysis studio exploring the cube data
  • Created Dashboards to present critical company data in a single report.

Confidential

SENIOR ENGINEER

Responsibilities:

  • Designed a program to get maximum output from wire cutting and crimping machine
  • Designed and developed a program in C for a tool to set the six lens assembly of a photocopier
  • Worked with BA, testers & different teams and DBA to get the issues resolved.
  • Communicated with the users and application team on the issue resolution and prioritization.
  • Worked as a quality specialist to train and educate on the usage of Xerox’s quality tools of process improvement and problem solving

Hire Now