PROFESSIONAL SUMMARY:

• Qualified professional with 8 years of IT Experience as a Data Analyst, Business Analyst, and Data Modeler especially in Data Warehousing and Business Intelligence applications.
• Over 4 years of extensive experience in Tableau 9.x/8.x/7.x of Desktop, Server, Public, Mobile.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Proficient in design and development of various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Donut Charts, Pareto Charts, Dual Axis, Blended Axes and also basic visualizations like Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Geo Maps ( Filled and Symbol).
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Extensive experience in Tableau Administration Tool for Configuration adding users managing licenses and data connections scheduling tasks embedding views by integrating with other platforms like SharePoint.
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User and Supporting for Oracle Financials R12/11iGL, AP, AR, CM,andFAmodules.
• Experience in creating and implementing interactive reports /dashboards with What-if analysis, Page Navigation, etc. using Parameters, Actions and Filters.
• Excellent knowledge in Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Expertise in BI/Data Warehousing concepts, designs, and project implementations
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Profiling, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Deep Experience in data modeling and data mapping with extensive knowledge in Normalization and De-normalizations
• Detailed understanding of Relational Database Design, Data Warehouse, OLAP concepts and methodologies.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Proficient Star Schema dimensional modeling, which includes understanding business, processes, modeling dimensions, hierarchies and facts.
• Data warehouse, ETL- Extraction/Transformation/Loading, Data Analysis, Data mining, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Expertise in reports automation to ensure timely delivery of the reports and also accuracy of the data on the reports.
• Excellent project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, Gap Analysis and Risk Analysis.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Flexible, enthusiastic and project oriented team player with excellent communication skills and leadership abilities to develop creative solution as per client requirement.

TECHNICAL SKILLS:

BI Tools: Tableau (Desktop/ Server/ Public/ Reader), Micro Strategy, SSRS, Cognos

ETL Tools: Informatica, Data Stage, SSIS

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Databases: Teradata, Oracle, SQL Server, DB2, Sybase, Access, Netezza

Document management: Documentum, Share point, Ultra Edit

Defect management tool: HP Quality center 10.0

Programming Languages: C, C++, HTML, SQL, PL/SQL, XML, Python, C#

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Experience with the design and development ofTableauvisualization solutions.
• Involved in creating dashboards and reports inTableau. Created report schedules onTableau server.
• Collaborated with key stakeholders and internal teams to define enterprise architecture principles, standards and guidelines, and blueprints.
• Manage sensitive information and information technology equipment in Tableau and lead team of 2 reports developer.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications forBusiness Objects Universes and Reports.
• Used informatica power center 9.0.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Data migration import export/BCP from Tableau Desktop to Server.
• Created Data Marts for both kinds of applications, CRM and financial and used effective querying and formatting tools to present the data to the end users.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• High-performing and motivated team created with record close to 95 % participation in agile meetings.
• Applied Agile Methodology for Rapid Software Development in all BI Reporting and Security project.
• Maintained existing data migration program with occasional upgrades and enhancements.
• Performed data migration enforcement tasks.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• GeneratedComplex reports in Cognos 10.1 report studio including Drill Down reportsfromDMR modeled Frame work model.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Developed complex custom SQL scripts to be used as Tableau data sources.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS). Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart. Working on the SQL tuning and optimization of the Business Objects reports.
• Appliedsecurity featuresof Business Objectslike row level, report level & object level securityin the universe so as to make the sensitive data secure.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• PreparedRD020, BP040, BP080, BR100, MD050documents for each financial module.
• Responsible for assisting the project manager by compiling information from the current systems, analyzing the program requirements and ensuring that it meets the specified time requirements using Informatica.
• Extensive experience on StructuringMetadata and Cognos Modelsusing Framework Manager.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• 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.
• Performed design reviews across company and collected enterprise architecture performance metrics to assure continuous improvement.
• 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.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on theTableauServer 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.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, IPhones, and other smart mobile phones.
• Involved in creating Stored Procedures, tables, and views for applications.
• Resolves moderate problems associated with the designed programs and provides technical guidance on complex programming.
• Actively participated in clarification meeting with the Clients.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAScubes
• Mentored business power users to create reports/dashboards using tableau desktop.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau (Desktop, Server), Microstrategy, Teradata, Teradata SQL Assistant, Netezza4.x, Teradata Administrator, SQL, PL/SQL, MS Project.

Confidential, Wadsworth, OH

Sr. Tableau Developer /Sr. Data Analyst

Responsibilities:

• As the Primary Tableau Lead for the Data Warehousing Project. Involved in thedesign, analysisofEnhancements to the Data warehouse of the project.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes as a Tableau Admin.
• Responsible for data migration and conversion activities such as extracting, transforming, migrating, validating and reconciliation of data. Provide guidance to internal IT key users to design and develop data loaders/templates to fit the business requirements
• Handled Tableau admin activities granting access managing extracts and Installations
• Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle/ SQL Server for design, development, testing, and production rollover of into Teradata for reporting and analysis projects withinTableauDesktop.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Migrated Workbooks and Tableau upgrades/migration works. Implemented new features in Tableau to the existing Workbooks and Dashboards.
• Created Data Marts for both kinds of applications, CRM and financial and used effective querying and formatting tools to present the data to the end users
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• As a lead of this assessment effort, responsible for review and audit the EA environment for existing tools and documents related to the information gathered in support of EA. The task involved review of the current state of the business enterprise architecture and technical architectures that provide the “authoritative source” of the data, including how the data is gathered, captured, and stored within different systems.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Developed and maintained high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Designed Conceptual and Logical data models based on source data requirements for Tableau reports.
• Defined roles and permission and matched them across all environments for multiple applications
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Participate in upgrade project (Unicode conversion) to migrate all the development objects from SAP 4.6 to SAP ECC5.0.
• Create/Update data migration plans and schedules, and develop cutover plans
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories as a team leader.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Worked with NZLoad to load flat file data into Netezza tables.
• Implemented security into Cognos Transformer Models using Macros.
• Published the Cubes to Cognos 8 Analysis Studio using Framework Manager.
• Good understanding about Netezza architecture.
• Assist DBA and Architect to identify proper distribution keys for Netezza tables.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a particular state.
• Invited by TCS-Keynote Relationship head to mentor their team on Mobile and Internet Telephony Domain.
• Performing Business Requirement Study in Financials and modelling Future Process Model and preparingAS-IS (BP040)andTO-BE (BP080)documents.
• Automated and enhanced daily administrative tasks including database backup and recovery
• Developed customized calculations when required.
• Set up groups and users for Business Objects deployment.
• Worked on drill through reports by creating HTML s.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Using Apex Data Loader mapped data sources and loaded data into Call Center application.
• Ensured the development teams are practicing the Agile principles. Completed product demonstrations, retrospectives, and resolve action items. Assisted Product Owner with Backlog maintenance
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report using in JIRA.
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle and Informatica PowerCenter.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Created common reusable objects for the ETL team and overlook coding standards.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• 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.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
• Creating users groups projects Data connections settings as a tableau administrator.
• Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Implemented security in reports according to employee groups and roles according to the requirement
• Involved deployment process.

Environment: Tableau (Desktop, Server), Microstrategy, Teradata, Teradata SQL Assistant, Teradata Administrator, Netezza4x, SQL, Share Point, Agile-Scrum, UNIX, MS VISIO, Microsoft Office Suite, JIRA.

Confidential, Dublin, OH

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS). Created mappings using pushdown optimization to achieve good performance in loading data into Netezza.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Coordinated with DBA and Business objects designer group in solving various technical issues.
• Created multiple contexts for catering different functional areas in a single user query.
• Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports using JIRA.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Front-end profiling on the application on Mobile and Web interface
• Developed highly polished executive level dashboard prototype for the Operations Research Consulting group which provides BI for different Airlines to implement their decision support systems for developing competitive fares, low fare schedules, optimizing the codeshare data, etc.
• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the developed dashboards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Used ETL to extract files for the external vendors and coordinated that effort.
• Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units. Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information

Environment: Tableau Desktop 8.2, Tableau server, Microstrategy, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL,MS Access, Windows 2007 server, Teradata, MS Office 2007, JIRA

Confidential, Elmhurst, IL

Tableau Developer /Sr. Data Analyst

Responsibilities:

• Liaison for project managers, managers, directors, and stakeholders.
• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
• Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.
• Develop, derive and clarify functional specifications and Use cases.
• Synthesized candidate architectures for enterprise wide web services security using WS-Security and WS-Policy.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services(SSRS).
• Designed the conceptual and business process models.
• Implementation of new systems including the integration of the new system with existing systems.
• Verifying installed systems to ensure that they adequately meet user requirements.
• Physical design of data record data files and databases.
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing using JIRA software.
• Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on Sales, Finance data.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Extensively used Oracle ETL process for address data cleansing.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Designed and developed complex views based on reporting requirements in Teradata and used the same as source in Tableau report development.
• Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables to improve the performance of Tableau reports/Dashboards.
• Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Designed, developed and deployed Apex Classes, Controller Classes and Apex Triggers for various functional needs in the application.
• Assist customers with problems involving DOS, Windows 7/ME/2000/XP/Vista or Mac OS X
• Coded APEX triggers and s-controls, created rule based automated workflows.
• Selected and implemented agile development practices according to the application requirements for every project
• Worked with power users in user acceptance testing of various reports/ dashboards in Tableau prior to deployment of same in Production environment.
• Published and scheduled Business Objects Reports to users using Scheduler
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Deployment of defect free code while managing the timeline set for the project.

Environment: Tableau (Desktop/Server), Micro Strategy (Desktop/ Server), Teradata, Oracle, Teradata SQL Assistant, TOAD, PLSQL Developer, MS VISIO, Microsoft (Word, Access, Excel, Outlook, JIRA

Confidential, Milwaukee, WI

Tableau Developer

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Involved in the completeLife cycle of the Project and in thedata analysis process
• Gather the various requirement matrices from the business analysts.
• Worked with Master Data Management.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Participated in designing and development of software using agile development practices
• Designs for the various reporting requirements.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Conduct Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
• Created Business Objects Repository while building Business Objects solution.
• Used ERwin for developing data model and forward engineer the data model.
• Reverse engineer the data base in to physical data model by using Erwin.
• Developed entities and relationships using Sybase Power Designer.
• Developed Data Migration and cleansing rules for the integration architecture.
• Developed data mapping documents between legacy, production and user interface systems.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse. DevelopedBusiness Objects Universeswithclasses, objectsandcondition objectsand developedhierarchiesto supportdrill downreports.
• Created reports usingBusiness Objects functionalitylikeslice and dice drill down, cross tab, master detail tables and formulas, etc.
• Implemented Triggers, Views, Synonyms, Hints, Partitioning of Tables, Clustered and Non-clustered indexing. Extensive work on the performance tuning of Oracle ETL process.
• Designed different type of STAR schemas like detailed data marts, Plan data marts,
• Used Erwin for monthly summary data marts and inventory data marts.
• Designed ER Diagrams, star schema and snow flake schema.
• Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server.
• Importing source definitions. Creating and importing target definitions. Creating the table targets.
• Tested all the business application rules with test & live data and automated.
• Developed & modified database Stored procedures and Functions.
• Involved in testing and fixing bugs on test and On-line data.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Tableau (Desktop/ Server), Teradata, Oracle, SQL Developer, Toad, Teradata SQL Assistant, Teradata Administrator, Power Designer, MS Visio, MS Office Suite (Word, Excel, PowerPoint)

Confidential

SQL Developer

Responsibilities:

• Partnered with business users in requirements sessions to gather, understand and document Master Test Plan.
• Responsible for preparation of Test Strategy document.
• Identified Various Business and Data Test Scenarios and assisted in the preparation of extensive set of validation test cases to verify the data.
• Served as aSSRS2000 Reports Developer and SQL Server Developer in support of Service Management System
• Coordinated test case reviews with SME to ensure scenarios accurately capture business functionality.
• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Prepared Test Data and set up Test Environment for Integration, System and User Acceptance testing.
• Performed Unit, Functional, Integration and Regression testing with other concur Modules.
• Responsible for workflow module of Concur product testing and delivery during Various Releases/Patch fixes. Worked with Installation and configuration of Business Objects XI R2 using Tomcat and Apache as Application and Web Servers.
• Migrating Business Objects6.5.1 version reports to new version XIR2.
• Used SQL queries to analyze and validate data.
• Identified and escalated Source data quality and Integrity issues.
• Responsible for running regression QTP test scripts.
• Worked with Business end users as UAT Coordinator during User Acceptance/End to End Testing.
• Coordinated Defect Meetings with Business and Technical team.
• Participated in Daily stand up meetings with other project team members.
• Responsible for generating Test and Defect Status Report from QC on a Weekly and Monthly Basis.
• Provided End-user, documentation and second-line support to Business Users.
• Configured and used Quality Center 10 for Defect Management Process and for maintaining the traceability from Requirements to Test Design, Test lab and Defect Report module

Environment: Quality Center 10, Informatica, Oracle, Toad, SQL, Microsoft Visio, MS Office Suite (Word, Excel, PowerPoint).