PROFESSIONAL SUMMARY:

• 10+ years of information technology experience with Requirements gathering, Analysis, Design, Configuration, Develop, Test, Administration and maintenance of Applications and ETL Processes, Databases and Data Warehouses and Reports development.
• Strong experience in Business Objects data services/Integrator XI/ 3.2/4.0/4.2.
• Expertise in Database Design, Data Modeling, Data profiling, Data Quality, Address Cleansing, Data Cleansing, Data Migration, Data Conversion, Data Integration, Data Transformation, Data Remediation, Data Validation, Data Reconciliation, Data Marts, Data Mining and Data Audits.
• Experienced with overall BODS architecture.
• Expertise in SQL, PL/SQL Procedures, SQL Query Execution Plans, Database Design & Maintenance, Scripting, and Programming.
• Expert in Data Quality to Parse, Standardize, Cleanse, Enhance, Match, Consolidate, and Validate Data.
• Experience in Star, Snowflake schema defining Logical and Physical Data Modeling.
• Capable to migrate, synchronize and replicate data among different operational systems and data sources.
• Experience in SAP BO 4.0, 4.1 building Universes, Dashboards, WEBi Reports by extracting data from Relational Database, BEx Queries and SAP BW Cubes.
• Expertise in SAP BI/BW 7.3, 7.1, 3.5 with SAP R/3 (ECC) 6.0/5.0, BOBJ 4.0 and BOXI R3.1
• Extensive experience of SAP BW/BI components like Standard InfoCubes, DSO's, InfoObjects, MultiProviders, DataSource, InfoSets, Virtual Providers, SPO, Hierarchies, Start/End/Transfer Routines, Open Hubs, Transformations, Transient Providers, Composite Providers, IDocs, User Exits.
• Strong leader with experience in developers and advising technical groups on ETL best practices.
• Team player with excellent communication and problem solving skills.
• Efficient in working with Oracle 11g, MS SQL Server 2012 running on Windows.
• Expertise in conducting corporate s for the end users.

PROFESSIONAL EXPERIENCE:

Confidential, Folsom, CA

WorkFlow Consultant

Responsibilities:

• BPM WorkFlow development and support to the clients of Confidential .
• Plan, design and development and configuration of Agents/Agency Onboarding Application.
• Used to create new Form, Custom Field, Section and Objects configuration and Scripting.
• Development of various scripts WorkFlow, Asynchronous, Form Event using Groovy.
• ICM database interaction using SQL scripts
• Error Handling and Performance development.

Confidential, Sacramento, CA

Senior BODS Developer

Responsibilities:

• Responsible for Creating and maintaining Jobs, Workflows, Data flows, Data stores, Template Tables, Flat files
• Configured Central Repository, Profiler Repository and added User roles
• Implemented SCD Type 2 Concept for Large Volume Data
• Worked on Management Console for Job Scheduling, Tracing, Monitoring, Editing Repositories, Job Servers.
• Performed Elementary Job analysis from Operational Dashboards and generated documents from Auto Documentation in Management Console
• Good knowledge on Transforms & Custom function.
• Worked on Data quality (data cleansing, standardization, duplicate entries) with larger Data volume.
• Performed Validation, Enrichment, Data staging.
• Used almost all the transforms from Data integrator, Platforms, Data quality.
• Wrote Scripts, Custom Functions with Global Variables.
• Used most of the String functions, lookup functions, Aggregate functions, Mathematical functions
• Provided complex SQL solutions.

Confidential

DBA / BO Admin

Responsibilities:

• Adopted the responsibilities to understand the system of Microsoft Dynamics AX for POS and Finance.
• Built the data warehouse for AX Database and SSIS package to load data into data warehouse.
• Used BusinessObjects Business Intelligence 4.x to develop Universe, Webi, Dashboard, Crystal Reports, Scheduling Jobs and CMC Tools.
• Responsible for BO Admin, User and Group Creation, Monitor/Execute Jobs using Instance Manager
• Installed & configured BusinessObjects Data Services (BODS) 4.0 for ETL.
• Responsible for Extraction Transformation and Loading data using multiple databases, Oracle db and SQL db and etc.
• Created BODS Batch Jobs for extracting data from POS transaction database to reporting database.
• Used various Transformers and functions from BODS to make information for top management reports and various department users reports
• Used Slowly Changing Dimensions techniques to import new data and to preserve history data
• Interaction with users and create/modifying reports to reach user satisfaction.
• Responsible fine tuning report performance, troubleshooting in data import/export

Confidential

Sr. Application Developer / BI Developer

Responsibilities:

• Responsible to gather business requirements and deliverables for report requirements along with functional end users in the business areas. And analyzed to identify business content data sources for Enterprise Data warehouse.
• Instrumental in bringing SAP BusinessObjects 3.1 for BI.
• Experience in version upgrade to 4 and reports migration
• Installed & configured BODS XI 4.0
• Created BODS Batch Jobs for data extraction from operation tables and to load report database.
• Used BODS various Transforms (Case/Merge/Query), Joins and used Slowly Changing Dimensions to import new records and preserve history records.
• Using BW designed and developed custom DataSources, Info Sources, Extractors, Info Cubes and DSO'S to fulfill user requirements.
• As part of the performance tuning created aggregates for info cubes.
• Involved in review for various objects and created test case and test plans in different environments.
• Performed Master data and Transaction data extractions (SAP, Non - SAP) and automated the data loads using Process Chains.
• Created Process chains for parallel data loads, and scheduled them at off-peak hours to reduce the system load.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Used Structures, Calculated key figures, restricted key figures, selection, Formula, exception and conditions.
• Troubleshoot BI tools, systems, and software.
• Universe Design: Universe planning building and implementation, design methodology, Creating Classes, Objects, schema, store procedures.
• Web Intelligence: Created Advance multiple Reports, Ad hoc query, tables, charts, Complex Filters customized formulas and highly formatted page layouts.
• Implemented Auto alerts to managements and key peoples about Sales vs targets reports in daily/weekly/monthly basis.
• Xcelsius: Creating chart with visualizing data range, Series, interactive model, map with graphics, Query as a Web Service.
• Crystal Reports: Planned, created formatted reports, multiple groups, Integration with SAP Data Source, manipulation formulas, applying conditions and exporting reports to Excel and Word.
• Connecting BO using SAP and MS Sql Server for reporting
• Extensively worked in INFOVIEW to create Web Intelligence Reports over the Universe Created.
• Extensively worked in CMC tools Management & Administration
• Gathering user requirements and developing business applications using VB 6.0, SDLC
• Design of databases and data warehouses, database backup, data import/export, schedulers, database link, sql scripts and performance monitoring from MS Sql Server
• POS application modifications, maintenance and support.
• Back office application development and maintenance.
• IT related presentations to senior manageme