We provide IT Staff Augmentation Services!

Technical Lead Resume

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

Hire Now