SUMMARY:

• 5+ years of professional work experience in Business analysis, Data Warehouse/Data Mart design, System analysis, design, development, Database design, SQL programming.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.
• A good team leader in terms of managing people's time, ability and delegate work accordingly.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Exceptional interviewing skills to accurately gather and capture project goals and requirements and converting them into High - level business requirements.
• Developing and/or maintaining project related documentation (SSR, WBS, BPP, BRD, FRD, Project Scope Statement(PSS), resource assessment, Network diagrams, Gantt chart, Data flow diagrams, Communication Matrix, UML diagrams, etc.) at all phases of the SDLC to keep project on track.
• Preparing graphical depictions of use cases diagrams including State Diagrams, Activity Diagrams, Sequence Diagrams, swimlane diagrams including the Business Workflow Chart.
• Developed and reviewed test plans and cases, worked with QA Testers for Functional, User Interface/GUI, UAT testing, and analyzed bugs.
• Developed OLAP cubes in Cognos for real time analytics.
• Developed Tableau dashboards for better analysis and report generation.
• Worked closely with DBAs and BAs to identify and rectify any issues with data extraction and modeling issues.
• Involved in testing and feedback loop to fine tune the reports and dashboards.
• Involved in maintaining the documentation of the reporting process.
• Extensive experience on Informatica PowerCenter with strong business understanding in power utility and insurance sectors.
• Expertise in implementing Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance
• Worked on integrating data from heterogeneous sources like Oracle, flat files, DB2.
• Knowledge of full life cycle development for building a Data Warehouse.

TECHNICAL SKILLS:

• Business Intelligence
• Tableau
• ETL
• Data Warehousing
• Agile/SCRUM
• Waterfall
• JAD
• Oracle SQL
• MS Visio
• Informatica
• Cognos
• Erwin
• SQL Power Architect
• WBS
• ALM
• HTML
• CSS
• SQL
• Java
• VB.Net
• C
• C++

PROFESSIONAL EXPERIENCE:

Confidential,Pittsburgh,PA

Data Analyst / Process Improvement Analyst

Responsibilities:

• Executed a multifaceted project that included migration, report development, user training, supervision and process development.
• Employed Excel and Sharepoint to track and maintain current report inventory and future reporting needs.
• Build appropriate tracker to tie reports to their respective data sources.
• Supervised team of 2 reporting analysts to help with migrating static excel and powerpoint reports to Tableau.
• Worked with the ETL team to construct appropriate tables with the right columns to satisfy reporting needs.
• Conducted UAT and provided training for users on how to utilize Tableau dynamic reports.
• Utilized data blending and cross database features to deliver
• Interview executives to gather requirements and help tune the thought process to manage expectations
• Describe and explain, different features of the tools to add more value and insight to data.
• Help shape drill-down and slice & dice capabilities.
• Worked on developing exploratory reports to provide dynamic and real-time insight into technology incidents. Ranging from Low to High Priority levels.
• Employing different plotting methods to adequately present data.
• Developed reports that provide a time series analysis on different incidents and provide some level of forecast.

Confidential,Plano,TX

Tableau BI Developer

• Worked on a Supplier sourcing project to capture the supplier related to project data. The project started off with data modeling to determine the gap between source and target schema. Based on the analysis an ETL strategy was designed and implemented. The combination of tools used included Informatica Power Center, Tableau, Oracle 10g, Excel, R.
• Effectively used data blending feature in Tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Identified the facts and dimensions and designed the relevant dim and fact tables.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Monitored Workflows and Sessions using Workflow Monitor.
• Documentation was done for all mappings and workflows processes.
• Used Debugger in troubleshooting the existing mappings.
• Created appropriate dashboards in tableau to present near real-time KPIs and other supplier information based on geographical presence and competencies.
• Publish dashboards on Tableau server and improve them based on user feedback.
• Deliver sorted reports from Tableau Desktop based on project requirements.

Environment: Oracle 10g, Informatica Power Center, Tableau, Excel, R

Confidential, McKinney, TX

Reporting Analyst

• The primary goal of the project was to shorten the time between data collection and report generation. Provide users not just Ad-Hoc reports but also near real-time visibility to the on-going business process.
• Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.
• Responsible for identifying and developing Source to Target cardinalities.
• Developed and Published Packages in Frame Work Manager-Connecting and testing the Data Source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Generated Complex reports in Cognos report studio including Drill Down reports from DMR modeled Frame work model.
• Created Dashboards to present critical company data in a single report.
• Manually modified the SQL in Report Studio to tune and/or to write reports.
• Used union/Join objects in Report Studio.
• Experience in developing Framework Manager Models and analyzed those models in analysis studio.
• Gathered and analyzed business requirements from users and business community.
• Analyzing existing transactional database schema and designing star schema models to support the users reporting needs and requirements.

Environment: Cognos (Report Studio, Query Studio, Analysis studio, Frame Work Manager), DB2, SQL Informatica.

Confidential,Gainesville,FL

ETL Developer

• The framework captures data daily from each of the client's various locations. The design organizes this consistent data storage for their national level, region level and functional level data analysis. This data was used for creating a baseline for data marts. With this centralized data infrastructure, the client could view its statistical information more accurately.
• Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a staging area using Informatica.
• Tuned Informatica mappings for better performance using different techniques to provide maximum efficiency and complete performance.
• Created the Workspace and Workspace Advanced dashboards.
• Created multiple layer reports providing a comprehensive and detailed report with drill-through capability.
• Created multi-dimensional cubes using Transformer with the IQDs, which is generated from Framework Manager by using the query subjects.
• Created and set up the security for all Employer groups.
• Performed DATA Quality Check for the tables
• Designed and developed catalogs that reflected business view of the data to enable other developers to design cubes and reports
• Used R programming to validate test data.

Environment: Windows NT, Oracle 8i, DB2, SQL, Informatica Power Center Cognos, PowerPlay, Transformer, SQL Server, SQL Power Architect, R.

Confidential,Buffalo,NY

Business Analyst

• The purpose of this project was to create an EDI parser. The system automates eligibility, confirms transaction codes from the healthcare gateway, gathers provider information, etc.
• Managed software system development and integration projects, through all phases of project life cycle - analysis, design, development, testing, implementation and post production support
• Gained knowledge of HIPP 5010 transaction series (200 series and 800 series). Along with CPT, ICD-9-CM, and ICD-10-CM codes.
• Strong understanding about user interface (UI) and user experience (UX) design principles and user centered approach to empower Patient, Provider, and Payer.
• Providing measured and analyzed discrepancies between current processing system and proposed system by providing statistical data.
• Conducted functional requirements reviews and walkthroughs with the designers, developers, stakeholders and actively participated in UAT.
• Participated in JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues.