CV,7+ Years Experience In Data Warehousing Targeting UK

Available
Serial No: 47706
Skills keywords: business intelligence, datastage developer, SSIS
Current location:  Kerala, India - View on map
Nationality: India
Spoken languages: english

PROFESSIONAL EXPERIENCE

INFOSYS LTD
Feb 2009 to till date

A highly reputed MNC which defines designs and delivers technology-enabled business solutions that help Global 2000 companies and also provides a complete range of services by leveraging their domain and business expertise and strategic alliances with leading technology providers.

CURRENT DESIGNATION: TECHNOLOGY LEAD

PROJECT NAME: MARKET PLACE
ROLE ETL DEVELOPER

Responsibilities

• Used DataStage as an ETL tool to extract data from sources systems, aggregate the data and load into the Netezza database

• Responsible for using different types of Stages such as FTP, Sequential File, Sort stage, Transformer and ODBC to develop different jobs.

• Performed Unit Testing and also Regression testing when needed along with Documentation.

• Developed Shell Scripts to run data stage jobs, PL/SQL blocks & Nzsql Scripts

• Unit Testing & Post Deployment Support.

Software/Tools Netezza DB 5.0.4, Unix, IBM WebSphere DataStage 8.1.

PROJECT NAME: MOTHERCARE INTERNATIONAL
ROLE ETL DEVELOPER

Responsibilities

• Developer Cubes and Calculations using MDX Queries to meet the requirements

• Automated the Cube Processing using SSIS Packages.

• Created Different Cube Partitions based on the Data Loads of various tables.

• Automated the Cube Partition creation using SSIS Packages.

• Unit Testing and UAT with End User

• Knowledge transfer to Support Team to enable them for the production support

Software/Tools MS SQL Server 2008, MS SSAS 2008 and MS SSIS 2008

PROJECT NAME DMP (INTERNAL PROJECT)
ROLE ETL DEVELOPER

Responsibilities

• Developing the SSRS Reports as per the Requirements

• Development of SSIS Packages and Jobs for the Uploading of Excel data to the Database.

• Development of Store procedures and Functions to support various SSRS Reports

• Deploying and Publishing of Report & Integration with the Portal.

• Unit Testing, Integration Testing

Software/Tools MS SQL Server 2005, MS SSRS 2005, MS SSIS 2005 and .Net.

PROJECT NAME: VODAFONE
ROLE SENIOR ETL DEVELOPER

Responsibilities

• Developed Data Crawlers and configured for HiMi(Infosys Text Mining Tool)

• Created Cubes and Dimensions out of the Database and Produced Various Reports

• Generated SSRS & Excel Reports from the SSAS Cubes.

• Identification various Important area s for the customer.

• Unit testing and Integration/Regression testing.

Software/Tools MS SQL Server 2008 R2, MS SSIS 2008,MS SSAS 2008, HiMi(Infosys Tool)

PROJECT NAME: MARKETSHARE
ROLE SENIOR ETL DEVELOPER

Responsibilities

• Development of Store procedures and Functions to load the tables based on the client requirement.

• Creating SSIS jobs for sequencing the scripts and scheduled using SQL Agent.

• Unit Testing and Integration Testing.

Software/Tools MS SQL Server 2008, MS SSIS 2008

PROJECT NAME; SALMON CUBE SUPPORT
ROLE SENIOR ETL DEVELOPER

Responsibilities

• Troubleshooting of SSAS Cubes and Virtual Cubes if some error happens.

• Analyze the Cube and find out Improvement Areas.

• Make sure that the cube execution is completed successfully on a daily basis.

• Manually process the cube if the scheduling job failed.

• Intimate the users that the cube is ready for browsing.

Software/Tools MS SQL Server 2008, MS SSAS 2008, MS SSIS 2008

PROJECT NAME; UCCS
ROLE ETL TEAM LEAD – ONSITE

Responsibilities

• Requirement gathering for the new development projects. Meeting with business team to get the requirements and scope.

• Developed simple to complex jobs using DataStage ETL tool as per the requirements

• Responsible for using different types of Stages such as FTP, Sequential File, Sort stage, Transformer and ODBC to develop different jobs.

• Improved the Job Performance by implementing various performance tuning activities

• Performed Unit Testing and also Regression testing when needed along with Documentation.

Software/Tools IBM DataStage 8.0,MS SQL Server 2008, MS SSIS 2008, Oracle 10g,DB2

PROJECT NAME; ODS PROJECT
ROLE SENIOR ETL DEVELOPER

Responsibilities

• Development of Store procedures and Functions to load the tables based on the client requirement.

• Creating SSIS jobs for loading the target tables.

• Designed High performance Jobs for loading Billion sized tables

• Unit Testing and Integration Testing.

• Worked in the agile method and used rally for tracking

Software/Tools MS SQL Server 2012, MS SSIS 2012, Rally,HP QC, IBM CDC

QUALIFICATIONS

• Bachelor of Engineering in Computer Science, Anna University, India
2008

CERTIFICATIONS

• IBM WebSphere DataStage 8.0 Certified Developer.

• Star Infoscian Certificate for Exceptional performance.

• Multiple Technical certificates (DataStage, SSIS, Oracle, SQL Server etc.) internal to Infosys.

TECHNICAL EXPERTISE

Operating System LINUX (RedHat, Ubuntu), Unix (Solaris 8, 10), Windows

Databases MS SQL 2005/2008/2012,Oracle 9i/10g/11g,Terdata,DB2

Reporting & Analysis Tools SSRS,SSAS, MicroStrategy 9.0

ETL Technologies DataStage, SSIS, BODS,SSAS

DB Programming SQL,PL-SQL, T-SQL, Stored Procedures, Functions, Triggers, Cursors,

Scheduler Crontab, Tidal, Control -M

Version Control Tools SVN, Visual SourceSafe

Other Tools Visio , Remedy ,Maximo , Rally, HP QC, IBM CDC, Infosys HIMI

 

 






popup-img