We provide IT Staff Augmentation Services!

Data Analyst/ Bo Reporting Developer Resume

0/5 (Submit Your Rating)

New, JerseY

SUMMARY

  • More Than 6 Years of Experience in various phases like Data Analysis, validation, Extraction, Transformation and concepts of SDLC, Loading and reporting using TERADATA (V2R5, V2R6, V12),Oracle, AS, Business Objects and Tableau.
  • Experience in Banking Deposits, Credit Card, Mortgage business processes.
  • Sound Knowledge in Amazon Web services (AWS)
  • Well versed Experience on SQL scripts on various Relational Databases.
  • Experience in Extraction, Transformation and Loading (ETL) processes on Teradata using BASE SAS.
  • Experience in Data Verifications, Validations and developing large financial reports.
  • Strong ability with standard, non - specialist software tools such as Excel, PowerPoint, Word and good working experience with Teradata SQL Assistant and Toad SQL
  • Excellent experience in Data mining with querying and mining large datasets to discover transition patterns and examine financial data.
  • Good Experience in Performing Grant, Revoke table accesses to Database Analysts, Business Analyst, Operational Analysts and Project Manager.
  • Experience in preparing Business reports using Teradata SQL and BTEQ.
  • Developed SQL, Stored Procedures, Views, Indexes and Constraints, Query Optimizer.
  • Created numerous Teradata BTEQ, MLOAD, FLOAD, and PLSQL scripts.
  • Handling all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
  • Performing Adhoc reports using Oracle, Teradata, Bteq, and UNIX.
  • Experience in working on Performance and Optimization of the SQL Queries.
  • Hands On experience creating, converting oracle scripts (Sql, Plsql) to Teradata scripts.
  • Good experience in submission of batch jobs using Oracle and Teradata.
  • Good Experience in Developing Webi, Deski, Crystal, Webi Rich Client and Xcelsius Dashboards.
  • Created reports using Business Objects functionalities like Queries, Graphs, Charts, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formula’s, etc.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Restricted data for particular users using Row level security and User filters and developed Tableau visualizations and dashboards using Tableau Desktop.
  • Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
  • Experience in designing/building the Universes and assigning user privileges.
  • Developed Report Mock-up samples before User interaction to analyze the business requirements.
  • Designed marketing campaigns using UNICA Affinium Campaign Management Tool.
  • Extracted data for the Segmentation Process for different channels like direct mail and e-mail using the Unica Affinium Campaign Management Tool.
  • Extracting data from existing data sources, Developing and executing Business reports for Performance Monitoring
  • Experience in Building up VBA Macro for Processes which are recurring jobs to pull data for specific requirement.
  • Extensively Used Access VBA and Excel VBA to efficiently perform reporting tasks.
  • Experience in developing data applications with Python in Linux/Windows and Teradata environments. Developed Restful APIs with help of Python to query and retrieve information from database.
  • Experience in Hadoop Ecosystems HDFS, Map Reduce, Hive, Pig, HBase, Sqoop.
  • Team player with ability to adapt to various environments with excellent communication and interpersonal skills.
  • Strong experience in using Agile/Scrum methodology and well versed in writing user stories.
  • Attending project meetings and work with teams, Project managers, team members associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks. Strong written and oral communication skills.

TECHNICAL SKILLS

RDBMS: TERADATA V2R3.0/V2R4.0/V2R4.0.1/V2R4.1, V2R5, Oracle 9i/8i

Database tools: SQL developer, TOAD,Teradata SQL Assitant

Languages: C, C++, SQL, PL/SQL, VBA, UNIX Shell scripting

OLAP Tools: Web Intelligence, Dashboards, Xcelsius, Tableau, AWS.BRIO

GUI Skills: Affinium Campaign (V6.4, V7.2)

Job Function: Data Analysis, Data validation, Business Analysis, System Analysis and Design.

Operating Systems: MS-DOS, Windows 95/98/2000, Win XP, Win NT, UNIX

Web Technologies: CSS, HTML5, PHP, Java Script.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Data Analyst/ BO Reporting Developer

Responsibilities:

  • Gathering requirements from Business Analysts and identifying the data sources required for the requests.
  • Developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
  • Extracted, Analyzed and Presented Data in a Graphical Format, such a way that helped project manager to make Business Decisions.
  • Developed SAS Program for Converting Large volume of Text File into Teradata Tables by importing the text file from Mainframes to Desktop.
  • Wrote SAS Programs to convert Excel data into Teradata tables.
  • UsedPythonprograms to automate the process of combining the large SAS datasets and Data files and then converting as Teradata tables for Data Analysis.
  • Automated Windows SAS Scripts on UNIX SAS platform
  • Worked on importing/exporting large amounts of data from files to Teradata and vice versa.
  • Used VBA Macro to create Weekly reports.
  • Used Joins like Inner Join, Outer join while creating tables from multiple tables.
  • Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data about the data.
  • Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
  • Created multi-set tables and volatile tables using existing tables and collected statistics on table to improve the performance.
  • Developed Teradata SQL scripts using olap functions like rank and rank () Over to improve the query performance while pulling the data from large tables.
  • Designed and developed weekly, monthly reports related to the Logistics and manufacturing departments using Teradata SQL.
  • Extracted data from existing data source and performed ad-hoc queries.
  • Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data.
  • Involved in designing and testing of Webi reports and worked with large data and in the agile environment.
  • Created Webi, Crystal Reports and Dashboards based on the END Users andBusinessrequirements and Modified the existing Reports based on the specifications and requirements.
  • Developed and created classes with Dimension, Detail & Measure objects and developed Custom hierarchies to support drill down reports.
  • Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
  • Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.
  • Created complex reports by linking data from multiple data providers and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
  • Created Standard Reports utilizing all the features on Web Intelligence like Optional Prompts, Functions, and Alerters etc.
  • Created alerts and sub-alerts to show different ranges in values and applied drill down analysis for some reports and defined hierarchies.
  • Created Breaks, Filters at different Levels of the reports and applied ranking in the Webi reports.

