SUMMARY

• 7+ years of IT experience inDataAnalysis including Project planning and Project management with various Business Domains expertise such as Banking, Finance, IT and health care working experience inETL, SAS, Data Warehouse, BI, MDM, Erwin, Big - Data, Hadoopand Teradata using industry best practice tools and techniques, combined with solid academic principles to deliver maximum value to teh client.
• Experience working on SAS, RDBMS,DataWarehouse Concepts, DataMapping,Data Visualization, DataQuality, DataProfiling, Data Scrubbing, DataAnalysis, Gap Analysis, DataCleansing, DataTransformations,DataRelationships, Source Systems Analysis and Reporting Analysis
• Good knowledge withHadoop, HDFS, SAS andHadoopEcosystem (Pig, Hive, Sqoop, HBase, Cassandra).
• Hands on experience in ETL, SAS, Data warehouse tools like Informatica 8.6.1 (Designer, Workflow Manager, Workflow Monitor).
• Excellent understanding of teh Business Intelligence, Reporting tools & Dash boarding, datavisualization using Tableau, SAP Business Objects Explorer, Dashboards.
• Proficient in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database and expertise in relational and dimensionaldatamodeling and logical and physical database design.
• Strong in Source to Targetdatamapping, Standardization Document Slowly Changing Mapping Creation, Star/Snowflake Schema Mapping Creation, RDMS, BuildingDataMarts and MetaDataManagement. Extracteddatafrom different databases using Postgres SQL and T-SQL. Connected databases with python to visualize thedata.
• Analytics experience with R-Programming and SAS, Hadoop, Statistical exploratory Built Predictive models, Develop Machine learning algorithms - Linear & Logistic Regression, Decision Tree, Neural Network, k-Mean Clustering etc.
• Worked closely with various teams in teh company to identify and solve business challenges utilizing large sets ofdatain a distributed processing environment and to develop marketing & management strategies. Experienced in implementation of Normalization and extensively worked on 3NF and UML.
• Proficiency working on teh RDBMS: Oracle, DB2, NOSQL Database: Mongo DB and Hbase and Platform: Unix, Mainframe, Windows Experience in manipulating, cleaning and processingdatausing Excel, Access and SQL.
• Experience in VB Scripts, advance Excel functions such as Pivot Table, Charts, Graphs and Macros. Extensively handled Onshore/Offshore delivery management, Test Management and procuring vendor services.
• Knowledge of Hadoop Installation, Configuration, Testing, Backup, Recovery, Customizing and Maintenance of Nodes, clusters .
• Experience in creating complex SQL Queries and SQL tuning, writing PL/SQL blocks like stored procedures, Functions, Cursors, Index, triggers and packages.
• Expertise experience working in teh Agile and SDLC methodologies and proficiency in communication, analytical and a Self-Driven, leadership skilled and a good team player.

TECHNICAL SKILLS

• Oracle
• DB2
• NOSQL
• Pig
• Hive
• Sqoop
• HBase
• Cassandra
• Unix
• Mainframe
• Windows
• Excel
• Access
• SQL.

PROFESSIONAL EXPERIENCE

Confidential - Dallas, TX

Data Analyst

Responsibilities:

• Worked with BI team in gathering teh report requirements and exportdatainto Cloud.
• Used SAS, ETL methodology for data extraction, transformations and loading in a complex Enterprise Data Warehouse (EDW) .
• Integrated SQL into SAS or R to access database using SAS PROC or R packages.
• Performed SAS Data Analysis and Data validation by writing SQL queries.
• Designed Informatics mappings such as pass through, split and used various transformation such as Lookups, Aggregator, Ranking, Connected and Unconnected lookup, SQL overrides etc.
• Validated SAS, ETL mappings and tuned them for better performance and implemented various Performance and Tuning techniques.
• Worked with team on developing MapReduce programs to extract and transform thedatasets and results were exported back to RDBMS using Sqoop.
• Patterns were observed in fraudulent claims using text mining in R and Hive, created tables in Hive and loaded teh structured (resulted from MapReduce jobs)data.
• Created Managed and External table inHadoopHive and loadeddatainto teh tables, importing and exportingdatainto HDFS and Hive.
• Load and transform large sets of structured, semi structured and unstructureddata, responsible to managedatacoming from different sources.
• Interacted with business and developer team fordatavalidation and defect tracking.
• Created Reports fordataload completion to include anydataissues.

Confidential - Wilmington, DE

Data Analyst

Responsibilities:

• Designed and implementeddataintegration modules for Extract/Transform/Load (ETL) functions.
• Involved inDatawarehouse andDatamart design.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub - reports, navigation reports (Hyperlink) etc.
• Experience with various SAS Reporting System Maintenance, ETL,datawarehousing tools and concepts.
• Documented teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Manipulating, cleansing & processingdatausing Excel, Access and SQL.
• Responsible for loading, extracting and validation of clientdata.
• Liaising with end-users and 3rd party suppliers. Analysing rawdata, drawing conclusions & developing recommendations Writing SQL scripts to manipulatedatafordataloads and extracts.
• Developingdataanalytical databases from complex financial sourcedata. Performing daily system checks.Dataentry,dataauditing, creatingdatareports & monitoring alldatafor accuracy. Designing, developing and implementing new functionality.
• Monitoring teh automated loading processes. Advising on teh suitability of methodologies and suggesting improvements.
• Involved in defining teh source to targetdatamappings, business rules, business anddata definitions.
• Responsible for defining teh key identifiers for each mapping/interface.
• Responsible for defining teh functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with teh requestor and coordinate with teh development and testing team.
• Coordinate with teh business users in providing appropriate, TEMPeffective and efficient way to design teh new reporting needs based on teh user with teh existing functionality.
• Documentdataquality and traceability documents for each source interface.
• Worked with project team representatives to ensure that logical and physical ER/Studiodatamodels were developed in line with corporate standards and guidelines.
• Also Worked on some impact of low quality and/or missingdataon teh performance ofdata warehouse client.
• Identified design flaws in thedatawarehouse.

Confidential - Dallas, TX

Data Analyst

Responsibilities:

• Work with users to identify teh most appropriate source of record and profile thedatarequired for sales and service.
• Implementation of Metadata Repository, MaintainingDataQuality,DataCleanup procedures, Transformations, DataStandards,DataGovernance program, Scripts, Stored Procedures, triggers and execution of test plans
• Prepared test Data sets and performed data testing using teh PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Developed SQL - based data warehouse environments and created multiple custom database applications for data archiving, analysis, and reporting purposes.
• Document teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining teh business/transformation rules applied for sales and servicedata.
• Define teh list codes and code conversions between teh source systems and thedatamart.
• Worked with internal architects and, assisting in teh development of current and target statedata architectures
• Worked with project team representatives to ensure that logical and physical ER/Studiodatamodels were developed in line with corporate standards and guidelines
• Involved in defining teh source to targetdatamappings, business rules, business anddata definitions
• Responsible for defining teh key identifiers for each mapping/interface
• Responsible for defining teh functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with teh requestor and coordinate with teh development and testing team.
• Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system.
• Documentdataquality and traceability documents for each source interface
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.
• Evaluateddataprofiling, cleansing, integration and extraction tools(e.g. Informatica)
• Coordinate with teh business users in providing appropriate, TEMPeffective and efficient way to design teh new reporting needs based on teh user with teh existing functionality
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Responsible for defining teh key identifiers for each mapping/interface

Confidential - New York, NY

Business Data Analyst

Responsibilities:

• Performed sourcedataidentification and analysis to get a clean masterdatato report to customer
• Liaison between stakeholders, system users, clients and managers, software development team and teh QA term to gather requirements.
• Designed and implemented complex SQL queries for QA testing and report/datavalidation.
• Dataanalysis and reporting using MY SQL, MS Power Point, MS Access and SQL assistant.
• Monitored performance, integrity to optimize SQL queries for better efficiency
• Performeddatacleansing,datavalidation and mapping as described in teh business requirements.
• Write down teh SAS programs for processing ofdatasets and performdatamapping in thedata warehouse.
• Derived "To - Be" processes re-engineered for optimization
• Analysed business requirements and participated in requirement sessions to understand and identify missing, ambiguous, inconsistent requirements
• Managed Requirements & Requirements documents using Marketing Studio
• Created interactive reports and dashboards using tool tips and customized features such as subtotal, alerts, colour coding and drill maps to better understand business trends
• Proficient in downloading SAS flat files to Microsoft Word, Access or Excel for additional database for manipulation and analysis.
• Tested dashboards and reviewed thedatafor various KPI.
• Extensive use of EXCEL PIVOT tables to run and analyze teh resultdataset and perform UNIX scripting.
• Implemented business modelling,datamodelling, and object modelling using MS Visio to develop teh business architecture for teh application.
• Analyzed, build and documented teh different Metadata andDatadictionaries that will be required
• Actively trained Business Users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure.