SUMMARY

• Over 10 years of extensive work experience as a skilled report developer
• Experience in using various reporting tools, such as SSRS, Tableau, Power BI Crystal Reports, MS Access, and QlikView.
• Working closely with management teams, business analysts, sales teams, and end users, gather report requirements TEMPeffectively and delivering teh reports accordingly.
• Create and maintain business reports for internal users and for compliances, and published as PDF, Tableau (worksheets, dashboards or stories), Excel, and CSV formats.
• Knowledge of data modeling/Star Schema and in - depth experience in OLTP. Experience with corporate databases in DB2, Oracle, SQL Server, and Excel or flat files. Extensive noledge of relational database design and development. Deep noledge of SQL commands, indexing, and functions.
• Using SSIS and SQL to transform data from a variety of data sources. Experience in ETL, data cleaning, data conversion, and data consolidation.
• Ability to work both independently and collaboratively with others in team environment.
• Ability to develop and organize high-quality documentation.

TECHNICAL SKILLS

• SSRS
• Tableau
• Crystal Reports
• QlikView
• MS Excel
• SSIS
• ETL
• SQL Server
• MS Access

PROFESSIONAL EXPERIENCE

Confidential

Report Analyst

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle and MS SQL Server by using SSIS services.
• Creating dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connecting Tableau server with share-point portal and setup auto refresh feature.
• Generated various Daily, Weekly and Monthly reports by different type of reports using SSRS.
• Extensively worked on SSRS and delivered complex reports from different data sources such as MS SQL Database and Oracle Database.
• Using Crystal Reports to Design, develop, integrate, support and maintain daily, weekly, monthly and adhoc reports for teh internal management team and State Government Office.
• Scheduling teh reports on teh Crystal Server and/or uploading teh reports on web site via SFTP.
• Using MS Access to generate call volume reports. Link teh tables to teh Oracle and MS SQL server. Using complicated queries and macros to generate reports.
• Using SQL, subqueries to create complicated reports

Confidential, Vauxhall, NJ

Report Developer

Responsibilities:

• Designed a database architecture, maintaining its reliability, and ensuring a stable and secure database environment
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS according to task
• Desinged teh reporting system and generated daily, weekly, monthly and adhoc reports for marketing and senior management team.
• Used SQL Server Reporting Services (SSRS) for creating matrix and tabular, drill down, drill through, and parameterized reports for marketing team and senior management team based on teh requirements.
• Using advanced SQL, developed views, sub-queries, and joins for complex queries involving multiple tables. Using various functions and formats in SQL to calculate business data.
• Used pivot and other functionalities to create summary reports such as area vs. month sales reports.
• Worked on formatting SSRS reports using teh global variables and expressions .
• Created parameterized reports, drill down and drill through reports using SSRS.
• Used Report Builder to do ad-hoc reports.
• Developed and rendered monthly, weekly, and daily reports as per teh requirement.
• Loaded data from flat text files and MS Excel files using SSIS.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Confidential, NYC, NY

Report Developer / Data Analyst

Responsibilities:

• Using SQL Server, MS Access, Visual Basic, Oracle, Crystal Reports, ODBC, designed and implemented five business management systems: Management Report System, Performance Report System, Labeling System, International Agent System, and Transmission System.
• All teh systems have a user-friendly front-end that allows users to enter data and choices to search information and to generate standard and/or ad hoc reports.
• Users utilize teh systems to conduct their business on a daily basis.
• Generating teh reports for teh department managers and scheduling and refreshing teh attachment reports on Monday mornings and sending reminding emails for teh users.
• Working close with business analysts, programming consultants and end users to get business and technical specification to implement teh application and reports.

Confidential

Report Developer / Data Analyst

Responsibilities:

• Involved designing reporting system with Sr. techical leader.
• Getting specification from BA and end users to design, generate and implement business application and reports with Ms Access and Crystal Reports.
• Downloading teh data from EDI system, Mainframe, MS Excel and text files. Cleaning and analyzing data for teh application and reports me designed and implemented.
• In charge of distributing teh application to teh overseas branch and monitoring teh performance of, maintaining, and, adding new features to said branch.
• Developing and delivering teh executive reports for teh management team.
• Making sure teh reports were delivered by teh deadline and were accurate.