Senior ETL/Business Intelligence
HSBC
مجموع سنوات الخبرة :6 years, 4 أشهر
Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
Fulfilled High Priority tickets with SLA of 3 hrs to meet the needs of High Stake Clients.
Coordinated with data modeler and database administrator to understand the business process of the data warehouse model.
Coordinated with data modeler and database administrator to understand the business process of the data warehouse model.
Involved in scheduling the DataStage jobs using Control-M.
Extracted the source data from different sources like Complex Fixed width Multiple record type flat files(from Mainframes) and DB2 Databases.
Extracted the source data from different sources like Complex Fixed width Multiple record type flat files(from Mainframes) and DB2 Databases.
Data masking rules were applied on the data to prohibit sensitive information from visibility.
User tables were created so that other user information is masked from becoming visible to unauthorized users.
Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
Great ability to create and manage various database objects like tables, views.
Created Maintenance Plans and setup log files to monitor jobs.
Designed, developed and monitored DataStage Parallel jobs using DataStage8.1(Enterprise Edition).
Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
Developed ETL routines based on technical requirements.
Managed star schema/snowflake data warehousing projects for medium and large corporations in diverse industries.
Analyzed the existing tool and participated in meetings with the business users to gather and writing technical specs.
Requirements and design goals of data warehouse.
Identified the dimension, fact tables and designed the data warehouse using star schema.
Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
Developed Aggregations, partitions and calculated members for cube as per business requirements.
Complicated jobs were developed to include changing business rules and perform quality checks on data received from external vendors.
Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
Experience Analyzing, Sourcing and Parsing complex Flat files and XML.
Defined the data definitions and created the target tables in the database.
Wrote Korn Shell scripts to schedule batch jobs to obtain data overnight from various locations, through Scheduling tool called Control-M.
Mapped the source and target databases by studying the specifications and analyzing the required transforms.
Unit tested the mappings to check for the expected results.
Experience in conducting data validation using SQL.
Architected and managed implementation of Oracle star schema/snowflake conformed data marts.
Involved in development of UNIX shell scripts for Batch jobs etc run.
UNIX Shell scripting (Korn, BASH, and CSH) as part of file manipulation, Scheduling and text processing.
Prepared test docs which involved preparation of test data, test case and unit testing of the jobs .
Provided data modeling support for numerous strategic application development projects.
Created various classes and objects for Universe. Measure, Dimension and Detail objects were created to meet the needs of end user requirements so that every possible query can be achieved.
Involved in the designing and development of Universes, Classes and Objects.
Involved in creating Conceptual design which gives the Source to target mappings with the business transformation rules.
Worked with functional staff to translate business requirements into appropriate logical and physical data structures.
Developed source to target mappings with transformation rules.
Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
Administered user, user groups, and scheduled instances for reports in Tableau.
Developed job sequence and implemented restart ability using various checkpoints.
Written Unix Shell Script for creating Header and Trailer for the output file.
Involved in Test case writing and code review.
Used DataStage version control to move the jobs from DEV to SYS to PROD.
Developed and deployed Control-M jobs.
Developed business process and technical design documentation for each reporting service developed in this project.
Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.
Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
Optimized queries by looking at Execution Plan for better tuning of the database.
Gathered business requirements by driving user-group meetings and working with various global, cross-functional and virtual teams.
Monitoring database servers for any unexpected errors/failures, providing 24 X 7 on call support for production environment.
Creation of new databases, planning the location of data, index, and transaction log files on the disks.
Created views, stored procedures, functions and triggers.
Worked on broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.