SUMMARY

• 3+ years of experience in IT industry as a Report Writer and DBA level 1 with strong expertise in Transact - SQL and designing stored procedures, designing Report using SSRS.
• Expert in developing stored procedures, functions, triggers, views, optimizing queries, table normalization, Union, Union all, temporary table and cluster index and non-clustered index.
• Expert in sorting and grouping the data on query.
• Strong working experience to apply join on database table to obtain result.
• Strong working experience on debugging the stored procedure using SSMS Tools.
• Experience in taking Backups and restoration of Development databases.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals and parameterized reports in SSRS 2005, SQL server Data Tools(SSDT), Report builder.
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Expert to deploy report on production environment successfully.
• Expert to debug existing report.
• Experienced in Agile Methodologies to produce high quality results.
• Experience in SQL Server Integration Service (SSIS) create package, control flow operation, Data flow operation.
• Experience in control flow and data flow transformation.
• Provide production support to fix issue.
• Communicates with users to understand and troubleshoot issues.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Enterprise Manager, SQL Server Management Studio (SSMS), SSIS, SSRS, SSDT, Report Builder

Reporting Tool: SSRS 2010/2012/2005

Programming Languages: T-SQL, PL/SQL, SAS, Visual Basic

Databases: MS SQL Server 2005/2008/R2/2012/2014, MS Access 2000/2003

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• Analyzing user requirements and coming up with specifications for the various database applications
• Developing Database application.
• Monitored the performance of the database and checked on the execution time
• Created stored procedure, Views, Cursors and functions to support application.
• Designed, developed and maintained relational databases.
• Designed and implemented complex SSIS package to migrate data from multiple data sources.
• Extensively worked on creating SSIS packages and have used For each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Maintain existing Crystal Reports and rewrite these reports in SSRS.
• Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator.
• Researched and resolved data issues related to existing data and processes in place.

Environment: MS SQL Server 2014/2012, SSRS 2005/2008, SSMS, SQL Data tools 2012, Windows7/10

Confidential, Chattanooga, TN

Report Writer / SQL DBA

Responsibilities:

• Evaluates moderately complex requirements and creates detailed business requirements and technical specifications. Analyzes impact to other reports and processes.
• Involved in full Systems Development Life-Cycle (SDLC) to produce high quality applications.
• Create table for CBKC Project, apply the index on table, and add relationship with existing table in database.
• Create data dictionary for database table with detail table description.
• Design and develop the SSIS packages to insert the data into OLTP database from the flat file source.
• Configured the flat file as data source then convert the data type using the Data conversation transformation, apply conditional split transformation to split the data into two destination table.
• Create the Stored Procedure based on user requirement and obtain the data.
• Using the Stored Procedure, create the report in SSRS 2005. We created the Dataset for each report, sub group report, implement drilldown option, and apply header and footer.
• Apply the static parameter and also add null option in parameter.
• Create the chart report.
• Rendering the reports to different formats and Cleansing the Data for CSV and Excel.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.
• Deployed the reports on production environment for user.
• Provide production support
• Communicates with users to understand and fix issues.

Confidential

Responsibilities:

• Gathering the requirement from client and create the detail design.
• Designed and implemented new tables needed in the implementation.
• Developed new Sub Reports, Matrix Reports, Charts, Drilldown reports, using SQL Server Reporting Services (SSRS).
• Responsible for creating parameterized reports in SSRS.
• Export report’s result in Excel file.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS).
• Scheduled SSRS reports and set up subscriptions to run the reports Hourly, Daily, Monthly according to client requirements for the periodic analysis
• Deployed the generated SSRS reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Participated in day to day build activities of report server.
• Updated and Modified report with new business logic.
• Debugged stored procedures using SQL profiler for fixing Production issues.
• Updated and Modified Stored Procedures with new business logic.
• Participated in discussions and created the documents for source target table mappings for future use.

Confidential

Report Writer / SQL DBA

Responsibilities:

• Designed reports which include charts using SQL Server Reporting Services (SSRS).
• Apply parameters, static parameters, dynamic parameters, dependent parameters and dynamic dependent parameters on report.
• Experience to hard code the report as per client requirement.
• Set up subscriptions to run the reports Hourly, Daily, Monthly according to client requirements for the periodic analysis.
• Experience to add detail description about the report on report server.
• Experience to edit, modify, delete the existing report which is added on report server.
• Tested existing SSRS reports, troubleshoot issues and fixed them.

Environment: MS SQL Server 2014/2012, SSRS 2005/2008, SSMS, SQL Data tools 2012, Confidential Test and production Report server, Excel 2014, Windows7