SUMMARY

• 9+ years of IT experience in Energy and Financial services industry which includes extensive functional and technical expertise in data warehouse architecture, data analysis, data modeling, performance tuning, ETL tools, product development and reports generation
• In depth conceptual understanding and working knowledge of data warehousing, large data warehouses, operational data warehouse (ODS) and data marts on Oracle platform
• Proficient in business requirements gathering, analyzing, ETL (extract, transform, load), data mapping and analyzing data using Cognos 8/10 BI tool Data Manager
• Extensive experience in Cognos Power cubes and Report Studio in Cognos BI 8/10 for multidimensional cubes design and ad - hoc reporting
• Complete software life cycle development (SDLC) experience - requirements gathering, conceptual design, analysis, detail design, development, testing and implementation
• Experience in Ralph Kimball's data modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation & dimension tables, slowly changing dimensions and surrogate keys
• Liaison experience between data architect, database administrator, end user and ETL team for structuring data into dimensional schemas for the most effective delivery
• Select proper development tools based on design requirements to ensure that suggested tools are best suited for particular task
• Proficient in Database design, creation and management of schemas, SQL query performance tuning, normalization, de-normalization, logical and physical entity relationship diagrams, PL/SQL using Oracle 9i/10g/11g
• Strong development and analytical skills, proficiency in root cause data analysis, and ability to problem solve combined with ability to work independently with minimal supervision and effectively meet project deliverables on time
• Ability to multi-task and provide expertise for multiple development teams across concurrent project tasks
• Experience in unit scripting, VB Script, Microsoft SQL Server

TECHNICAL SKILLS

BI Suite: Cognos Series7.x/8.x/10.1 (Data Manager, PowerPlay Transformer, Framework Manager, Report Studio), Microsoft DTS package

Languages: C, C++, Java, SQL, PL/SQL, SAS, Unix Shell Scripting, Visual Basic 6.0

Databases: Oracle 11g/10g/9i/8i, MS SQL server 2005, MS Access

Operating Systems: Windows 9X/NT/XP/2003, UNIX/Linux

Tools: Toad, CA ErWin 4.1, Harvest, MS-Office, Composite

PROFESSIONAL EXPERIENCE

Senior Data Warehouse Analyst/Developer

Confidential, Richmond, VA

Responsibilities:

• Responsible for understanding the process from Business Analyst/Users and work as SME in providing BI assistance to implement operational data store (ODS)
• Developed Prototypes of some of the possible BI solutions and presented it to the management team
• Design and develop advance cognos reports including cascading prompts, drill down reports, and conditional layouts preferred
• Design and develop Microsoft DTS packages to extract data from different source systems and present information based on the user requirement
• Involved in Migration of applications from Cognos 8.4 to Cognos 10.1
• Responsible for communications between the offshore development team and onsite Project Team and other related departments
• Conducted training sessions with end users to demonstrate capabilities of software based on their business needs

Environment: Cognos Series8.4/10.1 (PowerPlay Transformer, Framework Manager, Report Studio), Unix shell scripting, VB scripting, Microsoft SQL server, DTS packages, Oracle 10g/11g, Toad

Data Warehouse Developer/Architect

Confidential, Richmond, VA

Responsibilities:

• Design and deploy data warehouse consisting of star schema data marts using conformed dimensions by following Ralph Kimball data warehouse methodology
• Gather requirements, perform analysis and design ETL transformations on multiple data sources like relational databases, flat files and data from vendors outside Dominion based on business needs using Cognos Data Manager 8
• Optimize Data Manager ETL process by reducing processing done on database server and fully leveraging transformation capabilities of ETL tool like merging, looping, on demand data caching to transform data
• Design power cube model using Dimensions, allocation levels, measures and user classes using PowerPlay Transformer
• Interact with source system SME to understand source system and provide recommendation on source system to retrieve data in efficient manner
• Work with ETL developers to explain overall big picture of the project and explain how source, target and transformations come together
• Be a guardian and sponsor of existing best practices in documentation, coding, and naming conventions etc. It includes data security, data format and compliance standards if any.
• Conduct code review and peer review meeting with developers to recommend improvements and implement standards
• Work with corporate data architect to gather requirements, design, functional specification and deliver executive reports and framework using Cognos Framework and Report Studio
• Optimize the cube build times drastically and increase runtime performance by time partitioning the power cube and optimizing the SQL queries
• Create Unix shell scripts to preprocess data and automate various processes like building of power cube
• Lead the ETL design by creating source to target mapping for ETL development and coordinating with data architect, source team, end user and ETL developer to deliver effective end product
• Responsible for strict adherence to established data movement best practices and standards
• Prepare ETL documentation for data modeling, ETL standard and procedures, unit and system test case to ensure successful execution of the data

Environment: Cognos Series7.x/8.x (Data Manager, PowerPlay Transformer, Framework Manager, Report Studio), Unix shell scripting, Oracle 10g/11g, Toad

Confidential, Richmond, VA

Responsibilities:

• Researched on fuzzy relational database that dealt with imprecise data (fuzzy information) in a relational database. Application was implemented to retrieve facial images by using fuzzy queries, whose common-language descriptions are defined by the consensus of a particular user community
• Designed and developed the application using VB.NET and SQL Server 2000
• Presented and published the paper on fuzzy relation database in ACM SE conference
• Involved in full life cycle development of the project
• Performed unit testing for each module and prepared code documentation for future references and upgrades

Environment: VB .NET, SQL Server 2000, Windows XP

Analyst/Programmer

Confidential, Irving, TX

Responsibilities:

• Responsible for building SQL queries, query optimization and data validation
• Extensively worked on understanding the business requirements and designing applications to meet the financial requirements.
• Conducted performance evaluation, risk analysis, and performance forecasting for credit card and personal loan portfolios by using programming tools such as SAS and SQL on Oracle 8.0
• Automated the programming tasks and data generation using SAS, and UNIX Shell Programming to facilitate strategic decision making for profitability improvement of diverse overseas portfolio mainly in Japan and UK

Environment: Toad, Oracle 9i, Unix Shell Scripting, SAS

Senior Software Engineer

Confidential

Responsibilities:

• Designed, developed and implemented exam and result calculation modules of the project developed in 3-tier architecture- HTML in the first tier, Servlets in the middle tier, and Oracle database in the last tier
• Analyzed/Designed use cases and created various UML diagrams
• Wrote complex SQL queries and their performance tuning
• Led the team for development of exam and result calculation modules
• Full life cycle development

Environment: HTML, Java Script, SERVLETS, JDBC, ORACLE 8, Windows NT

Software Engineer

Confidential

Responsibilities:

• Developed and tested Forms, PL/SQL Packages, Batch Programs and Reports for Experience Rating and Forms & Correspondence module
• Participated in the development and review of Unit Test Cases and Test Case Identification Forms
• Led quality maintenance of the project using PVCS
• Provided full technical support to the on-site team

Environment: Designer 2000, Developer 2000, SQL*Plus and PL/SQL on Oracle 8.0, Windows NT