SUMMARY
- 3+ years of experience in Information Technology including experience in acquiring Business Requirements, Development, Analysis, ETL Design in MS SSIS, Report Design and Development in MS SSRS, Testing and adopting Data warehouse/Business Intelligence
- 3+ years of database experience in MS SQL Server 20012/2017 (Triggers, Constraints, Stored Procedures, Functions, Views, In - Line Views, Packages)
TECHNICAL SKILLS
- MS TSQL, XML
- SQL Server 20012/2017
- Microsoft Business Intelligence
- Integration Services MS SSIS
- Reporting Services MS SSRS
- SQL Server Mngt. Studios MS SSMS
PROFESSIONAL EXPERIENCE
BI Developer / ETL Developer
Confidential
Responsibilities:
- Conduct requirements gathering sessions with business stakeholders, develop business, technical requirements, & test plans
- Design and develop enterprise and departmental business intelligence, data warehousing and reporting solutions
- Create data models to show key components of source systems and perform profiling of source data
- Developed Tableau data sources to create Tableau reports
- Created SSIS packages that loaded Hyperion Financial data into SQL Server databases
SQL Developer / DBA
Confidential
Responsibilities:
- Designing, developing and implementing SSIS packages to Extract, Transform, and Load (ETL) data into a data warehouse for Business Intelligence, Financial and Operational Reporting for the enterprise.
- Developed stored procedures, User Defined Functions and Triggers
- Maintaining existing databases with maintenance plans for backups as well as maintained Replication
- Designed and Implemented an SSAS cube with requirements gathering and logical/physical design of data augmentation processes needed to support reporting needs
