Graduate Student Assistant Resume

PROFESSIONAL SUMMARY:

4 Years of work experience and expertise in working with various Business Intelligence ETL tools, Reporting Tools, Databases
Good Understanding of Data Warehouse Design and Data Modelling.
Pursuing Certification on Google Analytics and AWS Solutions Architect

TECHNICAL SKILLS:

Business Intelligence ETL Tool: Informatica PowerCenter 9.5.1/9.6, Talend, SSIS, SSAS, Pentaho

Business Intelligence Reporting Tool: Tableau - 8.x, 9.x, SSRS, IBM Cognos 10, Oracle BOXi R4, OBIEE, QlikView, Power BI, Looker

Database: Oracle 11g,12g, MS SQL Server 12/14, Teradata 14.0, PG Admin(Greenplum), Redshift, Mongo dB

Languages and Scripting: C/C++, Python, R, JAVA, SQL, PL-SQL, RDBMS, T - SQL, SAS, VB Script, Bash, Scala

Tools: Eclipse, Putty, MS Office, ServiceNow, Cronacle 9, Tivoli, TortoiseSVN

Big Data and Framework: Map Reduce, Hadoop Architecture, Apache Spark, Kafka

PROFESSIONAL WORK EXPERIENCE:

Confidential

Graduate Student Assistant

Responsibilities:

An online Hotel Booking Management system developed using Java and JavaFX using MS SQL Server Prediction and Analysis of New York Stock Exchange using Weka, R, Tableau, SVM, ANN
Analyzed the data patterns in the dataset, Predicted the future forecasting using Time series predictive model and Tableau Designing and Implementation of Data warehouse for Graduate School Admission using SSIS, SSRS, SSAS, Pentaho
Gathered requirements and built Data warehouse. Performed Analytics Tableau to find patterns to understand the statistics.
Performed multiple MapReduce tasks, retrieved information of huge weather data sets, and performed the analysis of data
Developed an Application to purchase Laptops. Developed modules in Python, Performed CRUD Operations
PHP Application on Cloud using EC2, Load Balancer, S3, RDS, SQS, SNS components of AWS with the backend as SQL, MySQL.
Deployed and tested a PHP application on AWS cloud. Implemented and tested shell scripts for automation

Confidential

Senior Business Intelligence Developer

Technology Stack: Informatica Power Center, SQL, Tableau, Microsoft SQL Server, SQL, T-SQL, SSAS, SSIS, SSRS, Power BI

Responsibilities:

Prepared and reviewed requirements, functional specifications, technical designs, and implementation documentation
Understood and maintained a multi-terabyte enterprise data warehouse with an accompanying nightly update cycle
Developed and implemented best practices for data movement, data quality, data cleansing, and other ETL activities
Developed and supported 9 servers, 600 ETL’s, 3 Cubes, 300 Business Reports
Responsible for data profiling as well as SQL and database tuning and optimization using execution plans
Experience with database development and data manipulation using PL/SQL (stored procedures, functions, triggers)
Developed and maintained Data Models, hence providing users a platform to create AD-HOC reports using Tableau Server
Developed dashboards using Tableau Desktop which involves various key performance indicators (KPIs)
Involved in Performance Tuning in ETL mappings and Performance tuning of Tableau reports
Handled production ETL, Reporting Data issues. Hands on experience on Unix and shell scripting
SeniorL3 support, Responsible for resolving Production Environment Technical issues tickets within SLA window
Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2008
Experience with SSIS script task, lookup transformation, and data flow tasks using T-SQL and Visual Basic(VB) scripts
Worked on MS Office Applications to analyze, prioritize, and make sense of large data sets
Development of BI Frameworks and standards.
Worked in Defect Analysis and Defect Fixing in Dev, QA and UAT stages and used UNIX shell scripting for scheduling & FTP

Confidential

Business Intelligence Developer

Technology Stack: Informatica Power Center, SQL, Tableau, Microsoft SQL Server, SQL, T-SQL, SSAS, SSIS, SSRS, Power BI

Responsibilities:

Integrated Data from heterogeneous Sources into a single Warehouse. Extracted Data to Staging Area, loaded data to Target Database. Performed Data Cleaning, Data Transformation, Data Loading as per requirement
Developed BI Reports and performed analytics using MS Excel, SSRS, Python

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship