Sign in

Developer Project

Charlotte, North Carolina, United States
85,000 +
August 22, 2018

Contact this candidate



**** ******* *** ******, ********, NC 28105 W: 301-***-**** H: 980-***-**** Professional Summary

• Hard working and effective BI developer who has five years of expertise seeking a Developer Position where a strong understanding of technology and a project management background can be best utilized.

• Experience in implementing and supporting Microsoft BI solutions who was involved in all stages of BI project Work (requirements and logical design, physical design, implementation, testing, and deployment).

• Strong BI implementation methodologies and had in-depth experience with the Microsoft BI Stack (SSIS, SSRS, and SSAS).

• Proven Skills in Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs

Certifications and Credentials

Certified Business Intelligence Professional (CBIP) Project Management Professional certification (CIPM) Fellow of American Academy of Project Management (FAAPM) Project Management Using Microsoft Project office

Data Analysis Using MS Excel

Data Quality Management Training

Technical Skills

Operating systems: Windows Server 2008/2003 BI/Reporting Tools: SSRS 2008,

/XP/Vista, Windows 7/8/10 2008R2/2012/2014 (BIDS and SSDT), Report Office Tools: MS Word, PowerPoint, MS Excel, Builder 3.0 & Power Pivot MS Outlook, MS Project GUI, and tools: SQL Server Management Studio, RDBMS: MS-SQL Server 2008- 2016 Visual Studio & Excel Pivot ETL: SQL Server Integration Services, Data Language: Structured query language (SQL) Transformation Services -TSQL, SSRS & SSAS,XML

Development Methodologies: Agile, Waterfall,

Software Development Life Cycle (SDLC)

Professional Experience

BI SSIS/SSRS Developer 03/2016 to Current

South East Mortgage Company Charlotte, NC

Involved in complete ETL life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production). Designed and developed SSIS Packages to import and export data from Excel, XML FTP, SQL Server and Flat files.

Utilized advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting)

Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis. Involved in ETL architecture enhancements to increase the performance using query optimizer, Implemented Event Handlers and Error Handling in SSIS packages. Experience in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating datasets required for further analysis.

Developed various types of custom reports including features such as matrices with drill-through functionality, Ad hoc reports, cascading parameters, subreports, and all available charts. Developed complex interactive dashboard report reports with Drill Down, Drill through, Cross tab reports

(Parameterized), bar charts, graphs 3D objects, pie charts, and KPIs. Created automated subscriptions like emails and file share for weekly, monthly quarterly and annually schedule reporting.

SQL Developer 03/2015 to 02/2016

Cardinal Financial Charlotte, NC

Created and maintained database objects such as Views, Stored Procedures, User Defined Functions, and Triggers using T-SQL in SQL 2012.

Implemented Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans.

Prepared Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.

Collaborated with clients, the business analyst, technical staff, and project team members to plan, design, develop, implement, and enhance applications

Processed importing and exporting data between Microsoft SQL Server Database tables, Microsoft Access, XML files, text files, and Microsoft Excel files. Extensively used excel for data visualization. Particularly, data compilation and consolidation were carried out using T-SQL and excel is used for reporting purpose. BI Developer 04/2013 to 02/2015

Pact Inc Washington, DC

Involved in Technical decisions for Functional requirements, Data Mapping, Data Directory. Interaction with Business Analysts, Client team, Development team.

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. Built different types of reports using Reporting Service (SSRS) for the business requirement. Involved in creating new databases, performance tuning, deploying, scheduling and creating reports. This included writing T-SQL backup and create various operational, drill-through and dynamic reports using SSRS.

Generated ad-hoc and parameter-driven reports using Microsoft T-SQL, SSRS and communicated project status to management as well as clients on a regular basis. Experience in using EXCEL and its data summarization tools including PivotTables, PivotChart, PowerPivot and Power View Participated and provided feedback in an enterprise SDLC that included interaction with project sponsors, managers, business users, and developers. Education and Training

Certification: Certified BI/EDW Developer 2017

Collaberry School of Data Analytics Plano, TX, United States Certification: Project Management 2013

The American Academy of Project Management USA

Master of Arts: Development Studies 2012

Indira Gandhi National Open University New Delhi, DL, India Bachelor of Arts: Social Science and Humanities 2001 Addis Ababa University Addis Ababa, Addis Ababa, Ethiopia

Contact this candidate