SUMMARY:

• IT Professional with 10 years of experience in Business Intelligence, Data Warehousing, Master Data Management, Data Profiling, Database Engineering, Business Analysis, Client Relationship Management and Project/Product Management in Media & Publishing and Enterprise Content Management domains.
• High level of success as a Tableau consultant with rapid business intelligence application implementations driving actionable insights through data visualization
• Extensive experience in Data Visualization, Analytics, Data Management, Data Integration, Implementation and Maintenance of Business Intelligence Applications, and the related Database Platforms
• Develop, maintain and manage advanced BI reports and dashboards using Tableau, SAP Business Objects, Excel, etc.
• Assessing, collecting and documenting business requirements for developing BI analytical solutions
• Experience in using Tableau features for creating different Reports and dashboards using filters, charts, interactive dashboards while configuring data refresh options
• Experience creating multi - level drill down dashboards addressing demands of different stakeholder groups at different levels
• Extensive knowledge in using various Tableau reporting objects like facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters, etc.,
• Experience in Universe Designing, Customizing and Creating BO Reports using Business Objects XIR2 enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View)
• Expertise in Dimensional data modeling, Star Schema Modeling, Fact and Dimensional table design, Physical and Logical data modeling
• Experience in designing, Creating, re-engineering and implementing Data warehouse, Data Marts and ETL
• Designing ETL processes for data transformation using Informatica PowerCenter
• Skilled at using various Informatica Mapping Components such as Source Analyzer, Target Analyzer, Mapping Designer, Transformations, Informatica Repository
• Developing Informatica applications; Designing and developing Workflows, Mappings, Sessions, Tasks, Transformations and Workflow scheduling
• Designing and developing complex mappings to move data from multiple sources into a common target area using Lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator and Update Strategy
• Understanding of Data Warehousing Design Methodology, Data Warehousing Concepts, Database design/architecture including both OLAP & OLTP systems
• Excellent understanding of Data modeling (Dimensional & Relational) concepts like Star-schema, Snowflake schema, Galaxy Schema using Fact and Dimension tables and Relational databases (Sybase, SQL Server)
• Extensive experience in Database Designing and Performance Tuning
• Identifying Business and Data requirements and converting them into conceptual and logical data models
• SQL Tuning, Index Design, Restructuring, Optimization, tempdb Optimization
• Developing Stored Procedures and Triggers, Data-feeds from/to upstream and downstream systems
• Designing Data Migration Strategies and executing large/medium scale data Migration Plans
• Optimizing long running processes by creating batches and performance tuning of sqls
• Automating Backend Processes using Autosys and Crontab
• Managing multi-member Development and QA teams for Production Support & Project Implementation
• Project Planning, Scheduling, Tracking project Metrics’, Customer and Stakeholders’ communications, and Reporting
• Scope Management and Change Control, Defect Management and Root-Cause Analysis
• Experience in Hummingbird Document Management (DM), Records Management (RM), Workflow and Business Intelligence (BI)
• Customizing BI Data model to enable business users to run their reports
• Developing C# Win forms for Paper Document check-out and check-in processes using

TECHNICAL SKILLS:

Business Intelligence/Data Visualization Applications: Tableau, SAP Business Objects XI, QlikView

Database & Database Applications: Sybase, MySQL, MS SQL, Oracle, ERWIN, TOAD, SQL Developer, DBArtisan, Confio-Ignite

ETL Tools: Informatica Power Center - Source Analyzer, Target Analyzer, Mapping Designer, Transformations, Informatica Repository

Languages: Java, C# & VB.NET, JavaScript, HTML, CSS

Other Tools: Rally, JIRA, TFS

Methodology: Agile/Scrum, Incremental, Iterative, Waterfall

ECM Tools: Hummingbird(e-Docs) DM, RM, BI and Workflow, SharePoint, OpenText-Livelin k

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Designed and created schema to support creation of BI reports for Mathematics and ELA K - 12 applications enabling creation of key dashboards for usage trends in districts by different schools and teachers and students
• Identified system issues and related opportunities for system enhancements by analyzing data trends through different dashboards
• Assisted senior management in defining enterprise level KPIs based on analysis of key trends for usage of 2-12 & K-1 apps, content and features
• Created multi-level drill down dashboards enabling quick and ready access to key data catering to demands of different stakeholder groups at different levels
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards
• Worked closely with business power users to create reports/dashboards using tableau desktop

Technical Lead

Confidential

Responsibilities:

• Interacted with business users and business owners to gather business requirements for developing and modifying Universes and Reports using Tableau and Business Objects
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
• Created complex Web and Desktop Intelligence reports to help management to track and monitor Print and Digital book’s Editorial and Production status
• Leveraged Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to support the business logic inherent to mappings
• Guided Dev team to migrate Large/Medium size Data sets from obsolete systems (PPS, CTMS, VISTA) to PCS.
• Integrated business rules into database, created E-R diagrams and mapped the diagram to tables, applied normalization and de-normalization (for optimization)
• Developed a UNIX script for deleting log/temporary files older than 30 days and scheduled the job through cron
• Created/Maintained scripts to automatically drop indexes, perform data loads and recreate indexes after load is over to enable fast bcp for volume-sensitive feeds

Application Developer

Confidential

Responsibilities:

• Customized Hummingbird BI OLAP component to enable different business users to analyze information in multi-dimensional databases
• Configured, customized and implemented Hummingbird BI solution providing users from ability to execute prompted or ‘canned’ queries and reports and the ability to perform complex queries and analysis
• Customized Hummingbird BI SQL Server DB to accommodate Hummingbird DM enhancements and ensured availability of newly added tables/columns for reporting purposes
• Acted as Hummingbird SME and engaged in product implementation discussions with different departments
• Captured product customization requirements and carried out implementation and design impact analysis
• Single handedly carried out product implementation, customization and deployment
• Upgraded existing DM and SQL server to DM 5.2.1 and SQL 2005 respectively
• Enhanced Hummingbird’s OOB MSWork features and enabled auto-population of key information in document templates and modified Macro code to fetch Real-time information from DM Server using DM APIs
• Upgraded existing DM to DM 5.2.1 for different business groups and migrated Dynamic Views from DM 5.0.1 to DM 5.2.1
• Integrated MS Outlook and Lotus Notes with Hummingbird DM Server to enable offline and online access

DATABASE developer

Confidential

Responsibilities:

• Worked with DB Architect to design and create database model, schema & entity-relationship diagram for ORCA application
• Designed and created Datamart for creation of ORCA reporting system supporting canned and ad-hoc reports
• Designed and developed database objects including tables, views, functions, triggers, stored procedures and automated scripts in SQL Server
• Assisted team in creating complex, performance optimized SQL queries to carry out different DB transactions
• Managed performance and tuning of SQL queries and fixed the slow running queries in production using MSSQL Profiler, Index Tuning Wizard and SQL Query Analyzer
• Maintained DB performance by following tuning tips like normalization, index creation, index de-fragmentation, reorg, rebuild and application of best practices while ensuring data integrity
• Developing system level reusable JavaScript functions and stored procedures