Candidates About

Girish Rajasekharan 

SUMMARY:

• Possess strong ER Modeling and Dimensional modeling skills for OLTP, Data warehouse and data mart applications for more than 8 years.
• Modeled data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like Erwin, IBM Infosphere Data Architect and ER STUDIO
• Experienced in UML Modeling using IBM IDA data modeling tool.

Implemented database standards and enterprise standards in the models and made sure the OLTP system adhere to 3^rd normal form.

• Carried out data analysis tasks by querying the data that is present in the database and worked with the ETL teams to design source to target mapping documents.
• Familiar with Ralph Kimball and Inmon’s dimensional approach to design data warehouses and data marts. Guided team members in following the best practices.
• Familiar with all stages of the SDLC development life cycle: Requirements gathering, Design, Development, Construction, testing and Implementation.
• Familiar with both agile and waterfall methodologies and provided quality deliverables to meet the project timelines.
• Experience in SQL and coding PL/SQL Packages, Procedures.
• Provided support and coordinated with DBA on data base build.
• Assisted with ad-hoc query and report requests to various customers.
• Experience in data mining and data analysis using Tableau Desktop
• Made sure the data models are compliant with the best industry standard practices.
• Interacted with ETL teams to develop data mapping documents for target applications.
• Familiar with big data and Hadoop concepts for data analysis using hive.
• Experience of working on ETL tools like Informatica
• Understand concepts of python programming language for data analysis. Currently learning a data analyst course in Udacity.

Technical Skills:

Data Modeling Tools: Erwin 8.2,9.5, E/R Studio, MS Visio, Oracle Designer, IDA 7.6,RTC Client

Programming Languages:  Matlab, Labview, C, SQL, PL/SQL, Python 2.7.12

Databases: ORACLE, MSQL, SQL Server, DB2Host, DB2 LUW, SYBASE, Teradata and Netezza

Other Tools: TOAD, Visual Source Safe, Clear Case, Aginity Netezza, DB Artisan, SQL Developer,Alation     

Operating System: Windows, UNIX, LINUX

WORK EXPERIENCE:

Logical Data Modeler,Data Logic Capabilities

eBay Inc. Austin, Texas, Mar 2016

Responsibilities:

• Design data models as part of Global Risk Platforms and Compliance initiative to identify risk, assess the risk and take appropriate actions to make eBay the best shopping experience for users.
• To understand the end user requirements to develop a scalable data mart that can be consumed by various downstream applications for ad hoc analysis, dashboards and develop risk models for predictive analysis.
• Used Erwin as a data modeling tool to forward engineer the models into scripts and reverse engineer the scripts into the tool .
• Worked to design data marts for account level and account status databases that help various teams to analyze the user experience, user statistics etc.
• Incorporated industry standard modeling practices to support a detailed and subject oriented data mart.
• Used Tableau Desktop to build dashboards and storylines for datasets in Teradata.

Senior Data Architect/Data Engineer

American Express, Phoenix, Arizona, Feb 2015 – Feb 2016

Responsibilities:

• Responsible for working closely with the customers and business analysts to understand the database requirements.
• Worked with ER Studio tool to create logical and physical data models.

Built data models for Amex Operational premium portfolios like Global Card Member Remittance, Credit Authorization Service and Wire Fraud Protection Systems.

• Captured appropriate and detailed metadata for the conceptual, logical and physical data models.
• Incorporated Amex and industry standard naming conventions for the attributes and entities.
• Incorporated the best modeling practices to avoid data redundancy and implement the operational models in its third normal form.
• Experienced in working for project teams that practice agile and waterfall methodology.
• Reverse engineered data models using the tool from the DDL’s or database schema.
• Developed data models to support the target databases like DB2 and Oracle.
• Involved in discussion with the DBA’s to fine-tune the database performance and model by adding additional indexes or revisiting the key structure etc.

Data Modeler Consultant

USAA, San Antonio, TX Jan, 2014 –Feb 2015

Responsibilities:

• Collaborated with the Business Analysts and development teams for data requirements by conducting JAD sessions.
• Developed data models for various target database platforms like Oracle, SQL Server, MySQL, Netezza, DB2 LUW, and DB2 Host.
• Used Erwin Data modeling tool to design Logical and Physical data models to suit the business needs.
• Designed Conceptual, Logical and Physical data models for OLTP, Data Warehouse and Data Mart Applications.
• Worked on BILAB Agile projects to design models with stringent timelines.
• Physically instantiated the DDLs generated from the tool to the target database.
• Experienced in different data modeling approaches to suit the data warehouse, data marts and OLTP applications.
• Meetings with the application teams, DBA and business analysts to come up with the optimized and best approach for the data models.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Maintained the data model and synchronized it with the changes to the database.
• Extensively used complex SQL queries for querying and analysis of data using the Squirrel Client, Aginity Netezza and DB Artisan.
• Assisted the DBA’s by Looking at the tuning side by analyzing the queries using the EXPLAIN PLAN & Auto-trace utilities.
• Provided other data analysis services as required.
• Created data mapping documents to assist ETL teams using Informatica and Data Stage.
• Worked closely with ETL and Business Objects teams for data mapping, extraction and reports.

Data Analyst/Modeler Consultant

JP Morgan Chase, Columbus, Ohio    Apr, 2013-Dec 2013

Responsibilities:

• Worked on reengineering projects in designing data models for target DB2 systems from legacy IMS database.
• Extensively worked on IDA and RTC tools to develop, maintain and enhance the data models as per the needs.
• Worked on building and maintaining a metadata at the Business Object Model level to be shared across peers and other technical and functional teams.
• Built reports to cater to the technical and functional teams using the IDA data-modeling tool.
• Generated a customized business object model using the IBM recommended artifacts for classes and methods in Java.
• Transformed the business object models to logical and physical models using IDA data modeling tool.
• Generated the DDL using the IDA tool to be implemented by the DBA in the database.
• Worked on building baselines versions of various releases and scope down of the existing classes used in the IDA data modeling tool.
• Weekly reviews and meetings with the team and the data architects to make sure the tasks are carried out in a timely manner.
• Made sure the model is synchronized to the changes in the database.
• Analysis of data from legacy systems and designing data model for target DB2 database.
• Provided reviews and approvals to new release changes across different applications.
• Generated UML scripts and class diagrams using the IDA data modeling tool.
• Worked on providing training across development teams to adhere and be familiar with the industry standard data models and artifacts.
• Worked to ensure data governance across various applications and project teams.
• Trained and shared information with other members in the data architect team.

Data Analyst/Modeler Consultant

Lowe’s Companies, Inc., Mooresville, NC    Oct, 2010-Jan 2013

• Worked with the Business Analysts for requirements gathering, business needs analysis and project coordination and validated data requirements by conducting JAD sessions.
• Extensively used Erwin Data modeling tool to design Logical and Physical data models to suit the business needs.
• Designed Conceptual, Logical and Physical data models for OLTP, Data Warehouse and Data Mart Applications.
• Generated DDL scripts during the forward engineering process for the actual physical build of the database.
• Built data models to bring it in compliance with the 3rd normal form.
• Frequent meetings and brainstorming sessions in order to make sure that the data corresponds to the business needs.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Used Model Mart in order to maintain a library of all the development models in progress.
• Used Complete Compare in order to make migrate from development to production version.
• Reviewed copybooks in order to make sure that the data adheres to the required standards.
• Maintained the data model and synchronized it with the changes to the database.
• Generated reports using the ERWIN tool in order to assist the ETL teams.
• Extensively used complex SQL queries for querying and analysis of data
• Created Triggers and Sequences in the Physical Data Model so as to meet the business logics as and when required.
• Assisted the DBA’s by Looking at the tuning side by analyzing the queries using the EXPLAIN PLAN & Auto-trace utilities.
• Provided other data analysis services as required.

Software Engineer                         

Infosys Technologies Limited, Chennai, India     Nov 2006 –July 2008             

• Web application testing regarding cheque fraud protection for Canadian client ‘Symcor’.
• Involved in testing the end-to-end system functionality and regression testing, identifying and retesting defects.
• Demonstrate a strong relationship with the developers and QA lead from the client side.
• Collaborate with the team manager and other team members to resolve team tasks and knowledge transfer to new team members.
• Involved in application testing for Toronto Dominion and Bank of Nova Scotia for over 8 months. Testing ensured processing cheques and raising exceptions in case of fraudulent activity detection.

EDUCATIONAL BACKGROUND:

Bachelor in Electronics and Communication Engineering

Certifications:

Currently pursuing to be Oracle SQL certified.