SUMMARY:

• 9+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Designing the solution to integrate existing Oracle data ware house data to GBS data warehouse, this is to create comprehensive data set that can be analyzed through Tableau.
• Worked closely with and ETL development team Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Data Management & Data Modeling experience in an Enterprise Data Warehouse/Data Mart application environment utilizing both the Ralph Kimball Star Schema Dimensional Modeling methodology and the Bill Inmon Relational Modeling methodology.
• Strong knowledge on Extraction Transformation and Loading (ETL) processes using Data Stage, Informatica, UNIX Shell scripting and SQL on Data warehouses. Experience in integration of various data sources like Teradata, Oracle, Netezza, DB2, Teradata and Flat Files into staging area.
• Developed business and technical requirements (DB2, SAS, Excel, Pivot Tables, SAP BO 4.1, WebI, Explorer, Dashboards) for monthly funnel, standardized approach among team members, development of SAP BO Dashboard to automated and replace existing manual process.
• Proficient in Analyzing source system by examining the content, structure and internal relationships of legacy data sources like flat files, Excel, Oracle, Sybase, SQL Server, XML and DB2 databases.
• Participated in development of User Acceptance Test strategy and cases and supported the execution of User Acceptance Testing.
• Experienced working in all phases of SDLC from analysis, design, coding, unit testing, system testing and user acceptance testing
• Experienced in data transformation, data mapping from source to target database schemas and data cleansing procedures using Informatica Power Center, Talend and Pentaho.
• Develops queries and runs reports to monitor validation and collection progress using Business Objects (WEBI), Crystal Reports, Excel and Microsoft Office.
• Experience using Business Intelligence tool sets and building solutions using these tools (Business Objects, Tableau, SAS, prefer business objects).
• Extensive experience in developing stored procedures, functions, views and triggers and complex queries using T - SQL.
• Experienced with Teradata utilities: BTEQ, FastLoad, MultiLoad, FastExport, and TPump. Familiar in writing Multi Load, Fast Load, Fast Export and BTEQ scripts.
• Proficient in Data Quality Management techniques like Data Profiling, Data Cleaning, Data Integrity, Data Mining, Data Reference and Security etc.
• Experience working on Tableau for analysis, creation of visualizations, dashboards and user stories.
• Business requirement gathering from various sponsors and stakeholders by understanding business goals and priorities through research, formal-informal sessions, JAD sessions with teams, stakeholders and end users.
• Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man.

SKILL:

Data Modeling Tools: Erwin r7.1/7.2, Erwin r8.2, Erwin r9.1/9.5, Embarcadero ER/Studio 9.7, Oracle Designer, Sybase Power Designer, Cognos

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9, SSAS, SSIS.

Programming Languages: SQL, PL/SQL, Base SAS, T-SQL, HTML, XML, VB.NET, C, C++, UNIX and Shell Scripting

Database: Microsoft SQL Server, MySQL, Oracle 10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1

Packages: Microsoft Office Suite, Microsoft Project 2010 and Microsoft Visio

ETL Tools: Informatica 7.1/6.2, Data junction, Abinitio, Data Stage, SSIS

Data Visualizations: Tableau, QlikView/Qlik Sense, SAP Business Objects, OBIEE, SSRS

Other Tools: SAS Enterprise Guide, Version One and JIRA, R

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Sr. Data Analyst

Responsibilities:

• Developed and optimized complex SQL queries and ensured optimal performance using joins, grouping, aggregation, subqueries, and views to retrieve data from relational databases.
• Managed the integrity, structure, and organization of data to maximize its value and accuracy with queries.
• Conducted the required Confidential analysis between their AS-IS submission process and TO-BE Encounter Data Submission Process. Professional experience of most advanced SQL Server, Database server installation, login and user creation, role and permission configuration.
• Experience on high performance data integration solutions- including extraction, transformation and load (ETL) packages for data warehousing.
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities such as MLOAD, BTEQ and Fast Load and Experience with Perl.
• Worked with architects and, assisting in the development of current and target state enterprise level Data architectures.
• Worked with project team representatives to ensure that logical and physical Data models were developed in line with corporate standards and guidelines.
• Performed Data analysis and Data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Extracted data from various data sources, and transformed, cleaned, validated, and loaded data into Oracle databases, flat files, spread sheets, Salesforce, and other destinations.
• Coordinate activities and workflow with other data Stewards in the firm to ensure data changes are done effectively and efficiently.
• Review the database to identify and recommend adjustments and enhancements, including external systems and types of data that could add value to the system.
• Extract the data from database and provide data analysis using SQL to the business user based on the requirements. Create pivots and charts in excel sheet to report data in the format requested.
• Assist CRM Analyst with Email Marketing Campaigns, including Client Publications, Newsletters and announcements.
• Assist other data Stewards with data Change Management (DCM) Inbox in resolving various tickets created by the User Change Request in Interaction Database.
• Designed STAR Schemas for the detailed data Marts and plan Data Marts involving Shared Dimensions.
• Tracked and documented data issues in the systems and coordinated with clients to resolve the issues.

