SUMMARY:

• 9+ years of experience in the Information Technology (IT) Industry serving as a Data/Business Analyst and Lead Statistician in a Data warehousing environment.
• Experience working as Team Lead, managing timeline, data quality and accuracy for reports.
• Working experience in various Six Sigma projects.
• Working knowledge of Finance, Mortgage, Insurance, Aviation and Manufacturing domains.
• Extensive experience on interaction with system users in gathering business Expertise in analyzing/troubleshooting and providing technical support for Teradata/Unix applications and their interfaces.
• Experience in Data alignment and Data cleansing, Dimensional Modeling and Data Migration.
• Vast experience of working in the area data management including data analysis, gap analysis and data mapping. Worked extensively in Data consolidation and harmonization
• Strong understanding of RDBMS concepts and 3NF databases.
• Experience in Data Transformation, Data Loading, Modeling and Performance Tuning.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Extensively Used Teradata Utilities as FASTLOAD, MULTILOAD, FASTEXPORT etc.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience with creating reports using Tableau, Business Objects, MS PowerPoint and Excel.
• Experience in SAS, creating data sets and migration from SAS data set to Teradata
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for UAT. Experience in providing Production Batch support.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing and defect tracking.
• Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.
• Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures and Functions. Tuning using various types of Partitioning and Indexes.
• Good Knowledge and understanding of Big data concept, Hadoop, mango db.

TECHNICAL SKILLS:

Database:  Teradata, SQL Server, My SQL, Mainframe, DB2, Oracle (8i/9i/10g)

 Data Warehouse Concepts: ODS, Star Schema, Snowflake schema, OLTP, OLAP, Big Data

Operating Systems: UNIX, MS Windows

Design: Entity - Relationships, Data Flow Diagrams, BRD, Agile Stories

Languages: Teradata SQL, PL/SQL, UNIX shell, Visual Basics, Python

Tools: Tableau, Teradata, Informatica, Erwin, TOAD, Teradata, MS-Visio, E-R Studio, DB Visualizer, SQL developer, Business Objects, Hadoop

Reporting Tools: Tableau, Business Objects, Cognos, SAS EG, SAS 9.2

Desktop: Software Teradata SQL assistant, SAS, Putty, Minitab MS Word, MS Excel, MS PowerPoint, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Plano TX

Senior Data Analyst /Architect

Responsibilities:

• Gathering Business requirements in creating Tableau dashboard, preparing detailed business requirement document including flow diagrams, Tableau view description and metrics.
• Created detailed mapping document from source table laying out transformation and business rules.
• Involved in loading of data into Teradata from legacy systems and flat files using complex SQL and Python.
• Created People management, department management, compliance and summary views in Tableau.
• Created flattened base table for tableau and aggregated table based on business requirement.
• Created Business objects reports to meet business requirement and eliminating multiple manual excel reports.
• Created roadmap to convert all Business objects report as metrics in tableau dashboard.
• Worked with business to lay out plan to decommission Business objects and manual report once migrated to tableau.
• Worked with business on UAT of tableau scorecard and resolve all outstanding issues.
• Extensive use of transformations like Aggregate, Filter, Joins, Lookup, Update Strategy, Expressions, Sequence Generator.
• Applying referential integrity constraints to define relationship between fact and dimensions tables for tableau base tables.
• Wrote complex queries, store procedures and join indexes and performed performance tuning on existing scripts to achieve sub second response time
• Supporting production team to resolve data issues.
• Created Various Executive reports, Adhoc reports for management.
• Extensively worked in Agile methodology, took part in sprint planning, grooming and retrospective sessions
• Played role of scrum master and successfully lead standup’s in absence of scrum master.
• Created Epics in JIRA, updated stories, created burndown chart marked impediments and successfully carried out sprint.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database
• Developed and executed high performance SQL queries extracting large volumes of Mortgage Loan level data.
• Developed Reconciliation, Data Metrics, Referential Integrity and Data dump reports for OCC quarterly submission files using SAS Procedures such as Proc Report, Proc Freq, Proc Means, Proc Compare and customized ODS HTML Reports
• Compare Reports (Metrics, Referential Integrity and Validation reports) to Freddie Mac internal management reports and external disclosures. Analyzed in-depth and provided solutions for any discrepancies found during the process.
• Develop and maintain tableau dashboard scripts of all Servicing and defaults lobs.
• Successfully created requirement document to create associate based performance evaluation metrics in tableau.
• Scheduled all Dashboard base table scripts using Jenkins.
• Intensively used GitHub for maintaining production scripts.
• Effectively setup email notification to business user in case of dashboard refresh delay.
• Implemented data load check script in Jenkins to hold dashboard refresh until all source tables have been refreshed successfully.
• Created Natural disaster reporting dashboard for management after LA flood to monitor monetary loss and detective CTQ metrics to highlight any breach in government regulation.
• Successfully worked with business to created operational reporting to meet business day to day work Some of many includes example breach reports which tell business whom to send breach letter, lien monitoring report which tells business wither we lost first lien, equity analysis report for foreclosure team to decide whether they need to do equity analysis or not and other reports.
• Worked with outside vendors managing bankruptcy and REO portfolios for Confidential to resolve any issues in inbound files from vendor.
• Created Python script to load various flat files to Teradata tables.
• Created data model using regression, hypothesis testing and standard deviation.
• Created visualization view in tableau containing interactive charts and graphs based on geography, demographics, gender, income for various critical metrics.
• Created Python Script for edit checks on table loads.
• Created various Training documents for Process flow, Teradata, Agile etc. to help new hires gain speed.
• Created documentation for SQL best practice and tips to increase table performance and conducted sessions for team to educate on do’s and don’ts while developing scripts.
• Helped in managing Backlog by updating priorities and impacts based on business update meetings.
• Worked as Product owner for tableau updates and continuously work with pod to get stories in backlog and prioritize in sprint based on user’s urgency.
• Help Creating Story cards and organizing agile board with scrum master.

Environment: Teradata SQL Assistant, SAS Business Objects, Tableau, Jenkins, Python, SAS 9.2, GitHub, UNIX, JIRA, Jenkins, SQL developer, Mainframe, DB Visualizer, MS Office, putty VBA and SQL server, UNIX Shell Scripts

Confidential, Richardson TX

Lead Technical /Business Analyst

Responsibilities:

• Worked as Team Lead to support data availability for BCBS’s various work streams.
• Worked Directly with Business to capture requirements and Analyzing Requirements.
• Creating detailed System Requirement Specification (SRS) document.
• Performed Source System analysis to identify requirement in source system and its format.
• Performed Gap Analysis to identify shortcoming from source system, worked with source system SME’s to resolve gap and provided effective alternatives.
• Identifying source elements and prepared detailed source to target mapping document.
• Created Format map to translate source data type into target database.
• Created Integration Map to define primary, secondary unique keys.
• Created Field and Table Level Transformation rules according to business requirements.
• Developed Point based scorecards rating for physicians based on thresholds.
• Created datasets using Teradata & SAS for Gov. regulated affordable care act Reporting.
• Developed model for DataMart (PL Layer) using Erwin/Visio and enhancing model based on business recommendation and use
• Optimizing performance by using indexes (AJI, join indexes), joins and efficiently utilized perm and spool space areas to reduce running costs.
• Creating Scorecard for Health Provider based business rules using complex Teradata SQL (Multiple Table Joins, Volatile tables, Parameters, Complex Casting, and Index etc.).
• Worked closely with BI team to simplify SQL to remediate reports into Business objects
• Extensive use of specific Teradata functions Volatile Table, Qualify, Aggregated Join Index etc.
• Involved in implementing range constraints for large tables using partitioned primary indexes (PPI) to improve query performance.
• Developed Test Cases and Test Script as per federal requirement for Quality check of regulatory reports.
• Developed Python scripts to check data loads and trigger email if load fails.
• Worked with business to understand business process and creating detailed metadata.

Environment: Teradata, DB2, SQL server, Teradata SQL Assistant, Business Objects, Windows XP, SAS EG, SAS GRAPH, Unix, Informatica, Python, SQL developer, Mainframe, DB Visualizer, MS Office, Erwin, putty, UNIX Shell Scripts,

Confidential, Plano TX

Senior Data Analyst /Team Lead

Responsibilities:

• Worked Team Lead with from scratch development of SCRA, Stress Test & Basel Presentation layer including creating source to target mapping document, designing, SQL scripts development, performing UAT and defect resolution.
• Product owner & Data guardian for Mortgage data warehouse.
• Gathering Business requirements and transformation required.
• Identifying source and preparing source to target mapping document.
• Performing Source system analysis and identifying data gaps.
• Coordinating with business analyst to resolve the data gaps.
• Analyzed and Documented CTQ’s (Critical to Quality) process and wrote complex Teradata SQL queried to pull the metrics for CTQ ‘s which depicts if process is within agreed tolerance limit.
• Preparing monthly stress test and Basel reports by executing complex SQL queries in Teradata.
• Created new DataMart for soldier and sailor reporting.
• Developed model for DataMart (PL Layer) using Erwin/ Visio and enhancing model based on business recommendation and use
• Optimizing performance by using indexes (AJI, join indexes), joins and efficiently utilized perm and spool space areas to reduce running costs.
• Creating Scorecard for credit bureau reporting and default report based on logic specified by business using complex Teradata SQL (Multiple Table Joins, Volatile tables, Parameters, Complex Casting, and Index etc.).
• Worked closely with BI team and help them to understand SQL to remediate reports into Business objects
• Test Scorecard by creating test accounts and inserting into tables using Teradata utilities.
• Extensive use of specific Teradata functions Volatile Table, Qualify, Aggregated Join Index etc.
• Involved in implementing range constraints for large tables using partitioned primary indexes (PPI) to improve query performance.
• Performed Source to target mapping between various divisions and merging divisional entities with enterprise semantic layer to provide one common platform for divisional reporting as well as enterprise reporting.
• Creating Multi-Level Aggregate join indexes to meet reporting requirements and reducing query response time.
• Developed UNIX wrapper scripts JOBS for scheduling Teradata FLoad, Mload and BTEQ Scripts in UNIX environment for batch processing.
• Worked on UNIX shell scripting, FTP and file management in various UNIX environments
• Utilizing Teradata utilities such as FASTLOAD, MLOAD to load data received as flat files.
• Developing complex SQL scripts to update variables from source to target.
• Developing QA scripts to validate the data.
• Automating scripts to build more robust and consistent analytical frameworks.
• Perform root cause analysis in case data issue is identified.
• Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the process.
• Wrote complex queries, store procedures and join indexes and performed performance tuning on existing scripts to achieve sub second response time.
• Wrote programs using UNIX SAS to convert the tables on Oracle and DB2 databases into SAS datasets using SQL pass through facility.
• Created Various Executive reports, Adhoc reports for management.
• Involved in defining the dimensions, fact tables and data loading process.
• Lead to UAT team for Developing & executing Test cases on Data ware house.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database
• Mentoring new hire to get up to speed.
• Assisting in Logical and Physical data model for MDW.
• Used UNIX shell scripts for automating tasks for BTEQ and other utilities.
• Used Control M Scheduling tool to schedule daily and weekly scripts.
• Used Fast Export to export large data sets from Teradata tables or views to flat files
• Writing complex SQL to validate and to generate Reports.
• Report automation using Business Objects.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Involved in loading of data into Teradata from legacy systems and flat files using complex SQL and SAS scripts.
• Developing BTEQ scripts to batch-load large data sets into the existing database
• Performing Data Analysis for data cleansing and data standardizing purpose.
• Developed various charts and graphs such as scatter diagram-np charts to monitor process.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Delivered the artifacts within the time lines and excelled in the quality of deliverables.
• Used SAS EG to generate web based SAS reports.

Environment: Teradata SQL Assistant, Business Objects, Windows XP, SAS EG, SAS GRAPH, SAS 9.2, Windows 2003 Server, HP Unix, Informatica, SQL developer, Mainframe, DB Visualizer, MS Office,, putty VBA and SQL server, UNIX Shell Scripts,

Confidential, Dallas TX

Senior Business Analyst /Report Developer

Responsibilities:

• Gathering Business requirements and identifying process bottle necks.
• Used UNIX shell scripts for automating tasks for BTEQ and other utilities.
• Performed Source to target mapping between various divisions and merging divisional entities with enterprise semantic layer to provide one common platform for divisional reporting as well as enterprise reporting.
• Analysis on resolving pending RFS
• Co-coordinating with QA team to facilitate testing
• Interface with the Business SME’s for requirement clarification.
• Responsible for the creation of the HLD and specific development documentation for client projects.
• Responsible for multiple system interfaces related to the appraisal process.
• Working directly with the Business owner and Development team to implement the required changes.
• PL/ SQL against a SQL Server backend.
• Projects involved multiple systems and system teams.
• Responsible for liaison between groups to ensure all interfaces have been identified and captured.
• Creating CR’s & SR’s for production deployment.
• Developed daily reconciliation script to check data consistency between the daily fact and the weekly aggregates. If the consistency is off by more than threshold percentage set rebuild recommendation message will be sent to production support personnel.
• Created Various Executive reports, Adhoc reports for management.
• Involved in defining the dimensions, fact tables and data loading process.
• Lead to UAT team for Developing & executing Test cases on Data ware house.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database
• Expanding the weekly aggregate to join to enterprise cross reference tables. Work with enterprise reporting team to suggest efficient join strategies for semantic layer.
• Researched upstream data sources and ensured all source data sources were attested by its owners.
• Created report specifications containing mapping to source data sources.
• Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Documenting whole process for on-boarding support personnel to reduce learning curve.

