SUMMARY:

• 12+ years of IT industries experience that includes extensive hands on experience in SQL Reporting Services, Database Programming, and Web Application Development.
• 3.5+ years Oracle SQL, PL/SQL including the use of statistical functions, stored procedures, and views.
• 9.5+ years developing MS SQL Reporting Services, MS SQL Server 2005/2008/2012 that includes developing Stored Procedures to create datasets for reports.
• Developed, updated, and maintained MS SQL Server Databases that contain complex queries.
• Experienced working with the SQL Server Integration Services (SSIS) for ETL processes.
• Creating database, functions, triggers, stored procedures, views, tables and T - SQL script for application and to meet the requirements of the business users.

TECHNICAL SKILLS:

Programming Languages: Transact-SQL, Oracle SQL, VBScripts, Visual Basic .Net, C#, ASP.NET, C, C++, Perl, Java, JavaScript, MFC, XML, UML, and HTML.

Tools: Microsoft SQL Reporting Services (SSRS), Microsoft SQL Integration Services (SSIS), Crystal Reports, TOAD, Oracle 9i, Rational Rose, Cognos, Business Intelligence Development Studio, MS Excel.Databases MS SQL Server 2005/2008/2012, Oracle, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

• Developed and support reports built with Microsoft SQL Reporting Services on SQL 2005/2008/2012 .
• Write complex SQL queries for validating the data against different of reports.
• Design, deploy, and maintain various SSRS Reports in SQL Report Server.
• Scheduled reports for daily, weekly, monthly reports to run automatically using SQL Sever Reporting Services.
• Developed complex reports in SSRS that including tabular, drill down, matrix and sub reports.

Mobile Phone Developer

Responsibilities:

• Designed and developed applications for mobile phone.
• A BoyRun game has been created and available for kids to download from Google Play.
• Completed Home Security project. Used Java language to develop the project.

Information Analyst

Responsibilities:

• Designed, developed and maintained reports to support Home Retention Process Control and Customer Assistance Operations by using Excel report and Oracle backend.
• Developed ad-hoc queries pulling data for internal customers.
• Developed, test and implement daily, weekly, monthly, and ad hoc reports that enable data driven business decisions.
• Developed, updated stored procedures, queries for Short Sell, Foreclosure, Bankruptcy and Collection reports.
• Query performance tuning by modifying SQL queries, eliminating redundant inconsistent data, established joins and created indexes wherever necessary.
• Developed and supported reports built with Microsoft Reporting Services on SQL 2005/2008/2012 .
• Developed stored procedures and called them in the SSIS packages.
• Write complex SQL queries for validating the data against different of reports.
• Worked comprehensively on complex dynamic SSRS 2008/2012 reports (Drill down, Drill through, Drop down, Multi-parameterized, ad-hoc, and linked reports).

Report Developer/Report Administrator

Responsibilities:

• Developed and support reports built with Microsoft SQL Reporting Services on SQL 2005/2008/2012 .
• Managing various processes across different reports and provided primary Admin and production support for these reports.
• Developed Query for generating drill down and drill through reports in SSRS 05/08/12.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Report Developer/SQL Developer Property Management

Responsibilities:

• Designing, developing and management internal reports.
• Created, modified existing SQL Reporting Services 2005/2008/2012 reports base on business requirements.
• Created dimensional models to support accepted Data Warehouse architecture.
• Used Dundas Chart to display reports in a graphical.
• Assisted Lead in the data gathering and SQL database management for the data needed by the reports and responsibility for Screening History data pull and maintenance.
• Designed, developed and supported reports built with Cognos 8 and 10.
• Expertise in Report building using Cognos Report Studio and Analysis Studio.
• Modifies and support existing reports related to Crystal Reports and SSRS.
• Converted Crystal Reports to SQL Server Reporting Services.
• Involved in extracting the data from different sources (SQL, Oracle, Excel, CSV, text files) and applying transformation rules using SSIS and finally loading the data into data warehouse tables.

Report Developer/SQL Developer

Responsibilities:

• Designed and developed SQL 2005 Reporting Services reports for Capacity Utilization Tracking project and Global Metrics Excellence project.
• Creating stored procedures to retrieve data by monthly and year for all the location groups set up for the report. The colors specified by the user.
• The report runs for all locations and display result on column chart.
• Used an inverted bar chart, which displays the KPI’s, targets and Solomon quartile data.
• These reports will be displayed in either a graphical or tubular view.
• The graphs will display a link to tabular report.

Report Developer/SQL Developer

Responsibilities:

• Developed SQL Reporting Services reports for Sale, Production, Financial, and Marketing departments.
• Creating stored procedures to retrieve data.
• Designing, developing SQL Reporting Services reports.
• Creating report subscriptions to send email to users.
• Applying report security and user roles to manage report accessing.

Programmer

Responsibilities:

• Developed Stored Procedures to retrieve and save data for Manual Mapping Utility.
• Designed Stored Procedures and Tables to support new enhancements in the Global Reports.
• Developed functionality within database that allowed administrative users to update certain list boxes and data input screens contained within the application.

Developer/Testing/Network Support

Responsibilities:

• Maintain enterprise web applications using .Net technologies for company.
• Repair, testing or exchange - PC parts, systems, mother board, CPU and processors.
• Duties include workstation support and configuration, computer upgrades and remote office technical support with networking