SUMMARY

• Business Intelligence Developer and Sql server developer in Production, Development and Staging Environments with hands on experience in Heterogeneous files processing like Flat Files, Excel and CSV files in SSIS and developing Dimensions, Measures, Cubes using SSAS.
• Expertise SSIS Customization by extending MS Business Intelligence Framework and writing stored procedures and views for SSIS, SSRS in SQL Server. Hands on experience in creating triggers, cursors, views and indexes, debugging database components.
• Create ideas that enhance efficiency and maximize performance, implementing cutting-edge technology solutions, and training/supporting end users.
• Performed stored procedure tuning with good understanding of execution plan. Gathering business requirements, requirement analysis, system design, data modeling, writing technical specification, and production support.

• Interacted and communicated with Production and Area managers, Distribution groups, documentation team.

TECHNOLOGY

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

• Migrated customers' existing business data related to reminders, customers, notification templates, and customer feedback to Forge System. Developed new packages accommodating customer's existing data in new system.
• Performed three tasks using Business Intelligence perspective a major accomplishment in this project.
• Implemented SDK Website and SDK Gateway, an enterprise service which serves various customers over cloud for Two Factor Authentication, Reminder Service, and Notification Management and Customer Response management.
• Integrated customers uploaded data to FTP site processed, developed utilizing SSIS.
• Created and delivered Forge Reports by email on monthly basis based on report type using SSRS 2012 utilized by customers to make decisions.
• Generated data writing queries, giving relationships to tables for extracting from source documented for migration utilized for business performance.
• Extracted data using SSIS tool utilized for the migration of data from source to the destination that enabled other to have data in a usable form to make decisions and plan better.
• Developed staging tables and related objects moving new customer business data, prior to migration enabling manager to plan better.
• Carried out migration, for up to 20 customer's data over a period of one year meeting tight deadlines. Each customer data had a volume of over a million.
• Implemented performance tuning of TSQL stored procedures by analyzing applicable indexes and filters used in queries for customer feedback process, which transferred back on overnight by SSIS packages minimizing downtime, increasing Image and efficiency.
• Performed SSRS Drill-down, and Pivot Reports, providing a paid subscription to customer. SSRS Subscription model for each report so that, an ASP.Net application subscribes in runtime enabling others to have the data in a usable form to make decisions or plan better.
• Designed reports using SQL Server Reporting Services SSRS and Excel Power Pivot table based on OLAP cubes improving communications, relations, sales, quality, and morale.
• Developed Service Utilization SSAS Cube from Vendor, Product, Area, Service dimensions and Number of hours, Service Charge measures. This cube is used for Executive team for reporting vendor utilization data to enable standards, regulations or compliance rules to be met.
• Utilized SSIS packages with multi-threading related to Customer Data Migration and Overnight batch processes, related to reminder service, notification management to reduce
• Implemented Exception Handling and used existing Logging sources in all SSIS packages to cover all exceptional scenarios and troubleshooting issues in production.
• Prepared SSIS package deployment ready for production release, including release notes enabling others to do their work more easily, effectively and productively.

Confidential

Business Intelligence Developer

• Automated and derived Risk Factor from the business factors meeting KPMG Client Standard, Regulations and Guidelines.
• Consumed Web Services in SSIS packages while validating Entity/Company identification by improving understanding.
• Created database objects like table, views, Store Procedure, Triggers, Functions etc. using T-SQL providing structure to store data and maintain database efficiently.
• Implemented DB Admin tasks viz., DB Backup, Shrinking Database Transaction logs and Updating Statistics after loading the daily huge load data to minimize downtime, negative impact.
• Configured, subscribed, deployed and managed reports using Report Manager and Report Builder enabling others to do their work more easily, productively.
• Developed SSRS Parameterized, Drill-through, and Drill-down Reports enabling others to have the data in a usable form to make decisions or plan better.
• Deployed and monitored SSIS packages for Dynamic ETL workflow to validate, extract, transform and load data into database enabling others to do their work more easily, effectively.
• Created SSIS packages and implemented Error handling with important Lookups validating master data, prior to updating transaction tables, and all invalid data will be routed to error file reducing errors and rejects.
• Utilized joins and sub queries simplifying complex queries involving multiple tables ensuring consistency.
• Provided documentation about database functional specification and technical design documents for reports and SSIS Packages providing management with the necessary information to plan.

Confidential

Sql Server Developer

• Developed new drivers and testing of application that supported transactions between new generation meters maintaining or increasing customer satisfaction.
• Created database and database objects like tables, indexes, constraints, views, triggers, T-SQL functions and stored procedures minimizing downtime and increasing Image and efficiency.
• Extracted the master data from SQL Server 2005, Flat Files, Transformed and Loaded into the target Data warehouse using SSIS providing management with the necessary information to plan.
• Fine-tuned and optimized database performance and worked with high volume online Transaction Processing OLTP applications ensuring accuracy.
• Designed SSRS Drill-through, and Drill-down Reports enabling others to have the data in a usable form to make decisions or plan better.