Target, Pittsburgh, PA

Sr. Data Analyst

Roles and Responsibilities:

• Defined Cognos security for the business complying with organizational security and audit policies.
• Lead the database development, ETL and report development activities and work closely with On-shore and off-shore developers to ensure proper data flow from SAP to Teradata and is available for reporting solutions.
• Design, develop, test, implement and maintain reporting solutions using the Crystal Reports 9.0 environment.
• Standardizing Business Objects development with best practices, upgrading to higher versions and mentoring supporting operational client staff.
• Involved in complete SDLC - Requirement analysis, Development, System Analysis and various testing phased like Integration testing, Component testing and Product system testing.
• Worked on different technologies that are used in this reporting system, such as T-SQL, Jet-SQL, SSIS, SSRS, SharePoint, Access, Excel, VBA etc.
• Experience working with large database to perform complete data retrieval, manipulation using multiple input files using SAS data steps.
• Developed an end-to-end ETL process using ORACLE Data Loader to move data from sources to Data Warehouse having Ralph Kimball star schema.
• Data Warehousing and Data Mart Databases Support, SSIS / SSRS deployments, Processing of Cubes.
• Gathering User Requirements by interacting with stakeholders, management, development personnel to get a better understanding of the Business Process.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Enabled new features and functionalities of Cognos BI 10.2.2 for business users like Visualizations, Mobile, Active reports, Workspace Advanced, Manage External Data, etc.
• Experience with Oracle database administration, including execution of daily/weekly and monthly DBA activities, such as server performance analysis, killing processes, database backups and quarterly security patches.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Developed macros, pivots reports, and charts in Excel (using Power Pivot, Power Map, Power Query, and Power View), and developed and designed queries (including update, append etc.), tables in Access using SAS, BI, Cognos, Abinitio, Tableau Desktop, Tableau Server, Info1 Reports.
• Experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Taught Oracle Database Administration courses in Oracle 10g and cover all areas of database administration.
• Involved in completely on Oracle BI servers and applications, setting up the Oracle BI environments for different projects.
• Closely worked with development team to enhance and standardize the ETL Process to load underlying system that supports UI.
• Worked on Essential data warehousing enterprise data for data analysis and transforming it into business user understandable with Cognos BI.
• Responsibilities included analysis, data mapping, design, QA testing and documentation of applications in support of end-user access to the Data Warehouse.
• Built a Web process that saved money by reducing Data Warehouse table maintenance from multiple days of application programming to only logging two database table entries.

Confidential, Carbondale, IL

Data Analyst

Responsibilities:

