SUMMARY:

• Senior ETL Developer with knowledge of SSRS, SSIS, SSAS, OLAP data structure, Dashboard, Power BI, Power Query, Power Pivot, and QlikView. Able to perform any related tasks.
• Has extensive experience in the conversion/migration of existing reports to new systems and a background in developing windows and web application using multiple languages (C#, VB6 and Javascript)
• Over 5 years of experience in designing and implementing complex SSRS reports (such as Pivot tables, Drill - down/Drill-through report, Charts, Parameterized report, Linked/Sub report and Label/Form report)
• Over 10 years of experience in writing complex SQL (T-SQL and PL/SQL) for large data retrieval/manipulation/ETL for various data sources and creating VBA functions in SSRS, Excel and MS Access for implementing data ETL and automation

TECHNICAL SKILLS:

Languages/Tools: SSRS, SSIS, SSAS, SSMS, SharePoint 2008/2013, QlikView, VB 6.0, VB.NET, ASP.NET, C#.NET, CVS, GIT, Dimensions, Quality Center, XML, HTML, ADO, RDO, JavaScript, VBScript, VBA with MS Office, Dexterity 4.0/5.0, Toad for Oracle 12

Databases: SQL Server 6.5/7.0/2000/2005/2008 R2/2014, Oracle, UDB/DB2, Sybase, Access

Report Tools: SSRS 2000/2005/2008/2013, Actuate 8/9/10, Crystal 6.0/7.0/8.0/8.5/9.0, ActiveReports, Access Report, Dexterity Report

Operating Systems: Windows 10, Windows 7, Windows Vista, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. SSRS Reporting Developer

Responsibilities:

• Reinforced strong understanding of SSRS reporting concepts and features such as Pivot tables, Drill-down Reports, Drill-through Reports, Data Matrices, Linked Reports, Sub-reports, Cascaded Parameterized Reports and Charts.
• Became more proficient in designing and implementing complex SSRS reports utilizing multiple reporting concepts and multiple data sources.
• Demonstrated strong ability to deliver innovative solutions, such as
• A SSRS report with the ability of maintaining data in the database
• SSRS reports using URL linked to a custom web interface created with C# for passing up to 30 parameters
• A SSRS report has 53 matrix tables/tabs and custom data filters to be exported in Excel format
• SSRS reports with multiple levels of drilldown in data matrix and can be dynamically shown/hidden
• A SSRS report has a function with VBA to pass parameter values into Web service in run time.
• SSRS reports using table function + stored procedure for the dataset
• SSRS reports using shared XML datasets and being managed on SSRS server
• Reinforced extensive experience in converting reports
• 63 reports with complex SQL, deploying scripts and template settings converted from a legacy Access application to SSRS with Oracle database.
• Data mapping for 26 reports for data source conversion from Oracle to SQL Server
• 6 reports converted for Oracle new data system.
• Gained experience in integrating SSRS with a database in the Cloud using XML data sources through web services.
• Gained experience in designing stored procedures and report datasets to optimize performance in SQL Server.
• Became more proficient in creating custom reports with pivot tables in Excel
• Became more proficient in using VBA to make additions and modifications to Excel reconnect a new data source (Oracle) make new data queries fill the data by VBA coding into multiple tabs
• Implement data process automation in Excel inputting data from other source doing data mapping and formatting filling data into the specified section on tab deploying report to SharePoint and network folder
• Gained experience of using Toad for managing tables/views/packages/synonym/deployment scripts
• Gained experience in working on team projects using GIT/Dimensions as the central code repository and Quality Center as the UAT test management tool.

Sr. SSRS Reporting Developer

Responsibilities:

• Gained experience working in a fast pace environment with a professional team (6 Sr. developers, 3 managers and 2 QAs) using TFS and SCRUM meeting managing our daily work
• Reinforced extensive experience in converting reports
• 95 reports with complex format from Crystal to SSRS
• Gained and reinforced experience working with SSRS, SSMS, Crystal, Complex T-SQL, VBA, VS2010, SQL Server 2008, and PowerBuilder
• Gained experience incorporating VB code into SSRS reports
• Demonstrated strong ability to deliver innovative solutions, such as
• A form type report that utilized multiple sub-reports to synchronize and map data
• A custom report with a complicated SQL query to dynamically generate 7 fixed columns in final dataset
• Label format reports with complex design

Sr. Web Reporting Developer and System Support

Responsibilities:

• Provided life-cycle support for multiple reporting applications
• Demonstrated strong ability to deliver innovative solutions, such as
• A component for Actuate e.RDPro that allows users to select the connecting data source on the reporting server dynamically, which results in large time savings when the data source changes for a large number of reports
• Converted BR (a Java application) to web enabling using SSRS. Replaced the original data ETL process implemented using Stored Procedures with an implementation using complex SQL text queries, resulting in big money saving in the bank
• Reinforced extensive experience in converting reports
• Converted the DBR reporting application which includes 12 reports from Access to SSRS2005 with multiple data source (Oracle and XML by creating a Web service)
• Converted WMRS (an Access windows application) to Web enabling app using C# and SSRS with SQL server database
• Upgraded 14 SWIFT reports from SSRS2000 to SSRS2005
• Migrated Intellimatch reports (total of 45) from Crystal 9 to SSRS2005
• Developed and maintained reports using SSRS2000 and SSRS2005
• Gained experience with the following tools: VS 2005, C#, JavaScript, CSS, SQL Server 2005, SSRS2000/2005 and SSRS server administration

Management Reporting Consultant

Responsibilities:

• Demonstrated strong ability to deliver innovative solutions, such as
• Made reporting and data retrieving automation for the group using Excel, Access, VBA, Micro and Pivot Table with SQL Server and Access databases, which results in large time saving in monthly report generation (two hours of working in automation process instead of one weeks of manually working in original)
• Coordinated meetings with LOB and IT groups
• Wrote business and technical specs
• Cooperated with other departments to accurately assess project requirements
• Wrote SQLs (complex queries/Stored procedures) to get reports’ datasets for customer requirements
• Designed new reports and modified existing reports using Actuate 8

Sr. Visual Basic Developer

Responsibilities:

• Created, developed and primarily supported ASPIRE (Agency Services Public Information Reporting), which is a stand-alone, front-end reporting tool for the Loan IQ and SAS (Syndicate Access System) applications
• Seamlessly converted 60 ASPIRE reports to new systems in company merger and system migration.
• Primarily gained experience in VB6, ActiveReports, Actuate8, Complex SQL with SQL Server 7.0/ 2000, Sybase, DB2 and UDB
• Tested and compared many reporting tools including Actuate, Crystal and SQL Server Reporting Services