We provide IT Staff Augmentation Services!

Bi-db-sql Developer 3 Consultant Resume

3.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

Multi - role developer/analyst experience in Business Intelligence, Data Engineer, SQL-Server Developer 2005-2016/Azure, SSMS, SSRS, SSIS, SSAS, ETL, BIDS/SSDT 2005-2015, Visual Studio.Net 2005-2015 Enterprise, Power BI, MSRA Excel, Data Modeling, data migration, transformation, validation, integration, SQL jobs, automation and production support.

TECHNICAL SKILLS:

SQL Server 2005-2016 and SQL Azure, TFS, SharePoint, SSMS, SSRS, Business Intelligence Development Studio, SSDT, SSMS, SSAS, SSIS, OLTP, OLAP, ETL, Power BI, Visual Studio.Net 2015 Enterprise, VSTS/ALM/SDLC, Excel Pivot, Erwin Data Model 2.1-7.0, Microsoft Report Analyst (Excel tools), Web Services, IIS, Oracle8-11g, PL/SQL Developer, Office 365, VSS, Code Complete and Boeing P+.

PROFESSIONAL EXPERIENCE:

BI-DB-SQL Developer 3 Consultant

Confidential

Responsibilities:

  • Design and develop BI-ETL-SQL Database architecture for Microsoft BI. VS2015.net Enterprise, SSDT2015, SQL-Server 2014-2016/Azure, SSIS, SSAS, SSRS, Power BI, MSRA Excel, TFS, SharePoint.
  • Develop DB objects, SSIS package and ETL from varieties of MS large OLTP DB To Data Warehouse/OLAP.
  • SQL Administrator to backup/restore SQL Servers.
  • Create jobs and fully automate processes from all sources to Data Warehouse and Cubes.
  • Create end to end deployment process documents for production.
  • Work closely with MS Enterprise team and perform data analysis of two legacy data model into new MS Compass Enterprise DB architecture.
  • Perform DBA, SQL, Power BI, Excel Pivot, SSIS, SSDT, ETL, jobs, and data transformation. Write complex T-SQL & automate processes.

Sr. BI-SQL Developer Consultant

Confidential

Responsibilities:

  • Collaborate with Data Architect and Business Analyst to analyze business requirement and provide delivery estimates of BI reports.
  • Develop reports in BIDS, SSRS, SQL-Server2008, stored procedures and perform ETL from various OLTP and OLAP databases.
  • Write quick test cases and scripts to ensure accurate details, aggregations and totals of the reports for each organization.

Lead Database-SSRS Developer Consultant

Confidential

Responsibilities:

  • Lead a team of three Analysts for the database conversion, migration and validation from various databases into Total Enforcement System.
  • Develop report in BIDS, SSRS and stored procedures.
  • Create complex SQL code to get database objects (tables, types, relationship) from SQL Server schema and load scripts into QAharness Test tool for regression and test automation.

Lead IT Developer Consultant

Confidential

Responsibilities:

  • Lead Developer Consultant (with developers, QA and 4 CSU IT OJT) for the development a new large LGU .Net and BI System. Perform full range of data analysis for solution architectures.
  • Design and develop data model (OLTP/OLAP), tables, reports, stored procedures, views, functions, triggers using Erwin Data Model, SQL-Server, Visual Studio.Net, SSRS, BIDS, Crystal Reports. Install and configure their first SQL-Server, SSRS and Custom Reporting System.
  • Plan all testing scenarios and assign to QA. Build complete system package for testing and create deployment process documents for production. Train lower developer and CSU IT OJT students. Provide training and present system demo to Clients.

Sr. Application Developer

Confidential

Responsibilities:

  • Perform full range of business and data analysis to capture business rules, data flow and convert information into technical and functional specifications of the new/upgrade system and reports.
  • Develop and maintain Communicable Disease ( Confidential ) and Business Intelligence System. Develop complex Confidential reports. Build various .Net System package for Prevention Division and other integration projects. Create deployment documents for production.
  • Design various databases using Erwin data model and perform development in SQL Server 2000-2008r2, SSMS, SSRS, BIDS, SSIS, VB.Net, C#.Net, IIS, Crystal Report, Web Services. Populate table structures and create stored procedures, views, trigger, functions, ETL and scripts. Create end to end deployment processes document and implement Systems for production.
  • Act as a QA lead and develop automated scripts for conversion, migration, transformation and validation of Emergency Management System. Setup QA/UAT area for testing. Train lower level developer on Oracle Data Warehouse reporting system.

Sr. BI-SQL Developer Consultant

Confidential

Responsibilities:

  • Design and Develop Confidential Client Services Reporting System. Develop dashboard, interface and various, medical billing, matrix and statistic reports.
  • Develop automated ETL process for data interchanges to load data and update to proper Client billings. Build system package. Perform unit, module, system testing and deployment.

Sr. SQL-Report Developer Consultant

Confidential

Responsibilities:

  • Assign as a lead Business Intelligence developer for development of new Work Order Asset System. Create data model, System prototype base from functional specs. Create overall test cases; assign simpler task to other analyst and handle more complex tasks while monitoring the project. Build System Package for deployment. Train lower level BI-SQL developer.
  • Enhanced Finance Data Mart Reporting system using SQL-Server tools, Oracle, Teradata, Erwin Model, Visual Basic, ASP, DTS, Crystal Report and ETL. Work closely with DBA. Monitor automated ETL status to refresh Data Mart data which done on weekends.

Sr. Software Design Engineer 3/3 Consultant

Confidential

Responsibilities:

  • Senior Analyst for the major upgrade of MS People HR Data Warehouse from SQL-Server 6.5 to 7.0.
  • Analyzed specifications and prepared overall test cases.
  • Plan and develop stored procedures, T-SQL and VB scripts to validate HR personnel information, row level security access and management level access.
  • Perform Web UI black box and white box testing.
  • Prepare overall test cases result and presented to Manager if system is go or no go with support files.

Sr. Software Engineer

Confidential

Responsibilities:

  • Assign as Lead data modeler and SQL developer of the Company’s on-line electronic retail accessories architecture.

We'd love your feedback!