SUMMARY:

• Over 8 years IT experience, 5 years’ solid working experience in SQL Server database development and administration performed with DBA duties all in the enterprise environment.
• Expert experience with the Microsoft Business Intelligence (MS BI) stack including Reporting Services (SSRS), Integration Services (SSIS), and Analytics Services (SSAS).
• Working experience with SQL Server and T - SQL in constructing triggers, tables, user-defined functions, views, indexes, stored procedures, user profiles, relational database models, and data integrity. Database storage, database upgrades planning, data integration maintenance.
• Experience as an MS SQL Server database architect/designer/developer/administrator on large scale software development projects. Hands on experience in database architecture design, data modeling, SQL Reports development, Ad Hoc Report Model designing, and SSIS package development.
• Working knowledge and experiences of installing, configuring and managing SQL Server 2008/2012, migrating existing applications to SQL Server 2008/2012. Database backup/restoration/upgrade, security management, data integration and synchronization. Transferring/Rewriting DTS packages to SSIS packages; Setting up SQL Server 2008 Database mirroring, etc.
• Working experiences of Software Development Life Cycle (SDLC), project methodologies, as well as tools and techniques within each phase such as requirement elicitation, data dictionaries, data diagram, ERD, programming languages, technical platforms, standards, and procedures.
• Hands on experience in Web development including VB.NET, HTML5, CSS3, JavaScript, etc.
• Proficient skills in Data warehousing and analysis including ETL tools, OLTP, OLAP, UDM, Data Mining, MDX, Transactional and Multi-Dimensional Modeling (Star and Snowflake schema).
• Proficient in creating Use Cases, Sequence Diagrams, Component Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Strong performance tuning, data analysis, troubleshooting and problem-solving skills.
• Good communication skills, proactive, self-managing, and teamwork spirits.
• SAP TERP10 Certification (05/2017). Designed the fundamental integrative business processes in Procurement/P2P, Production Planning/PP, Project Management, Sales/OTC, Customer Service, Asset Management, Financial Accounting/FI, Management Accounting/CO, Internal Orders, Human Resources and Analytics.
• Enterprise System Management / SAP Software. Basic knowledge of the core business processes, business interrelations, and integration of business processes in SAP ERP. Hands on experience on SAP Modules: FI, CO, SD, MM, PP, ME, HCM, etc.
• Enterprise System Configuration Using SAP. Utilized configuration and implementation tools of an integrated global enterprise business system to finish the following tasks.
• Configured and implemented business scenarios.
• Performed complex implementation procedures such as conditioning techniques, pricing procedures, and linking procedures.
• Planned, developed, and presented a project scenario that illustrates the SAP configuration implementation, and administration associated with a business enterprise.
• Implemented configuration of organizational elements, internal controls, and master data.
• Configuration leads knowledge of FICO sub-modules - GL (New GL), AP, AR, Fixed Assets and other Controlling components; thorough understanding of P2P, OTC and R2R processes and experience of working on FICO integration with SD and MM. 
• The scope of configuration and customization of business requirements in  SAP. Integration experience with Sales and Distribution, Financial Accounting, Material Management, PP, Professional Services and HR/HCM. Demonstrated experience with Integration of projects to FI, CO, SD and MM modules of  SAP .
• ABAP Programming for ES. Created user-friendly, full-screen system interfaces for executing various business processes (e.g. selling system, converter, members management system, etc.) using the ABAP Development Workbench.
• Participated full business cycle of a small company, interacted with suppliers, customers, and internal groups.
• Made and executed business decisions using SAP reports and dashboards.
• Provided SAP solutions in the day to day activities.
• Improved understanding of the integrated nature of SAP and the power of collaboration.
• Increased knowledge of basic navigation and operation of SAP.
• Enhanced business acumen and sharper decision-making skills.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2012/2008/2005 , MySQL, Microsoft Access, etc.

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Tableau, SAP Crystal Reports, Microsoft Excel, etc.

ETL Tools: Microsoft SQL Server Integration Services (SSIS), etc.

Programming: T-SQL, VB.NET, HTML5, CSS3, JavaScript, etc.

SAP: SAP TERP10, SAP Modules (FI, CO, SD, MM, PP, ME, etc.), ABAP Programming for ES, Enterprise System Configuration using SAP, etc.

Data Modeling: Microsoft Visio, UML, etc.

Applications: SQL Server Management Studio, SQL Server Data Tools, Microsoft Visual Studio, Enterprise Manager, Query Analyzer, Analytic Services, Profiler, Microsoft applications (Excel, Access, Word, PowerPoint, Visio, etc.), Dreamweaver, etc.

Operating Systems: Windows Server 2012/2008, Windows 10/8/7, OSX, etc.

PROFESSIONAL EXPERIENCE:

Confidential, OHIO

Microsoft SSRS Developer

