OBJECTIVE:

• To obtain a challenging position as Data/Business Analyst with an emphasis on Data Warehousing to utilize my qualification and experience in Data analysis, Statistical analysis, Data validation, Data Modeling & Gap Analysis successfully.

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

SR 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, PythonSAS 9.2, GitHub, UNIX, JIRA, Jenkins, SQL developer, Mainframe, DB Visualizer, MS Office, putty VBA and SQL server, UNIX Shell Scripts

Confidential

Senior Technical Data 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

Data Analyst

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 GRAPHSAS 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 baseVBA and Erwin. SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Macros