EXPERIENCE SUMMARY

• Seasoned business intelligence professional having experience working in entire software development life cycle.
• 10+ years of data processing experience. 2 years of analyst experience, working in banking products. 2 years of experience coding well - abstracted big data components.
• Currently working for Confidential as a Data analytics analyst
• Have used Perl, Bash and Python programming for data transfer and manipulation.
• Worked on following open source modules: MySQL, Jaspersoft, iReport, Pentaho Kettle. Experienced working with agile modules.
• Technical knowledge and project experience on MapR Hadoop, its ecosystem including pig, hive, sqoop etc., have used Pentaho data integration to solve many of the big data challenges.
• Exposure working on Splunk, AWS, VMware, EC2, S3 storage.
• Technical hands on experience on products like smart analytic networks, e-commerce, retail, educational services, AML risk rating, Retail Banking Group, Mortgage/Loan Conduit.
• Solved challenges faced in contract renewals by carving a strategy for data mashing. Given the fact that the legacy data integration took 3 days to crunch data, load distribution using Hadoop took only 8 hours’ time.
• Automated and created report using excels. These reports automatically got fed with data from backend. Created metadata layer using Perl, excel and shell modules.
• Created real time business intelligence with design of Operational data store. Staging layer for ETL, designed multi-level staging based on the complications with incremental loads of data.
• Authored snapshot, profile record facts, factless facts, slowly changing, and role playing dimensions. Designed DataMart, data warehouse from OLTP, ERP and Legacy systems. Worked on Analytical tasks: like cohort reports, trend analysis, and tree visualization for financial systems.

PROFESSIONAL EXPERIENCE

Confidential

Data Analytics Analyst

Responsibilities:

• Helped building a customer Master Data Management, by creating unique identifiable customer profile. Identify anomalies of customer profile using R; find a remediation plan for the same. Built KYC profile for 2.5 million customers.
• Resolve and participate in bringing conformity standards for reference data. Deriving common business definition. Helped in deriving consensus between different product hierarchies of the bank
• Testing the business functionality .Identifying remediation plan for defects. Helped in FDIC audits analysis.
• Created attrition model for attrition types and retention analysis .Found patterns of branch and online customer exit for checking and savings accounts in the bank.
• Customer 360 profiling for sourcing and origination tools. This helped in identifying the amount of data reconciliation taking place between backend and front end.

Environment: R, Oracle

Confidential

Data Analyst/Engineer

Responsibilities:

• Implemented the reporting structure of endowment process with the help of universe and desktop intelligence reports. Managing the testing phases of reports, handling queries from end users from the university. Performed root-cause analysis and issue resolution across complex report/data environments.
• Design and code in Perl for exporting and uploading data into MySQL database, using Perl regular expressions. Have used Perl hashes, arrays and scalars. Have used dbi, excel, JSON, Str modules. Work with end users for analyzing the required and provisioning the required Operational Analytics.
• Design and code in Python3.5 for moving data from xls, xlsx, xlsm, JSON file to splunk.
• Transfer data to Splunk as key value pairs .used lists, dictionaries, modules like xlrd, xlwt, re, sys, collections, Crypto Cipher, socket, getpass etc.,
• Created Python API modules to encrypt, decrypt passwords, data extraction and converting into JSON files. Designed and implemented solution for conversion of Perl object to JSON .Resolved Issues faced with JSON object parsing with Splunk. Redefining JSON schema to get a flattened structure, so that it is easier to build dashboards.
• Have used Perl and python to integrate, cleanse and validate data.
• Enable and setup pentaho audit database using oracle as backend, tuning the pre-defined reports. This enhanced the performance of master and carte pentaho servers
• Design platform landing zone for external and internal customers. Ensure security and compliance while bringing in new customers. Log management including rotation, retention and consolidation.
• Understand and investigate the requirements from contract renewal customers. Aggregate pig and hive scripts for enhancing the speed of the queries running on MapR Hadoop. Especially optimizing data munging (of 500 million joined with 50 million record size)
• Standardize and automate big data governance across multiple customer support projects. This includes geo-based data and file restrictions, retention, encryption etc., Plan, build and code for password encryption across the master and slave pentaho servers.
• Plan on fault - tolerance for hive servers. Code to alternate and automate the dynamic hive server connection from the edge nodes. Monitor the availability of hive server, and script for failure recovery. Have used transformations like input, output, JSON, Sqoop, hive transformations etc.,
• Conduct feasibility study for Informatica big data components with respect to pentaho and suggest right or alternate usage as needed. Work out case study scenarios before getting accepted in the product. Manage and analyze pentaho BI suite bugs. Find alternate solutions for unreleased bugs.

Environment: Splunk 6.3.2, Perl, Python 3.5.0,2.7.10 Bash scripting, MySQL, Pentaho data integrator v 5.x, MapR Hadoop, Apache Pig, Hive, Hbase, Sqoop, Oracle 11i,Business Objects XIR2, SQL developer

Confidential

EDW Developer, analyst

Responsibilities:

• Redesigned ELT for huge record volumes of data (millions per hour), thus reducing ELT load time from 3hours to 20 minutes. This also included downsizing unused metrics. Designed extraction layer using pentaho kettle and series of MySQL staging tables.
• Dimensional design, code and implement forecast model for financial planning
• Automate the monitoring process for accounting reports with the use of shell and Perl modules. Used Perl to create reporting abstraction layer, in HTML .The HTML fed excel dashboard reports. Eliminate manual check for month end reports by designing and scheduling checklist dashboard using HTML.
• Designed ELT system flow for bookings using Pentaho kettle jobs and transformations. Created and maintained jobs in parallel for processing million rows/hour.
• Pulled data for analytical use cases like:
• Marketing lead conversions - mobile, email, third-party, site conversions etc.,
• Customer engagement analysis
• Cohort analysis for subscriptions
• Tweak Perl modules to extract data from JSON file format .Gained knowledge of NoSQL and key value pair databases like Mongo db.

Environment: MySQL, UNIX, Perl, Shell, Pentaho Kettle Data Integrator, AWS

Confidential

Technical Lead

Responsibilities:

• Liaised with business partners for requirements, got clarifications and understood the business model and documented. This reduced the cycle time of project development as the documentation was clear and accurate.
• Converted the requirements to functional specifications, Component technical design after having consensus with all the work streams. Designed a terabyte sized system for extracting and loading text and document data from heterogeneous systems. Created materialized views to bring replication and this enabled real time reporting for the immediate needs of the financial clients
• Created Universes using @functions like @select, @where and @prompt in the process of building the universes. Used derived tables and views inside universes based on the reporting complications.
• Constructed analytical reports with complex graphical representation such as stacked graph with line in desktop intelligence. Created multi-tab reports with tabs ranging from 1-5. These report documents had 30 visualizations. Some were interactive in nature with drill-up, drill-down and cascading prompts.
• Authored reports which were very complex by using custom SQL in web intelligence and desktop intelligence
• Developed and converted complex desktop intelligence reports from desktop intelligence to web intelligence using report conversion tool. Migrated users and contents from one server to another server. Re-implemented the security features for the users and objects in the new server.
• Co-ordinated and tested/modified the reports and their schedules during Oracle upgrades
• Had exceptionally prioritized multiple responsibilities, while implementing 3 work streams and kept the stakeholders ahead of information.

Environment: Oracle 10g,Business Objects XIR3, Erwin and AIX UNIX

Confidential

Lead Consultant

Responsibilities:

• Helped the business users by visualizing the requirement using mock report in excel. Based on the gathered requirements designed the dimensional model (3 facts, 25 dimensions) using ERwin. Designed aggregate table. Designed a 10 million record size system to pull data from SQL server to Sybase database.
• Implemented the knowledge of table design into universe to create valuable analytical Web intelligence and desktop intelligence BO reports. Had handled fan traps and chasm traps using an efficient table design, without the need of a context.
• Had solved challenges in merging many data providers. Have done Instance Management for the scheduled reports, Content management and user management for setting up the new repository (using CMC and supervisor). Scheduled reports using BO command line commands .Used calendar objects for the location specific scheduling to maintain the schedules only during business days. Improved the performance of the reports by tuning the joins and the query indexes
• Created the metadata mapping from the source system to the target system. Responsible for drawing out the ETL strategy using Informatica. Created Informatica workflows to sends mail to the users.
• Scheduled the mappings through UNIX for the daily and monthly loads using autosys, a scheduler tool.
• Created challenging report metadata for iReport, (iReport is a java reporting application from JasperSoft).Conducted impact Analysis for implementing the XML tags for the reporting metadata. Created metadata and views for the report creation.

Environment: SQL Server 2005,Sybase,Informatica 7.0,Business Objects XIR2, ERWin, SQL Server 2005,Jboss,Jaspersoft I Report

Confidential

Senior Consultant

Responsibilities:

• Pictured the solution for the finance department’s reporting needs by the designing the flow of ETL pipeline and reporting for sales, booking, invoice and revenue Data Marts. Actualized the dimensional design and implemented the universe and reports for 4 datamarts. Worked with universe database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, object parsing and hierarchies.
• Created canned and ad-hoc reports. Created booking, sales and invoice reports, using BO full client. Authored sales and booking forecast reports which fetched 1 million records and improved the performance of the reports which were running for 3 hour to 1 hour
• Indicated the slowness of the system and suggested strategy for re-architecting ETL, which gave tremendous improvement. Tested and upgraded reports from 5.1.4 version to 6.5 of Business Objects.

Environment: Business Object 5.1.4,6.5, HP UNIX, Oracle 9i, 8i, PVCS

Confidential

roject Engineer

Responsibilities:

• Designed ETL strategy using the OWB for pricing datamarts. Trained the team and designed the entire ETL strategy including facts, dimensions (product, location), and error and audit tables.
• Wrote the ETL routines to transfer the data from flat files or Oracle tables to Oracle DB. Coded UNIX scripts to automate the ETL routines. This includes ETL routine migration from OWB to Informatica
• Designed and developed ETL mapping strategy using Informatica Power Center/PowerMart. Created / developed / enhanced more than 30 various ETL mapping and mapplet processes. Designed and developed various transformations (aggregations, route, rank, filter, join, dynamic lookups and many more).Analyzed gaps while integrating heterogeneous systems. Minimized manual work by using UNIX scripts, PL/SQL for complex mappings. Reduced code components by using mapplets.

Environment: Sun Solaris UNIX, Oracle PL/SQL 8.1, Erwin 3.5.2, VSS 6.0,COGNOS Impromptu Administrator 6.6, COGNOS PowerPlay Transformer 6.6, PowerPlay 6.6, BO 5.x,Informatica Power Mart 5.1,Autosys, Oracle Warehouse Builder 9.x, Informatica 6.x Solaris 2.8 Server, Oracle 9i,8i, PL/SQL

TECHNICAL SKILLS

Systems: Windows, Solaris and AIX UNIX

Languages: Oracle PL/SQL, SQL, Shell Scripting, Perl Scripting

Applications: Banking, Finance, Manufacturing, Utilities

Other Tools: Pentaho Kettle 4.3 5.0.7,(kitchen, pan, carte servers, report designer, schema workbench, metadata editor) Informatica 5.x7.x, Business Objects 5.x,6.5,XIR2,3.0( Supervisor, Infoview, BCA,CMC, Web Intelligence, Desktop Intelligence, Designer, xcelsius, Import Wizard, Query Builder, Report conversion ),Oracle Warehouse Builder 9.x,vi,SQL*Plus,, ERWin,Jaspersoft iReport 2.x

Databases: Oracle 8i, 9i, 10g,SQL server 2000, Sybase 11.5 ASE, MySQL, Splunk DB

Functional Expertise: Banking (Anti Money Laundering, Mortgage and securities, Retail banking), Finance, Accounting, Manufacturing, Educational services.