Data Sql Server

GARY HAMILTON

Tableau Developer/Data Analyst

Ph: 954-***-****

Email: ****.********@**********.***

Consultant: Sai Mani

SUMMARY

7+ years of IT experience with emphasis on business requirements gathering and analysis, design, development, testing and data management.

Sound knowledge of Retail, Finance, Insurance, Biotechnology and Pharmaceutical industries.

Proficient in Tableau 8.x/7.x/ 6.x (Desktop, Server, Public, Mobile)

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups and migrate objects of Tableau repository

Created various Tableau Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting

Created incremental refreshes to pull the delta records from data sources to Tableau Extracts.

Creating users, groups, projects, Data connections, setting up roles as a Tableau administrator.

Created subscriptions to deliver the reports on a scheduled time through email.

Experience in creating and implementing interactive charts, graphs, and other user interface elements.

Extensive experience in conducting Gap Analysis, Business Process Re-engineering, Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.

Experience to work with senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development and to manage risk analysis and mitigation plans, status reports, and client presentations.

A highly motivated and excellent team player with technical expertise in software engineering processes and outstanding knowledge on life cycle of the software design process (SDLC).

Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.

Organized numerous Joint Application developments (JAD) sessions, Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.

Posses strong knowledge of database management in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.

Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.

Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.

Good knowledge in Microsoft SharePoint 2010; proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.

TECHNICAL SKILLS

BI Tools

Tableau 9.0x/7 (Desktop/Sever/Reader), Business Objects, MS SQL Server Reporting Services, MOSS

SQL Tools

Rapid SQL, Toad, Teradata SQL Assistant, PL/SQL Developer

Modeling Tools

Power Designer, Erwin, ER Studio, MS Visio.

ETL Tools

Informatica, DataStage, MS SQL Server 2008 (SSIS)

Reporting Tools

MicroStrategy, Business Objects, Cognos, Qlikview

RDBMS

Teradata, Oracle, DB2, QMF, VSAM, SQL Server.

UI Tools

CICS, PUTTY, Visible Analyst, Lotus Notes

Testing Tools

Mercury Test Director, IBM Rational Tester, Quick Test Professional (QTP)

Scripting/Lang.

C, HTML, PERL, SQL, PL/SQL, COBOL and XML

Scheduling Tools

Autosys, Control M

Operating Systems

UNIX, Mainframes, Windows 7,8/XP/2000

PROFESSIONAL EXPERIENCE

T-Mobile US, Atlanta, GA April 2015 to Present

Sr. Data Analyst / Sr. Tableau Developer

T-Mobile is a leading telecom service provider in USA.T-Mobile is one of the major network providers in the US offering a wide variety of plans for wireless consumers. The application is being used to manage existing sites, towers for commissioning and decommissioning of telecom projects using over 25+ external systems/interfaces. The product is for complete project management of the telecommunication tower till the Site goes on air and ready for use by the telephone customers. The product is used for tracking milestones, between different business units during development of a new site.

Responsibilities:

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

Experience with the design and development of Tableau visualization solutions.

Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.

Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.

Mentored business power users to create reports/dashboards using tableau desktop.

Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

Developed of key indicators and the appropriate tracking reports with graphical and written summations using summary and Annotations to assist in the quality improvement initiatives.

Created quick Filters, customized Calculations, Conditional formatting for various analytical reports and dashboards.

Worked on data blending and linking in case of merging different sources.

Created a dual-axis chart with multiple measures and Synchronize the scale as per the need.

Performed Tableau type conversion functions when connected to relational data sources.

Created incremental refreshes for data sources on Tableau server.

Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.

Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server..

Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.

Involved in testing the database using complex SQL scripts and handled the performance issues effectively.

Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Server 8.x, 9.x, Tableau Desktop 8.x, 9.1, Teradata 12, SQL Server 2008, PL/SQL, SQL Developer, Informatica Power Center, SQL Server 2008, Control-M.

Comcast, Philadelphia, PA Oct 2014 - Mar 2015

Tableau Developer/Sr. Data Analyst

Comcast is one of the world’s leading media, entertainment and communications company

Comcast BCP, is an online web application used to support Comcast customers, to view/pay/customize their bill details based on the logged in user privileges. Customer can received their updates through mail and SMS based on the action they performed such as pay and automate their account bill. Customers can set up, manage and purchase domains under their account.

Responsibilities:

Responsible for gathering business requirements, doing gap analysis and documenting them textually or within models.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked on Symbol maps, Bubble chart, Drill down analysis using tableau desktop

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Involved in understanding the reporting requirements and providing Tableau reporting solutions.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Involved in creating advanced Tableau functionalities such as geographic mapping, data blending, extract optimization to create advanced chart types and visualizations.

Used MS Visio for flow-charting, process model and architectural design of the application.

Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.

Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.

Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped.

Extensively used SQL scripts for data mapping and querying.

Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.

Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.

Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.

Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues

Environment: Tableau Server 6.x,7.x, Tableau Desktop 6.x,7.x, Oracle 10g, TOAD, MS SQL Server 2008, Share Point, TFS, Informatica 9.1, UNIX, SQL Server 10g, Erwin, MS VISIO, Microsoft Office Suite.

Hartford Insurance, Hartford, CT Feb 2013 – Aug 2014

Business Systems Analyst/Data Analyst

The Hartford Financial Services Group, Inc., known as The Hartford, is one of USA’s largest insurance and financial services company. 200 year old firm headquartered in Hartford, Connecticut, USA. The Hartford is focused on a customer-oriented strategy and organized around six reporting segments: P&C Commercial; P&C Other Operations; Consumer Markets; Group Benefits; Mutual Funds and Talcott Resolution.

CLA is The Hartford’s premium Quoting, policy issuance, statistical coding and policy administration system for Select Customer and Middle Market commercial business. CLA supports a number of policy administration functions including Rating/Quoting, Coding, Policy writing, New Business Renewals, and Endorsements, cancellations Reinstatements, Audit and Inquiry. CLA has been used as the backend system for underwriting all Hartford Policies and to send policy forms to the insured.. CLA is also called as the rating engine, as the premium for front end applications are fetched from the CLA system only.

Responsibilities:

Interacted with various business people in External Vendors side and gathered the business requirements and translated them into technical specifications.

Documented business requirements, discussed issues to be resolved and translated user input into ETL design documents.

Experienced working with team, lead developers, interfaced with business analysts, coordinated with management and understands the end user experience.

Worked with data architects and DBAs to design and implement Conceptual data model, Physical Data Model, Informatica mappings and workflows to meet business requirements.

Involved in ETL process through the entire SDLC from analysis/design to production deployment.

Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.

Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.

Logged on to the QC Centre to find out the defects posted by testing team and fixed those defects.

Used SQL Loader to load the flat file data into temp tables to compare the data with that generated from CMA.

Involved in creation of Schema objects like Indexes, Views, and Sequences.

Extensively worked with Unix Shell scripting to validate and verify the data in the flat files generated by the ETL process.

Designed post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.

Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.

Scheduled the Informatica Workflows to start running at specified date and time repetitively forever.

Participated in User Acceptance Testing to validate the data in the flat files that are generated by the ETL Process.

Coordinated with the Informatica administration team during deployments.

Provided the production support and solved the production issues immediately after they are noticed.

Environment: Informatica Power Center, Oracle10g, MS Access, TOAD, SQL Developer, PL/SQL, UNIX,

Mercury Quality Center, WindowsNT4.0

Kettle Foods Inc, Irvine, CA Nov 2010 – Dec 2012

Business Systems Analyst/Data Analyst

Kettle Foods is an international manufacturer of potato chips, tortilla chips, and nut butters based in Salem, Oregon, United States, with a European and Middle East headquarters in Norwich, United Kingdom. The Kettle Foods UK office also supports a network of independent distributors through which Kettle Foods' products are made available in the Middle East and in European countries outside of the UKAs of 2006 they are the largest natural potato chip brand in the U.S. The company, founded in 1978 by Cameron Healy, has been owned by Diamond Foods since 2010.

Responsibilities:

Identify and analyze Business Requirements from documents and end-user discussions which involved in the review of Service Oriented Architecture (SOA) and design of data models which include Staging in data warehouse.

Expert Enterprise Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball data warehouse methodologies.

Identified the Objects and relationships between the objects to develop a Conceptual, Logical and Physical model in Erwin tool and later translated the model into physical model using the Forward Engineering technique in Erwin tool.

Ensuring the accuracy and level of information supports the business requirements, as well as subsequent development activities comparing the data loads between new EDW (Enterprise Data Warehouse) production system and the retiring system.

To reduce the bandwidth and execution time and also applying conditional logic, stored procedures are introduced in respected DBMS.

Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports using Erwin Tool.

Perform application testing eg.: of loading, reporting interfaces to BDW to verify all systems are in place and operational and the data restored is correct.

Conducted JAD sessions, and design discussions to come out with the appropriate data mart.

Experience defining enterprise data location architectures for ODS, Data mart, and Data Warehouse data.

Created test cases for carrying out unit testing and part of functional testing.

Documented the business logic in MS- Access associated with the development.

Environment: Erwin, ER/ Studio, DataStage, Oracle, DB2, SQL Plus/ PLSQL, Perl, Teradata, Quick Test

Pro, TOAD, UNIX, MS Office Suite (Word, PowerPoint, Excel), MS Project, MS Visio, Windows 2000

Micro land – Bangalore, India June 2008 – July 2010

Jr.SQL Developer

Responsibilities:

Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction

Prepared functional specifications for user requirements.

Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.

Developed and modified applications, authored database procedures and triggers for data processing.

Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.

Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.

Involved in creation of schema objects, roles and privileges, users.

Prepared User manual, Technical documents for the end user.

Prepared executables for system deployment and led the release of applications following

Environment: SQL, PL/SQL, SQL*Loader, Windows XP, UNIX

Contact this candidate