SUMMARY:

• Professional Experience around 8 years of strong experience in Information Technology in system analysis, design, development, implementation and maintenance of client server applications, portal (BIP) and Data Warehouse providing Business Intelligence reporting solutions to Financial, Tax Solutions, Manufacturing, Aviation, Supply Chain and Logistic.
• Strengths include requirements gathering, business analysis, data modeling, programming, development, documentation, training and software upgrade / conversions (Tableau 7 / 9.1, Informatica 9.0/9.5, WebFOCUS 7/8, Qlikview 9).
• Design HTML pages using WebFOCUS 8.1.05 App Studio.
• Expertise in developing action filters, parameters and calculated fields for dashboards and worksheets in Tableau 7 and Tableau 9.1
• Designed and developed visualization for logistics calculation and spend analysis using Tableau 9.1
• Experience in Enterprise Environment and Tableau Administrator including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge in Tableau Desktop, Tableau Reader and Tableau Server with hands on experience integrating Tableau Server to publish dashboard on portal.
• In-depth knowledge in HTML Composer, Document Composer, Info Assist, Report Caster and Developer Studio in WebFOCUS 7 and WebFOCUS 8.
• Experience in developing Dashboards with drilldowns, filters in reports and charts using Report Painter and HTML composer in WebFOCUS 7 and 8.
• Strong knowledge in upgrade implementation of WebFOCUS 7 to WebFOCUS 8.
• Proficient in JavaScript, JQuery, AJAX, PHP, HTML and CSS.
• Expertise in installation, upgrade and configuration of SQL Server and other databases.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 9.5 from various data sources like Excel, Oracle, DB2, MS SQL Server, Access and flat files.
• Hands on knowledge in Power Center monitoring, debugging, workflows and also error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Developed mapping parameters and variables to support SQL override.
• Excellent interaction with client users, understanding business applications, business data flow, data relations and experience in testing, production support and post production releases.
• Working on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor
• Maintain, improve and support current ETL and data integration processes.

TECHNICAL SKILLS:

Dash boarding/Analytics: Tableau 7/ 9.1, WebFOCUS 7/8, and Qlikview 9.

Languages / Scripts: SQL, JavaScript, HTML, JQuery and CSS

ETL Tools: Informatica 9 and 9.5.

Database: Oracle10g/11g, SQL Server, DB2, MySQL and Access

Platforms: Windows 10/7/ XP, and Windows Vista

PROFESSIONAL EXPERIENCE:

Confidential, Lake Mary, FL

Sr. BI Developer

Responsibilities:

• Collaborate with business partners / users / SMEs and cross functional teams in gathering business processes and user requirements.
• Design HTML pages using WebFOCUS 8.1.05 App Studio.
• Develop reports with APP Studio to modify, compute, filter and format the reports -- using java script and HTML for front ends on reports.
• Create complex executive dashboards that are used for healthcare and financial spend analysis with customization using filters and actions.
• Provide access to users using security administration in portal.
• Schedule tasks using Report Caster for the automated distribution of reports to e-mail and other sources.
• Involve in unit testing, user acceptance testing, error resolution with production incidents and post go-live releases.

Environment: WebFOCUS 8, SQL, Excel, Flat files, HTML, JavaScript and CSS

Confidential, Fort Worth, TX

Sr. BI Developer

Responsibilities:

• Collaborated with business partners / users / SMEs and cross functional teams in gathering business processes, user requirements and documented.
• Worked in extraction, transformation and loading (ETL) of data directly from different source systems like flat files, Excel, DB2, and SQL Server using Informatica 9.5.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Created complex executive dashboards using Tableau Desktop that was published for the business stakeholders for analysis and customization using filters and actions.
• Created dashboard-using parameters, sets, groups and complex calculations.
• Implemented Individual Axes in Tableau Desktop for measuring sales and profit by dragging measures to the Rows and Columns shelves.
• Developed actions, parameters, filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau Desktop.
• Implemented various data connections from data source to Tableau Server for report and dashboard development.
• Developed many reports with multiple data connections, performed data blending, and created different visualizations like three dimensional charts, Bar Charts, Gantt Bar Charts, tree maps, bubble charts using complex joins with Tableau Server 9.1.
• Created complex reports like detail level sales transaction reports, monthly aging, and YTD revenue reports.
• Developed quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Involved in unit testing, user acceptance testing, error resolution with production incidents and post go-live releases.

