We provide IT Staff Augmentation Services!

Data Warehouse / Report Analyst/consultant Resume Profile

EXPERIENCE SUMMARY

  • Certified QlikView Designer and Developer
  • Seasoned Business Intelligence professional with over 12 years of experience. Expertise in Data and visualization
  • Diverse experience working with multiple Dash boarding and Reporting applications like QlikView Cognos and Actuate
  • Extensive experience in Data modeling. Strong background in designing datamarts and data warehouses using SSIS and Informatica
  • Provided complete life cycle development in QlikView. Requirement gathering Data modeling creating visualizations and deployment on the QlikView Server
  • Worked with different ETL tools and CRM like Informatica SSIS and Sales Force.com
  • Worked with end users for requirement gathering. Developed end to end solutions
  • Worked on different systems including financial Insurance and Telecommunications.

Technical SKILLS

Reporting

Cognos10.X/8.4 Framework Manager Cognos Connection Report Studio Query Studio Analysis Studio Actuate Reporting suite 10.0

ETL Tools

SAS Data Integration Studio 4.4 Information Map 4.3.1 SqlServer Integration Services SSIS 2008/2005 Informatica Power Center 8.x/7.x Salesforce Apex Data Loader QlikView Expressor 3

Databases

DB2 Oracle 11/10g/9i MS SQL Server 2008/2005 TOAD Excel and MS Access 2007

Web

IIS TOMCAT Netscape Web logic 6.0

Version Control

TortoiseSVN Harvest Documentum Visual Source Safe Magic Test Director Share point

Dash boarding

QlikView 11.0

CRM

SalesForce.com

PROJECT EXPERIENCE

confidential

QlikView Developer

SunTrust is a leading financial institution. As a QlikView developer supported different LOBs with their dash boarding and reporting requirements. As an ETL developer build reporting data mart in SSIS

Responsibilities

Dash boarding

  • As a QlikView developer supported various LOBs and departments with Dash boarding requirements
  • Given presentations demos to the users on QlikView functionality. Got users onboard with the QlikView dashboards
  • Designed dashboards for consumer complaint lean six sigma Incident Management and Chat Sessions
  • Analyzed database to get all the required data attributes. Worked on various data sources like Sales Force.com SQL Server and DB2.Performed data extraction from different data sources to build dashboards
  • Designed data model using Sales Force connector database connection excel XML files and Share point List
  • Followed data modeling best practices. Build QVD architecture for data load. Created data layer transformation and presentation layer. Resolved synthetic keys in the model. Used various Load statements viz. Inline Resident Preceding CrossTable and so on.
  • Used functionality like Apply Map Match Peek AGGR Bookmark and Alternate State
  • Created multiple tab dashboards. Created Pivot tables Trend graphs Bar graphs Stacked Graphs Cumulative Line Graphs containers and so on. Used variables to show and hide objects based on user selection
  • Used SET Analysis expression to perform calculations based on user selections in list boxes
  • Implemented data level security by creating Section Access QVW and Binary Load. Performed incremental load
  • Build Benefit Summary stacked graph depicting the amount invested in projects that completed to projects that are active new or on hold
  • Build lean ideas by Department graph providing count of people trained in different lean 6 sigma belt across the company per business segment per department
  • Timeliness chart for Consumer Complaints. Top Trends in Volume of complaint per product Mortgage Credit Card Consumer Deposit Volume Consumer Lending Trends.
  • Build volume chat session all per day. Top 10 reason for chat. Source was XML file and used Loop Functionality to extract data.
  • Responsible for deploying dashboards on QlikView Server. Created load and distribution tasks
  • Managed Sales force CRM environment

Wrote VBS script to execute QlikView QVD builder/QVW from command prompt in development environment

ETL

Used SalesForce.com Apex Data loader to Extract/insert/upload data into cloud database for Business needs.

Build Database tables wrote ETL process using SSIS to transform Data from different sources such as datamarts CRM Flat Files SharePoint list others. Set up linked database

Wrote VBS script to automate data extraction using Apex Data loader.

Development Tools QlikView 11.0 QlikView server/Publisher Sales force.com Apex Data loader SAS EG5.1 SAS Data Studio MS SQL Server 2005/2008 SQL Server Management Studio SSIS Oracle 11g TOAD

Confidential

