| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Phone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEPROFESSIONAL SUMMARY:7 years of experience in IT industry as a Report Writer and DBA level 1 with strong expertise in Transact-SQL (T-SQL) and designing stored procedures, designing Report using SSRS, Power BI.Expert in developing stored procedures, functions, triggers, views, optimizing queries, table normalization, Union, Union all, temporary table and cluster index and non-clustered index.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.Experience in creating report using Excel Macros.Expert to deploy report on production environment successfully.Expert to debug existing report.Expert to bulk insertion and bulk updating.Excellent analytical and problem-solving skills.Excellent knowledge about Excel, SharePoint.Experience in generating fetch xml query.Experience to create view for dynamic CRM.Experienced in Agile Methodologies to produce high quality results.Experience in SQL Server Integration Service (SSIS) create package, control flow operation, Data flow operation.Excellent knowledge of Excel.Knowledge about the .net programming.Knowledge about Python.Experienced working with client and ability to work independently and manage multiple tasks simultaneously.Provide production support to fix issue.Communicates with users/clients to understand and troubleshoot issues.TECHNICAL SKILLS:SQL Server Tools : SQL Server Enterprise Manager, SQL Server Management Studio (SSMS), SSIS, SSRS, SSDT, Report BuilderReporting Tool : SSRS 2005/2010/2012/2015, Power BI, TableauProgramming Languages : T-SQL, PL/SQL, SAS, Visual Basic, fetch xml, pythonDatabases : MS SQL Server 2005/2008/R2/2012/2014, MS Access 2000/2003Software : Microsoft Dynamics CRM, XRM Tools Box, SharePoint, Microsoft AccessTracking Tool : JiraPROFESSIONAL EXPERIENCE:Girls Guide of Canada, Toronto, ON (Jan 2021 July 2024)Title: Database Report WriterGirls Guide of Canada is the national guiding company. This is the place where girls build friendship, create relationship and learn real life experiences. They explore fun activities, camping and volunteering work and explore the world.As database report writer, I worked with DBA and Database Reporting Analyst to implement SSRS based reports and web- based dashboards to transition from legacy information system to a modern web based system with new data structure. I worked on complex T-SQL queries. Handle day to day tasks based on the end-user request. Build the new reports as per the client request.Roles and Responsibilities:Review the existing Microsoft Access reports with data specialists and team members and create document and set priority to support organizations strategic goals.Based on the priority, review the existing code and converted it into the T-SQL code like stored procedure, view with efficient queries to quickly retrieve data.Designing and creating relevant, table reports, chart reports, sub reports and dashboard based on analysis of business requirements and existing legacy solutions.Analyze the user needs and system requirements to improve the report performance.Participate in User Acceptance Testing (UAT), data analysis and troubleshooting for existing reportParticipate in meetings with executives and business sponsors to discuss project status and activities.Wrote stored procedure to automate the some of the manual queries.Creates data dictionary and training staff on data system reports.Providing training and technical support of staff for developed reports, queries and dashboards.Provide documentation on how to utilize and interpret the report.Provide full support to launch IMIS 20 project.Quickly fixed the report bug and enhancement work based on the end user tickets.Exported and imported data from text files and excel to SQL server database using the Bulk insertion and bulk updating.Maintain report server.With Strong analytical skills, attention to detail, be highly organized, ability to set priorities and motivated and remain flexible under pressure.Create Data dictionary and technical documents for future reference.Optimize T-SQL queries for efficiency and performance and Ensure data accuracy and integrity in all reports.Mentor and support junior BI developers, conducting code reviews and sharing best practices to improve overall team performance.Troubleshoot and resolve reports bug very efficiently and quickly. Provide immediate solution.Environment: Windows 10, SSRS 2019, Visual studio 2015, SSMS, Zoho Ticket, Microsoft Power BI, Microsoft Access, SQL Server Data ToolCompTrak, Toronto, ON (July 2019 March 2020)Title: SSRS Report DeveloperCompTrak's single platform brings simplicity, visibility and security to all aspects of your compensation program. As a comprehensive compensation management solution, CompTrak is transforming the way variable incentive, merit review and equity plans are managed.As SSRS Report Developer, I am working with CompTrak teams to develop complex reports for their end client, which is RBC banks, Nutrient, OMERS etc.Roles and Responsibilities:Analyzing project requirements with CompTrak team member and create the Spec documents based on the requirement.Review the compensation plan and Calculate the complex logic.Created the SSRS reports like (Extract report, Dynamic columns changes reports, parameterized reports)Created Excel Macros to store complex compensation calculation using Developer tab.Created Excel summary report.Follows programming logic, testing, and report development process standards and report development life cycle to create new report.Configure the data source and data set with different environments.Upload the reports on server.Working with production issued and resolved quickly.Created Data Dictionary for database.Working with Advanced T-SQL commands to write the stored procedure.Import the data into database table from the excel sheets.Working with T-SQL function, common Table expression, Temp table etc.Used SQL profiler for performance tuning the SQL commands.Environment: Windows 10, SSRS 2012/2015/2017/2019, Visual studio 2012/2015, SSMS, SQL Profiler, TFS, JiraYMCA of Greater Toronto. Toronto, ON (Mar 2019-June 2019)Title: SSRS Report DeveloperThe YMCA of Greater Toronto is a charity tackling the most critical social issues in the GTA. For more than 160 years, we have offered children, teens, young adults and families the opportunity for personal growth, community involvement and leadership. Through childcare services, education and training programs, employment and immigrant services, family and youth services and health and fitness programs, the YMCA is building healthy communities across the GTA.As SSRS Report Developer, I am working with YMCA teams to gather information and identify immediate and long-term data & reporting requirements in order to design, develop, test, and deploy reports.I create the many report ex. Childcare tax report, Attendance sheet report for child and staff, GL report, membership audit report, membership discount report, EFT report for TD bank transaction, Day camp report etc.Roles and Responsibilities:Provides reporting support to end-users including report design, report debugging, optimizes fetchxml query and views to drive front-end reporting.Analyzing project requirements with business analysts and team memberFollows programming logic, testing, and report development process standards and report development life cycle to create new report.Using SSRS tools: Create project and configure the data source and data set.Create the data set using fetchxml query.Generating query based on using dynamic CRM 1) Advanced find 2) SSRS query builder 3) XRM ToolboxApply row and column level grouping, used the static parameter, dynamic dependent parameters, expression to generate the text box hidden visibility based on condition.Adjust the page layout for printing purpose.Unit testing on report by myself and send it to QA to verify the data and calculation.Rendering the reports to different formats and Cleansing the Data for CSV and Excel.Engages with stakeholders and management team to identify reporting needs and to determine and document requirementsCreates technical documentation.Upload new report on Dynamic CRMs test and production server.Environment: Windows 10, SSRS 2012/2015, Visual studio 2012/2015, Microsoft Dynamic CRM, Fetchxml, XrmToolBox configuration, JiraSystem Soft Technologies Inc. Toronto, ON (Aug 2018 Feb-2019)Title: SQL DeveloperNBS: NBS provides a tool to support the public health investigation workflow and to process, analyze, and share disease-related health information. NBS also provides reporting jurisdictions with a NEDSS-compatible information system to transfer epidemiologic, laboratory, and clinical data efficiently and securely over the Internet. NBS integrates data from many sources on multiple public health conditions to help local, state, and territorial public health officials identify and track cases of disease over time. This capability allows public health to provide appropriate interventions to help limit the severity and spread of disease.Roles and Responsibilities:Analyzing user requirements and coming up with specifications for the various database applicationsDeveloping Database application.Monitored the performance of the database and checked on the execution timeCreated 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/10TransCard, Chattanooga, TN (Aug 2014 Jun 2017)Title: Report Writer / SQL DBA level 1 (SSRS)Description: TransCard provides prepaid debit cards through banks, variety of prepaid card products can be made available to partners that include: fleet cards, payroll cards, gift cards, spiff cards, HSA cards, FSA cards, purchasing cards, government disbursement cards, insurance cards, promotion or rebate cards, disaster payment cards and even private label cards.1)CBKC (Central Bank of Kansas City) ACH Project:CBKC bank deposit money via ACH method into the funding account of TransCard. In this project, CBKC wants the credit and debit financial details per month. I have created multiple reports for CBKC bank to obtain various types of financial data per month (i.e. Monthly ACH Report, Transaction History Report, Rejection Report, etc.)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 supportCommunicates with users to understand and fix issues.2)US Bank Reports:U.S. Bank bought TransCard's fuel card division, which uses technology designed to help truck drivers pay negotiated prices at fuel stops. U.S. Bank will provide an unparalleled solution for U.S. Xpress. I have created multiple reports for US Bank.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 reports 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 analysisDeployed 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.3)Cardholder Statement reports:TransCard provide financial statements to their clients as per their requirement.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, TransCard Test and production Report server, Excel 2014, Windows7EDUCATION:Information Systems - Database Management ConcentrationChattanooga State Community College, Chattanooga, TNMaster of Business EconomicsVeer Narmad South Gujarat University, Surat, Gujarat, IndiaBachelor of CommerceVeer Narmad South Gujarat University, Surat, Gujarat, India* References available upon a request * |
