OBJECTIVE:

A dedicated individual with professional work experience in Financial Industry; looking to be employed in a firm where I can put my technical skills to use in enhancing the MS SQL Server systems and in developing software that will be boost the company’s productivity.

SUMMARY:

• On a path toward MCSA: SQL Server 2012/2014 Certification (Passed 70 - 461 and 70-462, 2 out of 3 test)
• Power BI certified from EDX.ORG
• Manage and involve in full project life cycle (SDLC) .
• Demonstrated ability to work effectively in a team or independently, with minimal supervision.
• Proven ability to multi-task and work with cross-functional teams in a very fast-paced environment.
• Solid analytic and metric creation skills and strong personal computing skills (data analytic tools, Excel, MS SQL, Scripting…) with the ability to quickly learn new applications.
• Creative thinker with work and academic experiences in analytics, mathematics & statistics.
• Experience in both T-SQL, SSIS and SSRS, Tabular model in SSAS, Power BI and Tableau

TECHNICAL SKILLS:

Software Application: DBeaver, Visual Studio Code, Microsoft SQL Server Management Studio, Visual Studio, TFS, MS Excel, Power BI, Tableau Desktop, Tableau Online, JiraDatabase: SQL Server 2008/2012/2014/2016 , Postgres

An Enthusiastic in Programming: Python, HTML, CSS, C#

Platform & Operating Systems: Windows, Microsoft SQL Server, Linux

PROFESSIONAL EXPERIENCE:

Senior BI/Database Developer

Confidential

Responsibilities:

• Responsible for designing and implementing BI solutions to enable the analysis of Tax data to support strategic initiatives and ongoing business requirements.
• Ability to complete take a project from end to end (Gathered business requirements, performed data cleansing, manipulation, import data into database and create reports)
• Created views, functions, stored procedures, indexes, and tables up to 3 rd form of normalization to support multiple corporate tax forms within the same database.
• Worked extensively with Tableau Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Created, integrated and optimized a hierarchy level of Tableau reports to a client’s webpage application that can pass selected filters down to the subsequent reports with minimal impact on performance using Live Connection to pull data.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards reports (SSRS) according to business requirement.

Data Engineer

Confidential, Dallas, TX

Responsibilities:

• Design and implement data strategy roadmap to improve existing software/processes.
• Improve existing data quality and quantity which lead to reduction in business cost.
• Ability to learn new tools and deliver projects from end to end such as using company’s homebrew ETL framework to import data from files source up to creating trend and reports for businesses.
• Establishes and documents data governance policies, processes, standards, definitions and roles
• Created tables, indexes, and referential integrity constraints (PK, FK, uniqueness) up to 3 rd form of normalization.

BI Developer

Confidential, Dallas, TX

Responsibilities:

• Responsible for the design and creation of many complex SSRS reports from scratch (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting).
• Continuously interacted with Business Analysts and end users to gather business requirements (Client: Confidential )
• Exceptional SQL Scripting and Debugging skills including DDL, DML, DCL and TCL
• Optimized T-SQL queries performance
• Experience in Data Extraction, Transform & Load (ETL) development using SQL Server Integration Services (SSIS 2014/2012/2008 )
• Strong experience in creating complex Stored Procedures, Indexes, Functions, triggers, cursors, views and joins.
• Thorough Knowledge on Data Warehouse concepts like Star Schema, Snowflake, Dimension and Fact Tables.
• Working experience developing Power BI reports and its data source through tabular model SSAS Cube.

Database Developer

Confidential, Dallas, TX

Responsibilities:

• Involve in the design, development, and analysis of data architecture
• Designing data sanity and integrity test cases
• Developed SSIS packages to pull data from multiple sources (Flat files, xml, excel, csv…Etc.)
• Updated legacy SSIS packages and logic to from 2005 SSIS version to 2016 version.
• Updated/optimized existing SSRS reports to meet new business’s needs
• Work with DBA to ensure a smooth deployment of SSRS and SSIS packages from Dev - QA - Stage - UAT- Prod
• Participate in troubleshooting production errors and replicate the problem to lower environment for rigorous testing and debugging before a fix is released.

BI Developer

Confidential, Dallas, TX

Responsibilities:

• Participate in the design, development, and analysis of data architecture and warehousing approaches
• Designing data sanity and integrity test cases
• Interacted with end-users to collect requirements and acquire the necessary domain knowledge to become a subject matter expert. Trained and provided support to end users.
• Create QlikView, SSRS and Power BI reports that are used to influence the behavior of the businesses to reduce risk to the environment while ensuring assets are productively used, minimizing the amount of money wasted on resources that are not properly utilized.
• Experience in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies
• Design and create Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• Write/optimize T-SQL queries and store procedures that are used in SSRS report and SSAS tabular models.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Experience in extracting, transforming and loading ( ETL) data from spreadsheets, database tables and other sources through SSIS, BULK INSERT, BCP...Etc.

Database Developer

Confidential, Los Angeles, CA

Responsibilities:

• Leveraging SQL Server Extended Events to identify poor performing and failed queries.
• Designing and maintaining databases to support cross platform applications with an architecture that enforces data integrity while efficiently expanding to grow with the organization
• Ability to analyze execution plans and data architecture to optimize procedures and queries.
• Able to design and develop robust and fault tolerant ETL processes to synchronize data across data sources.
• Experience in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Query performance optimization techniques such as index design, index hints, data partitioning, query plan analysis, and data pre-processing.
• Utilizing T-SQL to automate business processes, optimize query performance, generate and distribute reports, FTP file transfer, generate files in defined format to send commands to another data processing systems.
• Developed, maintained, and troubleshoot SQL jobs.
• Design and implement ETL processes to handle large data volumes in both real-time and batch environments.
• Developed ad-hoc reports, drill down, drill through reports, parameterized reports and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience designing, implementing, maintaining a data warehouse of similar size

Database Developer

Confidential, Irvine, CA

Responsibilities:

• Assisted in developing, building a new database, and creating stored procedures using MSSQL Server.
• Developed scripts automating daily and routine tasks including: reporting, FTP file processing, download, sending requests to another data processing systems, job scheduling;
• Design, write, and review complex stored procedures and functions using Transact SQL to automate calculation, create reports and optimize query performance
• Participated in project planning sessions with project managers and team members to analyze business requirements and outline the proposed solution.
• Responsible for preparation of management level reports analysis utilizing SQL queries from the multiple reporting systems and customer information collected from the business segments.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
• Created SSIS packages for File Transfer from one location to the other using FTP task
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Prepared the complete data mapping and Report Definitions for the project which involved around 30 reports.
• Designed SSIS Packages to transfer data from flat files to SQL Server using SSDT.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server

Business Analyst

Confidential, Westminster, CA

Responsibilities:

• Write macro to automate the redundant process of prepping data.
• Conduct of research and statistical analysis from a variety of sources, including competitors, customers, industry experts and through online researches and public records.
• Utilize SQL to mine information from databases to improve quality of statistical models, data cleanliness, and reporting.
• Calculate the specified problem, state of affairs and crisis; examine for solutions using data analysis practices and arrange analysis reports.
• Maintained the research database, renew and improve it from time to time and make sure safe storage of data.