SUMMARY:

• Over 7+ years of IT experience with emphasis on business requirements gathering and analysis, design, development, testing and data management.
• Proficient in Tableau8.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, Sc Confidential er 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.
• Created various Tableau Reports that include Charts, Filters, Scorecards, Drilldown and Drill-Through.
• 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.
• Excellent experience in Designing, Maintaining & tuning various RDBMS like SQL server.
• 2008R2/2012, MS Access databases and strong knowledge of SDLC principles.
• A highly motivated and excellent team player with technical expertise in software engineering processes and has knowledge on software development life cycle 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 M Confidential er Experts and the technology group.
• Strong knowledge of database management in writing SQL queries, stored procedures, database tuning, query optimization and resolving performance issues.
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post - Production support.
• Strong influence management skills, reporting and analytical/problem solving skills.
• Experience in modelling, architecture, designing, debugging and testing instrument driver/interface and other application in manufacturing, R&D environment across various platforms
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• 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.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, C, C++, ASP.NET

Databases: SQL Server 2012/2008/2005, Oracle10g/9.x

BI Visualization & ETL Tools: Tableau (Desktop & Server)8.x/9/10x, and MSBI (SSIS, SSAS, SSRS)

Operating Systems: Windows 2000/XP/2007/2010, UNIX, Linux and Mac

MS Office Tools: Access, Word, PowerPoint, Excel

Document Management: Share Point, Ultra Edit, Documentum

PROFESSIONAL EXPERIENCE:

Senior Data Analyst

Confidential, Chandler, AZ

Responsibilities:

• Creates and implements the Data Governance framework that meets Data objectives for the Organization.
• Involved in business meetings and interacted with Clients, Data Stewards to analyze the business requirements and developed a design plan and solution approach.
• Coordinated with business analysts to deeply analyze the business requirements from end to end perspective.
• Analyzes software requirements to determine feasibility of design within time and cost constraints involving management reporting systems.
• Consults with other engineering staff to evaluate operational and performance requirements of overall system.
• Designs, develops and directs software system testing procedures, programming, and documentation.
• Involved in Data Analysis, Data cleansing Requirements gathering, Business Analysis, Data Mapping, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams.
• Worked in an agile methodology to successfully accommodate changes and delivered user stories with more quality in stringent timelines.
• Designed and configured landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM.
• Involved in designing and implementing the security for the Hive databases.
• Created and configured Mappings, Trust and Validation rules, configured Match Path, Match Column, Match rules, Merge properties and Batch Groups to automate the batch flow.
• Normalized Data models across four different source systems and successfully delivered projects within timelines.
• Created DTD documents based on the good understanding of FRD and BRD documents.
• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
• Worked with Data Steward Team for designing, documenting and configuring Talend for supporting management of MDM data.
• Designed complex application in duplicate/discrepancy data handling by exception and human task and projecting bad data to analyst for data stewards to work on it and manager to review the work of the data stewards.
• Document all mappings, values, and rules in detail and hand over documentation to the customer.
• Assist in any other areas relating to the use of data quality processes, such as unit testing, or integration deployment.
• Assist in identification and definition of business glossary terms as well as general business glossary management.
• Implemented the different backup/restore strategies and converted the database from one RDBMS to other using different tools.
• Worked with Talend Data Quality product development managers and suggested added functionalities to TDQ Developer tool.
• Designed value maps and value list in the Talend Integration developer which is used as reusable rules at the profiling level.
• Developed job lets that are reused in different processes in the flow.
• Understanding normalized and star-schema (dimensional) physical models and logical modeling concepts.
• Created Accounts for all the Data Stewards, Data Steward Groups and created connections in the Admin Console.
• Provided Golden Set of Records using Grouping, Matching, and Consolidation to the Data team.
• Performed Data Profiling using Talend Data Quality Tool.
• Worked on TDQ Analyst for Profiling, Creating rules on Profiling and Scorecards.
• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
• Assist in code testing, migration, deployment, enhancement and bug fixes.
• Automated scheduled jobs in TAC (Talend Administration Console) which run nightly.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop& publish them to server.
• Performed unit testing and integration testing after the development and got the code reviewed.

