We provide IT Staff Augmentation Services!

Bi Data Ingestion Framework Resume

Bellevue, WA

SUMMARY

  • A Software Professional with 9+ years of experience as lead and consultant with recent emphasis in Big Data, Data warehousing, Business Intelligence Reporting, Analytics.
  • 9+ years of experience in all phases of software development, software architecture
  • Big Data Experience that includes Hadoop technologies with Hive, Pig, Sqoop technologies
  • Expertise in deriving big data patterns out of big data problems and designing solutions
  • Experience in Data Visualization tool like Tableau and Reporting tools like Cognos 10BI, Cognos TM1, MicroStrategy, SSRS, OBIEE
  • Proficient in Hive QL and SQL scripting and Query optimizations.
  • 9+ years of working experience in projects using Cognos BI Tools namely Cognos 10.2, Cognos 8.4 Suite (Framework Manager, Report Studio, Analysis Studio, Query Studio, and Cognos Connection), PowerPlay Transformer.
  • Experience in Cognos dimensional modeling and Transformer Cubes development along with DM functions and micros.
  • Database Experience includes Oracle, MySQL, Microsoft SQL server, Teradata
  • Proficient in Data warehousing concepts and Methodologies, Data Modeling Concepts: Dimensional Data Modeling, Fact Table, Dimension Table, OLTP, OLAP, Star schema, Snow Flake schema
  • Experience in Data modelling tools like SAP power designer and Erwin
  • Proficient in Data Modelling techniques like Physical Modeling, Logical Modeling, Conceptual Modeling, Dimensional Modeling (Star Schema, Snow - Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams
  • Solid experience in writing SQL queries, PL/SQL, Stored Procedures, and optimization.
  • Hands on experience in DWH concepts, Data Modeling and Data Profiling.
  • Excellent Client interaction skills and proven experience in working independently as well as in a team, good Confidential Documenting and Understanding User requirements and System Specification.
  • Strong work ethic with desire to succeed and make significant contributions to the organization. Sound technical, analytical, programming skills and good communication and inter-personal skills.

TECHNICAL SKILLS

Big Data: Hadoop, Hive, PIG

Data Modeling: SAP power designer, Microsoft Visio, Erwin 4.5

BI Tools: Cognos Series 8 & 10 (Framework Manager, Report Studio, Query Studio, Analysis Studio), PowerPlay TransformerCognos TM1 10.2.2, MicroStrategy 9.x/8.x, Tableau, SSRS, OBIEE

Databases: Oracle 10g/9i/8i, SQL Server (2005/2008), MS Access 2000, Teradata V2R6.0

Supporting Tools: JavaScript, Toad, Mercury Quality Center 9.0, Pl/SQL Developer

ETL Tool: DataStage Enterprise Edition (PX), v7.5Informatica Power Center v6.1/5.0

OS: Windows 95/98/XP/NT, UNIX (Solaris, Linux)

PROFESSIONAL EXPERIENCE

Confidential, Bellevue WA

BI Data Ingestion Framework

Responsibilities:

  • Worked on Big Data Framework.
  • Created Hive tables and written the Hive scripts to extract the data.
  • Created Pig Transformations to transform and load the data to Data Lake.
  • Worked on Logical and Physical data models for Hive using SAP Power designer.
  • Developed Cognos reports and Dashboard using HDFS Data for data analysis and data mining.

Environment: Cognos 10.2 BI, Hadoop, Hive, PIG

Confidential, Oakland, CA

BI Data Ingestion Framework

Responsibilities:

  • Participated in the workshops for gathering requirements.
  • Analyzed the impact on the reports due to the Cognos version upgrade.
  • Worked on Package modifications on Framework Manager and deployed monthly releases to production.
  • Created new reports in Report Studio and enhanced existing reports.
  • Upgrade of Cognos reports of 5 packages from 8.2, 8.4 to 10.2 version
  • Validated the reports data and tested the performance in Dev, test and Prod environments
  • Worked on production support to the weekly IQD transformer cubes refresh.
  • Validated the Cube data and execution.
  • Worked along with Admin teams on the Cube issues.
  • Worked towards adapting Data visualization through Tableau and Hadoop technologies like HBASE, HIVE, PIG, Sqoop in to the Client BI Architecture for Big Data analytics platform for processing customer viewing preferences and social media comments.

Environment: Cognos 8.2, 8.4, 10.2 BI, PowerPlay Transformer, Hadoop, Hive, PIG, Tableau

Confidential

BI Data Ingestion Framework

Responsibilities:

  • Participated in the Client interactions for gathering requirements.
  • Analyzed the existing Stored Procedure scripts/jobs in Datamarts pointed to Reports
  • Developed Framework Manager model from multiple database sources and published the packages
  • Changed the reports packages to the new packages.
  • Validated the reports data and tested the performance in Dev, test and Prod environments
  • Daily support the work of the Alcon Sales reps FCNs on Siebel application
  • Security Check: Add users, remove users, assign different role as per the employer change in designation as per the Business Rules
  • Handled the project independently.

Environment: Cognos 10.1BI, SQL Server 2008, Siebel

Confidential

BI Data Ingestion Framework

Responsibilities:

  • Analyzed the existing system in 8.3 environment and replicated the same in 10.4 using Teradata database
  • Validated the reports data and tested the performance - supported database systems
  • Worked on Database for performance tuning - created indexes, database views, materialized views, collected stats
  • Worked on the Framework Model changes
  • Checked the compatibility of reports
  • Configured the saved folders to Burst locations
  • Documented the KTLO - operational Guide for production use.
  • Generated BI reports and dashboards with parameterized, drill down, drill through, sub reports using SSRS
  • Wrote complex SQL statements to ensure data consistency by filtering corrupt data and implemented various constraints and triggers to preserve data integrity.
  • Developed matrix and tabular, drill down, drill through, and parameterized reports based on the requirements
  • Scheduled the reports to run on daily, weekly basis in the report manager.
  • Designed packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
  • Developed customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: Cognos 8.3 BI, 10.2BI, Teradata, SQL Sever 2008

Confidential

BI Data Ingestion Framework

Responsibilities:

  • Attribute rationalization for 99 GCD and MIS/CPR Reports
  • Designed Logical Data model for key bank entities
  • Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
  • Created MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and Architect.
  • Developed Customized and Ad-hoc reports in Grid & Graph mode using Templates, Metrics, Filters, Custom Groups, Consolidations and Transformations - The end-users were able to generate Ad-hoc Report by Drilling up, down, within and across dimension or anywhere.
  • Execute periodic - weekly & monthly standard reports consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
  • Creation of Interactive Dashboards in reports & utilized the new features to convert the dashboards into Flash mode.
  • Created Complex Metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
  • Effectively manage Changes through Change management process.
  • Created Summary and Drill down reports for various attributes based on their hierarchies.
  • Efficiently handle and Manage production support activities through Incident Management.

Environment: MicroStrategy 9.0, Oracle 9i, Windows XP, Autosys, MS Visio 2010

Confidential

BI Data Ingestion Framework

Responsibilities:

  • Documented the Implementation Approach and Design Specs for PIM dashboards and Reports.
  • Construct the metadata model and created query subjects, filters and packages.
  • Published packages with appropriate security settings to Cognos connection.
  • Developed PIM Business Metrics dashboard and Operations Metrics dashboard and its drill down reports.
  • Used Stored Procedures to output the Metrics onto the dashboard.
  • Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
  • Created Reports using Tabular SQL to reduce the load on the Framework Manager model
  • Created Query Prompts, Calculations, Conditions and Filters in the reports.
  • Developed Prompt Pages and Cascaded input Prompts to display only the selected entries in the report. Created ad-hoc reports Using Query studio

Environment: Cognos 10BI, SQL Server 2008 R2, Informatica Power Center v6.1

Confidential

BI Data Ingestion Framework

Responsibilities:

  • Involved in the development of the Metadata Model using Framework Manager and created query subjects, filters and packages.
  • Published packages with appropriate security settings to Cognos connection.
  • Developed complex multi-queried Business reports for the client for below modules:
  • Created adhoc reports Using Query studio
  • Administered tasks such as scheduling reports to auto generate mails to the Users, deployment, and security.
  • Daily work on the Requests logged by the Users in the DESFlow. (DESFlow is the firm's proprietary workflow management and request tracking system.)
  • Written SQL queries and created Stored Procs to be used in Cognos Package
  • Validated and tested the reports data against the GUI by writing test SQLs

Environment: Cognos 8BI, Teradata

Confidential

BI Data Ingestion Framework

Responsibilities:

  • Using Cognos Connection created and managed data sources, administer reports and deploy data from one environment to another.
  • Created List, Cross-Tab reports to users for Ad-Hoc reporting and analysis.
  • Developed professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, Page break, Master - Detail, drill through, drill up, drill down and have extensively used the other features in Cognos 8
  • Created Canned Reports using standard filters, calculation prompts, and conditions.
  • Installation and configuration of Cognos BI & Planning Services
  • Creating Planning contributor applications
  • Access to administration, creation of Local NT users to the Connection
  • Generation of final reports and documentation.
  • Deployment of Package and Reports to other servers
  • Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
  • Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Repository using Administration Tool.
  • Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
  • Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
  • Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
  • Generated BI reports and dashboards with parameterized, drill down, drill through, sub reports using SSRS for iDecisions Framework.
  • Wrote SQL statements to ensure data consistency by filtering corrupt data and implemented various constraints and triggers to preserve data integrity.
  • Developed customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Environment: Cognos 8.X, Cognos Planning 8.4, OBIEE 10.1.3.3, SQL Server 2008, Oracle 10g, MS Access, TOAD 7.4 MS Word, MS Excel

Hire Now