• Designed and developed new reports and maintained existing reports using Microsoft SQL Reporting Services (SSRS) and Microsoft Excel to support the firm’s strategy and management.
• Created SSRS Reports to show how they work and what reports they can provide.
• Developed, tested, and deployed new and updated SSRS reports to the production environment.
• Maintained and developed complex SQL queries, stored procedures, triggers, views, user-defined functions and reports that meet customer requirements using Microsoft SQL Server 2012.
• Designed and implemented Ad-hoc reports when requested. Wrote enterprise reports and stored procedures upon business users’ requests.
• Designed and implemented Ad hoc report models based on all kinds of data sources, set up and implemented Standards for SSRS environments.
• Met with business users regarding their reporting needs and create reports based on their requirements.
• Created, managed, and delivered interactive web-based reports to support daily operations.
• Created Views and Table-valued Functions to provide the reporting solutions.
• Delivered and maintained web-based reports to support daily operations and drive decisions.
• Implemented reports in line with established plans and standards.
• Wrote complex SQL scripts (temp tables, common table expression (CTE), self-joins, subqueries, table-valued functions) to populate new reports on demand from business users.
• Handled on SSRS reports development and maintenance, Ad Hoc reports designing, and Microsoft SQL Server Integration Services (SSIS) packages development.
• Collected requirements directly from business users, documented business requirements, translated requirements into technical specifications, and designed report models to meet business requirements.
• Ran month-end processes, and trained the business users to create Ad-hoc reports of their own.
• Designed, created and implemented a star-schema database using MySQL and MS VISO. Created ER Diagram based on users’ requirements.
• Designed, developed and tested enterprise Data Management Application using VB.NET and MySQL database.

Confidential, NEBRASKA

SQL Server Developer

• Created and maintained SQL Server databases, SSRS reports, SSIS packages, SSIS jobs, standard tables, views, stored procedures, and functions to support reporting needs.
• Maintained daily operations to develop business intelligence. Performed data integration utilizing SSIS, and developed dynamic business reports utilizing SSRS.
• Delivered and maintained interactive web-based reports to support daily operations and drive decisions. Wrote enterprise reports and stored procedures upon requests.
• Created SSIS packages with which data from different resources were loaded daily to create and maintain a centralized data warehouse.
• Troubleshot issues in jobs, reports, SSIS packages. Analyzed the posting data coming from several different business systems. Data sources include flat files, spreadsheets, and other third party sources.
• Managed and developed existing and new ETL processes for SQL Server reports.
• Implemented data partitioning, common table expression (CTE), self-joins, complex subqueries, indexes & profiling, etc.
• Modified existing SSIS packages, and changed data flow designs to accommodate business changes.
• Scheduled and maintained the activities of SQL Server 2012 to meet business requirements activities.
• Independently designed, developed and implemented Web applications for Employee Sales Commission Management and Employee Information and Payroll Processing Management using VB.NET and Access database to manage the data.
• Developed and customized multiple mini websites based on users’ specifications and User Experience Design. Web development skills include HTML5, CSS3, and JavaScript. Web development tools include Microsoft Visual Studio, Dreamweaver, etc.

Confidential

SQL Server BI Developer

• Developed new ETL processes to populate the Data Warehouse, tuned and optimized SSIS packages.
• Created, managed, and delivered interactive web-based reports to support daily operations.
• Analyzed business requirements and built logical data models, and wrote enterprise reports and stored procedures to meet business requirements.
• Designed and implemented Ad hoc report models based on all kinds of data sources, set up and implemented Standards for SSRS environments.
• Created SSRS Reports to show how they work and what reports they can provide.
• Created SSIS packages to load the staging tables, data marts, and to run jobs. Data sources include flat files, spreadsheet, access, SQL Server databases and other third party sources.
• Created Views and Table-valued Functions to provide the reporting solutions. Created Stored Procedures to load data and to log errors in ETL.
• Deployed and supported SSIS packages to the production server, and scheduled jobs to run the packages.
• Helped business users to reconcile reports from data warehouse with reports from legacy systems.
• Scheduled and monitored all maintenance activities including database consistency check, data backup & restore strategy, index defragmentation, statistics updates.
• Monitored and tuned the performance of certain report generation process.
• Maintained SQL jobs that refresh data warehouse, process cubes, and backup databases. Troubleshot issues in jobs, reports, SSIS packages, etc.

Confidential

SQL Server Developer

• Created SSIS packages with which data from different resources were loaded daily to create and maintain a centralized data warehouse. Made the package dynamic to fit the environment.
• Developed schemas for business applications with providing full-life cycle architectural guidance and ensured quality technical deliverables.
• Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
• Managed and developed existing and new ETL processes for SQL Server reports. Refreshed staging tables with ETL.
• Scheduled and monitored all maintenance activities of SQL Server 2005/2008 to meet business requirements activities including database consistency check, data backup & restore strategy, etc.
• Created new SSIS packages, standard tables and scheduled jobs to support reporting needs.
• Modified and tuned SSIS packages, and changed cube designs to accommodate business changes.
• Managed the production, development, and test database including access control, high availability, performance monitoring & tuning, and capacity planning.
• Migrated the databases, cubes, DTS packages from SQL Server 2005 to SQL 2008 based on the business requirements.