We provide IT Staff Augmentation Services!

Techno Functional Analyst Resume

SUMMARY:

  • Nine years of experience in the Design, Development and implementing end to end BI Solutions focused on Data warehousing using Teradata, Hadoop, Tableau for Business/Application software/Data Science.
  • Expertise in Data modeling, Enterprise Data Warehousing and Business Intelligence.
  • Proficient in TERADATA Architecture and extensively used TERADATA Utilities BTEQ, TPUMP, FASTLOAD, MULTILOAD, TPT, FASTEXPORT, FASTIMPORT.
  • Strong programming (PL/SQL) and debugging skills in TERADATA/HADOOP.
  • Significantly reduced turnaround time in Teradata/Hadoop - Hive reports production by continuously automating and scheduling them through UNIX based framework.
  • Leading offshore team (based out of India) to create seamless work environment with Confidential by providing on time knowledge transfer (KT) and helping solve technical and domain challenges.
  • Enhanced performance of existing TD system by minimizing database resource utilization and reducing CPU cycles thus significantly reducing skewness of SQL queries to a large extent.
  • Efficient in writing Complicated and efficient SQL Queries, Stored procedure and BTEQ Scripts in TERADATA.
  • Well versed with TERADATA/Hadoop Performance Improvement Techniques.
  • Ability to assess business rules, collaborate with stakeholders and perform source-to-target data mapping, design and review.
  • Familiar with Data mining, machine learning and advanced data processing.
  • Hands on experience in writing Unix shell scripts and BTEQ for report automation, data cleaning/quality checks, Report publishing and job scheduling.
  • Hands-on experience on major components in Hadoop Ecosystem including Hive, Sqoop, MapReduce/HDFS Framework.
  • Loading data from the different Data sources like Teradata into HDFS using sqoop and load into partitioned Hive tables.
  • Enhanced performance of Hadoop system by minimizing database resource utilization thus significantly reducing Mappers of Hive queries to a large extent.
  • Expertise in developing solutions using Hadoop and Hadoop ecosystem.
  • Basic understanding of VERTICA database.
  • Good experience in scheduling tools Autosys.
  • Having Working Knowledge on Sqoop for Data Processing.
  • Completed Cloudera Developer Training Apache HADOOP.
  • Experience with Tableau 10.x products - Tableau Desktop, Server and Public.
  • Proficient in creating dashboards and incorporating visualizations Table Calculations, calculated Fields, Groups, Sets, Hyperlink, Charts, Filters and Parameters
  • Wrote custom SQLs to connect to a specific query rather than the entire data set, which reduces the size of data for analysis.
  • Data blending to bring data from multiple data sources into one Tableau view
  • Schedule publishing of Workbooks and refreshing Extracts Using Tabcmd. Well-informed on carrying Tableau Server Admin activities - Installing/ Upgrading Tableau Server and Tableau Command Line Utilities Tabcmd and Tabadmin.
  • Carried out Full/Incremental refresh to extract records from data sources, depending upon the Data load of underlying tables.
  • Managing ownerships and granting permissions to user/user groups.
  • Co-ordinated with business users, business analyst and the marketing team to understand business requirements, implement and add latest functionalities to make visually attractive reports, that are show- cased to Prospective clients.

TECHNOLOGIES:

Microsoft .NET, C#, Visual Basic, Microsoft Visual Studio, SQL Server

PROFESSIONAL EXPERIENCE:

Techno Functional Analyst

Confidential

Responsibilities:

  • Ad-Hoc Report generation to support various businesses.
  • Discuss with business users regarding the functional\nonfunctional requirements.
  • Have regular meetings with clients and conduct onsite system study to analyze requirements and assess feasibility of the same.
  • Requirement Analysis, Designing, Developing and generating the reports/extracts.
  • Data Analysis (Analyzing the form granularity and other aspects of the data). This involves writing SQL queries.
  • Initial data setup using Teradata utilities (Multi load, Tpump, Fastload) and for Hadoop using Sqoop/Hive.
  • Writing Shell scripts.
  • Data Profiling, performing analysis on high volume data (in TBs) to design and build Teradata (TD) and Hadoop/Hive reports on product, sales, and operational performance of Confidential business for Confidential ’s internal users.
  • As the lead of the project, I Deliver technical and thought leadership to the team to optimize and better strategize the project.
  • Readily available for business users across various business areas on providing data related clarifications, common data patterns, data issues.
  • Weekly status with the Client manager to review the issues.
  • Emergency meeting for high priority reports.
  • Co-ordinate the tasks with various teams involved with the application.
  • Discuss with Client on issues raised by business users and optimal solutions to the problems raised.

Module Lead

Confidential

Responsibilities:

  • Discuss with business users regarding the functional/non-functional requirements.
  • Have regular meetings with clients and conduct onsite system study to analyze requirements and assess feasibility of the same.
  • Review Business Requirement document and Prepare estimates of the work involved.
  • Setting up environment of the Confidential internal Hadoop framework across Dev/Test/Prod servers.
  • Hadoop/Hive Data analysis, validation and support
  • Metadata setup for effective and fast table migration
  • Writing Shell scripts for automation
  • Data setup using Teradata utilities (Multi load, Tpump, Fastload)
  • Setting up the Crontab job.
  • Leading offshore team (based out of India) to create seamless work environment with Confidential by providing on time knowledge transfer (KT) and helping solve technical and domain challenges.
  • Weekly status with the Client manager to review the issues.
  • Emergency meeting for high priority production issues.
  • Discuss with Onsite/Client on issues raised by business users and resolving them.
  • Co-ordinate with framework team and other application teams to migrate the application to production.

Confidential

Lead Quality Assurance

Responsibilities:

  • Understanding Business Requirement Specifications and Interaction with client for query and issues regularly.
  • Design and Development of Stored procedures in TERADATA.
  • Writing the Unix Shell script and setting up autosys jobs
  • Involved in Functionality Testing, Integration Testing, Defect tracking and Fixing.
  • Offshore Module lead.
  • Mentoring and providing Knowledge transfer sessions to the new comers to the project.
  • Providing the status of development and other activities involved or assigned by onsite lead/Manager

Confidential

Lead Quality Assurance

Responsibilities:

  • Performed various testing like Regression Testing, Security Testing, Accessibility Testing, User Testing, Web based Testing, Integration and Functional Testing, User Acceptance Testing, Documentation.

Confidential

Lead Quality Assurance

Responsibilities :

  • Web form Development, Migration, Requirement analysis, Testing and validation, Co-ordination with onsite, Project documentation, Test cases and Use cases preparation,

Hire Now