PROFESSIONAL SUMMARY:

• Highly motivated SQL server developer with over 5 years of IT experience in database and business intelligence technologies with expertise on ETL process and Reporting using SQL Server SSIS and SSRS.
• Strong experience with T - SQL (DDL & DML) in implementing and developing stored procedures, triggers, nested queries, joins, cursors, views, user defined functions, indexes, user profiles, relational database models.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS, SSIS and ETL Development with MS SQL 2014/2012/2008/2005.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience in error handling and debugging coding issues and troubleshooting production issues.
• Expertise in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and in SQL Server Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Proficient in creating dynamic SSIS packages for Incremental Loads and used SCD and change data capture (CDC) control task that makes efficient data loading.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Excellent knowledge of scheduling jobs and alerts using SQL Server Agent.
• Experience Configuring and maintaining Report Manager and Report Server for SSRS. Deployed and Scheduled the Reports in Report Manager.
• Good understanding of Normalization /De-normalization, Normal Forms and database design methodology. Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Ability to work in all stages of system development life cycle (SDLC).
• Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Worked with Business Analysts, Web development team, and users on Microsoft Business Intelligence solutions.

TECHNICAL SKILLS:

RDBMS: SQL Server 2005/ 2008/2008R2/ 2012/2014, DB2, Oracle, MS Access

Database Tools: SSIS, SSAS, SSRS, Crystal Report

Languages: VB.NET, C#, C++, T-SQL, E-SQL

IDE: Visual Studio 2003-2012, Eclipse, MS Project 2013

Operating Systems: Windows Server 2000, 2003, 2008, 2012

Case Tools: MS Visio, Erwin

Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential - Arlington, VA

Sr. SQL Server SSIS/SSRS/T-SQL Developer

Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from SQL Server 2012 MS Excel and Flat files.
• Used various transforms in SSIS to load data from flat files to the SQL databases.
• Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process implementation from Initial phase, Ongoing, Deployment to Production Environment.
• Created SSIS packages to mitigate into the data warehouse database from heterogeneous databases/data sources.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Worked on Design and implement row level data warehouse security.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Used Visual Team Foundation server for version control, source control and reporting.
• Advanced extensible reporting skills using SQL Server … Reporting Services (SSRS).
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views using T-SQL code and SQL joins for applications.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.

Environment: SQL Server 2012, 2014 Enterprise Edition, Microsoft Visual Studio 2012 MDX, T-SQL, Oracle PL/SQL, MS Access, MS Excel, Windows 2008 Server, OLAP, Visual basic .NET, UNIX shell scripting.

Confidential - Willington, DE

Sr. SQL BI Developer

Responsibilities:

• Analyze, design, develop, implement and maintain different processes/jobs by using Pervasive Data Integrator and SSIS.
• Assist with implementation of new business, products or contracts by the analysis of business requirements.
• Apply in-depth knowledge of systems and business to the development of technical design for large complex processes and projects.
• Evaluate trading partner requests for new and modifications to existing applications and programs/processes /maps.
• Conduct research and make recommendations on ETL products, services, and standards in support of procurement and development efforts.
• Participate in project meetings, providing input to project plans and providing status updates.
• Assist the team in configuration of Confidential projects. Responsible for collecting, organizing, interpreting and analyzing healthcare data from a wide range of existing data sources for key stakeholders
• Creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Maintain detailed documentation and process flows of all data integration and Confidential processes. Created new and existing processes are appropriately documented, including both technical and user documentation.
• Create and Modify Processes and maps, According to the business. Performing the ETL operations to support the data loads and transformations for Confidential Processes.
• Create Datasets, Maps, also and Process using Pervasive Data Integrator. Handled pipe delimited files, fixed format files in pervasive data integrator.
• Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files and loading into SQL server.
• Created Data Flows for Aggregate, sort, lookup, merge, union all and fuzzy lookups and Used containers for repetitive control flow tasks.
• Worked with production support team for a while to handle high priority issues.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Monitoring of processes to automate the process of loading data into data targets and assist the team to schedule daily/weekly/monthly jobs.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Involved in fine Tuning, Performance and Query optimization of the Database as required by the application.
• Created Json output files by using Pervasive Date Integrator.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Participate in project meetings, providing input to project plans and providing status updates.
• Deployed pervasive process to production servers, scheduled the process to run daily, weekly, monthly loads.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2008R2.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Experience working in formal life cycle methodologies i.e., agile.
• Capable of functioning in an agile development environment, at times extracting data to enable discovery to help refine report specifications.

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Data tools, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Windows Server 2008R2.

Confidential, Addis Ababa, Ethiopia

Sr. SQL Server SSRS/SSIS Developer

Responsibilities:

• Developed complex programs in VB Script, which connects to SFTP server to get the initial data which is in CSV Format, with best execution plan.
• Involved in migration from SQL Server 2005/2008 to 2012
• Used Data Flow task, execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Created SSIS Packages to import the data from different databases, XML, text files, Excel files.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
• Created packages to convert flat file to XML file.
• Convert business requirements into actionable technical requirements for the project.
• Performed data conversions from flat files into a normalized database structure.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned.
• Created awesome dashboards with Power Pivot.
• Developed optimal stored procedures and queries to create data sets for reports.
• Expert in creating Star schema cubes using SSAS.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Sound Knowledge and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Good understanding of SSRS with Report authoring, created weekly and monthly reports as per requirement using SSRS.
• Configured mail tasks to know the job status of SSIS packages.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.
• Designed the ETL for merge operation as migration was to be done in phases with the view of shutting down old processes as transition happens to new data warehouse, old becoming void eventually.
• Build database queries and test cases for the testing team to test the reports.

Environment: SQL Server 2008/2008 R2/2012, SQL Query Analyzer, SQL Profiler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLAP, Crystal Reports, XML, XSL, .Net, Visual Studio 2008, ETL, MS Excel, MS Access.

Confidential, Addis Ababa, Ethiopia

SQL Server Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.
• Worked closely with Business Analysts to produce all required documentation.
• Worked with Product Development Team to architect Database Design and strategy.
• Worked with Business Users to architect Data Warehouse strategy based on reporting, analytical and dishoarding requirements
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Developed SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Migrated data from various sources into SQL Server 2008 using SQL Server Integration Services 2008.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Developed SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert scripts.

Environment: MS SQL Server 2012/2008, SSIS, T-SQL, .NET, Visual Basic 6.0, Performance Point, Data Analyzer, Visual Studio 2010, MS Access, Excel, SQL Profiler, Windows 2007.