SENTHIL SEKAR

acrt1z@r.postjobfree.com, 214-***-****

SUMMARY

IT Professional with 7+ years of experience with special emphasis on Data Analysis using Statistical Methodologies and development, analysis and design of ETL methodologies using Data stage. Extensive knowledge in Data Modeling, ETL design and development, Data Warehousing, and OLAP technology.

Experience with ETL design and development of DataMarts /Enterprise wide Data Warehouses/Operational Data Stores.

Expertise in data warehousing concepts, ETL programming using Ascential Data stage Parallel Jobs, Server jobs, Job Sequencers, Batch Jobs and other data warehouse lifecycle tasks such as data analysis, cleansing, transforming, debugging/testing, and data loading across source systems.

Designing information dashboard, design Reports for operation team.

Aligning the business requirement to design and technology method to provide information solution template to the operation team to give concluded report.

Slicing, Dicing, Drilling, Sorting and reporting of data using OLAP technology for providing consumption designs.

Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design Development and Debugging.

Experience developing Unix Shell Scripts for automating Extract, Transform, Loading process for various feeds and enabling the execution of jobs in Production environment using CronTab.

Developing user-defined Transforms and Routines in Data stage Server job Edition to solve complex business logic. Optimizing job performance with various partitioning techniques in the parallel processing environment.

Good understanding of Data Warehouse and Business Intelligence concepts and fundamentals e.g. schemas, keys, OLTPs. Vs. DW structures, normalization, fact and dimensional tables etc.

Experience in UNIX Shell scripting as part of file manipulation & familiarity with Autosys.

Excellent with trouble shooting skills and resolving errors and issues.

Hands on experience with dimensional design and modeling for data warehouse (ERwin).

Strong in data analysis skills and writing queries in 4GL languages (SQL, PL/SQL).

3 years experience with UNIX file system, commands and vi editor.

Experience on relational databases (RDBMS), data models and data warehouse architecture.

Proactive team player with excellent communication skills. Quick learner with a desire to grow skills and expertise.

TECHNICAL SKILLS

ETL Tools

Data Stage Information Server 8.1.1, Ascential 8.x/7.x/6.x/5.x/4.2 (Parallel Extender (Enterprise Edition), Quality Stage, Profile stage, RTI, Information Server Manager, Information Server Fast track

DatamodellingTools

ERWIN 4.x/3.5, Star-Schema, Snowflakes Modeling, Fact & Dimension tables

Apps & Reporting

Business Objects XI, Web Intelligence, Cognos Impromptu, Reportnet, Autosys.

Operating Systems

Windows 9x/xp/2000, HP-UX, AIX, Sun Solaris, Red Hat Linux

Languages

PL/SQL, C, SQL Server 2005/08, HTML, DHTML, Java and VB Script, XML,

Shell Scripting, Perl and batch scripting

Databases

Oracle 11i/10g/9i/8i, Informix ODS 7.x, Siebel, Sybase, Teradata, DB2 UDB

7.x/8.x/9.x, MS SQL 7.0/2000,SSIS/DTS, AS/400 DB2 V5R4, and MS Access

Mainframes

IBM – OS/390, VS-COBOL II, IMS DB, DB2, CICS, JCL, VMS

PROFESSIONAL EXPERIENCE

Safeway Inc., US Data Analyst Apr-2013- Present

Project Name: Retail Operations

Roles and Responsibilities

Responsible for the day-to-day management of data, collection, analysis, and summary of information and trends for solution development.

Skilled with business and technical requirements elicitation, analysis, communication, verification, validation and methodology development

Communicated data-related issues and developed recommendations by identifying problems.

Improved systems by studying current practices; designing modifications; training users

Provided references for business users and other contributors by writing and maintaining user documentation and estimating project timelines

Customized and configured workflow to automate processes and find efficiencies

Reduced-time rendered on large DSD flat files by 96.43% by developing and managing a MS-SQL Server Analysis Model/Database Cube; retrieves, compiles, and delivers key DSD Duplicate Vendor Data metrics by Division and Department to enable improved understanding of business needs, trends and practices.

Developed user-interface that automates manual data process of DSD Duplicate Vendor cleanup to MS Access Database (front end) supported by MS-SQL Server Analysis Model/Database; by the use of tables, VBA forms, and SQL queries.

Lead Direct Store Delivery (DSD) Duplicate Vendor Divisions Cleanup; compiled and analyzed different data sets to identify, describe and explore the relationship between the vendor-store-item and determine the current vendor for consumer UPC(s) in specific store(s) to maximize the accuracy of data in DSD and other Kroger systems.

Standardized Corporate Fresh Meat Consumer UPC data/processes across the enterprise, including the Product Information data warehouse and Plum.

Identified, researched, and established Nutritional Value (NuVal) scores for all Produce and Meat/Seafood categories.

Performed Shelf Tag Analysis and Item Maintenance on various Kompass categories (i.e. units-of-measure, descriptions, per codes, etc.) within established time frames.

McKesson Corp., US Data Analyst Sep-2012- Mar 2013

Project Name: Managing Resources at Ericsson (MORE) Project

Roles and Responsibilities

Formulated a model to develop an analysis for customer segmentation based on various inequalities like expiration date, digitalized address, Pharma numerics. Analysis provides unmatched records to regulatory affairs for validation.

Standardized the pharmaceutical files from the third party (DEA, FDA, and State) and SAP database systems using the rule set in Standardize stage (Quality Stage).

Data Profiling and cleansing the controlled substance files from the State, DEA and FDA.

Developed a prototype on statistical planning for matching the data from third party with the Oracle database system by effective blocking and matching of data using Match stage (Quality Stage).

Ericsson Inc., US Data Analyst Sep-2011- Aug 2012

Project Name: Managing Resources at Ericsson (MORE) Project

Roles and Responsibilities

Worked in analysis and design phases of MORE development, data modeling design and Project Estimation.

Involved in business requirement gathering, Developed Business requirement document, mapping documents with modeling documents, written techno functional documents, test cases, test case scenarios based on the ETL PROCESS, functional specification documents.

Extensive application knowledge in writing complex Structured Query Language in Oracle, SQL Server shop for a given business requirement.

Provide staging solutions for Data Validation techniques and Cleansing applications for different source system.

Prepared ETL Mapping documents & Workflow, thorough Design Documentation for each DataStage Job for Change Detection Load & Control Tie.

Prepared Data Flow Diagrams for each head/department.

Prepared set of System Documents that describe a production system and are strictly system-oriented.

Developed the ETL Development Standards and Best Practices to design the Data Stage Server jobs consistently across the project.

Did auditing/validation after each load and developed the code to perform actions according to the results.

Used Data Stage Manager to Import and Export Data Stage components and Import table definitions from source databases.

Created several Job Sequences for the maintenance of Data Stage jobs using Wait for file, Job Activity, Execute Command, Exception Handler, Job Sequencers and User Variable stages.

Implemented Surrogate key functionality for newly inserted rows in Data warehouse which made data availability more convenient.

Used Various Standard and Custom Routines in Data Stage jobs for better job performance in sequence level.

Used Data stage Director for validating, execution, monitoring jobs and check the log files for errors.

Verified job process logic by preparing test data and conducting unit tests and participated in the systems testing and user acceptance testing.

Used UNIX Shell Scripts to execute Data Stage jobs. Developed shell scripts to automate file manipulation and data cleansing procedures.

Verified job process logic by preparing test data and conducting unit tests and participated in the systems testing and user acceptance testing.

Ericsson Inc., US Data Analyst Nov-2010- Sep-2011

Project Name: RNC Capacity Planning Configuration and Network Data Integration Project

Description: Integrate RNC network information in a database to validate, analyze and deduct the configuration data. Analysis of this information leads to suggest the RNC capacity planning for client ATT, T-mobile, and Verizon.

This application provides managerial reports and dashboard with the profiled and analyzed data.

Roles and Responsibilities

Created databases, tables, functions, stored procedures and views in SQL 2005/2008.

Worked with third party tool called EXULT to transfer XML data to SQL server database.

Developed SSIS packages to merge data from different data sources in to SQL server.

Developed REST Services using WCF to extract XML data.

UsedVSS 2005 as code repository.

Responsible for code optimization and code review as per standards.

Involved in the Pyramid Conversion Project using Web sphere DataStage Designer to extract, transform and load from source to target systems

Developed multiple Info sphere DataStage mappings and jobs involving complex transformations to various clients within enterprise.

Performed Data cleansing and standardizing data Using Quality stage.

Developed WISD(Web sphere Information Service Director – RTI web services) stage for existing DataStage jobs to provide return of data rows to requesting client

Generated Job design reports for management to keep track of design changes and its impact.

Used Web sphere DataStage Director for viewing logs and warnings and fatal errors for debugging

Performed Testing of RTI Web services using SoapUI for testing Interfaces

Build and Deployed packages from/to different projects and export/import .isx files using information server manager

Used Clear case for Versioning of ETL jobs and scripts

Used Clear quest for tracking issues, and share point to upload and access the project documents, mapping and functional specs.

Involved in creating relational models for source and target databases in framework manager

Developed and validated the reports like list, crosstab, charts drill down drill up master detail reports in Report studio.

Developed UNIX Shell scripts to copy the different files from different Servers to Datastage Server.

Developed Control files for SQL Loader to populate database tables, UNIX shell scripts to process the Flat Files.

Developed of UNIX shell scripts to invoke the Datastage jobs.

Involved in creating System test plans and then debugging and testing Entire system.

Involved in the preparation of Autosys JIL scripts to schedule the jobs.

Involved in Debugging and Unit testing of the jobs

Tata Consultancy Services, India ETL Developer Jun-2008- Jul-2009

Equifax Inc., B2B Data Migration Project

Primarily involved in the development of B2B application which involved migration of data from Progress database to Oracle database and extract data from oracle to create reports in text formats as per the Equifax business rules.

Analyzed the logical model of the databases and normalizing it when necessary.

Involved in identification of the fact and dimension tables.

Attended meetings for validation of the Data Model with the Mapping document.

Involved in the designing process of getting the data from disparate systems to data warehouse.

Extensively used DataStage Designer to develop a variety of jobs for extracting, cleansing, transforming, integrating and loading data into target database.

Scheduled the jobs using DataStage Director, which are controlled by DataStage engine and also for monitoring and performance statistics of each stage.

Executed all Test cases in all phases of testing like GUI Testing, Functional Testing, Regression testing, Integration Testing, System testing, end-to-end testing and User acceptance testing

Implemented various strategies for Slowly Changing Dimensions using DataStage Server jobs.

Involved in Writing the SQL/PLSQL query’s for Extraction of Data.

Performed various transformations and derivations through expression editor using DS transforms, DS constants, system variables and DS routines.

Developed server jobs using stages like Sequential file, Hash file, Transformer, Sort, Aggregator etc from heterogeneous systems to Oracle.

Extensively used DataStage Manager to Export/import DataStage components.

Equifax Inc., Blended Premium Business Intelligence Project Oct-2007- Jun-2008

Insight is the name of Equifax's database which holds information provided by credit providers including details of existing and previous credit agreements and historical information about the repayment of these agreements.

This application involves extracting the data from COBOL files in data stage CFF stage. Standardizing to Equifax format (Data profiling, Data Cleansing operation), validating it and loading the data into Progress database.

Used the Datastage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.

Developed many Datastage application jobs for data processing and loading, jobs are scheduled using Datastage Director.

Created various Datastage Hash files (Look up tables).

Involved in Writing the SQL/PLSQL query’s for Extraction of Data.

Developed Shared containers for object reusability and to eliminate redundancy.

Actively participated in discussions and implementation of Error Handling and Reject management functions.

Importing and Exporting of jobs through Data Stage Manager into different projects.

Extensively worked with Fact and Dimension tables to produce source - target mappings based upon business specs.

Extensively used SQL Tuning techniques to improve the database read performance through DataStage Jobs and used Frame Work approach to improve transformation and loading steps.

Involved in implementing Star Schema for the data warehouse using Erwin for logical and physical data modeling.

Involved in Unit Testing, System Testing, Integration and Performance Testing of the jobs.

Involved with Team leader, Group Members and Technical Manager in discussions regarding any technical and/or Business Requirement issues.

Nielsen Inc., RxOTC Data Movement Jul-2006- Oct-2007

Nielsen services are used by the clients to measure their market performance, analyze market dynamics, diagnose solve marketing sales problems, and to capture growth opportunities.

This project is to establish a process to send OTC volume and pricing to a third party Rx partner (Wolters-Kluwer) for all available store level data from Food, Drug and Mass channels with significant OTC data movement.

Involved in Analysis, design, testing, debugging phases of the System.

Created simple, complex create joins, calculated items and conditions.

Worked with DataStage Manager for importing metadata from repository, new job, Schema files.

Involved in Designing Parallel Extender Jobs.

Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database.

Developed packages, procedures and functions in PL/SQL for data loading and data processing.

Writing SQL*Loader scripts and UNIX scripts to format, load data from text files to database.

Analyzed the tables and indexes using SQL and PL/SQL scripts.

Monitored existing code and doing performance tuning if necessary.

Wrote database triggers for audit and data validation.

Creation of users, roles, schemas, tables, indexes etc.

Planning of logical database and physical layout.

Wrote procedures and functions using PL/SQL.

Prepared Monthly and Weekly Status Reports.

Testing, implementation and documentation.

EDUCATION

University of Texas at Dallas Aug-2009 - Aug-2011

Masters of Science in Management Information Systems GPA - 3.5/4

PSG College of Technology, India Jul-2002 - May-2006

Bachelor of Electrical & Electronics Engineering GPA - 8.0/10

LinkedIn Profile: https://www.linkedin.com/pub/senthil-sekar/15/689/7ba

Contact this candidate