Assistant Manager Resume

TECHNICAL SKILLS:

Tools: R, Python, SAS, Java, SQL, RUBY, PLSQL, Excel, SPSS, Google Analytics, XML, VBA, SharePoint

Business Intelligence Tools: Tableau, Alteryx, Informatica powercenter, Amazon Redshift, SSAS, SSIS, OBIEE, MS BI

Database Platforms: MS SQL Server, Access, Oracle 11g, PostgreSQL, Teradata

WORK EXPERIENCE:

Confidential

Assistant Manager

Assisted Senior management in maintaining project schedules, work breakdown structures (WBS), meeting summaries and status reports to ensure effective, ongoing communications across all team members.
Coordinated a team of 7 members and monitored all project related activities including requirements gathering and strategy development to ensure smooth execution of project tasks and deliverable.
Followed SCRUM (Agile) methodology and developed a dashboard with value added product in a sprint
Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Built interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
Worked on the development of Dashboard reports for Key Performance Indicators for the top management
Rebuilt existing Reports into Tableau Visualizations with user and action filters
Performed Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
Generated various dashboards in Tableau Server using different data sources such as Access, Oracle and Microsoft SQL Server.
Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
Interacted with customers on a regular basis to resolve issues.
Created custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations
Published Workbooks by creating user filters so that only appropriate users can view/edit them.
Generated context filters and handled performance issues while dealing with huge volume of data.
Experience in creating aggregate tables, table partitions, indexes and cache management.
Also acted as the ETL developer in the team and used Informatica when complex transformations were required.
Created advanced mapping, transformations, and workflows using Informatica PowerCenter 8.x then exported the csv files to use in Tableau.

Confidential

Junior Manager

Created 50+ mappings, sessions and workflows by applying business logic using Informatica powercenter.
Improved the ETL performance by tuning queries, session partitioning, increased commit intervals, optimized the database and Informatica ETL mappings.
Automated manual tasks by creating shell scripts to create alerts upon start, end and failure of work flow there by increasing efficiency by 10%.
Created Data warehouse for Sales Depot Management System to take care of stock availability, sales etc.,
Identified Sources and Targets and created Informatica mappings between sources and targets. Defined various facts and Dimensions in the data mart.
Created Informatica mappings, transformations (Expression, Aggregator, Filter, Normalizer, Joiner, Lookup, Router, Update strategy and Procedures) workflows and sessions and resolved issues in transformations and mappings.
Interacted with Business Users and Business Owners to know their Business views in developing and modifying requirements.
Responsible for creating and modifying the PL/SQL triggers, procedures, functions and packages as per the business requirements.

Confidential

Senior Engineer

Interacted with business users to gather and analyse requirements for developing dashboards using BI tools.
Built ER models and Dimension Modeling according to client business needs.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship