TECHNICAL SKILLS:

Programming: (C#,VB.Net,ASP.Net) .Net 2010, SQL Server, SSIS,SSRS,SSAS, Java 6, JavaScript 1.8, Ajax, CSS, ActiveX, VBA (Excel, Word, Access), COM/DCOM, C/C++, SQL, JavaScript, HTML, XML, Visual C++, PL/SQL, R,SAS

Operating Systems: Win 8

Software: MS Office XP (Access, Excel, Word, Power Point, and Outlook), SQL Server 2010, MTS, SharePoint, Crystal Report 8, Oracle8i, Outlook 2010, Oracle, Sybase, Python 3.4.Micro Strategy, Tableau, R, SPSS, SASWeb (JavaScript, jQuery, HTML, CSS3, Node.JS, AngularJS, ASP.Net, PHP)

Others Languages: Java, C#, Python

PROFESSIONAL EXPERIENCE:

Confidential, CA

VBA/Access/SQL Lead/Power BI/ SAP(BUSINESS OBJECT)/ Python/SSIS ETL/SSRS

Responsibilities:

• Create Merchant Finance Planning Dbase for planner to allocate their categories using MS Access for all regions. Excel Template using VBA AND PYTHON. Source coming from SQL Server, SAP Business Object.
• Create reports and Analyst the data using power BI.
• Create, modify and maintain the database architecture as per the given instructions to accommodate the system requirements.
• Design and develop forms to enable users to maintain, process and view data & transactions.
• Design and develop queries for producing canned and ad hoc reports
• Design and develop macros and VBA scripts to improve functionality and performance
• Create, modify and maintain various data exports and imports including excel, csv, etc.
• Test the system at each stage of the development phase and identifying bugs in the system and fixing them.
• Create Matrix Reports, Excel Reports, and MS Access reports using VBA.
• Create Charts in MS ACCESS.
• Troubleshoot and resolve database performance issues.
• Act as liaison between information technology and business units. Interpret business requirements and, with developers’ input, design new database functionality.
• Develop strategies for data acquisitions, archive recovery, and implementation of a database.
• Design and manage the enterprise data warehouse - data marts, facts and dimensions
• Design, develop and unit test new database code to support requirements, using database triggers, stored procedure, and views.
• Migrate data by writing data extract, transforming, and loading routines for both loading new data as well as performing the migration.
• Troubleshoot and resolve database performance issues.
• Monitor production sizing information in order to possibly prevent future performance issues.
• Write complex queries to optimize performance.
• Job Complexity:
• Working with operational support to understand data requirements surrounding the exchange and reporting of data as well as with engineering for necessary table structure or other code needed to support those data requirements yet ensure optimal performance and scalability. Also need to execute against projected plans while meeting changing production needs and requirements.
• Help other people who run into Excel problems identify what is wrong and correct it
• Create SSIS Package to auto import different source data.
• Create SSRS report to analyst the report.

Confidential, Redwood, CA

Access/SQL Developer/ Test data/Tableau

Responsibilities:

• Create, modify and maintain the database architecture as per the given instructions to accommodate the system requirements.
• Design and develop forms to enable users to maintain, process and view data & transactions.
• Design and develop queries for producing canned and ad hoc reports
• Design and develop macros and VBA scripts to improve functionality and performance
• Create, modify and maintain various data exports and imports including excel, csv, etc.
• Test the system at each stage of the development phase and identifying bugs in the system and fixing them.
• Building welfare Database in MS Access to tracking member’s data. Ensure all the integrity Data.
• Troubleshoot and resolve database performance issues.
• Monitor production sizing information in order to possibly prevent future performance issues.
• Write complex queries to optimize performance.
• Develop strategies for data acquisitions, archive recovery, and implementation of a database.
• Design and manage the enterprise data warehouse - data marts, facts and dimensions
• Design, develop and unit test new database code to support requirements, using database triggers, stored procedures, and views.
• Migrate data by writing data extract, transforming, and loading routines for both loading new data as well as performing the migration.
• Troubleshoot and resolve database performance issues.
• Monitor production sizing information in order to possibly prevent future performance issues.
• Write complex queries to optimize performance.
• Create visualization reports using Tableau for others depts.

Confidential, Irvine, CA

Database Analytic Consultant

Responsibilities:

• Build SCRA Database vehicle loan remediation for Operation Risk Dept. It tracks all the repossession loan.
• Build REPO Database vehicle loan remediation Operation Risk Dept. It has quality checking feature, Errors reports, progress report. It has 3 stages. First stage is for a user process the case, second stage is for reviewer review the case. The final stage is for the manager to deal with the dispute case when neither user nor reviewer agree the answer.
• Build Matrix Reports and dashboard reports for the manager base on the errors and etc.
• Create queries reports to find out the status of the case.
• Build Checklist Tracking Database. This database mainly for tracking issuing the checks to the customer. This is done by using MS Access. Then creating statistic report to analytics the trend of customer respond the letter sent out and the number of reissued checks. The percentage of success completed the case. The outstanding checks.
• Create loading csv, text, Excel file feature in each database.
• Building ad-hock report in Excel and MS Access
• Helping user manipulate their excel Report data using v-Lookups, H-Lookups, Name Range, etc. and modify the macros code if it needed.
• Imported existing data from excel sheets, csv, text into Access Databases.
• Automated several manual data processes of collection of data to several MS
• Access databases by the use of VBA MS Access forms and SQL inserts, updates and queries to make the databases more efficient and protected by data integrity.
• This process required careful analysis of the data to identify duplicates, data errors and other changes that needed to be addressed in order to successfully import the data into Access.
• Migrate all MS Access DB to SQL server DB using ETL SSIS and convert VBA codes into stored procedure.
• Convert MS Access Reports to SSRS.
• Building the cube using SSAS for easily to analyze
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Developed stored procedures, functions, views and triggers.
• Created DTS package to schedule the jobs for batch processing.
• Scheduled the DTS packages using the Data transformation services SQL2000.
• Performance tuning to optimize SQL queries using query analyzer.
• Moving the database from MS ACCESS to SQL Server using SSIS (ETL).
• Interacting extensively with end users on requirement gathering, analysis and documentation
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model
• Involved in credit risk assessment model to calculate risk factor for individual clients based on hierarchy
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time
• Imported Data from relational database into SAS files per detailed specifications
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide

Confidential, New York, NY

Developer/Data Analyst

Responsibilities:

• Developed a business model to analyze the data for GAAP and STAT and Attribution report using VBA (MS ACCESS, EXCEL)
• Create a Tool for Testing the Template data using Excel Functions and VBA tools.
• Migrated the Excel VBA model code into SQL Server (Converted all the VBA code into stored procedure code and view). Excel model using Add-Ins and COM Objects. Data Sources from Excel, text, Oracle, XML
• Create SQL function such as (scalar, line-in or Multi) and stored procedure, triggers, and View.
• Define table relationship (Data Modeling) -200 tables and 10 Million records.
• Create Multi- dimensional, Fact table, set up schema using SSAS
• Created Cube using SSAS, create calculation, create KPI, Create Perspective, and using MDX to query data in Analyst Services Data Base,
• Create reports using SSRS for analyst
• Analyzed Oracle Data using PL/SQL. Used SQL server BI (SSIS, SSAS, and SSRS) for analyzing report data
• Built billing program using C#/WPF to process the order of material. Tested all the formulas given by the team. Now planning using IGLOO model to testing the all stress combining AIG model
• Analyzed business requirements and wrote business requirement documents
• Create functional requirements and specification documentations, construct flow charts of the processes, and produce the other documents as directed by the client project manager
• Testing and UAT. Assist with the QA and production turnover of the applications
• Perform daily business and application support. Provide timely updates to management members of the project team. Extracting Oracle Data to Excel and load it to Access Database using Power Pivot
• Creating Excel program for loading and generated the report for analyst using VBA
• Supporting production application when it needs such as constant coordinate with other groups when formulas have to be adjusted
• Lead in testing of new or modified systems. Work with the QA team in conducting multiple levels of testing from stress, performance and standard application testing
• Designed, created and maintained OLAP Cubes used for reporting by multi dimensions and measures as needed
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary. Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or Confidential s Development Life Cycle (SDLC) methodology
• Designed and delivered end-user and materials; provide technical support as necessary
• Led the integration efforts for merging BI platforms with enterprise systems and applications
• Designed, code, test, and documented all new or modified BI systems, applications, and programs
• Developed the semantic layer, metadata, reports, and report definitions
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications
• Created and maintained complex reports in MS SQL data sources using Reporting Services, MS Excel and other virtualization tools
• Developed complex SQL queries to support reporting requirements and SQL Server s stored procedures/functions and verified data accuracy
• Presented data in multiple formats including reports, charts, graphs, aggregates and statistical computations
• Reconciled discrepancies in reports by validating data and support information technology applications including database application while utilizing analytical and programming skills
• Created automated scripting procedures to speed up the processing of information
• Using Visio to Map out the work flow database design and the program design

Confidential, Chatham, NJ

Computer Programmer-Data Analyst

Responsibilities:

• Analyzed VB6 Customer service, Billing, Payment, New Graduates application codes
• Migrated customer service, Billing, Payment application written in VB6 to C# using Entity Framework
• Payment application: feature such as create a batch for post.
• Worked with Access and SQL Server Database, Access Reports and analysis tool
• Renamed fields name and redefined the type of the fields and redefined the new relationship (scheme)
• Built SSIS package for migration data from MS Access to SQL Server. Consolidate Excel Data using Excel VBA
• Built reports using SSRS with SharePoint for marketing department/analysts
• Maintained and extending several C# Applications. Supporting MS Access Reports, Queries, Scheme, VBA
• Designed and maintained Access Reports, Crystal Reports and the overall reporting function at the firm
• Rebuilt, expanded and improved all legacy reports on new reporting platform using SSRS 2008 R2
• Built out novel reports and migrated rebuilt legacy reports into new centralized reporting portal to meet reporting needs company-wide

Confidential, Long Island City, NY

Programmer/Data Analyst

Responsibilities:

• Configuration in FileNet CE, Coding Custom Components.
• Requirement gathering and Requirement analysis.
• Design development of solution for document migration.
• Writing test cases for different scenarios.
• Implementation execution of the solution in Production environment
• Support Securities Trader and responsible for programming and analysis of Liquidity and Operations for Derivatives applications in Citi Treasury Department
• Analyze business requirements and write business requirement documents
• Create functional requirements and specification documentations, construct flow charts of the processes, and produce the other documents as directed by the client project manager.
• Create project plans, and automate the processes to manage project plans and project activities
• Analyze financial data, and create financial models
• Identify opportunities to optimize business processes, and automate the processes
• Testing and UAT
• Assist with the QA and production turnover of the applications.
• Perform daily business and application support
• Provide timely updates to management members of the project team.
• Build and Support Libor FAS 133 Cash flow Hedge Program (Written in Excel, Access), then migrate to C# This is Citi Treasury FASB ASC 815-Hedge Accounting Program: Cash Flow Hedge of Variable-Rate Assets for Changes in Benchmark Interest Rates for the overall hedge program from MS ACCESS,EXCEL VBA, Python to ORACLE, C#.NET, Excel, Python
• Build and Support London Security Program -Daily P&L file as requested by the CTI London team to track MTD and projected monthly P&L for the London Credit book held in New York. Report will also show all trade indicatives. (Written in Excel, Access, Python),
• Build TIMS - Global Portfolio Analysis program using Bloomberg Pricing Data, DP (Derivative Price) Data, and Yield Data. (SYBASE,MS Excel)
• Trading Report- the Trading P&L Report is a daily report that summarizes the trading positions for the front office. The report shows the market to market P&L on all the trading activity. The information is sourced from Summit (product processor). The report considers new trades, matured trades, terminated trades in addition to open trades. The purpose of this automation effort is to reduce operational risk and increase efficiency. (SYBASE,MS Access, MS Excel, Python)
• Fed Feed of 3rd party derivatives- Review the 3rd party derivative trades in the Excel worksheet "CITI 3RD PARTY DERIVATIVES" from two external files (Customer XML, PC Download File). (MS Access, Excel VBA, Python)
• Treasury Liquidity Master Project Monitor- This is program keep track the status of all the Treasury Liquidity Master projects. It does generate the following information for the report; Project Information, Project Description, s this reporting period, Project Timeline, Open Risks
• AFS & MBS Reconciliation Report- Consolidated AFS & MBS data and generated a reconciliation report in Micro Strategy. The following information output from report (BU,BU Name,FRS,B2NCR,STAR,STAR Non-position)
• Confidential Treasury Investment Insight (CTI Insight) program-This is for the reporting for Market Risk and Written in (Oracle, MS Excel, Python)
• Provide technical support and manage enhancement requests for existing applications
• Conduct functional validation reviews on existing tools to mitigate risk, improve functionality and reduce support requirements
• Support Securities Trader with their application.
• Produce performance standards analysis reports.
• Generate reports in accordance with established schedules and provide reports, background information, and report summaries for internal and external use in Micro Strategy
• Work closely with the systems staff to generate needed reports in Micro Strategy
• Ensure accuracy and timeliness of reports in compliance with contract and project requirements.
• Support all teams (Summit, Technology Management, Operations Risk management, trading desk, etc.) for program enhancement or fixing errors.
• Supporting Mortgage AFS, AFS securities (Trading Securities) application.
• Supporting Department Central Funding - trading desk (swap, securities, ..), Operations Risk management
• Supporting Hedge Program, Securities Reports for Trader, Liquidity for Government Report, (Capital Requirements Directive 4) CRD4 for Europe gov’t, 4G System for U.S government, and Liquidity Coverage Risk (LCR) for Global.
• Consolidate CRD4 and LCR Database using SSIS importing MS Access Data to SQL Server and create cube using SSAS to analyst the data.
• Modernized, eliminated and condensed existing outdated reports and rewrote processes
• Implemented monthly "Executive Summary " report identifying increase/decrease in key accounts receivable indicators against previous years
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues
• Utilize programming and reporting tools to provide input and transmit output.
• Create and modify various reports based on user requests.
• Added/updated system transactions and data code tables.
• Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users.
• Designed, created and maintained OLAP Cubes used for reporting by adding dimensions and measures as needed.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or Confidential s Development Life Cycle (SDLC) methodology.
• Designed and delivered end-user and materials; provide technical support as necessary.
• Led the integration efforts for merging BI platforms with enterprise systems and applications.
• Designed, code, test, and documented all new or modified BI systems, applications, and programs.
• Developed the semantic layer, metadata, reports, and report definitions.
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Conducted research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluated and selected database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications.

Confidential, New York, NY

Programmer/Data Analyst - Access/Excel/VBA

Responsibilities:

• Developed a process to extract portfolio holdings, Model scoring/ranking, and individual stock performance information from GQE proprietary databases, Confidential performance/portfolio tools, and other external data vendors to develop content for client reporting using VBA
• Collaborated with Research and Portfolio Construction and Trading team to on how to best extract information from GQE proprietary databases
• Provided alternative deliverables to the CPM team
• Operationalized the process so that can be used by other
• Trained Client Portfolio Management Associate (CPMA) team members to use this process to supplement current client reporting efforts
• Reduced system slowness and retrieval time of financial report information with design of databases, thereby eliminating the use of billing software for reporting
• Modernized, eliminated and condensed existing outdated reports and rewrote processes
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues
• Performed analysis of the given data and draw accurate inferences, in accord with the objectives of the analysis
• Gathered data required to conduct analysis from several sources, compile it together in prescribed format and enter the data in several data analysis software
• Evaluated the given problem, situation and crisis; investigate for solutions using data analysis practices and prepare analysis reports
• Determined the methodologies and procedures for carrying out effective data analysis. Provide to the staff members on the new systems implemented

Confidential, New York, NY

Developer - MS ACCESS/VBA/MS Excel 2010/SQL Server/Python/ Crystal Reports

Responsibilities:

• Created custom reports in MS Access and Excel on a daily, weekly and as needed basis for project managers
• Created dashboard using MS Excel Formula and Python.
• Extensive use of Pivot Tables and Charts for reports
• Consolidated all the reports in MS Access using VBA and using SQL data.
• Used v-lookup function for comparing the data.
• Made updates and changes to the MS Access Database to speed up the process for reports generating (IBD and PWM)
• Managed files in Shared Point.
• Extensive use of MS PowerPoint for reports presentation
• Reduced system slowness and retrieval time of financial report information with design of databases, thereby eliminating the use of billing software for reporting
• Modernized, eliminated and condensed existing outdated reports and rewrote processes
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues
• Utilized programming and reporting tools to provide input and transmit output.
• Created and modified various reports based on user requests.
• Added/updated system transactions and data code tables.

Confidential, Prussia, PA

Developer - C#/MS ACCESS/VBA/MS Excel/VB.Net/SQL Server/ MSBI (SSIS (ETL) /SSAS/SSRS)

Responsibilities:

• Develop an MS Access Database with VB.NET to identify and analyze data errors such as overdue date, Logic error, Plan Date error, etc., for two markets (King of Prussia, and New England). The database works for any markets for AT&T based on region. It also has a feature to generate Templates such as NDER, CSS, BILLING, and LAC to upload to the database. Then later Migrate it to C#.
• Using MS Excel Power Pivot to analyze data and create reports for Accounting Dept. (Analyze all different Program Projects Cost (vendor, material, labor, etc.) within a year and delete some scope of the work if it is not required.
• Analyze financial data and prepare financial statement and reports for directors and propose recommendations.
• Develop and maintain financial databases using C#.
• Financial audit preparation and coordinate the audit process
• Ensure accurate and appropriate recording and analysis of revenues and expenses using SSAS
• Analyze and advise business operations which included revenue and expenditure trends, financial commitments, and future revenues using SSAS
• Analyze financial information to recommend or develop efficient use of resources and procedures, provide strategic recommendations and maintain solutions to business and financial problems
• Developed Crystal Reports
• Migrating data from Access to SQL server using SSIS
• Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users.
• Designed, created and maintained OLAP Cubes used for reporting by adding dimensions and measures as needed.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or Confidential s Development Life Cycle (SDLC) methodology.
• Designed and delivered end-user and materials; provide technical support as necessary.
• Led the integration efforts for merging BI platforms with enterprise systems and applications.
• Designed, code, test, and documented all new or modified BI systems, applications, and programs.
• Developed the semantic layer, metadata, reports, and report definitions.
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Conducted research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluated and selected database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications.
• Create Cube using SSAS to analyst the data in SQL SERVER for the projects

Confidential, New York NY

Developer - MS ACCESS/VBA/MS Excel

Responsibilities:

• Developed Retail reports using VBA
• Reports Data store in MS ACCESS
• Debugged Excel Links
• Rebuilt, expanded and improved all legacy reports on new reporting platform using SSRS 2008 R2.
• Built out novel reports and migrated rebuilt legacy reports into new centralized reporting portal to meet reporting needs company-wide.
• Assisted Controller and Accounting Team with research and data analysis
• Guided and mentored junior staff and provided expertise to software development team.
• Directly supported Finance, Marketing, Client Services, Sales, HR departments,
• Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to company.
• Reduced system slowness and retrieval time of financial report information with design of databases, thereby eliminating the use of billing software for reporting
• Modernized, eliminated and condensed existing outdated reports and rewrote processes
• Implemented monthly "Executive Summary " report identifying increase/decrease in key accounts receivable indicators against previous years
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues

Confidential, Little Rock, AR

Developer and Data Analyst - C#, MS ACCESS/VBA/MS Excel Developer/VB.NET/MSBI (SSIS, SSAS, SSRS)

Responsibilities:

• Built a program using C# to track all department different reports data with sites status
• Ran CASPR Reports for Site Acq, Check Schedule for Over Due Date, and analysis of the data using VB.NET code
• Developed a program system in MS ACCESS/VBA/VB.NET for Site Acq Dept., Engineer Dept., RF Dept., Project Controller Dept. to run their reports, retrieve information, and coordinated the data with each other
• Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users
• Designed, created and maintained OLAP Cubes used for reporting by adding dimensions and measures as needed
• Performed troubleshooting on BI tools, systems, and software; performance-tuned these applications as necessary
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or Confidential s Development Life Cycle (SDLC) methodology
• Designed and delivered end-user and materials; provide technical support as necessary
• Led the integration efforts for merging BI platforms with enterprise systems and applications
• Designed, coded, tested, and documented all new or modified BI systems, applications, and programs
• Developed the semantic layer, metadata, reports, and report definitions
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions
• Modernized, eliminated and condensed existing outdated reports and rewrote processes using C#
• Instituted a series of system/database audits to detect and address input code issues
• Helped customers streamline workflow activities, and effectively manage human resource information

Confidential, New York City, New York

C#/VBA/MS ACCESS/MS Excel/SQL Server/MSBI (SSIS, SSAS, SSRS) Developer and Data Analyst

Responsibilities:

• Developing Weekly Report Program for the Operation Department using VBA (Excel, Access) to be compatible for all the different countries.
• Developing Region Report Database DB Program using VBA
• Developing Holding Report Database Program Using C#
• Manipulating the data in Excel acting like a Database using ADODB
• Migrating MS Access 2004 data tables to SQL Server 2008 using SSIS
• Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users.
• Designed, created and maintained OLAP Cubes used for reporting by adding dimensions and measures as needed.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or Confidential s Development Life Cycle (SDLC) methodology.
• Designed and delivered end-user and materials; provide technical support as necessary.
• Led the integration efforts for merging BI platforms with enterprise systems and applications.
• Designed, code, test, and documented all new or modified BI systems, applications, and programs.
• Developed the semantic layer, metadata, reports, and report definitions.
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Conducted research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluated and selected database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications.

Confidential, New York, NY

C#, VB.NET /MS Access/VBA/MS Excel/SQL Server/ MSBI (SSIS, SSAS, SSRS) Developer and Data Analyst

Responsibilities:

• Developing Program for Sales department. using VBA (Excel 2003, Access)
• Developing Product Database Program using C#
• Developing Customer Database Program using VB.NET
• Developing Business Database Program using VBA
• Manipulating the data in Excel acting like a Database using ADODB
• Create a sale reports for all the departments. in MS Excel
• Accounting Department Report. (Managed accounts payable, accounts receivable, and payroll departments.)
• Generated budgets and forecasts on a quarterly basis and presented to the management team.
• Reported on variances in quarterly costing report
• Extract Data from SQL server for other reports
• Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users.
• Designed, created and maintained OLAP Cubes used for reporting by adding dimensions and measures as needed.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or Confidential s Development Life Cycle (SDLC) methodology.
• Designed and delivered end-user and materials; provide technical support as necessary.
• Led the integration efforts for merging BI platforms with enterprise systems and applications.
• Designed, code, test, and documented all new or modified BI systems, applications, and programs.
• Developed the semantic layer, metadata, reports, and report definitions.
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Conducted research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluated and selected database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications.

Confidential, Rochelle Park, NJ

C#/MS ACCESS/VBA/MS Excel Developer/VB.NET/SSIS/SSAS/SSRS Developer and Data Analyst

Responsibilities:

• Built a program using C# to track all department different reports data with sites status. This programs give all different project Milestone status such time need to get it done, which Milestone has been actualized and which is not, and etc.
• Using ETL OR SSIS to transport excel data to MS ACCESS.
• Run CASPR Reports for Site Acq, Check Schedule for Over Due Date, Analysis the data using the VBA CODE.
• Develop a program system in MS ACCESS/VBA/VB.NET for Site Acq Dept., Engineer Dept., RF Dept., Project Controller Dept. to run their reports, retrieve information, coordinated the data with each other.
• Develop a program for Finance department to perform cost estimating, analysis, and control activities using VB.NET. Later Migrate to C#.
• Using Power Pivot to analyze data and create reports
• Rebuilt, expanded and improved all legacy reports on new reporting platform using SSRS 2008 R2.
• Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users.
• Designed, created and maintained OLAP Cubes used for reporting by adding dimensions and measures as needed.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or Confidential s Development Life Cycle (SDLC) methodology.
• Designed and delivered end-user and materials; provide technical support as necessary.
• Led the integration efforts for merging BI platforms with enterprise systems and applications.
• Designed, code, test, and documented all new or modified BI systems, applications, and programs.
• Developed the semantic layer, metadata, reports, and report definitions.
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Conducted research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluated and selected database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications.
• Built out novel reports and migrated rebuilt legacy reports into new centralized reporting portal to meet reporting needs company-wide.
• Assisted Controller and Accounting Team with research and data analysis
• Guided and mentored junior staff and provided expertise to software development team.
• Directly supported Finance, Marketing, Client Services, Sales, HR departments,
• Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to company.
• Reduced system slowness and retrieval time of financial report information with design of databases, thereby eliminating the use of billing software for reporting
• Modernized, eliminated and condensed existing outdated reports and rewrote processes
• Implemented monthly "Executive Summary " report identifying increase/decrease in key accounts receivable indicators against previous years
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues
• Researched and updated over 12 months of missing employee data, this increased the accuracy of Human Resources Information Systems.
• Trained personnel and staff on new HR System; resolved complex questions related to its functionality.
• Created personalized database solutions, which simplified routine processing and reporting for customers.
• Helped customers streamline workflow activities, and effectively manage human resource information.
• Collected, analyzed, and interpreted human resources data, and advised managers on the readiness of personnel, in order to plan and utilize human resources more effectively.
• Produced routine, and ad hoc reports, to respond to immediate customer request.
• Utilize programming and reporting tools to provide input and transmit output.
• Create and modify various reports based on user requests.
• Added/updated system transactions and data code tables.

Confidential, Long Island, NY

C#/ VB.NET/ MS Access /VBA/MS Excel /MSBI (SSIS/SSRS/SSAS) Developer and Data Analyst

Responsibilities:

• Updated all the sites data into EPM, CASPR for Site Acq using SSIS
• Checking and updating data in SIM when it is needed
• Support Site Acq., Construction, Engineer, Project Control
• Run CASPR and EPM Reports for Site Acq, Check Over Due, and Analysis of the data
• Develop a program in MS ACCESS/VBA/VB.NET for Site Acq., Engineer, RF, and Project Controller to run their reports, retrieve information, coordinated the data with each other.
• Developed a program to perform cost estimating, analysis, and control activities using VBA
• Design and Program data input interfaces using Visual Basic Studio 6.0.
• Issue security protections on linked programs.
• Consolidate program using VB.NET and SQL
• Rebuilt, expanded and improved all legacy reports on new reporting platform using SSRS 2008 R2.
• Built out novel reports and migrated rebuilt legacy reports into new centralized reporting portal to meet reporting needs company-wide.
• Assisted Controller and Accounting Team with research and data analysis
• Guided and mentored junior staff and provided expertise to software development team.
• Reduced system slowness and retrieval time of financial report information with design of databases, thereby eliminating the use of billing software for reporting
• Modernized, eliminated and condensed existing outdated reports and rewrote processes using C#.
• Implemented monthly "Executive Summary " report identifying increase/decrease in key accounts receivable indicators against previous years
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues
• Directly supported Finance, Marketing, Client Services, Sales, HR departments,
• Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to company.
• Utilize programming and reporting tools to provide input and transmit output.
• Create and modify various reports based on user requests.
• Added/updated system transactions and data code tables.
• Designed ETL packages to transfer files into SQL Databases and designed reports to present the Data to end-users.
• Designed, created and maintained OLAP Cubes used for reporting by adding dimensions and measures as needed.
• Performed troubleshoot on BI tools, systems, and software; performance-tune these applications as necessary.
• Produced ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or Confidential s Development Life Cycle (SDLC) methodology.
• Designed and delivered end-user and materials; provide technical support as necessary.
• Led the integration efforts for merging BI platforms with enterprise systems and applications.
• Designed, code, test, and documented all new or modified BI systems, applications, and programs.
• Developed the semantic layer, metadata, reports, and report definitions.
• Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Conducted research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluated and selected database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Analyzed user requirements and, based on findings, design functional specifications for BI front-end applications.

Confidential, New York City, NY

MS ACCESS/MS Excel/MS Word Support

Responsibilities:

• Troubleshooting hardware and software (show students how to using excel functions and pivot tables, Graph table charts)
• Troubleshooting MS Office (MS Access, Excel MS Excel 2003, Outlook)

Confidential, New York City, NY

Web (VB Script)/Database (SQL) Developer/ASP

Responsibilities:

• Write store procedure, Database Design
• VB ACTIVEX DLL Project: Calculator( Whole Life, Universal Life, Variable Life, Banking, Estate) VB ACTIVEX DLL
• ASP: VB script, Java script, HTML, XML
• MS Access 2000
• Modernized, eliminated and condensed existing outdated reports and rewrote processes
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues

Confidential, New York City, NY

Support VB, VB script, MS Office 2000, & SQL Server

Responsibilities:

• Coding in VBA for Excel, Outlook, Access, and MS Word.
• Client Application written in VBA
• Client.xls (Retrieve data from Database), etc.
• SQL SERVER
• Write store procedure, Database Design
• ASP: VB script, Java script, HTML, XML
• Supporting Fixed Income bond markets: pricing, trading, distribution and risk management
• Rebuilt, expanded and improved all legacy reports on new reporting platform using SSRS 2008 R2.
• Built out novel reports and migrated rebuilt legacy reports into new centralized reporting portal to meet reporting needs company-wide.
• Assisted Controller and Accounting Team with research and data analysis
• Guided and mentored junior staff and provided expertise to software development team.
• Directly supported Finance, Marketing, Client Services, Sales, HR departments,
• Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to company.
• Modernized, eliminated and condensed existing outdated reports and rewrote processes
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues

Confidential, New York City, NY

Programmer Analyst/MS Excel 2003/MS ACCESS

Responsibilities:

• Coding in VBA for Excel, Outlook, Access, and MS Word.
• Create the spreadsheet calculation for retirement pension estimate using Functions in Excel and VB codes.
• Create the Access report using SQL and VBA
• Troubleshoot all the VBA coding in Excel, Access, and VB application
• Trouble shoot all the linking in Excel and Access
• Design and Program data input interfaces using Visual Basic Studio 6.0.
• Issue security protections on linked programs.
• (Consolidate) program using VB and SQL
• Modernized, eliminated and condensed existing outdated reports and rewrote processes
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues
• Modernized, eliminated and condensed existing outdated reports and rewrote processes using VBA
• Discovered and reported material variances in daily system activity
• Instituted a series of system/database audits to detect and address input code issues