QlikView Developer / Consultant

COX communications is a third-largest cable entertainment and board band service provider.

Responsibilities

  • Involved in high-level and detailed specification design for the development of Dashboards
  • Designed dashboard for Incident management. Dashboard displayed analytics on different incidents like technology weather facility and life safety
  • Data was sourced from flat files and SQL Server. Data associations are performed between Flat files and SQL Server
  • Created visualizations like Stacked graph Trend chart pie chart straight table Pivot table
  • Created Survey dashboard. Dashboard provided insights into the service level satisfaction by resolution group and portfolios. Data was extracted from multiple excel files
  • Converted SSRS reports to QlikView dashboards
  • Involved in designing and developing Data Warehouses Data marts using Star Schemas and Snow Flake Schema functionalities
  • Designed and developed SSIS Packages to extract data from various data sources such as flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS
  • Created Stored Procedures for better performance to generate reports
  • Performed unit testing peer reviews. Optimizing mappings
  • Responsible for resolving migration issues. Working with Testers during UAT. Providing clarifications bug fixes and scheduling.
  • Developed Custom Reports using SSRS/SQL server BI studio
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Created tabular matrix chart drilldown reports parametric and cascaded reports according to business requirement
  • Created Stored Procedures for better performance to generate reports
  • Responsible for Migrating code from development to UAT environment using both XML format and deployment group in Informatica
  • Performed unit testing peer reviews. Optimizing mappings
  • Responsible for resolving migration issues. Working with Testers during UAT. Providing clarifications bug fixes and scheduling.

Development Tools QlikView Desktop 10/11 QlikView QVDs QlikView Server/Publisher MS SQL Server 2005 SQL Server Management Studio SSIS SSRS Informatica 8.6.1 Reporting Oracle 11g Tomcat Windows XP Linux

Confidential

Sr. Programmer Analyst/Consultant

ATT Cingular is the nation s fastest 3G network and the largest international coverage of any U.S. wireless carrier.

Responsibilities

  • Involved in the entire SDLC for ATT project. i.e. Data gathering Designing of ETL Development ETL Job Implementation Peer Testing etc.
  • Analyzed database and tables. Prepared the ETL mapping document source to target. Worked with Sr. Software Engineer to translate design documents into software specification. Involved in defining technical and functional specifications for ETL process
  • Involved in development phase meetings for Business Analysis and requirements document reviews and in translating business requirements into high level design specification
  • Parsing high-level design spec to simple ETL coding and mapping standards
  • Played role in design of scalable reusable and low maintenance ETL templates
  • Designed and developed SSIS Mappings to load data from Source systems to staging tables and then to Data Mart
  • SQL was written is such a way that it can be easily reused and maintained for future projects.
  • Created SSIS packages to perform ETL task from various data sources like Oracle text files SQL Server and reporting data
  • Generated parameterized/Drilldown reports using SSRS
  • Created various UNIX Shell Scripts for scheduling various data loading process. Maintained the batch processes using Unix Shell Scripts
  • Perform unit testing at various levels of the ETL
  • Provided knowledge transfer to the end users and created extensive documentation on the design development implementation daily loads and process flow of the mappings
  • Work with QA analysts to ensure proper test plans are developed
  • Involved in Installation of DataStage for POC

Development Tools MS SQL Server 2005 SSIS SSRS SQL Server Management Studio SQL Server Business Intelligence Studio Informatica 8.x Power Center Workflow Manager Workflow Monitor Repository Manager Oracle 11g Web sphere Windows XP Unix Sun Sparc SourceSafe TOAD Korn Shell Erwin

Confidential

Senior Programmer Analyst

21st Century Insurance is an Auto Insurance company owned and operated by Farmers Insurance.

