Senior SQL Server/ Business Intelligence Developer Resume Houston, TX - Hire IT People

PROFESSIONAL SUMMARY:

Having 9+ years of strong experience as a MS SQL Server Database and Business Intelligence developer in various domains like Oil & Gas and Banking.
Proven expertise in MS SQL Server 2016/2012/2008 R2/2005, SSIS, SSRS and SSAS.
SQL and Business Intelligence development professional experience in data analysis, database design, ETL design and reporting with strong verbal and written communication skills.
Also, have In - depth understanding of all stages of software development life cycle (SDLC) and solid analytical skills for writing relational database and business intelligence solutions for businesses.
Capable of working independently or participate in a team or lead a team to a collaborative solution.

TECHNICAL SKILLS:

WORK HISTORY:

Confidential, Houston, TX

Senior SQL Server/ Business Intelligence Developer

Responsibilities:

Requirement analyze, scoping and documentation with precises deliverable for business needs.
Design ETL process with data quality and testing. Developed and documented ETL Design.
Create SSIS package to extract, transform and load (ETL/ELT) data from different sources into destination storage (ODS/Data Warehouse), Flat file, Excel, OLE DB destination.
Execute, manage and trouble shoot jobs with SQL jobs /scheduler and custom error alert system
Data modeling, documenting logical and physical database design.
Develop database object as T-SQL, stored procedures, user defined functions, user designed datatype, triggers, views, ad-hoc queries, indexes, sequence, synonyms
Develop reports by gathering requirement from business users
Develop Desktop and Web .Net application for internal business users.
Implement database solution using cloud infrastructure (DynamoDB)

Confidential

BI Consultant

Responsibilities:

Gather requirement from clients and provide best solution that fit for their business
Perform data analysis and provide data management solution that will support and enhance Information Management systems
Work independently or as part of a team to design and develop business solutions.
Provide expert solution for Data Management, Business Intelligence, Data Analytics and Reporting
Analysis, architecture, design, and development of ETL, data warehouse and business intelligence systems
Collaborate to create and enhance data structures (data marts, cubes) to facilitate decision-making
Follow best practice methodologies for database development and design with Microsoft recommendations
Lead analysis, architecture, design, and development of data warehouse and business intelligence solutions
Performance data migration, database scalability analysis, database upgrade
Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.