Software Developer

Responsibilities: • Design and support of ETL applications using Informatica workflows and SQL Server Integration Service (SSIS) packages for loading the data coming from various source such as SQL Server, Oracle, Teradata, VSAM files, text files, Excel files etc. • Scheduling and maintaining daily and weekly Labor tracking and Adjustments data through ETL jobs, tasks, and alerts. • Generated periodic sales/labor reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS) • Based on the client requirement, developed various operational Drill-through and Drill-down reports using SSRS. Also developed Sub Reports, Charts, Matrix reports, Linked reports, etc. • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity. Projects: • Generating insights on store performance, cashier performance and labor hour prediction for a leading retail chain in the US