• Primary Data Analyst/Data Modeler performing Business Area Analysis and logical and physical data modeling for a Data Warehouse utilizing the Bill Inmon Methodology. Also designed Data Mart application utilizing the Star Schema Dimensional Ralph Kimball methodology.
• Created and published packages based upon SAP projects onto Cognos Connection in Dynamic Query Mode.
• Involved in various phases of Software Testing/Development Life Cycle (SDLC/STLC) of the application like Requirement gathering, Design, Analysis and Code development.
• Involved in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Abilities and Informatica Power Center and testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Used Business Intelligence tool sets and building solutions using these tools (Business Objects, Tableau, SAS, prefer business objects).
• Gathering business requirements and converting them into functional requirement specifications and user requirement specifications.
• Conducted working sessions on the benefits of integrating data lake Hadoop into existing data warehouse that allowing a more robust processing of data for the corporation’s future business needs.
• Responsible for business requirements definition for sales opportunity data warehouse which collected data from MS Sales, SAP Financials, compensation, and Seibel sales opportunity applications.
• Evolved Enterprise-wide Data Warehousing & Data Mart Strategies, Standards & Procedures for HAS utilizing both the Bill Inmon and Ralph Kimball methodologies.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Experienced in installing and maintaining the Informatica environment through, applying software upgrades and troubleshooting environment issues.
• Ensured development team was adhering to best practices in their development efforts through coaching and training.
• Provided systems metric tracking reports to senior management, so management could make key decisions for the environments current state and propose new solutions.
• Preparing the SQL script to verify data and validating data from source and target Through PL/SQL Developer.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Analyzing raw data, concluding, developing recommendations and manipulate data for dat loads and extracts.
• Data output - Made data chart presentations and coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.
• Experience in Creating visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP.
• Carried out data manipulation, data cleaning, dealt with missing records, purged and consolidated data for analysis and selected the appropriate visualization techniques; developing reports and communicating insights to stakeholders.
• Developed multiple reports/dashboards using Dual Axes charts, Histograms, filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with Stakeholders and business groups. Coordinated with all downstream application teams.
• Created Mappings to load the data from Oracle Database Tables to Flat Files Using Informatica Power Center and Tested the Data.
• Researched modern technologies to simplify and standardize data across multiple lines of business.

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Involved in analysis, design, development and implementation of Business Intelligence Applications.
• Reversed engineered existing data bases to understand the data flow and business flows of existing systems and to integrate the new requirements to future enhanced and integrated system.
• Experienced and Practiced on System Development Life Cycle (SDLC) process through the project.
• Experience in OBIEE/OBIEE for different business verticals - Insurance, Life Sciences / Pharmacy, Public Sector and horizontals like Call Center, Service, Marketing and Sales.
• Prepared Business Requirement Documents (BRDs) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Extensive Unix Scripting for Sybase and DB2 development, Rapid SQL for Oracle development. Relational Database Warehouse / Data Mart Design, Excel Pivot Tables, Templates for Ad Hoc Reporting.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Actively analyze the individual shop database on an on-going basis to identify potential opportunities, and/or potential concerns.
• Identify the problematic groups and processes from large volume of data with respect to each shop using advanced filters in excel.
• Created, analyzed and presented various performance parameters to better understand the nature of the data set using Tableau.
• Responsible for data aggregation, data pre-processing, missing value imputation and descriptive and inferential analysis.
• Compare the manufacturing performance with the ERP master database and plan of each shop and their respective causes using excel Pivot table.
• Collaborate with regional stakeholders, benefits and provider configuration, system load and other IT constituents to establish, document, and implement the User Acceptance Testing plan.
• Worked with ETL team using SSIS packages, to plan an effective package development process, and design the control flow within the packages.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor and Statements for Applications by using T-SQL.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Cognos and Tableau desktop report.
• Used SQL for Querying the SQL Server database for front end application to source data validation.
• Involved in Data Analysis for the data warehouse and data mart system for the process of report generation.
• Worked with Data Warehousing developers who extensively used Informatica, to design mapping to move data from source to target database using Stages to do the functionality.
• Create ad hoc reports and perform regression testing based on user requirements in the MicroStrategy and Business Objects.
• Providing administrative and maintenance support of Cognos applications including routine model changes, data loads, validations & troubleshooting.

Confidential, Waco, TX

Data Analyst

Responsibilities:

• Extensively worked in Teradata jobs including performance tuning, profound knowledge in UNIX environment.
• Developed detailed technical specifications for ETL & reporting in collaboration with data warehouse architect and senior ETL and business intelligence developers.
• Installed SSRS reporting service, designed and developed SSRS reporting with advanced features, deployed into report manger and assign permission to differ user group.
• Understand the business intelligence of data warehousing environments and the data flow from the source systems to the target systems.
• Used Toad to write SQL queries to execute the procedures, and validating the source and target tables at various stages in the database.
• Design, develop and maintain SSIS Packages & Migrate data from SharePoint List to SQL database.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files to target tables.
• Testing reports thorough MicroStrategy web to verify that reports are migrated properly from development to testing and Production.
• Developed SQL procedures to ensure compliance with standards and lack of redundancy, business rules and functionality requirement into ETL procedures.
• Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed.
• Used Power View to view them and created Pivot tables and lookups on the aggregated data to group them according to business needs.
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Extensively worked on Installing and setting up of MicroStrategy Intelligence server and Web servers.
• Responsible for creating the data needed to satisfy the business requirements by working with the Business Line and Technical Resources involved in providing the data.
• Created SQL test scripts for complex integrated systems to validate data and performs test executions.
• Responsible for holding meetings with line of business and TOS to review the data and reporting the metrics to the project manager.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Enhanced Crystal reports and Data Warehouse analytical models in support of strategic business planning and at customers' requests.
• Provided on the spot troubleshooting and monitoring using Oracle tools and/or third-party tools.