SUMMARY

• 8+ years of total IT experience.
• 5+ years of relevant ETL developer working experience in Microsoft SQL Server environment.
• 1+ year of experience in Big Data and NoSQL database developer like MongoDB.
• Hands on experience in BI Best Practices/Methodologies, Relational structures, Dimensional data modeling, and structured query language (SQL) skills.
• Deep understanding of OLAP, OLTP and Data Warehouse (DWH) architecture concepts.
• Hands on experience in relational databases and ETL/data integration concepts.
• Hands on experience in the design, development and deployment of ETL using SQL Server Integration Services (SSIS).
• Hands on experience in designing logical and physical relational and dimensional data model using Oracle SQL Developer Data Modeler.
• Experience wif complex ETL transformations including using C# for SSIS Scripting
• Extensive noledge of developing various types of reports using SQL Server reporting Service (SSRS).
• Experience in MongoDB document based data base system, none relational data modeling, and CRUD operations.
• Extensive noledge of various MongoDB database design patterns and physical architectures for different use cases.
• Experienced in working through the software development life cycle on the Waterfall model and very noledgeable of the Agile SDLC model.
• Self - motivated, quick learner, goal-oriented, resourceful and innovative team player.
• Excellent team spirit and leadership qualities wif good communication and interpersonal skills.

TECHNICAL SKILLS

Databases: SQL server R 2/2012/2014/2016 , MYSQL, and MongoDB 3.6/4.0

Programming Languages: SQL, Java Script, PHP, Python, C++

Databases Tools: SQL Server Management Studio, SQL Profiler, and MongoDB Compass.

ETL Tools: SQL server Integration services (SSIS), Import /Export (DTS)

Reporting and Analytical Tools: SQL server reporting services (SSRS), Power BI Desk Top.

Data Modeler Tool: Oracle SQL Developer Data Modeler 18.4

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

ETL Developer

Responsibilities:

• Build ETL solution using SQL Server Data Tools to extract files from various data sources and FTP server, store the files in data storage tan load them to staging database.
• Design conceptual, logical, and physical dimensional data model following data dictionary and user document using Oracle SQL data modeler.
• Perform data cleanliness, logic consistency, and result accuracy as per client’s requirement.
• Perform SSIS scripting using C# for complex data transformation.
• Build ETL solution using SQL Server Data Tools to load data to Fact and Dim tables of dimensional data warehouse.
• Used different transformations like slowly changing dimension, Lookup, Conditional Split, Merge Join and others features for incremental data loading.
• Deploy SSIS packages to SQL server Integration Service and create Jobs for loading data to data to production server.
• Support day-to-day performance, monitoring and maintenance of running Jobs.
• Assist a reporting team to optimize the ETL tool to ensure that business requirements are met.
• Planning and implementing capacity expansion in order to ensure that the company’s databases are scalable.
• Engaged in application design and schema less data modeling team discussions for big data in MongoDB environment.
• Design, build and maintain Big Data ETL workflows/pipelines to extract, transform and load data from relational SQL server to a MongoDB test sever using ODBC connector.

Confidential, Silver Spring, MD

ETL Developer

Responsibilities:

• Work wif business requirements analysis to identify and solve business problems.
• Work wif business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Design, Develop and test ETL (extraction, transformation, and load) processes using SSIS.
• Adapt ETL processes to accommodate changes in source systems and new business user requirements.
• Developed and Optimized Stored Procedures and Functions using T-SQL.
• Used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Provide support and fix issues in the packages.
• Excellent experience wif TEMPeffective teamwork in an agile team setting.

Confidential - Addis Ababa, Ethiopia

SQL Developer

Responsibilities:

• Worked wif internal and external clients for import and normalization of third-party data.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Designed, developed and maintained relational databases.
• Implement stored procedures and TEMPeffectively query a database.
• Gatheird business requirements and converted it into SQL stored procedures for database specific projects.
• Developed Data Flow Diagrams, Entity Relationship Diagrams and Data Structure Diagrams.
• Ensured availability and security for database in a production environment.
• Involved in debugging and testing of software modules, documentation, code reviews wif other engineers.