We provide IT Staff Augmentation Services!

Datawarehouse Resume

Raleigh, NC

Summary of Experience

  • Eight plus years of professional experience in Software Design, Data Analysis, Data Modeling, Data Warehouse / Mart design, development, Application Support.
  • Lead developer with experience in SDLC processes, standards and managing multiple projects
  • Adept in gathering requirements, profiling data, checking information system needs, evaluating end-user requirement and working through the entire project cycle.
  • Expertise in Relational, Dimensional modeling and creating ER Diagrams, Logical, Physical data models
  • Proficient in writing Complex SQL, PL/SQL, Packages, Triggers, Analytical SQL, functions, Mat Views
  • Sound knowledge in tuning SQL Queries and using Table Partitions, Table Clusters, DB Link, SQL Loader
  • Well aware of the data warehouse concepts using Kimball and Inmon Methodologies.
  • Good understanding of 3 tier architecture: Database, Middle tier, Application Server, Portal and Application
  • Strong skills in the development of ETL Mappings and Workflows using Informatica PowerCenter.
  • Proficient in report writing using tools such as Crystal Reports and Oracle Reports Builder
  • Experience in writing complex Batch and VB Scripts, UNIX shell scripts, Awk and Nawk Scripts.
  • Ability to handle data migrations, heavy volumes of data and installation of application patches.
  • Expertise in managing upgrades, designing business process solutions and deploying scripts in production.
  • Experience in the Installation and configuration of oracle databases on Sun Solaris, Linux, and Windows.
  • Well versed in writing Test plan and Test scripts to test the backend and Front end functionalities
  • Very strong communication, interpersonal skills and extensive International client experience.
  • Education

  • MS-Management Information Systems
  • Post Graduate Diploma in Computer Applications
  • Bachelors of Commerce
  • Professional Diploma in Network Centered Computing
  • Technical Skills

    RDBMS :

    Oracle 9i/10g/11g, Sybase, SQL Server 2000

    Languages/Utilities :

    SQL, PL/SQL, SQL Loader ,VB Script, VC++, VJ++, HTML, DHTML, XML,
    C and C++, Java

    ETL Tools:

    Informatica Power Center/Power Mart 6.2/7.1.2/8.6.1, Data Stage

    Data Modeling:

    Sybase Power Designer 12, ER Studio, MS Visio 2003, ERWIN 4.0

    OLAP:

    Crystal Reports XI R2, Infoview, CMC, Oracle Report Builder 9i/10g, Analytics and OBIEE, Microstrategy 7.2.1, Business Objects 5.1

    Operating Systems :

    Windows NT Architecture, Windows XP, Solaris 8

    Other Tools:

    PLSQL Developer 8.0.4, TOAD 11, SQL Developer 3.0.04, MS Office 2010, Developer 2000, Change Control Application, BMC Service Desk Express, Remedy, Mercury Quality Center, Symantec PC Anywhere

    Version Control Tools:

    CVS, VSS, Livelink Document management, SharePoint, Documentum 6.6

    Applications:

    ORACLE AERS 4.5.1 and 4.6.2 Application/Server/Portal,
    Siebel CTMS, Lawson, SABA, Databasics, AWARD, ART

    Experience

    Confidential,Raleigh, NC Mar ’10 - Current
    DataWarehouse Admin/Developer

    Work as part of Enterprise Reporting to Install, maintain, and support enterprise applications like Crystal Enterprise, Business Objects, Infoview, Analytics, OBIEE and Informatica PowerCenter tools.

  • Work closely with users in the Americas, Europe and Asia to transform data into information.
  • Respond to Help Desk requests via Remedy and troubleshoot, resolve System\\ETL\\reporting issues.
  • Subject matter expert for SABA (Training tool) and designed data models for various subject areas.
  • Use Lawson, CTMS, ART, AWARD, SABA applications to troubleshoot reporting data issues.
  • Participate in the planning of sprints and provide estimates for task completion times.
  • Manage assigned projects, work through the entire SDLC and drive the projects to completion.
  • Conduct business requirement meeting with users of source systems for operational/warehouse reporting.
  • Perform data profiling, research and analysis for Financial, Clinical, HR, Training and other subject areas.
  • Design, develop Type 1 and 2 dimensions, facts, Star Schemas based on user requirements
  • Create and Optimize PLSQL packages for ETL, Reporting to automate and enhance functionalities.
  • Create and manage 500+ backend PLSQL procedures linked to crystal reports (using ref cursors)
  • Develop complex crystal reports and test the report output data in the relevant application for accuracy.
  • Involved in query re-write, creating indexes, SQL tuning and query optimization using Explain Plan.
  • Ensure high level of application availability and provide technical support to developers.
  • Develop VB Scripts and use Informatica, OEM for scheduling jobs at required frequency.
  • Troubleshoot issues with the nightly data load in the Informatica ETL jobs or OEM jobs.
  • Document Requirements, Analysis and Design information related to SDLC for sprint assignments.
  • Create Unit Test Cases, Test Plans based on requirements and perform Unit, Stress and System tests.
  • Work on Analytics, OBIEE dashboards, Prompts, Filter, Queries, Catalog Management and Manage Users.
  • Environment: Oracle 10g/11g,TOAD,OEM, Power Center 7.2/8.6, Crystal Reports 11 R2, Instance manager, Central Management Console, Analytics, OBIEE, Siebel CTMS, ER Studio, Visio 2003, Documentum, VSS.

    Confidential,Morrisville, NC Mar ’08 – Mar ‘10
    Systems Developer

    Worked on Oracle Adverse Event Reporting System (Oracle AERS) - This is a comprehensive solution for product safety monitoring and compliance product integrated with Oracle Clinical and Thesaurus Management System.

  • Lead systems developer in the support of ORACLE AERS Application.
  • Performed Data Migration for various business units with the appropriate workflow, processes and users.
  • Handled communication with users, vendors, clients and trained new system developers in AERS support.
  • Developed custom backend PLSQL Packages for enabling various functionalities in the AERS application.
  • Created complex custom reports using Reports Builder and resolved issues with existing reports.
  • Analyzed backend database objects, functional dependencies to troubleshoot complicated AERS issues.
  • Handled Schema Creation, Report Server Issues, Portal Administration/Issues, User Roles, Data Export/Import, SQL Loader, Installation and Operational Qualification checklists, Meeting Minutes
  • Installed AERS iPatches, handled batch loading scripts and password changes in the database/portal/ application servers and refreshed backup (Disaster Recovery) servers.
  • Created Service Requests with Oracle for Application, Server, Portal and Report related issues.
  • Responsible for creating and maintaining the System Architecture diagram in Visio.
  • Prepared requirements document, flow charts, system specification document, test plans, user manuals.
  • Used BMC Service Desk Express, Quality Center to manage technical issues for Application Support.
  • Responsible for dictionary upgrades, adding products in TMS, creating change controls, IOQs.
  • Created Unit Test Cases, Test Plans and performed Unit and System test as well as validation testing.
  • Environment: Oracle 9i/ 10g, AERS 4.5.1 / 4.6, Remote Desktop, Visio 2003, BMC SDE Express, Change Control Application, Mercury Quality Center, Oracle Reports Builder 9i/10g

    Client:
    Confidential,NC Jul ’07 – Jan ‘08
    DataWarehouse/PLSQL Developer

    Worked as a Lead Developer in Trading Knowledge Center project for Webstats. Webstats is a large data warehouse used for directional analytics.

  • Responsible for System Design and development of DB components based on user requirements.
  • Created and documented System design specification and Technical Design specifications. (SDS/TSD)
  • Used Power Designer for logical, physical data model and database design using database standards.
  • Developed Context, Data Flow Cycle and Sequence diagrams using Visio for SDS / TSD.
  • Created Tables, Synonyms, Grants, Directory and used Dynamic SQL, Ref Cursors, DBLINKS.
  • Worked extensively with PL/SQL packages, procedures, and functions using TOAD.
  • Documented details relevant to different phases - Design, Development and Implementation.
  • Analyzed query performance using Explain plan and worked in an environment containing Partitions.
  • Developed UNIX shell scripts to automate processes and for production deployment of the scripts.
  • Worked closely with the QA Team to resolve defects and performed unit testing for data consistency.
  • Environment: Oracle 9i, Power Center 6.2, Sun Solaris, Power Designer 12, Visio 2003, SharePoint, VSS.

    Client:
    Confidential,Cary, NC Mar ’06 –Jul ‘07
    Junior DBA /Systems Analyst

    Worked as a Junior DBA to provide on call database support as well as a system analyst for many projects.

  • Worked in a high pressure production environment and on call 24/7.
  • Actively participate in System Implementations, Schema changes, Upgrades and Data Migrations.
  • Involved in gathering requirements, database design, logical data model for Stats – Project
  • Created and maintained databases, schemas, tables, indexes, sequences, views and record types.
  • Enforced and maintained database constraints to ensure integrity of the database.
  • Gathered domain knowledge, analyzed data and wrote complex SQL using correlated sub-queries
  • Wrote stored procedures, database triggers, packages, functions, referential cursors, DB LINKS.
  • Involved in query optimization and used SQL Trace, Explain Plan, TKPROF, Hints to tune queries.
  • Generated various reports for different departments using SQL, Unix Shell Scripts, Nawk Scripts
  • Automated processes using cronjobs, monitored database activity, utilization and reported progress
  • Handled Java Programs, JDBC to communicate with the database.
  • Reduce data inconsistency and post-integration issues by providing a robust data validation layer.
  • Environment: Oracle9i, SQL Loader, ERWIN 4.0, Sun Solaris 8, UNIX, Aqua Data Studio, CVS

    Client:
    Confidential,Columbus, OH Aug ‘05 – Jan ‘06
    DataWarehouse developer

    Worked on the Cook Project - This involved extracting data from different data providers to load in the warehouse.

  • Involved in design, development of the Data Mart and used ERWIN for Physical, Logical Data Modeling.
  • Provide analytical expertise, support during Analysis, Design and setting up environment.
  • Used ETL to load data from multiple input sources like flat files, DB2, SQL Server to target DB2 database.
  • Developed complex aggregate, normalizer, XML, join, look up, update strategy transformations
  • Used mapping parameters for incremental loading.
  • Handled Round Robin, Key Range Partitioning and data parallelism to fine tune execution times.
  • Worked with UNIX commands and wrote UNIX Shell Scripts to automate processes.
  • Performed unit test and extensively worked with the QA team to get the desired results.
  • Environment: Oracle 9i, SQL Server 2000, DB2, ERWIN 4.0, UNIX, Power Center 6.2, Business Objects 5.1

    Client:

    Confidential,Scottsdale, AZ Jan ’05 – Apr ‘05

    Programmer/ Analyst

    Confidential,This is a program that uses various attributes, events, classification and file loads. Loyalty card also links actual prescription dispensing activity to patient benefits and interactions.
  • Involved in the design, analysis, programming and testing of the ETL.
  • Extensively worked with PLSQL packages, procedures, functions, ref cursors and triggers.
  • Developed and tested ETL applications for the warehouse using Informatica, Oracle and SQL
  • Developed complex joins in source qualifier transformation using transformation rules
  • Documented the Informatica mappings in excel for the entire project
  • Administrated Workflow Manager to run session, tasks, worklets and workflows.
  • Involved in designing universes, developing reports using BusinessObjects 5.1
  • Environment: Oracle 9i, SQL SERVER 2000, UNIX, Informatica Power Center 6.2, Business Objects 5.1

    Client Confidential,Mineola, NY Aug ’04 – Dec ‘04

    Informatica Developer

    Worked on the Revenue and Statistics Phase II project – This is an expansion of phase I and leverages the dimensional model, focusing on providing analysis reporting capabilities on the billing and usage information.

  • Translated business requirements into data mart design / development
  • Generated sample SQL, PL/SQL scripts to business users for approval.
  • Used Informatica to pull data from Oracle, cleanse, transform and load data to SQL SERVER 2000
  • Used Workflow Manager to setup workflows, worklets and tasks to schedule loads at required frequency
  • Defined and created reports in MicroStrategy 7.2.1 and validated reports
  • Environment: Oracle 8i, SQL SERVER 2000, MS Visio, UNIX, PowerCenter 6.2, MicroStrategy 7.2.1.

    Confidential,Teaneck, NJ
    Management Information Systems – Intern Jan ’04 - Jul ‘04

    • Created databases in MySql to manage prospect contact and mailing lists and developed SQL Queries in MySQL for data extraction, manipulation, reporting and migrated data from MS Excel to MySQL.
    • Established communication information flow systems and helped in marketing research.
    • Involved in marketing system study, requirement analysis and coordinated graduate recruitment programs.
    • Handled the entire correspondence

    Hire Now