Environment: Teradata, BTEQ, VBA, PYTHON, SAS, FLOAD MLOAD, UNIX, SQL, Windows XP, SAS, Business Objects.

Confidential - Washington, DC

SQL Functional Analyst/Tableau Developer

Responsibilities:

  • Responsible for gathering requirements from business analysts and operational analysts and identifying the data sources required for the reports.
  • Highly experienced in performance tuning and optimization for increasing the efficiency of the scripts.
  • Worked on loading data from flat files to Sql tables using SAS Proc Import and Fast Load Techniques.
  • Worked extensively with Tableau Business Intelligence tool to develop various dashboards.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Created Custom Hierarchies to meet the Business requirement in Tableau.
  • Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
  • Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel and SQL Developer.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Writing SQL scripts for huge data pulls and ad-hoc reports for analysis.
  • Develop reports using the advanced techniques like rank, row number and etc.
  • Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse.
  • Expertise in generating graphs using MS Excel Pivot tables and creating presentations using Power Point.
  • Experience in using OLAP functions like sum, count, csum, etc.
  • Created Set, Multiset, Derived, Volatile, Global Temporary tables.
  • Experience in writing korn shell scripts for automating the jobs.
  • Experience in scheduling the jobs in UNIX using Crontab and sleep functions.
  • Good at modifying UNIX existing scripts.
  • Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.

Environment: Oracle SQL Developer, UNIX Shell Scripts, SAS, MS Excel, MS Power Point, Tableau

Confidential - Phoenix, AZ

Business Data Analyst

Responsibilities:

  • Analyzed user requirements and developed, tested, and tuned various scripts, procedures, and database triggers to validate data.
  • SQL scripts were developed for accessing data from the Teradata tables.
  • Tuned the SQL queries for optimum performance.
  • Data loaded into Teradata from flat files using data stage dynamic sequence job with schema file concept.
  • Wrote Case Expressions, Data Manipulation Command by using Teradata (BTEQ).
  • Created numerous Volatile, Global, Set, MultiSet tables.
  • Used Inner, Outer Join, UNION, INTERSECT, CUBE, RANK, QUANTILE and OLAP functions CSUM, MSUM, MAVG, MDIFF.
  • Extensively used data blending, embed functionalities in Tableau.
  • Develop, Organize, manage and maintain graphs, tables, slides and develop document templates for the efficient creation of reports.
  • Created numerous scripts with Teradata utilities BTEQ, MLOAD and FLOAD.
  • Used Basic Teradata Query utility for reporting Purpose.
  • Developed Basic Teradata Query (BTEQ) for Interactive & batch queries.
  • Used FLoad for loading, Mload for modifying database objects.
  • Assisted in the analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
  • Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, Ms Excel, VBA Macros
  • Worked closely with different Marketing Groups in designing and analyzing the data.
  • Performed two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
  • Built the Operational data store by using BTEQ, Teradata, Oracle, SQL, PL/SQL, and UNIX.
  • Used Proc SQL to connect to Teradata.

Environment: Teradata, UNIX Shell Scripts, MS Excel, MS Power Point

Confidential - Charlotte, NC

Data Analyst

Responsibilities:

  • Involved in gathering the requirements from Business users.
  • Played a key role working closely with and supporting the Project manager and associates.
  • Performed numerous huge data pulling requests using SQL Assistant.
  • Created tables, views, database links to see the information extracted from SQL files.
  • Extracted data from existing data source and performed ad-hoc queries using SQL.
  • Extensively used Teradata Advanced Techniques in writing the scripts.
  • Worked on tables (Like Set, Multiset, Derived, Volatile, Global Temporary), views, using SQL scripts
  • Generated flat files using the Teradata Export for the Segmentation process.
  • Proficient in Data Verification and Validations.
  • Performed in depth analysis on data & prepared weekly, biweekly, monthly reports by using SQL and UNIX.
  • Developed of Fast Load /Multiload scripts for loading purpose.
  • Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
  • Specified the Joins and checked the cardinalities and Implemented User Objects in Reports and Created Condition in Universe. Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.
  • Used@functions like @select, @where and @prompt function,createpromptswhich helps the user to select the values dynamically
  • Formatted the Reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.
  • Involved in Performance testing of all the reports, which helped in analyzing its performance before moving into production.
  • Extensive use of Teradata Utilities (BTEQ, MLOAD, FASTLOAD, FASTEXPORT).
  • Involved in query Performance Tuning for accessing the data fast.
  • Provided data to Business analyst in graphical format using MS Office and Power Point Presentations.
  • Experienced in exporting data into flat files in .csv, tab fixed delimiters and etc. formats.
  • Developed new reports for the end-users and maintained current ones.
  • Documentation of scripts, specifications and other processes.

Environment: Teradata, SQL Assistant, UNIX, MS Excel, PowerPoint, Business Objects.

We'd love your feedback!