Environment: Tableau Desktop/Server 9.x/8.x, Oracle 11g, TOAD, Hortonworks, Talend Studio Data Integration, DB2 (Relational Database), Data Quality 6.1.2 and 6.2, Talend Studio Big Data Platform 6.2.1, UNIX, XML files, Flat files, Hadoop 2.4.1, HDFS, Hive 0.13, Agile Methodology.

Senior Tableau Developer

Confidential, Durham, NC

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
• Develop data validation quality rules and scorecards in Information Steward including maintain data standard. Focus on Material/Vendor master data.
• Designed and implemented a multi-tier data warehouse and Data Mart using SQL Server 2008
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual axes.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs, which were visually easy to understand, and at the same time maintaining the accuracy of the core information content.
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later.
• Used LOD Expressions to perform Cohort Analysis of different market segments.
• Validated the results in Tableau by running SQL queries in Oracle SQL developer and Google Big-Query.
• Working with business SME's and Data Architects to design and implement 3NF and dimensional data models.
• Participation in periodic meeting to discuss Data Cleansing activities.
• Pull information from multiple sources together into an RDBMS (SQL Server/Access) and Excel.
• Confidential ended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment implemented the feedback and incorporated the necessary changes.
• Specialized in designing, implementing and maintaining security using SAS Metadata and ACL’s on AIX
• Created tableau functional design document.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Performed performance tuning of the dashboard in Tableau desktop.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the retrospective meetings and next sprint planning meetings.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop9.x/8.x (Desktop/Server) Qlikview, Hadoop HDFS, Hive 0.13, SQL Server Tools: DTS, BIDS (SSIS, SSAS, and SSRS) OBIEE, DB2Oracle, SAS 9.1.3, Google BigQuery, Informatica, PowerCenter, Salesforce, SharePoint.

Tableau/ SSIS Developer

Confidential, Temecula, CA

Responsibilities:

• Had thorough understanding of highly normalized/back-end intensive data model.
• Class diagrams, Sequence diagrams and State diagrams were provided according to UML standards .
• Developed and created logical and physical database architecture using ERWIN.
• Designed, developed and tested several T-SQL Queries using Joins, Indexes, Stored Procedures, User Defined Functions and Views.
• Created and deployed SSIS packages using various transformations such as Slowly Changing dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, & Data Conversion Transformations.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Experience with creating Worksheets and Dashboard.
• Experience with Tableau for Data Acquisition and Data visualizations.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Experience with Sorting, Building Groups and using in visualizations.
• Worked on Global, local and Context filters.
• SQL Performance tuning by modifying SQL or adding/changing indexes.
• Created and developed DML Triggers for auditing purposes.
• Migrated old data from MS Access and Excel into SQL Server 2012 using SSIS Packages in Microsoft Visual Studio.
• Developed, deployed and monitored SSIS Packages to SQL Server 2012.
• Loaded Historical data from Legacy System into SQL Server 2012.
• Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points, and Logging using SQL Server 2012.
• Used parameters to make dashboards dynamic.
• Worked extensively with Date, String and Logical Functions.
• Used Trend Lines, Parameters, Aggregate Functions, Filters.
• Created Inventory trends, sales integration and forecast accuracy related dashboards.
• Deep experience with the design and development of Tableau visualization solutions.
• Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Deployed the report developed on to the Report Server, assigned Security Roles and used Data-driven Subscriptions to email the reports to a dynamic list of subscribers using Report Manager.
• Developed various financial reports using SQL Server 2012.
• Installed, authored, and managed reports using SQL Server 2012 Reporting Services.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
• Worked closely with Application Developers and Business Analysts to produce all required documents.
• Proficiently developed Functional Requirement Documents, Design documents, Test Cases and project documentation (user guides, standard report instructions, demos).

Environment: SQL Server 2012 Enterprise, Windows Enterprise Server 2008, Tableau Desktop 8.0, Tableau server / Administrator, SSIS, SQL Server 2008, Windows/UNIX, Oracle.

