Manager Data
Resume:
MYTHILI VADIVU JAYACHANDRAN
***********@*****.*** Mobile: 201-***-****
SUMMARY
Looking for Business Intelligence Developer focusing on ETL and reporting with a keen interest for learning and a vision for successful designing, coding, and debugging to meet client requirements.
5 years’ experience in Data warehousing and Business Intelligence Applications (Spotfire & Informatica)
Reporting:
Great Knowledge in developing complex dashboards using Spotfire Features like Filtering Schemes, Text areas, Property controls and Action controls
Developed Spotfire Visualizations to meet the client needs and improved performance using Load on demand.
Extensive experience in creating Information links using information Designer
Experienced in Data Blending for combining the data from multiple sources
Good in using HTML, JavaScript APIs to create mashups, to integrate visualizations with various web applications, embedding visualizations
Knowledgeable about Installation, Automation services, Upgrading and Installing Hotfixes, Database drivers, Deployments, Action logs, Library Administration as Spotfire Admin
Great in writing SQL Queries, JavaScript, Iron Python and R scripting for customizations of reporting
Experience in UI /UX-Created Front End Design/Layout using HTML, CSS, JavaScript, Angular JS
Excited to learn new technologies and have excellent ability to coordinate with other technicians in various data analysis and development projects to satisfy the client within the company events
ETL:
Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
Strong Data Warehousing ETL experience of using Informatica 9.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
Expertise in Data Warehouse/Data mart, ODS implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
Extensive testing ETL experience using Informatica 9.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
TECHNICAL SKILLS
BI tools : Informatica 9, Tibco Spotfire 7x/6.5, Tableau 8, MS Power BI
Databases : MS SQL Server, Oracle 11g and Data warehousing Schemas with (RDMS, OLTP, OLAP), MySQL
Languages : JavaScript, SQL
IDE : Notepad++, Brackets, Text Editor, MS office suite
WORK EXPERIENCE
ETL Developer/Architect – Scope International Chennai Jan’15 to Dec’17
Responsible for Business Analysis and Requirements Collection.
Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
Parsed high-level design specification to simple ETL coding and mapping standards.
Designed and customized data models for Data warehouse supporting data from multiple sources on real time
Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
Created mapping documents to outline data flow from sources to targets.
Involved in Dimensional modeling (Star Schema) of the Data warehouse to design the business process, dimensions and measured facts.
Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
Developed mapping parameters and variables to support SQL override.
Created mapplets to use them in different mappings.
Developed mappings to load into staging tables and then to Dimensions and Facts.
Used existing ETL standards to develop these mappings.
Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
Modified existing mappings for enhancements of new business requirements.
Used Debugger to test the mappings and fixed the bugs.
Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
Involved in Performance tuning at source, target, mappings, sessions, and system levels.
Prepared migration document to move the mappings from development to testing and then to production repositories.
Environment: Informatica Power Center 9, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, SQL Server 2005, Sybase, Toad 9.0
Spotfire Developer/Admin – Scope International Chennai Sep’12 to Dec’14
Created statistical reports with Visualizations, designed various dashboards for employee, Shipping status dashboard, Tracking order status, Warehouse order performance, Factory Productivity Analytics
Followed Agile methodology and SDLC for requirement gathering and created data flow diagrams from source to target systems
Used Information links, Transformations, Load on demand, Navigation links, and Filtering schemes
Experienced in Data Blending for combining the data from multiple sources
Experienced in designing reports with the charts like Combination charts, Bar charts, Pie charts, Cross tables, Summary tables, Tree map, Heat map, etc
Monitored server to fix network problems, LDAP servers and other issues
Used Spotfire features like Text area, Reference lines, Custom expressions, Action controls, Property controls, Inserted images, Markings, Trellis, OVER functions
Used Pentaho Data Integration/Kettle for designing ETL processes of extracting data from multiple sources, transform and load the data to target data warehouse
Created transformations that involve configuring the following steps: Table input, Table output, Text file output, CSV file input, Insert/Update, add constants, Filter, Value Mapper, Stream lookup, join rows, Merge join, Sort rows, Database Lookup, Set Environment Variables
Responsible for creating various reports that also involves Iron python and R scripting for various customizations
Used K means clustering, Regression modeling and TERR tools in R to predict the model
Responsible for Installing Spotfire server, upgrading, creating action logs and migrating the files to acceptance/ production for further access
Set up Guided Analysis DXP files- that includes Navigation links, cover page, filtering schemes, etc.,
Responsible for creating single sign on, server upgrades, governance structure for UAT and application documentation, implemented automation services for regular updates
Environment: TIBCO Spotfire Professional 6.x, Spotfire Server, Spotfire Automation Services, MS SQL Server, Spotfire Web Player, Oracle 10g, Windows Server, Pentaho Kettle, MySQL, Iron Python, R
EDUCATIONAL QUALIFICATIONS
Bachelor of Computer Science
Madras University, TN, India.
Master of Computer Applications
Madras University, TN, India
PERSONAL DETAILS:
Calling Name : MYTHILI
Legal Name : VADIVU JAYACHANDRAN
Work Visa : EAD
Email ID : ***********@*****.***
Mobile : 201-***-****
Contact this candidate