Professional Summary:

• Strong IT experience in the field of Data analysis, ETL Development, Data Modeling, and Project Management with experience in Big Data and related Hadoop technologies.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
• Strong experience in Data Modeling with expertise in creating Star Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Embarcadero.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge in Business Intelligence tools like Business Objects, Cognos and OBIEE.
• Experience with Teradata as the target for the data marts, worked with BTEQ, Fast Load and MultiLoad.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experience in various phases of Software Development life cycle Analysis, Requirements gathering, Designing with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Experience in conducting Joint Application Development JAD sessions for requirements gathering, analysis, design and Rapid Application Development RAD sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project's exposure to the forces of change.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, and MultiLoad to export and load data to/from different source systems including flat files.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN,Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

Professional Experience: Confidential

Sr.Data Analyst

Responsibilities:

• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Transformations of requirements into data structures, which can be used to efficiently store, manipulate and retrieve information.
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Created new reports based on requirements.
• Responsible in Generating Weekly ad-hoc reports.
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day.
• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities such as MLOAD, BTEQ and Fast Load.
• Involved in Building a specific data-mart as part of a Business Objects Universe, which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets.
• Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform.
• Provided design recommendations and thought leadership to sponsors/stakeholders that improved review processes and resolved technical problems.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Used data analysis techniques to validate business rules and identify low quality for Missing data in the existing Bank data warehouse EDW .
• Also Worked on some impact of low quality and/or missing data on the performance of data warehouse client
• Identified design flaws in the data warehouse.
• Tested raw data and executed performance scripts.

Environment: MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, Informatica, HDFS, PIG, HIVE, Map Reduce, Linux, HBase, Flume, Sqoop, Matlab, SAS

Confidential

Sr.Data Analyst

Responsibilities:

• Met with Customers to determine User requirements and Business Goals.
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• Worked closely with the claims processing team to obtain patterns in filing of fraudulent claims.
• Conducted JAD sessions to gather requirements, performed Use Case and work flow analysis, outlined business rules, and developed domain object models.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Responsible for management of data, duplicating the data and storing the data in to specific data warehouse using Talend Platform for Data Management and MDM.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interact with the SME's to analyze the data extracts from Legacy Systems Mainframes and COBOL Files and determine the element source, format and its integrity within the system
• Transformations of requirements into data structures, which can be used to efficiently store, manipulate and retrieve information.
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.
• Patterns were observed in fraudulent claims using text mining in R.

Environment: Oracle 10g, Microsoft Excel, Microstrategy, MS Visio, MS Project, Informatica, Matlab, SAS

Confidential

Senior Data Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for Dual Medicare Medicaid Data mart.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Responsible for ETL development with successful design, development, and integration of components within the Talend ETL Platform and Java Technology.
• Responsible for management of data, duplicating the data and storing the data in to specific data warehouse using Talend Platform for Data Management and MDM.
• Involved in defining the trumping rules applied by Master Data Repository.
• Define the list codes and code conversions between the source systems and MDR.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules, and business and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Reverse engineered all the Source Database's using Embarcadero.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Document data quality and traceability documents for each source interface.
• Designed and implemented data integration modules for Extract/Transform/Load ETL functions
• Involved in data warehouse and Data mart design.
• Experience with various ETL, data warehousing tools and concepts.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Good Experience with Mainframe enterprise billing systems Involved in defining the business/transformation rules applied for Dual Medicare Medicaid data.
• Worked with internal architects and, assisting in the development of current and target state data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Used data analysis techniques to validate business rules and identify low quality for Missing data in the existing Humana Enterprise data warehouse EDW .
• Also Worked on some impact of low quality and/or missing data on the performance of data warehouse client.

Environment: SQL/Server, Oracle10 11g,MS-Office, Embarcadero, Netezza, Terradata, Enterprise Architect, Informatica, ER Studio, XML, Informatica, OBIEE.

Confidential

Programmer Analyst

Responsibilities:

• Work with the Project Management in the creation of project estimates.
• Analysis of the data identifying source of data and data mappings of HCFG.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interact with the SME's to analyze the data extracts from Legacy Systems Mainframes and COBOL Files and determine the element source, format and its integrity within the system
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.
• Enforce standards to ensure that the data elements and attributes are properly named.
• Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Perform small enhancements SOR element additions, data cleansing/data quality .
• Create various Data Mapping Repository documents as part of Metadata services EMR .
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.

Environment: MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL