SUMMARY

• Engineering development using .Net, all layers, from database to services to user interfaces
• Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS) with good knowledge onSQL Server Analysis Services(SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience indeveloping,monitoring, extractingandtransformingdata using SQL Server Integration Services (SSIS), Import Export Wizard, and Bulk Insert.
• Analysis and design of databases and user interfaces
• Implementing software development life cycle policies and procedures
• Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills
• Accomplished SQL server, Oracle and PostgreSQL Databases Specialist: experienced database administrator, data modeler, SQL and PL/SQL (DDL, DML) developer.
• Experience with Oracle9i, 10g, SQL server 2005/2008 and PostgreSQL9.1 under Unix and Windows, in production support and development environments.
• Strong knowledge of database performance tuning, monitoring, database backup and recovery, installation, configuration, upgrading and patching of Oracle software and databases, data modeling. Self - starter and quick learner with excellent analytical, problem solving and communications skills.
• Ability to work as a team member and as an individual contributor.

TECHNICAL SKILLS

• C#
• ASP.net
• Microsoft Visio 2010
• MS Windows XP
• MS windows 7
• Dreamweaver
• EMS SQL Management Studio
• SQL
• MySQL
• PostGreSQL
• SQL Server 2008
• SSRS
• SSIS
• Ireports
• MS outlook
• MS office Tools (MS access
• MS word
• MS excel
• MS PowerPoint
• MS publisher…)

PROFESSIONAL EXPERIENCE

Confidential, Iowa

Software Engineer / BI Engineer

Responsibilities:

• Requirements, Design, Development, Test and Release software processes, tools, methods and coding best practices with primary emphasis on software design, development.
• Design, code, and integrate regression testing, test and document software.
• C#, ORACLE 10g, Visual Studio 2012, WCF, XML, JavaScript, Oracle SQL Developer Data Modeler 4.0.0, Oracle SQL Developer.
• MS visual studio C# Windows forms: Integrating Reporting Services Using the reportViewer Controls,
• MS Visual studio C# aplication encrypt and decrypt coding.
• T-SQL including stored procedures, user defined functions, views, query optimization.
• Designed and created database schemas, views, stored procedures, triggers and functions. Created various reports in SSRS called from .NET front-end.
• Converted Data Transformation Services(DTS)application to SQL Server Integrated Services (SSIS)as assigned.
• Created complex stored procedures, triggers and cursors in SQL server
• Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Designed dynamicSSISPackages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports usingReporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server 2005to SQL Server 2008.
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments Oracle, SAP Quality Assurance, SAP HR Quality Assurance, Excel, MS Access, text files.
• Create the Data Warehouse Model to store atomic level data and the summarized data.
• Performed Dimensional Data modeling and created Star Schema and snow Flake Schema data model to meet the OLAP needs.
• Create a protocol data warehouse and provided the OLAP front end to show the drill Down, Roll Ups, Pivoting, Slice and Dice feature.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• UsedSSISto unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load (ETL) development Using SQL server 2008, 2012 Integration Services (SSIS).
• Generated several drill down and drill through reports usingSSRS.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.

Confidential

Programmer analyst

Responsibilities:

• Data Migration Project: Migrate Sara Lee company in South Sioux City, Nebraska and Sara Lee company in Sioux Falls, South Dakota, IT equipment, user accounts, and exchange accounts to the Bimbo Bakeries (BBU) domain.
• Designed, created and managed database using MS Visio 2010.
• Develop data models according to company standards.
• Create and administer a SQL Server Database using T-SQL (DDL, DML).
• Maintained and optimized SQL server Database Queries, Stored procedures, triggers.
• Migrate SQL server database to PostGreSQL 9.1 database using ESF Database migration toolkit.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Study an existing data model and change it according to the changes in the business.
• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.
• Developed various operationalDrill-throughandDrill-downreports usingSSRS.
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Application project “address book” using C#.net, ASP.net, MS visio 2010, SQL Server 2008, SSRS,
• Microsoft access database Engine 2010 redistributable installation and configuration;
• Import data form Microsoft Excel to Microsoft Access with Get External Data tool.
• Export data to Microsoft Excel from Microsoft Office Access by using the report wizard in office,
• Write Vba code in Excel and record Macros to automate tasks in Excel 2010,
• Microsoft Visual C# 2010 and SQL Server 2008 technology for building application program "Simple Text Editor”.
• Create and administer a Postgres Database using pgAdmin 4.1
• Created SQL queries for diverse usage; ensured integrity of data with frequent restoration and back up using pgAdmin 4.1, PostGreSQL.

Confidential

Responsibilities:

• Compassionate assistance to people in the disaster,
• Assist people to carry out their materials in the flood
• Assist householder to protect their house again another flood in the future
• Look for new place (apartments) to live for people in need,
• Collect some clothes and some foods for people in need

Confidential

Database Developer/Administrator

Responsibilities:

• Designed, created and managed database using MS Visio 2010.
• Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements;
• Create and administer a Postgres Database using pgAdmin 4.1, PL/pgSQL (DDL, DML)
• Development and manage a Postgres Database using PL/pgSQL (DDL, DML)
• Install, configure, maintain and administer Linux Debian operating system
• Install and configure the MediaAgent - AIX, HP-UX, Firewall.
• Experience as an Unix (AIX, HP-UX, Open Server) and Linux Ubuntu 10.10 System management;
• Experience in Linux system installation, configuration, administration, the development and testing of backup and recovery methodologies, troubleshooting, monitoring and alerting setup and security hardening;
• Migrate PostgreSQL 8.4 database to PostGreSQL 9.1 database using pg dump and pg dumpall on Linux platform;
• Migrate Oracle 9i database to PostGreSQL 9.1 database using ESF Database migration toolkit.
• Created SQL queries for diverse usage; ensured integrity of data with frequent restoration and back up using pgAdmin 4.1, PostGreSQL.
• Performed Data Gap Analysis in current data warehouse,
• Assisted with project and problem analysis, effectively communicate with management and adhere to Bank’s policies and procedures.
• ETL (Extract, Transform and load) data in distant databases using Informatica PowerCenter and SQL Server Integration Services (SSIS).
• SQL Server 2008 database OLAP using SQL Server 2008 Analysis Services
• Developer of electrical equipment database of SONABEL Energy company using using C#.net, ASP.net, MS visio 2010, SQL Server 2008, SSIS, SSRS,
• Developer of training and improvement competencies database of SONABEL Energy Company using C#.net, ASP.net, MS visio 2010, SQL Server 2008, SSIS, SSRS,
• Developer and administrator of Geographic Information System application using ARCGIS 9.1, C#.net, ASP.net, ARCVIEW, SQL Server 2005 / 2008, EMS SQL Management Studio
• Developer and administrator of Socio-economic application using PostGreSQL, PHP, Java, HTML, XML, pgAdmin 4.1, ireport.
• Developer of Human resource application using Oracle 10g, PHP, Java, HTML, XML, Crystal reports 2008
• Database design and modulation Environmental management using MS visio 2010, PostGreSQL.

Confidential

Programmer analyst

Responsibilities:

• Create and develop database using pgAdmin 4.1;
• Create and develop Geographic information system (GIS) using Postgres Database, VB.net, ASP.net, ARCGIS 9.1, 2005,
• GIS database administrator using PostGreSQL, pgAdmin 4.1,
• Application program “System Information Foncier” using PostGreSQL, pgAdmin 4.1, VB.net, ASP.net, ArcView 3.2a, Google Map, Crystal reports
• Application program “Management system of electric equipment” using Oracle 9i, VB.net, ASP.net, ArcView 3.2a, Google Map, Crystal reports.