Lea W.A

To obtain a position in the field of IT; special interest in Database developer. An accomplished database developer (DBD) with experience in designing, coding, testing, and supporting database solution that improves business functionality. Possess strong interpersonal skills and follow specific instructions with a high degree of accuracy. A well-organized person who enjoys working with public. Problem-solving skills and ability to perform multi-tasking are tools to work effectively both independently and as part of a collaborative team. Detail-oriented Computer Systems Engineer committed to improving system design and operations for reliable workflow management. Researches and implements budget-conscious security and encryption solutions to protect user privacy and increase overall network health. Creates easy-to-follow guidelines and troubleshooting documentation for non-technical staff.

• ETL/SSIS Package import/export
• Project designing and scheduling
• Power BI
• Professional Summary:-
• Over 5 years Strong T-SQL experience in creating database objects like tables, Stored Procedures, DDL/DML Triggers, Views,User defined data types, Cursors and Indexes
• Created SSRS report projects in BI Visual studio and created, modified, and managed various report models with multiple objects, source fields and expressions
• Creating BI reports, visualization and dashboards
• Generate a report, which a structured arrangement of information to answer business questions by presenting data in matrices, charts, tables, maps, and such
• Defined the report layout and identified datasets for the report generation
• Developed reports using complex T-SQL queries, user defined functions, stored procedures, and views
• Developed various types of interactive reports like drill down, drill through, gauges, pie chart, bar chart, sub-reports
• Business Intelligence experience in Development, Client Analysis, Database Design, Reporting, and Presentation using SQL Server 2008R2/2012/2014, SSIS, SSAS and SSRS in an agile environment
• Knowledge of complete software development life cycle (SDLC) including Requirement Analysis, Requirement Gathering, Design, Development, Implementation and Testing and Development experience
• Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency
• Involved in designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key, and Unique key) and Indexes
• Developed and Maintained Microsoft SSIS packages including database design, ETL and analysis integrations to meet business requirements
• Integration Service that can extract and transform data from a wide variety type of sources such as json files , xml data files, Flat files, OLEDB, Excel files and relational data sources, and load data to data warehouse databases
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements
• Designed and developed data warehouse, data marts using multi-dimensional models - star schema and snowflake schema
• Implemented different slowly changing dimension methodologies to maintain and update historical data corresponding to dimension tables in the data warehouse
• Followed Agile Methodology to keep track of projects and maintained schedule by being an active participant of daily scrums and bi-weekly sprint
• Create and manage AWS Cloud implementations, compute engine, IAM, Cloud migration cycle, Dynamo DB.