Environment: Teradata, Oracle, UNIX, SQL server, SQL Developer, Business objects, Quick base, VBA and Erwin. SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Macros

Confidential, Plano TX

Senior Data Analyst /Teradata ETL developer

Responsibilities:

• Gathering Business requirements and identifying process bottle necks.
• Performing root cause analysis to identify the KPI’s and process shortcomings.
• Creating the enterprise ROLAP cubes from divisional facts.
• Harmonize the metrics in an enterprise fact. Join enterprise fact with enterprise dimensions to create the enterprise reports.
• Performed Source to target mapping between various divisions and merging divisional entities with enterprise semantic layer to provide one common platform for divisional reporting as well as enterprise reporting.
• Creating Multi-level Aggregate join indexes to meet reporting requirements and reducing query response time.
• Developing Trickle update option using stored procedure to mitigate lack of dynamic update on summary cube while insulating ETL impact.
• Developed daily reconciliation script to check data consistency between the daily fact and the weekly aggregates. If the consistency is off by more than threshold percentage set rebuild recommendation message will be sent to production support personnel.
• Created update process to run in parallel for all divisions without impacting each other.
• Simulating AJI’s by varying the size of update, insert and delete and Study IO/ spool and CPU differences between queries to arrive at a recommendation and suggest hardware requirements.
• Determine the additional CPU/ IO and SPOOL required for the process. Study the impact on existing ETL batch processes and reports.
• Expanding the weekly aggregate to join to enterprise cross reference tables. Work with enterprise reporting team to suggest efficient join strategies for semantic layer.
• Used Teradata performance monitor (PMON) to study the time consuming steps and finding resolutions.
• Study harmonization of metrics across divisions to form a single fact that joins with harmonized dimensions to enable sub second response for IPAD applications
• Applying referential integrity constraints to define relationship between fact and dimensions tables.
• Wrote complex queries, store procedures and join indexes and performed performance tuning on existing scripts to achieve sub second response time.
• Documenting whole process for on-boarding support personnel to reduce learning curve.

Environment: Teradata, Micro strategies, Windows XP, UNIX, Informatica, SQL Developer, PMON, MS Office, putty, VBA and Erwin. SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Macros

Confidential, Plano TX

Data Analyst III/Team Lead

Responsibilities:

