Chirag Mavani

ETL Developer/SAS BI/DI Consultant

+91-990**-***** actvo9@r.postjobfree.com

ABRIDGMENT

3.5 years of extensive IT experience in SAS Business intelligence and data warehousing, quick learner with excellent problem solving skills.

Worked with SAS DI Transformations Append, Extract, Table Loader, Lookup, SQL Join, SCD type 2 and User written Transformations.

Developed custom marts using SAS DI and custom reports for banking solution.

Experience in testing SAS DI solutions and support activities.

Knowledge of SAS programming in analyzing the Data, generating reports, tables, listings and graphs.

Established a change management environment.

Pre-process and post process coding for all jobs.

Working with Table Loader transformation, managing indexes and constraints during loading, bulk loading DBMS tables.

Analyzing metadata using impact analysis, comparing tables, conditional execution, exploring metadata promotion, exploring version control, establishing, and checkpoints.

Used SAS Management console to Schedule various jobs.

Knowledge in Data Warehousing Methodologies, SAS Data Integration Tool, SAS Business Intelligence Tools, and Database concepts.

Good knowledge of SAS Functions, Procedures, Formats and Informats.

Knowledge on Data analysis, Data validation and Data quality checks, Data extraction and loading into Data Warehouse.

Experience in SAS BI tools i.e. SAS Data Integration Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Management Console, SAS Enterprise Guide, SAS Information Delivery Portal, SAS BI Dashboard and SAS OLAP Cube Studio.

Worked on SAS banking DDS (Detail Data Store), SAS Banking solutions such as Customer analytics for Banking, familiar with foundation mart and reports.

Knowledge of SAS Programming in analyzing the data, generating reports, listings and graphs.

Experience in different domain like banking, retail and insurance.

SKILLS

SAS EBI/BI: SAS Data Integration Studio 4.2, SAS Information Map Studio 4.2, SAS Web Report Studio 4.2, SAS Management Console 4.2, SAS OLAP Cube Studio 4.2, SAS EG4.2, SAS Add-in for MS Office, SAS BI Dashboard 4.2, SAS Information Delivery Portal 4.2, SAS Stored Process

SAS Foundations: Base SAS, Advanced SAS, Proc SQL, SAS Macros, Statistical Procedures.

Platform: Windows, UNIX.

TRAINING

Creating Business Intelligence for your organization : Fast track

Data Integration Studio : Fast track

EXPERIENCE

Sr. Software Engineers at Zensar Technologies [May’12 – Present]

Client : Kuwait Finance House, Malaysia.

Role : SAS DI/BI Consultant

Project : Customer Analytics for banking

Description : A custom SAS Customer analytics solution for banking was developed. Source data originated from core banking system, loan originating system, mortgage, and credit card system. Data was staged and loaded into Banking DDS and a custom mart was created for analysis and reporting.

Technologies : SAS DI, SAS BI, SAS 9.4, SAS CAB (Customer analytics for Banking) Solution, Baking

DDS (Detail Data Store), Oracle, UNIX

Key Role:

Involved in initial requirement gathering meetings just to get an idea about project.

Given feedback in data mapping sessions, has done basic mapping from old system.

Responsible for creating low level ETL framework such as metadata folder structure, job status capture mechanism, exception handling, libraries definition, data loading sequence, transformation properties, job properties etc.

Developed DI jobs to load data from source flat files to target tables, using staging tables in between.

Worked on SAS DI Studio, Data Extraction, Transformation and Loading of data.

Used file reader transformation to read data from source files, validated using data validation transformation and loaded data using table loader transformation in to staging table.

Improved job performance by using indexes, parallel processing, run SQL in multi-threading, views and Pass through facility.

Accessed and modified data in Oracle using SQL pass through.

Scheduled job and performed Column addition in metadata and physical table using SAS DI Studio.

Used transformations such as SQL join, Lookup, hash objects, Data Validation in different jobs.

Developed, Maintained, Scheduled & Monitored ETL jobs.

Implemented SAS Information maps with SAS Information map studio using relationship between tables with filters, joins, prompts, pre-filters, create calculated fields, aggregations, grouping etc.

Used SAS web report studio to Created different types of reports such as summary detail, drill up/ down, with features such as report linking, different sections, filters, prompts and conditional highlighting etc.

Generated monthly reports for customer analysis and reporting with different dimensions including product, area, distribution channel, states, and branch.

Generated ad-hoc reports in multiple formats such as HTML, PDF, or RTF.

Automated regular manual processes, e.g. Development and enhancement of standardized reports and incorporated minor changes.

Analyzed and gathered requirement from client.

Incorporated several ad-hoc requests and delivered in a timely manner.

Created user account, groups, and roles with SAS Management console studio.

Suggested methods to improve performance in processes that was incorporated by client.

Self directed documentation and present ideas/deliverables during walkthroughs.

Met tight deadlines due to end of the month.

Client : Dai-ichi Life Insurance, USA.

Role : SAS DI/BI Developer

Project : Insurance Data Warehouse Development and Reporting.

Description : Developed a DW solution for a insurance company’s MIS and operational reports. Source data originated from operational system in flat files and some of reference data from Oracle database and SQL Server.

Technologies : SAS DI, SAS BI, Oracle, SQL Server.

Key Role:

Developed of ETL Jobs using data from flat files, ORACLE database, and SQL Server, using SAS DI.

Created metadata for source and target systems.

Used multiple transformations such as file reader, loop, SQL join, SCD type 2, table loader, data validation and lookup transformation.

Used check in and checkout concept for DI Jobs (Change management).

Scheduled and deployed jobs, created flow in SAS management console using schedule manager plug-in.

Responsible for unit testing and quality check for the job.

Responsible for fixing issue occurred in system integration testing.

Developed reports using Stored Process (Macros, Base SAS), Information Mapping and Web Reports with SAS Meta data.

Implemented SAS Information maps with SAS Information map studio using relationship between tables with filters, joins, prompts, pre-filters, calculated fields, aggregations, grouping etc.

Created ad-hoc reports with filters and prompts that were run by end-user.

Deployed reports on delivery portal.

Co-ordinated with end-users for UAT.

Generated reports using SAS BI tools such as: Daily MIS, Policy Reports, Policy Registers, and Claims Register.

Client : Belk Retailer, USA

Role : SAS Programmer

Project : Development, Support and maintenance as a SAS Programmer.

Description : The project involved Acquisition, retrieval and management of sales data. The system performed the statistical analysis of product sales, performance sales by department, region, month, quarter year.

Technologies : SAS 9.2, SAS DI 4.2, SAS EG

Key Role:

Involved in initial requirement gathering meetings just to get an idea about project.

Populated warehouse tables from multiple staging tables.

Developed end-to-end reporting using SDLC methodology.

Created SAS datasets from flat files and oracle database using libname and pass through method.

Used infile options like Flowover, Missover, Truncover etc. for reading raw data files.

Used dataset options like Keep, drop, Rename and where as a part of storage efficiencies.

Used advanced SAS concepts such as parallel processing, hash objects and data merging techniques such as concatenating, interleaving, and match merge and if statements.

Validated data using different functions such as Compress, Compbl, Verify, Scan, Substr, Translate, Spedis and Put.

Cleansed data using Proc Format, Proc Freq, Proc Means, Proc Univariate and Proc Report.

Debugged and fixed SAS programs using data _NULL_ and PUT statements.

Reduce code complexity by using SAS macros and modularization.

Developed macro programs defining the macro parameters using several debugging options such as MPRINT, MLOGIC, and SYMBOLGEN.

Formatted HTML, PDF, CSV and RTF reports using SAS – ODS (output delivery system).

Created test cases and test plans and executed them test data.

Documented work and deployment process.

Prepared test data and verified test results in UAT environment.

ACADEMIC QUALIFICATION

Bachelor of Computer Application V.N.S.G.U, Surat, Gujarat. 2012 Second Class

PERSONAL DOSSIER

Date of Birth : 28th August 1991

Marital Status : Married

Present Address : I-202 Viola Residency, near cipla foundation, opposite atul nagar, Mumbai-Bangalore express way warje, pune.-411058, Maharashtra, India

Permanent Address: A-31 madhuvan society, b/h laxmi narayan soc., dabholi road, Katargam,

Surat.-395004, Gujarat, India.

Languages Known: English, Hindi and Gujarati.

Contact No : +91-990**-*****, +91-902**-*****

Passport No. : M6180653

Nationality : Indian

Date:

Place: Pune Chirag Mavani

Contact this candidate