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
