SUMMARY:

• Engineering development using .Net, all layers, from database to services to user interfaces
• Expertise in Pentaho 5.4 and 6.0.0, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL 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 in developing, monitoring, extracting and transforming data using Pentaho 5.4 and 6.0.0, SQL Server Integration Services (SSIS), Import Export Wizard, and Bulk Insert.
• Experience in developing, monitoring, extracting and transforming data to a meaningful information using Pentaho data integration and pentaho business analytics.
• 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:

• Pentaho 5.4 and 6.0.0; SSIS, SSRS, Ireports, MS outlook, MS office Tools (MS access, MS word, MS excel, MS PowerPoint, MS publisher…)
• C#, ASP.net, Microsoft Visio 2010, MS Windows XP, MS windows 7, Windows 8.1
• Dreamweaver, EMS SQL Management Studio, SQL, MySQL, MariaDB, PostGreSQL, SQL Server 2008R2, 2012

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines area, Iowa

Senior ETL Developer/BI Developer

• Design, develop, test, Optimize, Deploy and Document ETL data flows to perform all ETL related functions.
• Plan, coordinate ETL and database roll-outs with project team members, development and DBA’s.
• Provide support, maintenance and issue investigation and resolution for font and back-end ETL processes.
• Works closely with the business, other architecture team members and global project teams to understand, document and design ETL processes and needs.
• Participates in the defining, development and implementation of data warehouse and data mart databases and their content.
• Converting existing SSIS Package to Pentaho 5.4 data Integration jobs.
• Model data into a database design (i.e. star schema, snowflake schema, data vault, 3rd normal form, etc.).
• Mentor existing staff on database modeling techniques.
• Working on project teams utilizing Agile principles, practices, and methodologies.
• Subversion Source Control repository.

Environment and tools:

• Windows 7; Unix/Linux/Shell Scripts
• Pentaho 5.4; MySQL; MariaDB; Oracle, XML
• SQL; Stored Procedures, Views
• Ant; Putty; Python, Java/JavaScript; SQLYog; Heidi

Senior Data Developer (contract)

• Follow development & testing procedures from direction & designs of analyst(s)
• Coding, testing, implementing SSIS packages
• Windows forms WPF to allow the users to update some tables records.
• Data Warehouse ETL SSIS and C# scripting within SSIS
• Transact-SQL( Stored procedures, functions, triggers) and SQL server 2012 database management using Microsoft SQL Management Studio
• Creating new SQL server tables/marts and modifying existing ones
• Create new SSIS packages to extract, transform and load data to a new WC unit Stat Reporting database
• Update existing SSIS package to meet the new data model requirement
• Creating interface files by transforming data from the new Policy Administration System database for consumption to downstream mainframe applications
• SQL Server Reporting Services(SSRS), SharePoint, FTP, Infogix balancing and ESP scheduler
• Creating/Modifying conversion routines to load legacy information to the new Policy Administration system at renewal
• Implementing & scheduling new batch jobs

Senior Data Developer

• Designed GUI using C# and Windows forms WPF
• Design and code business logic in C#, XML, Javascript
• Involving in Database Design using MS Visio
• Write Queries and Store Procedures, triggers MS SQL Server 2008R2
• Convert Existing DTS Packages to SSIS Packages in MS SQL Server bids 2008
• Maintain Existing SSIS packages and code behind in MS SQL Server bids 2008R2
• Write a new requirement reports with SSRS to be added to the reporting portal
• Involve in database modeling
• Transform existing Data model to include a new requirement
• SQL server 2012, SQL server 2008R2, SSIS, SSRS, Oracle 10g, Oracle SQL Developer. Oracle Designer
• Customers credit card and purchase metadata management
• SSIS package monitoring and troubleshot
• Performed daily tasks including backup and restore, SQL Server 2008 r2 performance tuning (SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler)
• Agile dev environment

Software & BI Engineer 

• 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.
• Source Code Repositories svn
• C#, ORACLE 10g, Visual Studio 2012, WCF, XML, JavaScript, Oracle SQL Developer Data Modeler 4.0.0, Oracle SQL Developer.
• WCF windows and web services, exposing and consuming data using a variety of bindings and authentications including custom bindings.
• WCF hosted on Windows service parsing automatic export errors files generated by electronic components manufacturing machine into Oracle 10g Database.
• WCF service for Client Java application with HTTP protocol and XML messaging and Client Windows application with TCP protocol and binary messaging.
• MS visual studio C# Windows forms: Integrating Reporting Services Using the reportViewer Controls,
• MS Visual studio C# application encrypts and decrypts coding.
• T-SQL including stored procedures, user defined functions, views and 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 using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix 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.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases
• 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).
• Used SSIS to 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 using SSRS.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.

Confidential,Carrollton Tx 

Programmer analyst 

• 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 operational Drill-through and Drill-down reports using SSRS.
• Developed different kind of reports such a Sub 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.

Database Developer/Administrator

• 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 PostgreSQL Database using PL/pgSQL (DDL, DML)
• Install, configure, maintain and administer Linux Debian operating system
• Install and configure the Media Agent - AIX, HP-UX and 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.
• Worked on developing ETL for supporting data extraction, transformation and loading using Informatica Powercenter.
• Used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Used Informatica scheduler to schedule jobs.
• SQL Server 2008 database OLAP using SQL Server 2008 Analysis Services  
• Developer of electrical equipment database of SONABEL Energy company 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 unit testing with Nunit tool
• 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, JavaScript, HTML, XML, pgAdmin 4.1, ireport.
• Developer of Human resource application using Oracle 10g, PHP, Java, JavaScript, HTML, XML, Crystal reports 2008
• Used JavaScript, HTML, DHTML, IIS and CSS for developing Web Pages.
• Involved in creating web methods for web service.
• Database design and modulation Environmental management using MS visio 2010, PostGreSQL.

Programmer analyst

• 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.