Environment: DB2, Access, Informatica 9.5, SQL, Tableau Desktop 9.1

BI Developer

Responsibilities:

• Participated in business analysis workshop and documented business requirements from the business process owners and SMEs including data sources and processes.
• Involved in all phases of SDLC from requirement, design, development, testing, deployment and support to production environment.
• Extensively used Informatica Client tools -- Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Performed extract, transform and load data from data sources (SQL Server, Access and DB2) to Data warehouse using Informatica 9.5
• Used debugger to identify the issues/errors in the mappings.
• Designed and developed visualizations with functionality like Drill Down, Slice & Dice, Drop down and parameters using Tableau Desktop 9.1.
• Created calculated fields, advanced filtering, analysis and creation of dashboards based on the business user requirements.
• Worked with Tableau Desktop 9.1 to create complex reports such as interactive charts, drilldown, and mapping.
• Collaborated with business users in creating and modifying worksheets and data visualization dashboards using Tableau Desktop.
• Published dashboards to Tableau Server for users to view and interact with data visualization.
• Published Tableau dashboards on to server, administered user groups and provided support to business users.
• Identified slow running reports and coordinated with cross functional team and business users to identify cause and resolved the issues to improved performance
• Involved in testing with various scenarios in the developed reports for user acceptance and production deployment.
• Involved in production support and product releases after post go live.

Environment: SQL, Oracle, Tableau 9.1, Informatica 9.5, Flat files and Excel.

BI Developer

Responsibilities:

• Participated in business analysis workshop, collaborated with business SMEs and users to document business requirements, data sources and business processes.
• Designed and developed to convert existing reports from WebFOCUS 7 to WebFOCUS 8.0.09 enterprise business intelligence application based on the business requirements.
• Developed ETL (extract, transform, and load) procedures to load reporting database from source data on a scheduled basis using Data Migratory.
• Developed reports with Developer Studio to modify, define, compute, filter and format the reports -- used java script and HTML for front ends on reports.
• Worked with Style Sheets to control styling of WebFOCUS reports.
• Scheduled tasks using Report Caster for the automated distribution of reports to e-mail and other sources.
• Designed and developed drilldown reports and used CSS to style the reports.
• Deployed OLAP response sets and WebFOCUS Info Assist to enable ad hoc reporting.
• Worked with Developer Studio Advanced Graphics Tool to enhance report aesthetics, including drilldowns from graphs to details.
• Executed test plans for unit testing, integration testing, user acceptance testing, documentation and tracking.
• Provided error resolution to production technical incidents and documentation of the resolution.
• Involved with the product releases post-production go live.

Environment: SQL, Oracle, WebFOCUS 7 / 8, Data Migrator, JavaScript, JQuery, HTML, and CSS.

Sr. BI Consultant

Responsibilities:

• Participated in business analysis workshop and documented business requirements from the business process owners and SMEs including data sources and processes.
• Involved in all phases of SDLC from requirement, design, development, testing, deployment and support to production environment.
• Extensively used Informatica Client tools -- Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Performed extract, transform and load data from data sources (SQL Server, Access and DB2) to Data warehouse using Informatica 9.5
• Used debugger to identify the issues/errors in the mappings.
• Designed and developed visualizations with functionality like Drill Down, Slice & Dice, Drop down and parameters using Tableau.
• Created calculated fields, advanced filtering, analysis and creation of dashboards depending on the user requirements.
• Used Tableau Desktop 7 to create complex reports such as interactive charts, drilldown, and mapping.
• Worked with business users in creating and modifying worksheets and data visualization dashboards using Tableau Desktop.
• Published dashboards to Tableau Server for users to view and interact with data visualization.
• Published Tableau dashboards on to server, administered user groups and provided production support for users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Identified slow running reports and coordinated with cross functional team and business users to identify issues and resolved to improve the performance.
• Performed testing with all values and scenarios in the developed reports for user acceptance and production deployment.
• Involved in production support and product releases after post go live.

