Client Services Analyst Intern Resume San Antonio, Texas - Hire IT People

TECHNICAL SKILLS:

Big Data Technologies: Hadoop, Hive, Pig, Horton Sandworks

Analysis/Reporting Tools: Microsoft Excel, Power BI, Tableau, Qlikview

Programming Languages/ Databases: R, Python, SQL, MS SQL Server, MS Access, Oracle 11i and R12, Putty

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, Texas

Client Services Analyst Intern

Responsibilities:

Analyzed Team’s performance using Excel Pivot and Power BI Dashboard Analysis
Performed predictive Analysis on metrics affecting on time performance to achieve higher efficiency
Automated Reports and Dashboards to improve operational KPI's and optimized processes to reduce lead time
Designed and maintained Business Intelligence reports for better understanding of market trends

Confidential

Senior Systems Engineer

Responsibilities:

Analyzed business requirements, prepared functional requirement specifications (FRS), designed specification documents, estimated project scope and worked closely with clients to finalize acceptance criteria
Delivered Business Intelligence Solutions for Oracle Finance Components such as Interfaces, Reports and Conversions using SQL programming language on Oracle EBS Application Platform
Incorporated Architectural Design, Development, Unit testing, System Integrated testing (SIT), User Acceptance testing (UAT) along with end users and final deployment on production environment
Validated database updates in parallel with front - end functional scenarios using SQL queries in TOAD
Developed application design to extract and transform (ETL) raw data from base tables using web-services filter in service-oriented architecture (SOA)
Integrated Oracle OBIEE with transformed data to create Report, dashboards for enabling key business process

Confidential

Senior Systems Engineer

Responsibilities:

Predicted possibility of aircraft bird strike with 93% accuracy using Matplot, NumPy, Pandas libraries in Python
Developed various models using Logistic regression, Decision Trees and Neural Network and determined the best model to predict aircraft bird strikes
Proposed actionable recommendations to avoid possible bird strike and improve business profitability

Confidential

Senior Systems Engineer

Responsibilities:

Analyzed and designed database schema by defining entity-sets, relationship-sets, cardinality and documented ER Diagram using MS Visio
Optimized SQL queries by creating index, stored procedures, triggers and view for the faster accessing of data
Improved business process by implementing database management system which resulted in better tracking of sales and inventory, systematic storage of information (Business data)
Inserted data using Forms, built menu driven Navigation Switchboards, generated reports using MS Access

Confidential

Data Modeler

Responsibilities:

Analyzed and Designed Entity Relation Schema of Confidential using Erwin and implemented the database of this model using MS SQL Server
Designed Dimensional model by removing loops, traps in Universe Design Tool and Information Design Tool and implemented the database in MS SQL Server

Confidential

Senior Systems Engineer

Responsibilities:

Plotted accidents data points on the map and color coded different states to visualize the number of accidents
Joined multiple data sets using Data Blending feature of Tableau to enhance the visualization
Created interactive visualizations such as Dashboard, Storyline using Grouping, Sorting, Formatting and Dual Axis Charts to get aggregated data knowledge
Created the semantic layer/data model using ER and Dimensional modeled databases.
Created Qlikview files by connecting to database, executing script, resolving circular references & synthetic keys
Designed various visualizations for objects using Charts, List Boxes, Sheet Objects, Pivot Tables and Multi Box