SUMMARY:

• Over 8+ years of IT industry experience with good understanding of Business intelligence applications, Database development, Data Warehousing, Data marts and ETL for clients in major industry sectors like Retail Sales, Pharmacy, Insurance, and Finance, with full involvement in implementation of cycle development in BI project.
• Design and Built Confidential Solutions for Account payable finance users. Worked directly with customers to define and design dashboard requirements.
• Designed and implemented proof of concepts for clients in the Healthcare, Pharmaceutical, Financial and Manufacturing sectors.
• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys, including Performance Tuning and Deployment of Confidential Applications
• Extensive experience in developing different analytical applications using Confidential suite of Products ( Confidential Server, Publisher and Confidential Enterprise, Qliksense).
• Expertise in Creating Dashboards using Confidential 11.0 using different data sources like DB2,Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Experience in advanced loading concepts like ‘Incremental Reload’, ’Partial Reload’ and ‘Binary Reload’.
• Involved in Optimizing existing Confidential dashboards with a focus on usability, performance, long - term, flexibility, and standardization.
• Demonstrated professional excellence in understanding the customer’s business needs and translate them into targeted and effective solutions that improve processes, increased productivity & reduce costs.
• Extensive experience with Confidential BI in planning, designing, implementation, maintenance, expertise in designing Confidential applications and building BI dashboard and analytics reporting solutions/reports with graphs and analysis.
• Involved in the full life cycle of the data warehouse building process including ETL and reporting lifecycle reloads automation and management using Confidential also creating qvd extracts and report reloads, reporting BI needs and enterprise reporting architecture.
• Experience in scripting language Macro,VBScript,JavaScript,AJAX, PDF reporting, Confidential enterpriser and publisher, Confidential developer,Section Access writing,security Entitle model.
• Experience in installing and configuring Confidential Desktop, Confidential Server, Confidential publisher, Qliksense,Qlikmaps.
• Strong Experience in all Confidential objects, Pivot list, Multi box, multiple chart types using complex multiple data sources like SQL, Flat files, Excel and access for deigning and modeling of Confidential, data cleansing, data transformation.
• Expertise in Dimensional Data Modeling, Qlikmart, Star Schema,Snow Flake Schema, Fact and Dimensional tables, Strong Skills in Data Modeling & Loading data from multiple data sources.
• Working knowledge of RDBMS in ORACLE 8i/9i/10g and SQL SERVER 2000/2005.
• Proficient in SQL and PL/SQL Programming for reporting database integrity.
• Ability to work in a team environment. Strong communication and interpersonal skills, creation and implementation of KPI’s, deliveries as per SLA’s.

TECHNICAL SKILLS:

BI Tools: Confidential 11/10/9, Hyperion reporting and analysis 9.x/11.x, SAP,BO,Crystal Reports, SAS

Tools: TOAD, SQL developer

Operating Systems: UNIX, Windows NT/95/98/2000/ME/XP

ETL Tools: Informatica Power Mart 4.5.2, 4.7.3 and 5.1.1, Power Center 1.7 and 5.1.2

Data Analysis and Reports: Business Objects v 5.1, Erwin data modeller

DBMS: Oracle 8.x, MS SQL Server, MS Access.

Servers: WebSphere 5.1, WebLogic 5.3

Languages: TSL, VB Script, Java Script, JDK 2.0, Java 1.2, SQL, PL/SQL, C, Shell, python

ERP Packages: Peoplesoft version 6.0. (People Tools, People Code & HRMS Module)

Internet Tools: VB Script, Java Script, Active Server Pages 2.0, and HTML.

Job Scheduling: CONTROL-M & AnthillPro

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Global Applications Developer

Responsibilities:

• Reviewed user requirements and expectations, providing end to end reporting solutions
• Created dashboards by extracting data from multiple databases, sorting into QVD files, write load scripts
• Executed existing data models and optimizing them including load scripts to load data.
• Design the data model, constructed data model, implementation of Star schema for QV better optimization
• Created Dashboards using chart boards such as Bar Chart,Pie chart, straight table and Pivot table
• Created Variables and to enhance the functionality of Confidential .
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the Confidential publisher
• Developed Confidential documents and frameworks for l,ERP, CMMS,Point of scale and medical instruments
• Conducted testing of dashboards for functionality, data, performance, look and heel
• Managed schedules and reloading of Confidential data model QVds and QVWs through Confidential QEMC
• Developed Confidential data warehouse enterprise framework.
• Used exceptional handling for handling errors of programs, Scripts and procedures
• Participated in creating stored procedures to generate various Drill through reports and functions to support efficient data storage and manipulation
• Converted business requirements into technical specification and designed for reporting Database/data mart and Adhoc/standard reports using Confidential
• Designed and Developed Confidential dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar meeting the business requirements
• Generated new QVD files from the EDW by writing scripts in Confidential applications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys
• Developed forecast models and created 3 year forecast model implemented in Confidential
• Extensively worked on Confidential Set Analysis
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys
• Experience in scripting Confidential Set Analysis and Macros.
• Used Simple and Complex SQL Queries like Joins, Select, and Update for data validation and data manipulation
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.Responsible for doing all the functional testing of the application
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Involved in defect tracking, reporting and coordination with various groups from initial finding of defects to final resolution.

Environment: Confidential 10/11, Oracle,SAP BW, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Confidential Enterprise Server, Confidential Server and Publisher

Confidential, Long Island,NY

Applications Developer

Responsibilities:

• Gathering Business requirements and created technical and functional specs and worked with business clients to confirm and clarify requirements and business logics
• Extracted information from different data sources like Teradata, Sql Server, MS access and flat files etc by using different scripts like add, concatenate, resident, qualify, unqualify
• Developed Dashboard size of layouts using different sheet boxes like list boxes, Multi boxes,slider, current selections box, bookmarks etc.
• Upgraded Confidential Server from Confidential 9.0 SR3 to Confidential 10.0 SR3
• Wrote scripts and created batch files for automatic running of Confidential scripts and was also responsible for batch scheduling
• Automated and scheduled daily /weekly /monthly data loads of QVW documents using Confidential publisher
• Conducted different tasks like repeat tasks, reload tasks, and distribution tasks using the Confidential publisher
• Maintained and administrated source documents, source document sets, user profiles and executed resource management services like access point resources, distribution folders and email servers.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction in loading time, simplifying complex issues in the front end, improving layout structure.
• Involved in design and development of Confidential platform integrated and expandable databases.
• Created complex data models without synthetic tables and circular loops
• Involved in writing shell scripts.
• Validated conceptual documentation and Technical specification documentation
• Tested the source to target mappings that contain the business rules for the server during the extract, transform and load process using Informatica ETL Tool.
• Verified schedules and monitoring sessions using Informatica Server Manager
• Verified very often, the Source to Target Field Mapping Report, this contained transformations, expressions and descriptions in a mapping for documentation.
• Prepare log file from test environment UNIX box on periodical basis to allow space.
• Coordinated with the developers to fix the problem and enhancing the application delivery process.

Environment: Confidential 10/11, Oracle, BO, SQL Server, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Confidential Enterprise Server, Confidential Server and Publisher, Qliksense

Confidential, Livonia, MI

Applications Developer

Responsibilities:

• Developed systems architecture for Confidential implementation identifying the data sources and target reports.
• Analyzed end user requirements and developed technical solutions.
• Developed different complex models eliminating closed loops, Synthetic tables and ambiguous relationships.
• Worked closely with end users and developers to validate the data model.
• Used variables for calculation purposes.
• Reviewed Confidential error logs and daily production support.
• Created PDF push reports.
• Optimized existing Confidential reports.
• Used Mapping tables, Apply Map, resident load, concatenate, joins etc…
• Implemented complex SET Analysis for aggregation calculations so that set of records can be defined in an expression.
• Implemented what-if functionality for analytical purpose.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Standardized the sheet by Universal Naming Convention.
• Designed and developed easy to use dashboard with different types of Charts, Dynamic Text Objects, Tables to meet the requirements in the simplest way.
• Developed Heat map charts with Alternate state for data visualization.
• Developed scatter and radar charts for regional analysis.
• Used Check boxes and radio button for dynamic display of dashboards and reports.
• Developed KPI’s, User Interactive Sheets as business needs.
• Efficiently used hierarchy and Interval match for grouping.
• Identified the highly memory consumption objects and performed necessary steps to reduce memory used by objects.
• Implemented Incremental Load to improve application performance.
• Implemented section access for Department and Designation level security.

Environment: Windows 2000 Server, Confidential 11.0, Oracle 11g, SQL Server 2005, MS Office.

Confidential, Houston, TX

Data Analyst

Responsibilities:

• Worked directly with end users to gather Business requirements.
• Design and develop a front application in VB 5.0.
• Designed and developed Search and View screens and did field level validations for all the fields used in the application using VB6.0.
• Analyzed the source data coordinated with data warehouse team in developing relational model.
• Used ETL for the design of the Warehouse.
• Used the Oracle Client, TOAD to run SQL queries. Written advanced SQL queries to test the database backend.
• Responsible for classifying the attributes and entities as part of Entity Relationship Modeling.
• Involved in Data Mapping for given set of requirements, Queried the Database using Complex SQL Queries as part of Data Mining and performed analysis, design and Data Modeling.
• Involved extensively in the Logical, Physical, Transformational and Conceptual stages of Data Modeling, during the Database Design Life Cycle (DDLC).
• Used MS Excel to create Tables and Charts.
• Extensively used Erwin for Logical / Physical data modeling and Dimensional data modeling, and designed Star join schemas.
• Used Microsoft Project to create visual representations of Program Plan for reporting to Senior and Executive level managers and update them regularly.
• Created new wikis/information portals for the various groups within engineering (Apache Web server and eTouch/SamePage wiki), including: audience analysis, wireframes, blueprints and functional prototypes.

Environment: Confidential 10.x/9.3, MS Excel, Teradata,Oracle

Confidential

Data Analyst

Responsibilities:

• Developed Project Concept and Defined Project Scope with the assistance of team lead.
• Created Work Breakdown Structures (WBS), Project Timelines and Project Schedules using MS Project.
• Perform data manipulations and scrubbing. Unix, BTEQ and KSH scripting.
• Designed the database in MS Access (Creation of Database, tables, views and Procedures).
• Performed validation testing and UAT to produce clean and consolidated results.
• Manipulated and updated the tables as per specifications and extensively used stored procedures.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
• Came up with methods to improve functionality and effectiveness of the code by brainstorming with other team members during team meetings and discussions.
• Assisted the DBA with scheduling jobs, running various scripts related to space management.
• Assisted in documenting User Manual and facilitate UAT and provide follow up to resolve the issues.
• Automating reports using MS Excel with ODBC Connection.
• Scheduling SQL Job to run at night times.
• Designed and developed a metadata driven automated reporting system.

Environment:, MS Excel, SQL Server, Windows 2008 Server