Environment: Tableau Desktop 7, Informatica 9.5, SQL, SQL Server and Access.

BI Developer

Responsibilities:

• Participated in business process workshop and worked with business SMEs and users to document business requirements, data sources and processes.
• Developed reports with Developer Studio to implement filters, dropdown, drilldowns and graphs.
• Developed export menu to download the selected reports into various formats such as html, pdf, and excel using Report Painter.
• Extracted and loaded data from data sources (DB2 and Access) using Data Migrator in WebFOCUS 7 to create complex reports such as dashboard with animated charts, filters, mapping and calendar.
• Developed dashboard with Developer Studio and added the dashboard to enterprise Business Intelligence portal.
• Designed and developed drilldown reports and used CSS to style the reports.
• Scheduled tasks using Report Caster for automated distribution of reports to e-mail and other sources.
• Provided access to users using security administration in portal.
• Performed with testing to test manually all values in the developed reports for production.
• Actively engaged in product releases post-production go live and production support.

Environment: SQL, JavaScript, JQuery, WebFOCUS 7, Data Migrator, DB2, Access, HTML, and CSS.

ETL Data Analyst

Responsibilities:

• Analyze reported data issues and inconsistencies.
• Streamline the current system design where possible.
• Evaluates data mining request requirements and help develop the queries for the requests.
• Write complex SQL queries to pull and analyze data from large relational databases.
• Perform analysis on existing data and identify root causes for data inaccuracies.
• Analyzing Business requirement specifications and identifying the source data and transformations that needs to be applied in the process of moving data to target database
• Preparation of High level design and ETL Technical specifications
• Identifying Fact and dimension tables and Primary key foreign key constraints on the basis of data profiling
• Figuring out various error handling strategies to be adopted during cross system data migration.
• Working on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor
• Maintain, improve and support current ETL and data integration processes.
• Respond in a timely manner to data requests to ensure daily, weekly and monthly deadlines and goals are met.
• Analyze data and create detailed reports utilizing proprietary tools and third party technologies to identify and resolve data quality issues to ensure quality assurance and drive data quality initiatives.
• Involved in discussing Requirement Clarifications with multiple technical and business teams
• Impact analysis of scheduled source and target changes on the Data warehouse components. Formulating tactical and strategic solutions to accommodate these changes.
• Formulating exhaustive Informatica metadata queries to establish data lineage across various layers of data warehouse.
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House
• Creating complex data analysis queries to troubleshoot issues reported by users.
• Working with various project managers and business users to sort out any potential impact of scheduled changes in business logic on the system from data acquisition to downstream views and reports.
• Validating business rules using Trillium discovery

Environment: Sun Solaris 32-bit, Oracle 9i, Informatica Power Center 9.1, Informatica Metadata manager, Trillium Discovery.

Reporting Analyst

Responsibilities:

• Designed and Developed reports to assist the Accounting Team using MS Excel from SQL Server data source.
• Extracted and loaded data from data sources (DB2 and Access) using Informatica ETL to Data Warehouse.
• Created various monthly and yearly sales, production and inventory reports using QlikView 9.
• Developed dashboards for sales forecast and production analysis using Qlik Sense.
• Handled user authorization request and provided access to users in QlikView using Session Access.
• Produced routine and ad hoc reports to respond to immediate customer request using MS Excel.
• Implemented monthly "Executive Summary" report identifying increase/decrease in key accounts receivable indicators against previous years in Excel.
• Directly supported Finance, Marketing, Sales, HR departments as well as executive leadership teams.
• Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to company.
• Created daily reconciliation of cash postings and bank deposits to resolve variances.
• Discovered and reported material variances in daily system activity.
• Reduced system slowness and retrieval time of financial report information with design of databases.

Environment: SQL, Excel, Informatica 9.0, QlikView 9, SQL Server, DB2.