• Team Lead with end-to-end grasp of the entire Datamart (MUDS) development including creating source to target mapping document, designing, SQL scripts development, performing UAT and defect resolution.
• Product owner & Data guardian for Mortgage data warehouse, tracking timeline, developing UAT plan, assisting in Data modeling, resolving data issue, assisting in developing Roadmaps.
• Served as Subject Matter Expert for Mortgage data assisted in requirement gathering, data modeling and data quality
• Consolidating Data from different sources to build BI Layer for reporting.
• Providing monthly reports to Loan origination & default management
• Performing Data Analysis for data cleansing and data standardizing purpose.
• Worked with several marketing managers and project manager to gather financial data and requirements and build reports using Teradata SQL.
• Performing Source to Target Mapping.
• Supporting production team to resolve data issues.
• Created Various Executive reports, Adhoc reports for management.
• Involved in defining the dimensions, fact tables and data loading process.
• Lead to UAT team for Developing & executing Test cases on Data ware house.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database
• Mentoring new hire to get up to speed.
• Assisting in Logical and Physical data model for MDW.
• Used UNIX shell scripts for automating tasks for BTEQ and other utilities.
• Used Control M Scheduling tool to schedule daily and weekly scripts.
• Used Fast Export to export large data sets from Teradata tables or views to flat files
• Writing complex SQL to validate and to generate Reports.
• Report automation using Business Objects.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Involved in loading of data into Teradata from legacy systems and flat files using complex SQL and SAS scripts.
• Developing BTEQ scripts to batch-load large data sets into the existing database
• Extensive use of transformations like Aggregate, Filter, Joins, Lookup, Update Strategy, Expressions, Sequence Generator Transformations.
• Developing VBA macros for populating charts in MS PowerPoint.
• Creating management reports including origination, performance and portfolio reports in form of PowerPoint slides.
• Acted as Subject Matter expert (SME) for home loan portfolio.
• Reduced Teradata space used by optimizing tables - adding compression where appropriate and ensuring optimum column definitions.
• Extensively worked on Teradata performance optimization by using various Teradata optimization strategies and increased the query throughput
• Worked extensively for OCC reporting, STRESS TEST and BASEL
• Assist in defining technical requirements for the ETL process and reporting in an aggressive time-lined project implementing Standard SDLC processes.
• Wrote programs using UNIX SAS to convert the tables on Oracle and DB2 databases into SAS datasets using SQL pass through facility.
• Developed and executed high performance SAS/SQL queries extracting large volumes of Mortgage Loan level data.
• Developed Reconciliation, Data Metrics, Referential Integrity and Data dump reports for OCC quarterly submission files using SAS Procedures such as Proc Report, Proc Freq, Proc Means, Proc Compare and customized ODS HTML Reports
• Compare Reports (Metrics, Referential Integrity and Validation reports) to Freddie Mac internal management reports and external disclosures. Analyzed in-depth and provided solutions for any discrepancies found during the process.
• Developed Shell scripts to parallel extract and process data from CDW sources simultaneously to streamline performance and improve execution time (up to 800 million records within 2.5 hrs) in a parallel process for better time, resource management and efficiency.
• Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Multiload, Fastload, Fast export and BTEQ.
• Developed standard and re-usable mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router using Informatica Power Center.
• Participated in Measure and analysis process of lean six sigma project as Green Belt.
• Modified the existing mapping template.
• Developed complex SQL queries to bring data together from various systems.
• Developed various charts and graphs such as scatter diagram-np charts to monitor process.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Delivered the artifacts within the time lines and excelled in the quality of deliverables.
• Used SAS EG to generate web based SAS reports.

Environment: Teradata SQL Assistant, Business Objects, Windows XP, SAS EG, SAS GRAPH, SAS 9.2,Windows 2003 Server, HP Unix, SQL developer, Mainframe, DB Visualizer, MS Office,, putty VBA and SQL server, UNIX Shell Scripts,

Confidential, Middleboro MA

Lead Developer /Statistician/Lean Six Sigma/Quality Specialist

Responsibilities:

• Development of Customer Complaint Handling System and Returns Goods Authorization System.
• Conducting Statistical analysis including Analysis of variance, Hypothesis testing and Design of experiments.
• Developing Management reports using Cognos and Microsoft excel.
• Developing SAS data sets to facilitate statistical analysis and six sigma projects using Teradata SQL assistant.
• Developed SAS data set to perform Pareto analysis and root cause analysis from defect tracking system
• Participated in Six Sigma Project to cut done customer returns.
• Performed analysis of variance for defect issues using statistical tool such as Minitab.
• Analyzed data and developed strategies to prevent production problems
• Conducting Design of experiments and Failure mode effect analysis for new product development process.
• Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Multiload, Fastload, Fast export and BTEQ.
• Participated in Measure and analysis process of lean six sigma project as Green Belt.
• Resolving Data issues to improve data quality.
• Modified the existing mapping template.
• Developed complex SQL queries to bring data together from various systems.
• Developed various charts and graphs such as scatter diagram-np charts to monitor process.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Identified the source and target tables. Developed mapping document using MS excel.
• Determined the natural keys for the target tables.
•  Performed Data alignment and Data cleansing.
• Developed Reports using SQL Server Reporting Services (SSRS)
• Provided the required transformation logic using SQL.
• Organized and conducted cross-functional meetings to ensure linearity of the phase approach.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Delivered the artifacts within the time lines and excelled in the quality of deliverables.
• Validated the data during UAT testing.

Environment: Minitab, SAS, Teradata, Cognos, Windows XP, Windows 2003 Server, HP Unix, Informatica 7.1, SQL developer, Mainframe, DB Visualizer, MS Office, putty, PPM VBA and Access 2007 / VBA.