Data Warehouse Specialist Resume

SUMMARY:

IT professional with keen ability to adapt quickly to shifting priorities and environments. Team - player with excellent communication skills. Able to follow instructions precisely and supervise/train others. Thrives under pressure to meet critical project deadlines. Flexible, honest, and dependable. Decisive decision maker.
IBM InfoSphere DataStage, IBM Cognos Analytics, Transact-SQL, PL/SQL, Microsoft SQL server, Oracle, Data Modeling, Data Management, Data Entry, Data Warehousing, Java language, MYSQL, Python, Visual Studio, and Microsoft Office
Configuring and installing Linux, windows XP, windows vista, windows 7, windows 8 and 10
MS office: Word, Excel, PowerPoint, and Access
SQLServer Integration Services (SSIS), andSQLServer Analysis Services (SSAS)
ETL implementation usingSQLServer Integration Services (SSIS) in OLTP and Data warehouse Environment
Computer hardware assembly and maintenance
NOSQL database
Understanding of different backup options in SQL server
Android Studio
Linux operating system; CentOS and Raspbian
SQL server(2008,2012,2014)
Optimizing the database by creating various clustered, non-clustered indexes and indexed views
HTML/CSS, Java, Ruby on Rails, C++, and C#
Proficient with Virtual machines(VMware, Virtual Box)

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Specialist

Responsibilities:

Implementing business rules via stored procedures, and ETL tool (IBM Infosphere DataStage).
Acting as a liaison between Information Technology and business units.
Developing, implementing, refining, and supporting a data warehouse used for analytics and reporting and optimizes processes while working closely with internal stakeholders.
Responsible for verifying accuracy of data and maintaining and supporting the data warehouse.
Responsible for coding and documenting procedures, and programming, testing and debugging data warehouses.
Migrating reports from Cognos 10 to Cognos 11(Analytics).
Extensively working on Framework Manager in creating models and implementing ‘best practices’ while modifying relationships, resolving the loops in Relational data.
Building and publishing dynamic cubes in IBM Cognos Dynamic Cubes.
Designing star schema for Orders and Shipments.

Confidential

Business Analyst

Responsibilities:

Used Oracle PL/SQL on a regular basis to create tables and extract data.
Collaborated on daily basis to define promotion effectiveness metrics used by Merchandising and Advertising for mass promotions.
Performed ad-hoc analysis and provide insights to support specific Merchandising promotion initiatives and projects.
Monitored the sales of front page and back page ad and making recommendations on what to put on ad for the following week.

Confidential

Associate Programmer Analyst (Business Intelligence)

Responsibilities:

Developed and implemented OLAP cubes, reports, and documentation for end users, including systems and methodologies for report processing for data warehousing and business intelligence.
Identified data sources, and designed and maintained the acquisition, security and integrity of reports by developing strategies and methods using various tools.
Created new tables, written stored procedures for Application Developers and some user defined functions.
Helped migrating from, IBM Cognos 7 to Cognos Analytics
Created ETL mapping and process flow, as well as provided daily production support to report processes and end-user community.
Worked on Data modeling, creating star and snowflake schemas.
Developed and maintained databases in multiple versions of Microsoft SQL server.
Performed data conversions from flat files into a normalized database structure.
Managing historical data from various heterogeneous data sources (i.e. Excel, Access)
Implemented different types of algorithm for Business needs.
Converted large amount of data from snowflake schema to star schema.
Implemented data level security for specific users.
Trained users how to write reports more efficiently.
Implemented different kind of calculations for report specific needs (KG, LBS, and MT)
Created complex T-SQL queries with little to no help from supervisor.
Gained deeper knowledge of Left, Inner, and Outer joins, mostly used left joins.

Confidential

IT Intern

Responsibilities:

Gained experience in shadow protect software to back up the servers.
Involved in Performance tuning ofSQLqueries and stored procedures usingSQLProfiler and Database Engine Tuning Advisor.
Experience in how to backup MS SQL server and what backup options to use.
Understanding of how to map network drives
Understanding of big data such as Maria DB database.
Understanding of backing up servers. Create a backup plans.
Serve as the Systems Administrator in absence of Systems Administrator.
Manage roles in exchange server.