SUMMARY:

• 8 (approx.) years of experience in developing applications using Microsoft SQL Server and SAP ABAP.
• 5+ years of experience in MSSQLServer R2 / 2012 as a Database Developer / Business Intelligence Developer.
• 2.6 years of SAP ABAP development experience in FICO, SD and MM modules.
• Experience in MS SQL Server with OLTP/OLAP and Business Intelligence (BI) delivery using T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Report Builder.
• Experience in Logical and physical Data modeling of relational data bases and drawn data base diagrams using tools like Visio and SQL Server Management Studio (SSMS).
• Experience in Data Modeling Techniques like Star and Snow-Flake Schema and Data Warehousing Concepts like Fact and dimension tables .
• Excellent knowledge in creating Databases, Tables, Stored Procedures, Views, CTEs, USD Functions, Triggers, Indexes, Cursors etc. using T-SQL.
• Hands on experience in creating different types of constraints like Primary Key, Foreign Key, Default, check and Unique in order to implement Referential Integrity and other Business Integrity rules.
• Excellent in Query Optimization, Performance tuning using tools like SQL Profiler, Index Tuning Wizard, Execution Plans and Database Engine Tuning Advisor.
• Experienced in Designing SSIS Packages for integrating data using OLE DB Connection from different sources like Excel, CSV, Oracle, flat file to MS SQL Server by making use of multiple transformations provided by SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent and schedule SSIS Packages using SQL Server Agent.
• Experience in using variables, expressions, functions in the reports and in handling Parameterized reports in SSRS.
• Good at using variables, expressions and functions in SSIS and making the packages dynamic by accepting the values dynamically in the packages.
• Expert in configuring Reporting Services (SSRS) in native mode using Reporting Services configuration manager.
• Experience in deploying SSIS Packages and using Package configuration to export various package properties to make package environment independent.
• Hands on experience in Deploying SSRS Reports to Report server and managing them on Report Manager.
• Skillful in creating Dashboard Reports, drill down, drill through, sub-reports, multi-valued parameterized and chart, spark line reports in SSRS and also ad-hoc reports using Report Builder.
• Proficient in development methodologies like SDLC, AGILE and Waterfall
• Generated reports in various formats like Table format and Matrix format using Reporting services.
• Expertise in loading and extracting the data into data warehouse using SSIS (ETL).
• Experience in using the command line utilities like DTEXEC, BCP and SQLCMD.
• Hands on experience in High level languages C and Java.
• Having Good Knowledge in SQL Server Analysis Services (SSAS).
• Strong in Analytical, Technical Skills coupled with Good Communication and Interpersonal Skills and Ability to work in team environment and also individually.

PROFESSIONAL EXPERIENCE:

Confidential, Calabasas, CA

SQL Developer/BI Developer

Responsibilities:

• Written several stored procedures to use with SSIS and to use as Data sets in SSRS Reporting.
• Authored several SQL Server Reports using SSDT and Report Builder according to the Business requirements.
• Documented and updated the related documentation in the team collaboration software.
• Created a Column Chart report to display average hourly no of emails, calls and other inquiries using SQL Server Reporting Services 2012(SSRS).
• Developed several (SSRS) parameterized reports such as unique users Log-ins in a day which have several number of parameters and giving the user flexibility of selecting Multiple Values.
• Authored reports such as Sales by Country which in corporate cascading parameters, i.e populating filtering parameters depending on the value of another parameters value.
• Used Indexes to enhance the performance of individual queries and stored Procedures.
• Extensively made use of Expressions in SSRS for several tool box items such as Text box, Tables, Charts etc. and Parameters to in corporate conditional logic
• Developed and ReviewedSQLServerStored Procedures, TunedSQLQueries (using Indexes and Execution Plan)
• Extensively used and analyzed Execution Plans, profiler for performance reasons.
• UsedSSIS to create ETL packages to Validate, Extract, Transform and Load data into ODS.
• Extensively designed the packages and data mapping using Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS.
• Created packages with error handling and worked with different methods of logging in SSIS.
• Implemented Error Handling in Stored Procedures using @@error and THROW to raise andthrowerror within a TRY-CATCH block.
• Used various control flow tasks like FTP, File System, for each loop container and data flow tasks.
• Automated the report execution and delivery by using Subscriptions and Data-Driven Subscriptions in SSRS.
• Experience working with lookup, conditional split transformations.
• Worked with the Technical Architect in design sessions to develop Logical and Physical modeling of data base for SQL Server Reporting Services solution.

Confidential, Bentonville, AR

SQL Developer/BI Developer

Responsibilities:

• Developed physical data models and created Confidential scripts to create database schema and database objects like Tables, Views, Stored Procedures and various User defined Functions.
• Created linked Reports based on an existing sales country report for a different country in the Report Manger.
• Created Clustered and Non-clustered indexes on the table for improving query performance.
• Created stored procedures to use as the datasets for the Report Design.
• Implemented Error Handling in Stored Procedures using @@error and RAISERROR within a TRY-CATCH block.
• Used Analytical functions, Merge, OUTPUT, Temp Tables and Confidential 's in T-SQL.
• Created SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File, CVS files etc. and vice versa.
• Monitoring and Analyzing execution plans to enhance the performance of the various queries.
• Created temporary tables and table variables while writing complex queries in SQL Server
• Created multiple views and queries for complex SSRS reports using T-SQL.
• Extensively used and created variables and expressions in packages in order to make the SSIS package dynamic.
• Created Triggers to maintain the Business Integrity and written several table constraints like default, check etc. to implement the Business Integrity rules according to the BRD.
• Had professional interaction with the testing team regarding defect resolution and minimized the development cycles.
• Involved in Unit Testing and prepared test cases for Unit Testing.
• Extensively written stored procedures and used different types of Joins, CTEs.

Confidential, Harrisburg, PA

SQL Developer/BI Developer

Responsibilities:

• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity for the transactional databases.
• Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables and CTEs.
• Used Analytical functions like Row number, Rank and Dense rank functions for implementing patient De-duplication and lab provider identification.
• Used different transformations like Lookup, Conditional Split, Data Conversion etc., in SSIS for transforming lab test results from different laboratories.
• Created SSIS Packages to import and export data from Excel, text files and CSV files, Implemented Error Handling and Logging in SQL Server Integration Services (SSIS).
• Development of packages according to the ETL specifications for the staging area & Warehouse data loading using SQL Server Integration Services
• Created variables and expressions in packages in order to make the package dynamic like getting the file names at runtime for looping through.
• Designed disease surveillance reports like Child lead, TB Follow up using SSRS with Cascading and Multi-valued Parameters
• Designing and implementing a variety of SSRS reports such as Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder for disease outbreak surveillance.
• Prepared Technical specifications from the functional specification and maintained project related documentation.
• Proficient with SQL server agent and Scheduled Reports to run on daily and weekly basis in Report Manager and also emailing them in different formats.
• Responsible for deploying reports to Report Manager and Troubleshooting for any errors occurred during execution.
• Analyzed the existing application T-SQL programs and tuned SQL queries using Execution plans, SQL Profiler and database Engine tuning Advisor.
• Resolving the issues/defects in time and making development to the existing system or coding the new developments according to the client requirement by following coding standards.
• Analyzing and understanding the Functional specifications provided by the functional consultants/ interacting with onsite team members to get the exact requirement details.
• Coordinating with onsite for offshore development activities.
• Testing the application in quality and pre-production systems as well and ensuring the correctness of development.
• Preparing and maintaining application specific quality related documents for all technical/development work.
• Preparing the documents to migrate changes to preproduction system and drafting the production readiness documents after UAT sign off.
• Worked extensively on ABAP, Workflows, Enhancements, BADI's, BAPI's, Classes, Module pool programming, Reports, Smart Forms, Data Dictionary, Interfaces, workflows and Conversions.
• Experience in using IDOC Adapters to send and receive IDOCs from SAPECC system.
• Strong skills in usingSAPABAP/4 Development Workbench, Classical, Interactive Reports, Data Dictionary, Interfaces and RFCs.
• Experience in creating and maintaining Data dictionary objects, Classical and Interactive,ABAPList Viewer (ALV reports using classes and Function modules) editable ALV.
• Worked on customizing data dictionary objects like Table, Data Element, Domain, Search help, Structures.
• Experience with code checking options like Extended Program Check and Code Inspector tool.
• Written several BDCs for Auto clearing of profit Centre items, Automatic TC interface, GL line item display for TC creation and Clear GL account
• Written several interfaces like SAPADS interface, Auto clearing of profit Centre items, Local schemes Data movements, Client actuals from A&L self-fill ATM, Shopping basket interface, EDS Cheque Client Interface and Horizon interface.
• Created Reports like Local schemes client settlement Reporting, Clear Across GL accounts and

Confidential

Associate Consultant

Responsibilities:

• Fixing the issues and coding the new developments according to client requirement in the existing system.
• Understanding the Functional specifications provided by the functional consultants, interacting with client (core team members and users) to get to know the exact requirements.
• Preparing Technical Specification documents based on Functional Specifications and Preparing the Unit Test Plans and test them.
• Developed report for reimbursement of taxes paid to the Govt., a report to display TNGST 3J sales details.
• Created a report to Display all open sale Orders, Customer, Part number wise, and also displayed Stock available for each part number.
• Created Reports for B17 Bond Register, CT3 Register, Import Register and Recredit Register
• Developed a report to display service tax details and a report for Cenvat clearing A/C.
• Modified standard Script for Purchase order printing.
• Modified standard Script for Printing Scheduling agreement according to client’s requirement.
• Developed a Smart Form for printing taxes paid to the Govt. for Exports Oriented Division.