SQL Developer

Confidential

Responsibilities:

• Provides high-level database development assistance in creating specific applications for businesses.
• Strong understanding on Software Development Life Cycle (SDLC).
• Develop and maintain SQL scripts, indexes and complex queries for analysis and extraction.
• Perform basic Admin activities like automated backups, setting up database monitoring agents.
• Perform quality testing and assurance for operations and disaster recovery.
• Interacted with Business Users and gathered Business Requirements and created BR documents.
• Created new Views, Business Models, and Transformations in Composite according to business requirements.
• Created Views, Functions and developed Stored Procedures for a new database instance.
• Designed and created SQL Database, Tables, Indexes, User Defined Functions, Stored Procedures, and Triggers.
• Transformed the complex business logic and calculations into coding.
• Optimized query performance by creating Indexes.
• Created SSIS packages using SSIS to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Transferred the data from SQL Server 2005 to SQL Server 2008R2 database using SSIS.
• Used SSIS for data population from different sources and create SSIS packages for data conversions and load data from flat files and vice versa.
• Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
• Form Confidential ed the reports using the Global variables and expressions.
• Created Drill down Reports, Parameterized Reports, Linked Reports and Sub Reports apart from generating Ad-hoc Reports. using SSRS.
• Ensure best practice application to maintain security and integrity of data
• Support production activities which would require non-business hour availability.
• Implemented industry best practices and trends related to data ingestion and database design/development.
• Assist the Web Developer and Research Analyst in the development of data access p Confidential erns, reporting, charting, and documentation; as well and examine performance issues created by bad queries and indexes. Have a deep understanding of how a database works or the performance implications of the code.
• Acting as a liaison between the Firm and outside programmers to produce software to meet the specifications.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Problem solving skills and prioritizing abilities.
• Prepare instructions for deploying the applications, including instructions for custom configuration needed on servers or client workstations
• Designing or developing databases and database solutions using MySql, Oracle.
• High achievement record in process quality improvement and efficient data solutions management in data intensive applications.
• Converts legacy database systems to new formats and structures.
• Design tables, stored procedures, views, functions, etc; to write applications that can provide data feeds to web user interface.
• Experienced in Data Modeling, Database design & well versed with Server best practices and hands on experience in developing Stored Procedures/routines and Reports.
• Implemented performance tuning especially tuning complex queries, procedure and indexing strategies, Data Import/Exports, Database Recovery/Backup.

Environment: MS SQL, Oracle SQL, Database Design, PL/SQL, MySQL, Data Modeling, MS SQL Server 2008, MOSS 2007, Migration, SQL Reporting Services, ReportBuilder 2.0, SQL Server Integration services, VSS, Oracle 10g, SQL, ASP, Erwin.

SQL Developer

Confidential

Responsibilities:

• Worked on the project which involves Database development and management using SQL codes.
• Worked on Databases like - Oracle SQL and PL/SQL.
• Should have strong understanding in Data Modelling (Dimension-Fact Model).
• Involved in Data Analysis and wrote complex SQL queries.
• Meet with system users and advise as to the best solution to meet change requirements.
• Managing and storing the data by using ETL and Data warehousing concepts.
• Handled both internal and external communications.
• Maintaining the integrity and security of databases.
• Develop new business applications in accordance with customer requirements.
• Meet with system users and advise the best solution to meet change requirements.
• Modify existing business applications in accordance with customer requirements.
• Troubleshoot and fix application problems.
• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
• Prepared functional specifications for user requirements.
• 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.
• Environment: SQL, PL/SQL, SQL*Loader, Windows XP, UNIX
• Created and modified stored procedures, triggers and cursors.
• Designed, developed and modified various Reports.
• Handled and managed customer relationship management system.
• Designing and modeling database according to Requirement. And made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Built and performed user acceptance testing on modified reports.

Environment: MS SQL Server 2005/2008, MySQL, MS-Access, MS-Office (Word, PowerPoint, Excel).