SUMMARY

• Experience in various Data Base platforms, OLTP and OLAP including SQL Server, Oracle, MySQL, PostgreSQL, Vertica and Mongo DB
• Experience in Pentaho Dashboards with CDE and C tools.
• Worked on the complete Software Development Life Cycle (SDLC).
• Strong knowledge in OOP’s (Object Oriented Programming) concepts and 3 - Tier Architecture.
• Excellent Knowledge in RDBMS Concepts and Data Modeling using Erwin 4.0, Star and Snowflake Schemas.
• Highly experienced in Data Warehousing, ETL and Business Intelligence experience using Pentaho Suite (Pentaho Data Integration/Kettle, Pentaho BI Server, Pentaho Meta Data and Pentaho Analysis Tool & Mondrian OLAP and Ctools).
• Experienced in developing Data Warehouse architecture, ETL framework and BI Integration using Pentaho Reports and Pentaho Dashboards.
• Experience in Installations, Up-gradations, Configuring MS SQL Server
• Experience in performance tuning, stored procedures, Database tuning wizard.
• Hands on experience overall ETL (Extract Transformation & Load) process.
• Strong Knowledge on MS SQL Server Integration Services (SSIS)
• Experience in designing Database Models using Microsoft Visio and creating class diagrams, activity diagrams, use cases diagrams, and flow charts using UML.
• Hands-on experience on Data Warehouse Star Schema Modeling, Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling.
• Extremely motivated, diligent, conceptually strong team player
• Detail-oriented, results-driven, excellent verbal and written communication skills
• Experience with software development methodologies and practices (SDLC, Agile, Scrum, Waterfall, DSDM
• Fulfilled Data Architect Role Designed ETL and Reporting FRAMEWORK and structure.
• Knowledge in Big Data Technologies as KAFKA and Apache Spark
• Strong Guidewire Knowledge with the Insurance Industry (Policy Center, Claim center, Billing Center)
• Experience in Data Migration and Guidewire Claims/Policy Migration analysis
• Strong understanding of Legacy Systems and programs written in Cobol
• Experience in PENTAHO Enterprise Administration BI Server including Installation, Assigning User Roles and Credentials on the Pentaho Server Side

TECHNICAL SKILLS

Business Intelligence: Microsoft & Pentaho BI Tools

Databases: Oracle 10g, SQL Server2012/2014, MySQL, MS Access

Tools: MS Visio, SAS/Access, Crystal Reports8.5, 10, XI, R2, Business Objects, MS Project, MS office 2003/2007/2010/2013

Operating Systems: Windows XP/Vista/7/8, Windows NT/2000, Windows Server 2003.2005.2008

Programming Languages: T-SQL, PL/SQL C, C++, HTML, XML, MYSQL, VB.NET, ASP.NET, .NET Frame Work, C#

Query Tools: Toad, SQL Plus, SQL Developer, SQL Server Management Studio, MySQl Query Browser

FTP Tools: Putty, OPENPGP

Pentaho Suite: Pentaho Data Integration (Kettle), Pentaho BI Server, Pentaho Analysis Tool, Pentaho Report Designer, Pentaho Mondrian, Pentaho Metadata Editor, Pentaho Design Studio, Mondrian OLAP Server, C Tools

Reporting Tools: Tibco Spotfire, SAP Business Objects, MS Access, MS Excel

Data Modeling: ERWIN, MS Visio, ER Studio.

PROFESSIONAL EXPERIENCE

Confidential, MI

Senior ETL Developer (Pentaho)

Responsibilities:

• Migrated All Reporting Legacy systems and built Data Marts to handle all reporting.
• Created Data Marts to store all needed data for reporting based on the Requirements.
• Involved in development, testing and migrate the data from DEV to TEST.
• Designed Data Profiling and Data Validation procedures to ensure data Accuracy.
• Pentaho Suit tools were used to design the source definition, target definition and transformations to build mappings.
• Created Triggers in T SQL to enforce data and referential integrity.
• Created complex mappings which involved Slowly Changing Dimensions and implementation of Business Logic.
• Implemented Change Data Capture code to optimize performance and Error handling scenarios to ensure efficiency.
• Work with management, staff, Data Architects and vendors translating business reporting needs and/or operational reporting requests into technical requirements.
• Worked as a DATA ARCHITECHT designing the whole Framework for ETL Code required to extract Data from Legacy Systems, Staging Data and Loading Data to Data Marts and Data Warehouse including Planning for Projects Deployment Strategy from Dev to Test to Production and Coordinating with the Network and Infrastructure Team.
• Worked with DBA on assigning users and roles specifically for ETL developers. worked with Business and Programmers of Legacy systems to get Requirements and translated Business Logic into SQL Code.
• Involved on data base analysis and provided methods of cleansing data and data quality projects.
• Designed Logical Models of Proposed Data Mart Projects and Gave architectural direction on Validation Rules.
• Worked with various developers in Conversion Team, Data analysts, System analysts, Legacy Systems developers (Cobol) and coordinate how the Data will be handled and landed in Data Warehouse and data marts.
• Adapted Agile methodologies along with Water Fall Methodologies.
• Done many technical researches to make the best use of the evolving technologies to help developers.
• Provided architectural direction for Data Acquisition, Conformance and Delivery.
• Maintained the Enterprise Data Repository.
• Designed Databases and provided DDL scripts as well as Data base constraints and triggers to ensure capturing all enterprise data in staging databases.
• Worked on Project optimization, including database performance tuning, and ETL performance tuning.
• Provide technical knowledge on data architecture related trends, issues, and tools
• Designed, modified and maintain logical and physical dimensional data model.
• Was responsible for All tiers of launching worker Compensation Reporting project up till day one production including Development, Testing, Data analysis and production
• Designed Jobs for Automation.
• Worked on upgrading Pentaho to version 6.1 then to version 7.0.
• Worked in mapping Logic of Legacy Programs written in Cobol into complex SQL queries, Functions, triggers building Data marts with Pentaho Data integration
• Worked on Policy Center / Claim Center GYUIDEWIRE Conversion. Translating Business Logic into Requirements and thus helped in launching Guidewire
• Created, designed, and executed the test plans and test cases including the below
• Validation of data movement from the source to the target system.
• Verification of data count in the source and the target system.
• Verifying data extraction, transformation as per requirement and expectation.
• Verifying if table relations - joins and keys - are preserved during the transformation.
• Implemented Data transformation and data quality testing as well as Regression and incremental testing, Retesting and System integration testing.

Environment: Pentaho 5.4,6.1,7.0, SQL Power Architect, Visio 2013, SQL Server 2014, Octopus Deployment Tool, Power shell 4.0, Windows Server 2014

Confidential, Alpharetta, GA

Network and Control System Admin

Responsibilities:

• Handled Customer Phone and email communications concerning their equipment.
• Configured and loaded operating systems on computer systems.
• Networked the PC’S together to form one control system.
• Loaded application software to allow integration with PLC portion of control system.
• Tested all connections, Circuits, and Programs for basic functionality.
• Studied the Data structure in the company in preparation for the new Data services project initiated for building New Data Warehouse for the company.
• Helped with analysis for selecting ETL Tool as Pentaho suite for the Proposed Data Integration Project.
• Worked with DBA on setting Roles and ETL credentials

Environment: Windows Server 2012, SPPA T3000 Application Server, CISCO Config Manger. SQL SERVER 2012, FT SERVER 4300/4400, SP3 and SP4 DR Server MX.

Confidential, Alpharetta, GA

BI Developer TRAINEE

Responsibilities:

• Trained on new technologies like Tableau and Spot fire reporting tools.
• Furnished my skills in Pentaho Suite learning Advanced ETL Techniques and Dashboard development.
• Completed some Advanced courses for Passing MS SQL Server Certification (MCSA 70-461) and Pentaho Certification.
• Designed Pentaho Dashboards with CDE and Integrated C tools.
• Managed and edited existing Dashboards and published reports and Dashboards to Business based on Requirements.
• Worked on Designing and Implementing a whole BI project for Philips Health care Call Center Customer Service Data Mart and its companion BI Reports, Dashboards and Score Cards.

BI/ Pentaho Developer

Responsibilities:

• worked on projects for Insurance, Call Centers, financial Domains using Pentaho PDI.
• Analyzed data, Designed Data marts, Implemented ETL logic using Pentaho CE. 6.1
• Furnished my skills with different DBMS as MS SQl, Oracle and MySql, Postgre DB.
• Designed Pentaho Dashboards with CDE and Integrated C tools.
• Managed existing Dashboards and Designed Reports using Report Designer.
• Implemented Test use cases for ETL testing, ensuring code quality.
• Worked on DBA Tasks for MySQL PostgreSQL.
• Got Knowledge with Cloud Computing like AWS, Azure.

Environment: Oracle 11g, PL/SQL, SQL SERVER 2012, MySQL 6.1, PostgreSQL 9.1, Pentaho 5.3, Windows 7, Windows 10, MS Visio.

Confidential

Senior BI/ETL Pentaho Developer and Data Architect

Responsibilities:

• Did complete architecture of Business Intelligence Infrastructure for ISP using Pentaho Suite (PDI/Mondrian/Metadata) for ISP developer Console and publisher console.
• Created jobs to pull the data from the staging tables in PostgreSQL.
• Supported Data warehouse including star schema design and DW capacity planning.
• Created jobs to pull the data from the staging tables in PostgreSQL.
• Modified existing Oracle PL/SQL code of stored procedures, functions using TOAD.
• Converted all database code including stored procedures, functions and triggers written in PL/SQL into T-SQL to be created in new system running on SQL Server Database.
• Identified, tested, and resolveddatabase performance issues(monitoring and tuning) to ensure database optimization.
• Created triggers on master data tables in OLTP to keep track of insertion and updates.
• Actively participated in all phases of system development life cycle starting from requirement gathering all the way up to deployment in production and system testing.
• Experience extracting data from Oracle EBS and SAP ERP Systems, staging data to files.
• Act as Team Lead for Offshore and on site Junior Developers ensuring Quality of ETL.
• Implemented Test use cases for ETL testing, ensuring code quality Including Unit testing, Data transformation testing, Incremental testing, Regression testing.
• Worked on Administering Database including MySQL PostgreSQL.
• Got Knowledge with Cloud Computing like AWS, Azure.
• Developed Business Architecture using Requirements such as Scope, Processes, Alternatives and Risks.
• Engaged Client to gather Software Requirements/Business rules and ensure alignment with development teams.
• Translate stakeholder requirements into tangible deliverables such as functional specifications, user cases, Workflow process diagrams, data flow /data model Diagrams.
• Evaluate risks related to requirements implementation, testing processes, project communications and training saving the company on average 5,000$ Plus.
• Identify and reconcile errors in client data to ensure accurate business requirements.
• Communicate client’s business requirements by constructing easy-to-understand data and process models.
• Facilitate Monthly meetings with clients to document requirements.
• Conduct 5+ level of testing including functional, regression, user acceptance, integration and performance to verify the client’s need are met.
• Analyzed Data using SQL Server analytical queries to understand and analyze data.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer, MS SQL Server2005/2008,SQL Server Integration Services (SSIS), Oracle 10g, PostgreSQL Access 2003/2005,Enterprise ManagementStudio, MS Query Analyzer, SQL profiler and SSRS.

Confidential

BI Developer

Responsibilities:

• Done DBA activities, on SQL Server Like Installation, Upgrades, Backups, Monitoring.
• Modified existing Oracle PL/SQL code of stored procedures, functions and packages.
• Created and executed SSIS packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source (Oracle), flat files, XML files, CSV files and Excel Spreadsheets to SQL Server 2005 and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Implemented conceptual database design into SQL Server using various constraint and triggers.
• Used Oracle Enterprise Manager for troubleshooting, monitoring, and optimizing of Oracle
• Involved in creating logical and physical models of the database using Erwin and Visio.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation and data extraction.
• Used Oracle UTL SMTP package to send email messages using the database as an SMTP mail server.
• Used Oracle UTL FILE package to read and write files on the host operating system.
• Interaction with business and technical teams across geographic boundaries, with clients, technical architects, project managers, requirements analysts and testing teams.
• Provided 24/7 production support for the production database

Environment: Oracle 10g, PL/SQL, Toad, SQL Loader, Oracle SQL Developer, SSIS, Oracle Enterprise Manager, SQL Server 2000/2005, SQL Agent, Visio, Erwin, HP-Unix, Linux, Windows XP/Vista/2003 Server, Visual Studio .NET 2005.