· Requirement specifications collected from several parties and individuals.

· Provided all technical support for the developers.

· Mainly participated in Development, test environment and Implementation stages.

· Extensively worked on building business components, database, server and client system designs.

· Extracted large volumes of data from different data sources and loaded the data into target database by performing different kinds of transformations using SQL Server Integration Services (SSIS).

· Optimization of stored procedures used as the source for the reports.

· Implementing logging and Deploying.

· Having hands on experience in Migration DB’s and SSIS Migration from SQL Server 2000 (Rewriting SSIS packages in 2012), SQL Server 2008 to 2012.

· Supporting end user Applications and working on enhancement requests.

· Used Best practices for package design, dataflow techniques, deployment and management in SSIS.

· Developed Power BI reports and dashboards from multiple data sources using data blending.

· Expertise in writing complex DAX functions in Power BI and Power Pivot.

· Automated Power Query refresh using power shell script and windows task scheduler.

· Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure etc.

Extensive experience in onshore/offshore coordination and responsible for project deliverables.

· Worked with SSIS Packages.

· Created the mappings using transformations such as the Derived Column, Data conversion, Union All, Multicast, merge join, Sorter and Fuzzy Lookup using Data Flow Tasks.

· Optimization of stored procedures used as the source for the reports.

· Implementing logging and Deploying.

· Having hands on experience in Migration DB’s and SSIS Migration from SQL Server 2000 (Rewriting SSIS packages in 2012), SQL Server 2008 to 2012.

· Supporting end user Applications and working on enhancement requests.

· Used Best practices for package design, dataflow techniques, deployment and management in SSIS.

· Tracing performance tuning through Query Analyzer and Sql server Profiler.

· Created Drill down and drill through reports in SSRS.

· Expertise in scheduling reports to end-users and give acess to the report server.

· Created Subscriptions such as standard and data driven in Report Manager SSRS to generate email notifications.

· Developed and scheduled the cached reports in SSRS

Extensive experience in onshore/offshore coordination and responsible for project deliverables.

· Involved in Supporting and Enhancing the SSIS packages, keeping in view implementing appropriate SSIS controls and Implemented Package Configuration, Message Logging and Auditing.

· Created the mappings using transformations such as the Derived Column, Data conversion, Union All, Multicast, merge join, Sorter and Fuzzy Lookup using Data Flow Tasks.

· Tracing performance tuning through Query Analyzer and Sql server Profiler.

· Optimization of stored procedures used as the source for the reports.

· Supporting end user Applications and working on enhancement requests.

· Handling ITSM resolutions and creating the CR for enhancement work and released it in weekend release process.

· Working as Release Manager to process the CR release in weekend and co-coordinating with Onshore/Offshore team and responsible CR release to Production.

· Extensive experience in creating Datamart reports in Microstrategy as per the user requirements

· Extensively working on user requests to resolve Access issues and provided required access to particular area of reports in Microstrategy web.

· Worked on Microstrategy Report data issues and provide the solution to users. Good exposure to data query tools like SQL Developer and TOAD.

· Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts.

· Extensive experience in onshore/offshore coordination and responsible for project deliverables.

· Handling ITSM and JIRA’s resolutions

· Involved in Unit Level and Peer Testing.

Requirement specifications collected from several parties and individuals.

Extensively worked on building business components, database, server and client system designs.

Implementing SSIS packages to load the claims details into the database. pdf compress and decompress using SSIS packages.

J.D. Power is a global leader in consumer insights, data, analytics, and advisory services that helps clients drive growth and profitability. The companys industry benchmarks and reputation for independence and integrity have established it as one of the worlds most well-known and trusted brands.

M&T Bank has been committed to customers and community for more than 150 years. Founded on the principle of providing exceptional financial products and friendly, personalized service, M&T is more than just your neighborhood bank. Let us help you reach your financial goals with our full suite of bank accounts and lending solutions, including savings accounts, checking accounts, auto and home loans, and more.

Lloyds TSB is the largest retails bank in the UK with a number of leading market positions. In wholesale Markets, the Treasury and Trading solutions are provided by summit which provides a fully integrated transaction processing platform for a wide range of Treasury and wholesale market participants.

MedNeutral offers a secure and scalable on-line solution that enables faster processing and improved outcomes for claim handlers, attorneys, and medical professionals who rely on medical records for facts & information. With medical inflation continuing to outpace price increases in other parts of the economy, the importance of medical record review takes center stage as a means of evaluating standards of care, making decisions about long term treatment, and managing cost. Top institutions are using MedNeutrals Medical Records Optimization (MRO) platform to streamline the medical review process and make more accurate and informed decisions.

Call Randomizer is a CRM application which deals about quality of the calls received from the customers. The application consists of data capture of call details which are received and isolated by various locations. All these calls are captured by agents and mapped to them accordingly. To review the quality of the calls, Randomizer application randomly picks the n no of calls for each agent, so that the administrator will assign the calls to the particular employees to review the calls. The employees will login and checks the assigned calls which are assigned to them. Review the calls and change the status of the calls like low quality of voice, invalid calls, and complete call. If the status of the call is not complete call, there is a option provided to replace the call details with other call for the same date and same agent.

GAME is a chain of retail stores in UK, specializing in video games and accessories. There are over 1200 stores in UK. The company was looking for business enhancement and competitive edge using ARC to make better business decision. Management is concerned with the logistics of ordering, stocking and selling products as well as maximizing profit. The Warehouse system was developed that lets management see what products are selling in which stores, at what price, as well as who their most frequent/valuable customers are and also to know the effects of promotions..

SMW is a Canberra based specialist sporting goods retailer, operating for over 24 years retailing quality sporting Leisure and recreational apparel equipment and footwear. The main objective of the project is to help the senior and middle level management of the organization to improve the sales and get the knowledge of the new business opportunities.

Wyeth is a research-based, global pharmaceutical company responsible for the discovery and development of some of todays most innovative medicines. Worked in their business intelligence team on a Data Warehousing project based on IMS prescription and sales data project.