SUMMARY

• A self - motivated, goal oriented team player with demonstrated records of challenging achievements.
• More than 5 years of IT experience as SQL developer, BI developer (SSIS, SSAS, SSRS), Involving in the Design, Development & Support of MS SQL Server 2005/2008R2/2012 in Production, Staging and Development environments.
• MS SQL Server 2005/2008R2/2012, XML, MS Access.
• Writing, Performance Tuning and Optimization of Complex Stored Procedures and TSQL queries.
• Data Modeling using Erwin, MS Visio
• Custom application development using VB.Net, C# .Net Programming
• Migrating, Transforming and Loading(ETL) data using SSIS
• Creating Unified Dimension Models (UDM)/OLAP Cubes using SSAS
• Designing complex managed and Ad hoc reports using SSRS, Tableau, Power Pivot and Power View.
• Windows Server 2008R2,TFS,Share Point 2010

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SQL BI Developer

Responsibilities:

• Extensively worked on profiling data from various health Management Systems.
• Defined and developed logical and physical data models to support business needs.
• Worked closely with the business to ensure data warehouses are able to support all business requirements across the organization.
• Extensive experience in T-SQL programming and created stored procedures, triggers and user defined functions on 2008 and 2008 R2 Servers to meet the requirement of the applications.
• Designed and developed ETL Framework. Log and Audit data of detailed errors, package executions and variable values are stored at centralized database location for later look up and analysis.
• Designed and developed SSIS Package template, so similar development practices are followed by all SSIS developers for logging, configurations and error handling.
• Designed and developed control tables that had to be used by various SSIS developers to store and retrieve source and destination Connection strings information, Incremental column and data info, table and columns names for Meta data driven implementation etc.
• Responsible for developing and unit testing of ETL (Extract, Transform and Load) processes.
• Perform data cleansing and data auditing to ensure data quality.
• Identified slowly changing dimensions and determined the hierarchies in the dimensions.
• CreatedSSIS packagesusing different transformations in SSIS toolbox like aggregate, Merge, Merge join, Pivot, etc.
• Used variousTransformations in SSIS Dataflow, Control flowlikefor loop Containersand Fuzzy lookup to clean the bad data in the tables.
• Involved in designing ofdata warehouse architecture. Defined the Referenced Relationships with the measure groups and fact tables.
• Involved in Full and daily loads (Incremental) intoStaging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Created complex SSAS cubeswith multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Established connections to report server to browse the saved reports on SharePoint Integrated Mode.
• Involved in Report generation using SSRS and Excel services and deployed them on SharePoint Server.
• Deploying and scheduling Reports usingSSRS to generate all daily, weekly, monthly and quarterly Reportsincluding current status.
• Supported the logging framework by generating reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server.
• Configured deployment of SQL Server Reporting Services to work with deployment of Microsoft SharePoint Foundation 2010 or Microsoft SharePoint Server 2010.
• Designed ad hoc SSRS reports in the test environment for data validation using SQL Server 2008.

Confidential, San Diego, CA

SQL Server/ Business Intelligence Developer

Responsibilities:

• Worked closely with the end users in writing the functional specifications based on the business needs.
• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse.
• Created Technical Design Specification Documents based on the functional design documents and the physical data model.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS
• Define strategy for ETL processes, procedures and operations.
• Created and Modified Reports using MS SQL Server Reporting Services (SSRS)
• Involved in source data profiling & source system analysis.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Involved in extracting source data from Oracle, Access, XML, Flat Files, Excel files on different systems.
• Involved in massive data cleansing prior to data staging.
• Involved in performance and tuning the ETL processes.
• Performed validation and loading of the Flat files received from business users.
• Identified slowly changing dimensions and determined the hierarchies in the dimensions.
• Developed complex SSIS mappings to facilitate daily, monthly and yearly loading of data.
• Wrote Stored Procedures, Functions and Triggers according to Requirements.
• Optimized indexes to improve queries and analyzed database performance with SQL Profiler.
• Involved in troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code.
• Interacted with DBA’s about database issues and performed applications tuning by analyzing trace files and explain plans.
• Involved in development and debugging of complex batch Transact SQL Procedures and functions.
• Created various reports using the Report designer in SQL Server BI Studio 2008R2.
• Created several reports using SSRS like drill through reports, linked and sub reports, parameterized reports from EDW and cubes along with its deployment on Reporting Server with various security measures.

Confidential, San Diego, CA

BI/Reports Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specification.
• Documented the technical specifications and generated the reports for the implementation and testing of the application
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query.
• Worked on multiple teams that used elements of agile methodology for creating our applications.
• Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel, Access Database and SQL Server 2008 using SSIS.
• Deploying SSIS Packages on respective server and effectively using configuration files for using same packages on other environments.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Developed Access and SQL Database and wrote queries for data migration and Reporting Services. (SSRS).
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Created data driven subscriptions for different users using Report Manager.

Confidential, San Diego, CA

SQL Developer

Responsibilities:

• Design/develop database using SQL SERVER 2008R2
• Created High level Normalized Database and Detail Design using Erwin.
• Wrote stored procedures, tables, triggers, indexes and views using Detailed Design Specifications.
• Fine-tuned queries, assigned proper Indexes for better performance.
• Prepared Patch and upgrade scripts for service packs and new releases
• Implementation of MS SQL database Replications methodologies.
• Configuration of client workstation with client operating system.
• Prepared trace files using SQL profiler to fine tune the application
• Used visual source safe as configuration management tool.
• Provided training sessions to the SQL developers to maintain the application integrity
• Helped developers and testers in integration testing

Confidential, Addis Ababa, Ethiopia

SQL/BI Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.
• Extensively used System as well as User-Defined functions to enhance the functionality of my T-SQL code.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Implemented SSIS Packages to perform ETL Operations from multiple data sources including excel and text files.
• Was responsible for detecting errors in ETL Operation and rectify them.
• Incorporated Error Redirection during ETL Load in SSIS Packages.
• Developed SSRS Reports like drill through, drill down, linked, sub reports and parameterized reports.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Formatted the reports by applying parameters, and assigned parameter defaults and data types and extended reports.