SUMMARY

• Accomplished, solution - focused, creative and analytical ETL Developer with a wealth of experience in industries including healthcare, consumer products, telecommunications, and automotive.
• Skilled in T-SQL development, data analysis, systems development life cycle (SDLC), and Agile software development models.
• Innovative change agent with a proven track record of fostering high performing teams that enable organizational success by executing consistent processes, effective communications, and stakeholder collaborations.
• Continuous learner who seamlessly adapts to new software development and emerging technologies.
• Fosters a culture of innovation and effectively communicates concepts and complex technical information to all stakeholders.

TECHNICAL SKILLS

• ETL Development
• SQL Server
• SSIS
• Systems Development Life Cycle (SDLC)
• GitHub
• Agile Software Development
• Technical Data Analysis
• Big Data
• Visual Studio
• RDB (Relational Database)
• Mentoring
• Training
• Software Applications
• Master Data Services ( MDS )
• Data Quality Services ( DQS )
• OLAP

PROFESSIONAL EXPERIENCE

ETL Engineer

Confidential

Responsibilities:

• Smoothed the data pipeline by extending and improving automation.
• Controlled the code versioning using Git under Linux environment.
• Developed ETL jobs using PHP and MariaDB (a fork of MySQL)
• Established new and secure ETL processes using API calls with PHP
• Automated ETL workflows to effectively load medicare data into the data warehouse.
• Optimized SQL and PHP scripts to improve ETL performance.
• Managed and configured various GCP (Google Cloud Platform) VM instances.
• Implemented a data archive process to GCP.

SSIS Developer

Confidential

Responsibilities:

• Made enhancements to existing processes by designing SSIS Packages to transfer data from/to flat files using Business Intelligence Development Studio.
• Maintained Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Automated various manual ETL jobs.
• Enabled the Physician Compensation team to trace ETL jobs by creating logging tables.
• Monitored ETL jobs, handled errors, communicated to the business stakeholders.
• Developed SSRS reports using the Global variables and expressions.
• Designed and analyzed OLAP cubes with SSAS.

Big Data ETL Developer

Confidential

Responsibilities:

• Oversaw CDC jobs to perform extract, transform and load large data sets (TBs+ range)
• Established and maintained attunity tasks to handle big data and worked on Hadoop cluster using big data analytic tools including attunity, HUE, Spark and Kafka
• Led JAR file jobs using Linux terminal commands
• Constructed Apache Spark applications in IntelliJ IDEA
• Assisted the previous team with SSIS technical needs

ETL Developer

Confidential

Responsibilities:

• Automated and scheduled SSIS ETL jobs from source to target for various clients.
• Formulated enhancements to data quality designing and implementing Data Quality Services (DQS) solutions.
• Created, developed, and implemented Master Data Services (MDS) solutions and performed in an ETL role in developing, implementing, and maintaining SSIS solutions.
• Orchestrated the maintenance of database objects (i.e., tables, stored procedures) using SSMS.
• Led the implementation of Git for the team to maintain packages/projects.
• Programmed C# / VB script components of SSIS
• Designed user-friendly C# applications that call SSIS packages
• Built star schema cubes using SSAS

Sr. Technical Analyst

Confidential

Responsibilities:

• Formulated report automation by developing stored procedures with SQL Server Management Studio.
• Fortified ETL processes by creating SSIS packages with Visual Studio 2013 and assumed a leadership role for the ETL QA process by building data validation queries for the team.
• Developed SQL queries, conducted analyses for sales teams and leadership teams, including standard and ad-hoc reports, and served as a subject matter expert on advanced analytical processes/procedures.

ETL Engineer

Confidential

Responsibilities:

• Optimized the ETL flow by modifying SSIS packages and database object scripts.
• Enforced security and data customization with views and triggers and shortened the run time by automating manual ETL tasks with SSIS.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data and executed enhancements to the existing packages by modifying variables and flows.
• Oversaw the data flow from flat files to staging (de-normalized database), staging to mart (normalized database), and mart to the reporting layer using SSIS (BIDS 2008).
• Ensured scripts and packages in sync across a variety of environments by deploying them with TeamCity.
• Provided support to the revenue cycle management BI tool by identifying, researching, and resolving performance and data handling issues.
• Delivered excellence in troubleshooting, inspection, ensuring top-quality at all times.
• Maintained the database objects up-to-date to support the constant business requirement changes.
• Created, implemented, and maintained various SQL batch jobs to increase query performance.
• Conducted a pre-deployment unit test on packages and database object and improved the data testing process by developing SSRS reports.

Senior Business Analyst / SQL Report Developer

Confidential

Responsibilities:

• Led the ETL process, including data import, transformation, and query building in Microsoft SQL Server.
• Created ease of use for end-users by developing TSQL (T-SQL) stored procedures, triggers, functions, indexes, and views to reduce the complexity of data sets.
• Enhanced query performance 20% and reduced database load and server requirements through code review, performance tuning, and rewriting of views and queries.
• Executed the reduction of report development turnaround time from one week to one day by writing stored procedures and Visual Basic VBA script to increase automation.
• Collaborated with BI business intelligence enterprise data warehouse team to efficiently extract data and validate (quality assurance QA) integrity to meet business requirements.
• Created organizational structure diagrams in Visio by establishing ODBC connections to the SQL server.
• Designed internal databases with Microsoft Access by creating tables, queries, forms, reports, macros, charts, and modified them as necessary.
• Evaluated worldwide sales initiatives to determine overall strategic fit by concluding historical data stored in SQL Servers connected to Oracle Financial E-Business Suite Systems.
• Developed tools and reports in Excel power pivot tables and distributed reports via SharePoint Server.
• Designed complex database queries to meet the business needs using Microsoft Access, Microsoft SQL Server, and MSTR MicroStrategy.

Sales Analyst / BI Reporting Analyst

Confidential

Responsibilities:

• Generated Commercial Business reports with key metrics and KPIs (key performance indicators) by creating ad-hoc queries using complex formulas and macro functionality.
• Penned, tested, and executed SQL scripts for creating reports and improving data quality through identifying errors.
• Accelerated the productivity of analysts by writing VBA code that enabled MS Access and MS Excel to perform more tasks automatically.
• Adjusted reports and databases to changing business requirements by utilizing data and tools within Cognos, TERADATA, Microsoft MS Access, and Excel.
• Collaborated cross-functionally with IT to enhance a set of database standards, automated recurring reports, and QA testing of results.

Reporting Analyst

Confidential

Responsibilities:

• Delivered technical expertise in database design, development, and administration.
• Developed Human Resources (HRM) multi-user databases with MS Access.
• Formed and administered an automated model that analyzed the volume of vehicle orders and payroll data.
• Created ad-hoc reports in support of Human Resources planning and budgeting.
• Coordinated with Japanese employees living in the United States regarding immigration, vehicle order, and other Human Resources general matters.
• Spearheaded the new hire orientation process upon Japanese employees’ arrivals.

Reporting Analyst

Confidential

Responsibilities:

• Reviewed financial data and generated ad-hoc reports by creating complex Excel formulas, pivot tables, and chart functions.
• Established and maintained databases managing property tax and immigration.
• Updated and maintained department intranet website using IBM Lotus QuickPlace.
• Oversaw the management of corporate contributions to non-profit organizations.

Reporting Analyst

Confidential

Responsibilities:

• Delivered sales reports to assist managerial accounting.
• Created data dashboards that analyzed sales trends, and provided management views into business operations using MS Access and MS Excel.
• Directed a tracking database to maintain current production and sales data.
• Managed sales and purchase volume to maintain proper product inventory levels.
• Produced purchase orders, invoices, and packing lists based on bill of landings with the 3rd Wave system.