Resume Lovelin Shillu Edwin Joseph Raj

Name: Lovelin Shillu Edwin Joseph Raj

Email:acxjs9@r.postjobfree.com

Mobile: +1-434-***-****

EXPERIENCE SUMMARY

Lovelin has 6 years of Data Warehousing, Business Intelligence & Support Engineering experience with specialization on BI Reporting, Data Modeling, Data Analysis, Data Querying, Business Analysis & Trend analytical experience in the Banking sector. She has been a passionate professional with the drive to innovate and improvise constantly.

• Gathered business requirements, quantified business impact, analyzed and discussed the reporting feasibility with Business users

• Prepared high-level design documents mapping data sources to requirements

• Co-ordinated and assisted Business & Technology teams in bringing new data-streams to Data Warehouse

• Strong experience in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server 2012/2008R2/2008/2005.

• Expertise in designing SSIS packages (2008/2005) to export, import and transform data between databases, external data sources

• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

• Experience in creating and updating of OLAP cubes with SSAS

• Good experience with Microsoft Excel (Pivot Tables, Vlookups, Macros).

• Developed numerous adhoc queries, reports & visualizations using SQL, Tableau, (SSRS) SQL Server Reporting Services & Excel PowerPivot to support organizational decision-making needs

• Created and maintained Sharepoint to post the generated reportsBuilt automation framework for several reporting needs there by increasing the turn-around time considerably; also ensured best practices were captured and implemented consistently

• Created & enhanced SSIS packages for report generation needs per business requirements

• Continuously monitored automated data load pipelines, performed integrity checks, reported & fixed data quality issues

• Created JIRA and remedy tickets for the identified issues

• Co-ordinated with Business & Data engineering teams by providing appropriate and effective suggestions for optimized data loads and reporting solutions

• Extracted data from diverse sources, analyzed, aggregated, drew conclusions and made recommendations on several business critical instances

• Trained several Business teams on the effective usage of reports, tools & resources Resume Lovelin Shillu Edwin Joseph Raj

• Created effective training materials, conducted one-on-one, live group, and WebEx training

• Developed data analytical data marts from complex financial source data, performed daily system checks created & audited reports for accuracy across data mappings, business rules & definitions

• Framed/Designed and reviewed application deployment plans for Infrastructure releases and initiatives

• Documented, clarified, and communicated requests for change requests with the requestor and coordinate with the business and testing teams

• Experience with various Reporting, data warehousing tools and concepts

• Proven Business and communication skills, fast learner, hard worker and a committed team player TECHNOLOGY

Programming Languages/Technologies SQL, UNIX

Reporting Tools Tableau, SSRS, MS Excel

Databases SQL Server, Oracle and Teradata

Design Tools MS Visio, SSIS, SSAS

Domain Banking

Other Tools Toad, Remedy, Autosys, Introscope, Bladelogic, Viewpoint, Sharepoint

CERTIFICATIONS

• Teradata Basics Certification (Technical)

• General Banking (Domain)

EDUCATIONAL QUALIFICATION

Degree and Date Institute Major and Specialization Bachelor of Information

Technology, 2005 -2009

PSG College of Technology,

Coimbatore, India

Bachelor of Technology in Information

Technology

TRAININGS ATTENDED

• Data Warehousing Concepts

• US-Banking Concepts

• Mail Etiquettes

• Security Awareness

• Integrated Project Management System (IPMS)

• Integrated Quality Management System (IQMS)

Resume Lovelin Shillu Edwin Joseph Raj

• Effective Technical Writing

• Defect Prevention and Causal Analysis

• Communication Series

• Foundation – Lean Six Sigma

PROJECT DETAILS

Project Title AML Risk Assessment

Employer Tata Consultancy Services

Customer Bank of America, Charlotte, North Carolina, USA Role BI Data Analyst & Support Engineer

Responsibilities • Played a pivot role in the enterprise-wide AML Risk Assessment in developing a risk based approach to customer due diligence thereby address areas of money laundering and Terrorist Financing

• Executed all the phases of the project from Requirements Gathering, Conceptual Design, Analysis, Development, Testing & final Data report review

& delivery

• These reports help Business and product teams to identify areas in need of increased surveillance and more in-depth review

• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)

• Data Mapping and modifying the SSIS solution to extract & load the data into data warehouse tables

• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task to generate underlying data for the reports and to export cleaned data from Excel, Text file and MS Access to different Data Marts

• Experience in Performance Tuning and providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages

• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS

Resume Lovelin Shillu Edwin Joseph Raj

• Responsible for creating parameterized reports, Ad-hoc reports Sub Reports, Matrix Reports, Charts, Drilldown reports using SQL Server Reporting Services (SSRS)

• Scheduled SSRS reports and set up subscriptions to run the reports Hourly, Daily, Monthly according to client requirements for the periodic analysis

• Deployed the generated SSRS reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval

• Generated several drill down and drill through reports using SSRS, Excel and Power Pivot

• Updated and created cubes in star and snow flake schemas for developing reports on the data-warehousing environment

• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data

• Designed Cubes with Star Schema using SQL Server Analysis Services 2008

(SSAS)

• Developed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation

• Performed data gap analysis using SSIS and transformed the data according to the required format

• Involved in data validation using MS SQL queries and back end testing

• Scheduled Jobs and Alerts using SQL Server Agent

• Analyzed multiple data sources, consolidated relevant data streams and setup automated data-load pipelines

• Identified Data Quality issues, prioritized, escalated & assigned tasks to appropriate teams, coordinated efforts and ensured timely delivery of reports

• Created JIRA and remedy tickets for the identified issues

• Managed the testing and bug fixing tasks in coordination with testing team

• Created and maintained Sharepoint for all supported applications by uploading and updating necessary documents on a timely fashion

• Reviewed implementation plans prior to deployment releases

• Also monitored the performance of the platform by effectively using various tools

Database Oracle,SQL Server

Tools Used

SSIS, SSAS, SSRS, Toad, MS Excel, Putty, Remedy, Viewpoint, Introscope, Bladelogic and Oracle Enterprise manager, Tableau

Resume Lovelin Shillu Edwin Joseph Raj

Project Title Disaster Recovery & Support

Employer Tata Consultancy Services

Customer Bank of America, Charlotte, North Carolina, USA Role Data Analyst

Responsibilities • Participated in client discussions to gather requirements and perform initial analysis to plan for the extensive disaster recovery analysis

• Interacted with project stakeholders from Other technology teams like Sourcing/ Testing/ DBAs, etc. (TDMs, PMs, BAs, etc.)

• Provided inputs for overall implementation plan, lead deployment of applications/infrastructure and post-production support activities

• Performed the role of an onsite coordinator on understanding requirements and sent detailed explanatory mails to offshore counter parts ensuring seamless execution of project delivery

• Developed complex modules and delivered defect free and highly optimized deliverables

• Trigger emails with the data from SQL Server Database through SSIS package on a daily basis to the desired recipients

• Modified Existing SSIS package to meet current needs

• Performed detailed analysis of data according to the mapping & transformation rules, which helps in catching many sourcing Issues upfront

• Developed MS Visio flows to illustrate the mapping from source to target of multiple applications

• Mentored other team members on important aspects of the project and the technology for overall team building and raise the quality of deliverables consistently

• Handled critical testing timelines with end to end processing of daily cycle files and validating the data

• As a Disaster Recovery lead, was coordinating the annual DR Exercise for Mainframe, Teradata, Informatica, Datastage and Hadoop platform applications

• Lead Onshore and Offshore teams in DR planning, co-ordination, execution and post DR activities

• Ensure that different technical groups create Disaster Recovery processes and procedures that can be executed

• Report on Post DR activities to the wide audience, track and resolve DR defects after the DR Exercise and fix them prior to the next exercise Database SQL Server, Teradata

Tools Used

Teradata 14.0, Microsoft SQL server 2012, SQL Server Integration Services

(SSIS) Tool

Resume Lovelin Shillu Edwin Joseph Raj

TRAININGS CONDUCTED

• Autosys Scheduling Overview

• Anti Money Laundering Overview

• Disaster Recovery Process and Training

STRENGTHS

• Technically strong and provides sound technical support to the team to resolve critical problems

• Unique ability to quickly adapt to changing scenarios and effectively manage deliverables accordingly

• Very strong Analytical, Problem solving and Interpersonal skills with very good communication skills, Willingness to listen to new ideas, and/or adopt to alternative approaches

• Teamwork and collaboration

• Focus on customer satisfaction and value-add

Contact this candidate