SUMMARY

• Over 20 years of experience in analyzing, designing and verifying data with relational database and data warehouse environments; Using SQL Server 2016/2 R2/2008/2005(stored procedure, view, trigger and diagram), Oracle, T - SQL, PL/SQL, SSDT, Visual Studio 2012/2010/2008 (SSIS, SSRS and SSAS); ETL, Knowledge Share Power Share, Power BI, Toad, TIER System, Excel, Access, Visio, Erwin, Informatica, Cognos, Tableau,dashboards, VB, Crystal Reports, SAP, SharePoint, JIRA, Remedy.
• Significant computer information technology in healthcare, education, accounting and finance experience;
• Excellent analytical and problem solving skills; Ability to work independently and as part of a team.
• Data Conversions and Data Migrations by using SQL Server, SSIS and Informadica; Creating and maintaining an extraction, transformation, and loading process from different sources.
• Deep understanding of RDBMS, relational database, data warehouse, data mart, data lake and data modeling(Erwin), business intelligence (Dimensional Modeling and Star/Snowflake schemas) and cube data architectures; Very strong logic thinking, web technology, presentation and software development life cycle.
• Performance tuning and resolving databases performance issues (indexing, data partitioning/clustering, updating statistics; Import/Export Data, backup, maintenance, monitoring and other daily administration tasks for databases; Scheduling jobs; Query Builder, data visualization and SQL Tuning Advisor.
• Interact with the Database and Business Intelligent development to develop solutions based on the business end user's requirements. Strong PC skills including advanced level of Excel (pivot tables, dashboard, macros, external data, and queries), Access (queries), Word and PowerPoint.
• Excellent T-SQL, queries, views, stored procedures, triggers, functions, indexing, web services, flat files; strong reporting skills, Crystal Reports and SharePoint; knowing how to properly use SQL Server Profiler.

TECHNICAL SKILLS

Database: SQL Server 2016/2 R2,Oracle SQL Developer, PL/T-SQL, SSDT(Visual Studio) 2012/20102008 (SSIS/SSRS/SSAS), Power BI, Informadica, TIER System, ETL, Excel, Access, Crystal Reports, XML, Data Mining, Data Modeling/Erwin, Knowledge Share, Power Share, Visio

Application: Java, JavaScript, C/C++, Perl, Visual Basic, HTML, XML, FrontPage, Illustrator, DreamweaverPhotoshop, Microsoft Office (Word, PowerPoint) and Adobe

Op Sys: Windows 10/8/7/2000/XP, Unix/Linux, DOS, and Mac OS

Courses: Database Management Systems (PERL), Quantitative Methods Foundations (using statistical formulas and models), C/C++, Java/JavaScript, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential

ETL Architect

Responsibilities:

• Own and make strong contributions in architecting, designing and planning BI / AI solutions, configuring services, aggregating data from multiple sources into a data repository
• Establish best practices for BI, AI, & analytics solutions to ensure they are being effectively applied to all efforts
• Guide technology teams in creating and deploying solutions that cater to various business needs.
• Perform architectural reviews of BI / AI & analytics solutions
• Define and implement business transformation rules and logic
• Identify, establish, communicate, and manage data quality and integrity standards
• Participate in and direct data architecture design activities within development teams
• Experience with database analysis, database modeling, design, and implementation especially for data lakes / marts / warehouses
• Experience with the design of scalable ETL / ELT solutions with multiple data sources
• Hands-on development experience with ETL / ELT tools and resources
• Data transformation support and management through MS SQL SSIS / DTS, Informatica, Cognos, and Tableau
• Experience in SQL development focused on MS SQL, T/PL SQL-based development
• Experience in working across multiple production and development environments

Confidential, Lancaster, PA

DBA/Database Developer

Responsibilities:

• Creating databases, tables and staging tables in SQL Server 2016/2014/2012 ; loading, Transforming and Extracting data from SQL Server 2016/2012/2008 R2,Oracle,Informatica, Flat files, SAP, Knowledge Share.
• Writing SQL code and creating SSIS packages for test data quality and other projects.
• Creating and developing control projects by using SSIS: foreach loops, containers, Scripts task, writing C# code, FTP file, SAP and more functions; Working on Mortgage, Debit and Credit database
• Oracle/SQL DBA: scheduling new jobs and reloading and modifying jobs; trouble shooting job problems; managing jobs; backup and recovery scenarios; adding and deleting users; editing emails.
• Technical Support and problems solving; installing software; posting information into SharePoint.
• Working report projects by using SQL, SSRS, SAP, Power Share and Knowledge Share.
• Creating a Data Elements Document from 235 T-SQL and PL/SQL scripts.
• Performance Tuning(Hardware, software and estimating workloads-sizing Data) by using SQL Server Profiler.
• SQL Tuning, Testing, Debugging, and Validating a Design.
• Installing, testing and updating software(SQL Server 2008R2 to 2012,2014 and 2016), Toad, oracle and etc.
• Testing and changing databases, tables and scripts by using SSDT 2016 (Schema Comparison, Snapshots Project, Refactoring, Solution to Source Control)

Confidential, King of Prussia, PA

Business Data Analyst

Responsibilities:

• Testing two projects by writing SQL coding and using Netx360.
• Translating and reading 47 Oracle scripts into SQL coding. Creating test tables and loading data by writing SQL coding, SSIS packages, and SSDT from flat and excel file to SQL server database.
• Reading data and database structure from 15 databases; learning business system from Netx360 and getting to know account, performance, profile, investment name, type and chart.

Confidential, Wilmington, DE

Software Developer

Responsibilities:

• Creating and editing TIER forms by writing Tier coding and T-SQL;
• Designing and editing Tables (with around 800 columns of each table) in SQL Server 2008 R2 database, Loading/ETL data into the database by using SSIS and T-SQL;
• Developing and testing forms and data; Billing reports by using SSRS;
• Working with Day Treatment and Crisis Risk Assessment projects.

Confidential, PA

Data Analyst/ (SQL/BI Developer)

Responsibilities:

• Analyzing, reporting, testing and extracting Electronic Medical Record (EMR) data in complex databases;
• Loading EMR reports to SharePoint after generating claims, members, providers and diseases (ICD9, HIPAA) data;
• Testing Databases and reviewing code; Designing ETL and diagrams.
• Analyzing ad hoc and daily reports by using SQL 2008 R2, Visual Studio 2008(SSIS, SSRS and SSAS) Crystal Report, SAP; Creating test data warehouses.
• Wrote complex codes and sub queries using T-SQL and leveraged strong understanding of relational and dimensional data modeling (Multi-Dimensional Modeling and Star/Snowflake schema models) and data architecture by using Erwin (tables relationship, primary keys and foreign keys); very strong logic thinking.
• Provided manual test, reviewing test cases, peer review and unit test scripts; updated and maintenance database, flow charts, schema, and data modeling; created view, stored procedure and indexes.

Confidential, Dover, DE

Data Analyst/SQL Developer

Responsibilities:

• Installing, configuring and upgrading SQL 2008/2005, Oracle 9; providing analysis, and data modeling support for the college, creating and maintaining student databases (import/export/backup/storage) and computer Labs.
• Setup processes collecting data into database, backup, storage data, performed data validation, mapping and mining data, generating and analyzing student records and various reports by writing SQl and Oracle queries (Dashboards and T-SQL/PL-SQL), Visual Studio 2008 (SSRS, SSAS and SSIS), ETL, Excel, and Access.
• Created, designed and maintained website by using HTML, Java, JavaScript, Photoshop, Dreamweaver, FrontPage, Illustrator, PowerPoint and Adobe; web development.
• Performing advance levels of database systems planning, analysis and design; problem diagnosis, resolution, troubleshooting; tracking, reporting, upgrading and planning for projected software requirements and computer capacity.

Confidential

Programming Engineer

Responsibilities:

• Establishing, modeling and analyzing Electronic Medical Record (EMR) in complex databases / data for thousands of Confidential ts, the claims billing and finance departments (knowledge of Confidential t Protection and Affordable Care Act (PPACA) and Health Insurance Portability and Accountability Act (HIPAA)), codes and varieties of diseases, and reporting departments.
• Establishing data warehouses that maintained Confidential t cases, which included Confidential t contact information, current medical records and medical history and designating medical codes (ICD-9). This resulted in quicker data retrieval and ultimately resulting in a reduction of required physical storage space.
• Performing advance database operations (database tuning, table space sizing and location, database monitoring), diagnosing and debugging the two database programs for existing and potential performance or security issues and planning for projecting software requirements and computer capacity needs.
• Programming Confidential t billing, hospital finance and Clinical biochemical lab projects by using statistical formulas; setting up a huge volume account database of thousands Confidential ts and wrote codes to retrieve monthly, annual and ad hoc reports. After using the programs, the work efficiency improved 90%, more accurate and increasing savings.
• Establishing backup and recovery or replication plans to minimize data loss and system downtime.
• Developing database standards, documenting and administering processes, system security and authorization procedures, troubleshooting and maintaining data warehouse environment.