Responsibilities

  • Analyzed reporting tables views and procedures. Created Tables Indexes and Triggers.
  • Developed ETL s using Informatica to upload compensation tables in True Comp.
  • Created Informatica mappings using different data sources viz. database tables flat files xml. Used various transformations to implement the right functionalities.
  • Created reusable Informatica sessions and workflows and used parameter files and variables.
  • Monitored workflows using Informatica Workflow Manager and Informatica Workflow Monitor.
  • Wrote UNIX scripts to automate the application processes. Wrote UNIX scripts to schedule Informatica workflows report execution process and pipeline process.
  • Prepared common utilities in UNIX such as e-mail notifications file transfers using scp and archival processes. Enhanced and debugged Perl scripts for data warehouse support.
  • As Report server administrator managed services users assigning privileges to reports. Monitored Server space folder cleanup and so on.
  • As a support person debugged pipelines Informatica mappings reports and so on.
  • Developed and enhanced crystal reports for Saleslogix system.
  • Developed and Enhanced actuate reports for True comp EIM.
  • Generated reports in excel using Acexcelworksheet functions in Actuate. Developed reports which can be generated as roi and CSV simultaneously.
  • Overridden Actuate API s to download reports in PDF and ftp to cold fusion.
  • Worked as a support personnel monitoring overnight jobs troubleshooting problems so on and so forth. Worked on enhancement and modification of the reports.
  • Involved in upgrade of Callidus/True Comp from version 4.3 to version 4.4.0.4.
  • Developed data model using Cognos Frame work manager. Developed Reports using Cognos 8.3 Report studio. Analyzed data using Query studio

Development Tools Cognos 8.3 Framework Manager Report Studio Query Studio Informatica 7.1.1 Power Center Workflow Manager Workflow Monitor Repository Manager Crystal Reports XI Actuate 7.0 E-Reporting suite True Comp 4.4.04 Oracle 10g Web sphere Windows XP Unix TOAD

Confidential

Data warehouse / Report Analyst/Consultant

IBM Global Business Services offer strategic business consulting expertise in industry-specific business and IT issues.

Responsibilities

  • Analyzed database and tables. Created reporting tables views and so on.
  • Analyzed requirement documents for ETL mappings and workflows.
  • Implemented reusable Informatica sessions. Made use of parameter files and variables.
  • Redesigned and monitored Workflows using Informatica Workflow Manager and Workflow Monitor.
  • Identified data discrepancies and enhanced data quality by various Informatica transformations.
  • Wrote cron jobs in UNIX to schedule Informatica workflows.
  • Provided script to schedule and run the reports and IO to support team.
  • Worked on Report enhancement and change requests.
  • Involved in providing steps for implementing scheduling and running of Reports/Workflow objects in Production to support team via Change Management Tool used by IBM.

Development Tools Informatica 7.1 Power Center Designer Workflow manager Actuate 8.1 E-Reporting suite DB2 Iplanet Windows XP UNIX Manage Now DB Visualizer Tool for DB2 Application Development Front end for DB2

Confidential

Report Analyst/Consultant

Confidential is a leading provider of local and long distance phone service High Speed Internet Wireless Advanced TV service.

Responsibilities

  • Developed Informatica mappings to pool data from various sources including Oracle and SAP.
  • Removed any data discrepancies and restructured Informatica mapping by using various transformation to provide the right data.
  • Evaluated source data for ETL and recommended data acquisition and transformation strategy.
  • Developed various reports viz. Sales Payout Analysis Bonus reports so on and so forth.
  • Created Unix Scripts as per the requirement.
  • Worked on the solution of day-to-day customer problems. Provided clarifications on the reports.
  • Involved in implementation of Actuate objects in Production and Pre-prod environments.

Development Tools Informatica 6.0 Actuate 6.0/7.0/8.0 E-Reporting suite Oracle 8i TrueComp3.1/3.7/4.1 Iplanet Windows NT/2000 Sun-Solaris 5.8 Test Director HTML TOAD Tool for Oracle Application Development Front end for Oracle

Confidential

Report Developer/ Consultant

The Charles Schwab Corporation Charles Schwab provides services to retirement and other benefit plans.

Responsibilities

  • Developed various reports for the Retirement plan project. Worked on Sequential reports Cross-tab reports graphical reports using XML as a Data source.
  • Created configuration files to include the libraries in the reports.

Development Tools Actuate e.Reporting Suite 5.0/6.0 Windows NT 4 SqlServer 2000 XML HTML IIS

Confidential

Developer

Confidential is a leading chemical Research Lab.

Responsibilities

  • Involved in system study requirements gathering and analysis. Designing of inputs and outputs.
  • Designed the ER model and Data Schema using Designer 2000. Generated the server logic DDL script using Designer 2000.

Development Tools Oracle7.3 PL/SQL Developer 2000 Forms Reports2.5 Windows NT

Hire Now