SUMMARY:

• 6+ Years of experience with MS SQL Server 2005/2008/2012, as a Business Intelligence and back end developer
• 6+ years of experience in data management and database development as a data manager and database developer.
• 5+ years of financial reporting and analysis with excellent Accounting background.
• Expert in financial transactions and report preparation.
• Expertise in developing and designing reports with SSRS and Report Builder.
• Experienced in Data Extraction, Transforming and Loading (ETL) usingSQL Server Integration Services (SSIS) .
• Expert in Ad - hoc, drill down, and drill through reports.
• Experienced in Database design and Implementation.
• Involved in the creation of different scripts and functions using SQL.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008/2012 (SSRS).
• Proficient in creating Index, Views, Complex Stored Procedures and appropriate User defined functions.
• Experienced including analysis, modeling, design, and development of dashboards for analytics.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP system.
• Experienced in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, and Bubbles.
• Experienced in T-SQL scripts, stored procedures, triggers, views, tables, indexes, CTEs, joins, and constraints.
• Excellent Oral and written communication skills.
• Ability to work on fast paced work environment.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training /supporting end users.

TECHNICAL SKILLS:

Business Intelligence Tools: SQL Server, SSIS, SSRS, SSAS, and Report Builder

Health related tools: Health Map per, DHIS, EPI Info, and ARV Drugs Dispensing Tool 2.0

Programming Languages: T-SQL

Development Environment: Visual Studio, SSMS, SQL Server Data Tools (BIDS)TFS, PowerPoint, MS-excel, MS-Access

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

SQL/ BI Developer

Responsibilities:

• Developed different types of ad-hoc reports using complex formulas in SSRS.
• Deployed SSRS Reports to Report server.
• Maintained Error logging using Exceptional Handling in T-SQL and SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate and Conditional split.
• Created databases and schema objects including; tables, indexes connected various applications to the database.
• Implemented Entity-Relationship models and coding using ER diagram.
• Responsible for scheduling the packages through Jobs.
• Involved in creating database objects such as tables, views, stored procedures, triggers, and functions using T-SQL.
• Provided general support on information technology to design, develop, execute, and maintain the database application systems, applying several RDBMS.
• Ensured best practice application to maintain security and integrity of data.
• Documented design and functional specifications.

Environment: Report Builder, SQL Server 2012, Integration Services (SSIS), MS Visual Studio and BIDS, MS-Excel, MS-Access

Confidential

Financial Business Intelligence Analyst

Responsibilities:

• Provided on-going business intelligence reporting and analysis in support of revenue cycle management.
• Handled moderate to large tables/databases, and TSQL.
• Implemented Entity-Relationship models and coding using ER diagram.
• Provided general support on information technology to design, develop, execute, and
• Maintained the database application systems, applying several RDBMS.
• Ensured best practice application to maintain security and integrity of data.
• Maintain database by entering, verifying, and backing up data
• Improves financial status by analyzing results; monitoring variances; identifying trends; recommending actions to management
• Analyze current and past financial data and performance for projection
• Maintain proper Accounting System and control all financial transactions
• Provide financial models and forecast
• Migrated reports from Excel to Reporting Services (SSRS).

Confidential

SSIS/SSRS Report Developer

Responsibilities:

• Extensively used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data.
• Developed ETL processes to migrate and sync processes between two databases.
• Created Mapping, Design and technical Documentation for complex SSIS packages.
• Played an active role during requirements gathering, analyzing and designing.
• Developed various operational Drill-through and Drill-down reports using SSRS with integrated security.
• Developed interactive reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Migrated reports from Excel to Reporting Services (SSRS).
• Managed and maintained reports and subscription on production environment using Report manager.
• Developed Reports for business end users using Report Builder.
• Used SSIS to create ETL packages to extract, transform and load data to a reporting database.
• Developed and Optimized Stored Procedures, Trigger, Views, CTE and User-Defined Functions.
• Involved in designing, building & testing of OLAP cubes with SSAS.
• Interacting with Business Analysts and Developers in identifying requirements, designing and implementing BI solution.
• Documented and maintained user requirement and technical specifications.
• Provided End Users support, technical guides and host training sessions when required for all Business Intelligence applications.
• Working closely with Line of Business to develop and enhance timely and quality solutions.

Environment: SQL Server 2005/2008/2012, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), C#, T-SQL, Windows 2000/2003/2008, MS-Excel, MS-Access, MS Visual Studio and BIDS

Confidential

Regional Data Manager

Responsibilities:

• Served as the focal point for collection, entry, and analyses of ART, PRE-ART, VCT, PMTCT, PIHCT, and other HIV related activities at a central level ensuring timely reporting.
• Assisted in gathering and analyzing data for reports required by funding agencies (CDC and PEPFAR) and other partners and stakeholders.
• Managed hospital Data Managers and Data Analysts, and ensured that comprehensive HIV database reports are received, entered, and analyzed.
• Generated and disseminated regular monthly reports major program activities ART scale-up, PMTCT, VCT/PIHCT, TB/HIV, and palliative care, and social mobilization.
• In close coordination with I-TECH Ethiopia’s, Ministry of Health of Ethiopia’s (MOH), and HIV AIDS Prevention & Control Office’s ( Confidential ) Clinical team, developed reporting templates for data collection and reporting as related to donors and various stakeholders.
• Lead the system of data collection at the central level and prepare suggested formats for use in making computer programming changes as necessary.
• Being a monitoring & evaluation team member set up quality assurance and control procedures, as well as data validation tools to assure the quality, accuracy, and completeness of the data.