SUMMARY

• Over 10+ years of total IT experience in software analysis, design and development for various software applications in client - server environment wif expertise in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems.
• Experience in Information Technology as Business Analyst/Data Analyst, Access/Excel Developer, Metrics/Reporting Analyst, and Financial Systems Analyst using Big Data, Teradata, Hadoop, Oracle, SQL, DB2 and MS Access RDBMS.
• Expertise in SAS/Base, SAS/Graphs, SAS/Macros, SAS/ODS, SAS/SQL, SAS Access, SAS/STAT, SAS/Connect, SAS/ETL.
• Extensive experience in preparation of reports, tables, listings and graphs.
• Excellent command in producing reports employing various SAS Procedures and handling Large Databases to perform complex data manipulation using files in SAS data steps.
• Loaded data from any source into teh SAS LASR Analytic Server, users can visually and interactively explore data to gain insights and discover patterns and trends for further analysis.
• Manipulated, merged and created restructured datasets from big data using Machine learning, Hadoop, Big Data, SAS, Python, R, SQL and built predictive models.
• Excellent experience in ETL processing using Informatica Power Center 8.x/ 7.x, Power Connect, Power Exchange.
• Extensive experience in LSF Platform. LSF batch TEMPhas sophisticated controls for sharing hosts wif interactive users.
• In-depth understanding of Data warehousing concepts such asBill Inman, Kimball methodologies wif strong understanding of Logical, Physical, and Dimensional Data Modeling to Design Star and Snow Flake Schema’s.
• In depth noledge of Access including tables, queries, forms, reports, Access SQL.
• In depth expert level noledge of Excel including defined data ranges, data validation, functions, pivot tables, MS Query, V-Lookups, Sum-Ifs, arrays, macros, graphing, VBA, backwards compatibility and Excel/Access integration.
• Teradata: SQL scripting, uploading data, creating tables/views, development of presentation layer.
• Knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Experience in SQL Server Reporting Services, Cognos, Crystal, Business Objects.
• Responsible for creating ETL design specification document to load data from operational data store to data warehouse.
• Experience in MS Excel, PowerPoint and other MS Office Suite.
• Created numerous Volatile, Global, Set, Multiset tables.
• Performing Ad-hoc reports by using Oracle, Teradata and UNIX.
• Experience in Banking and Credit Card industry business processes.
• Extracting data from existing data sources, Developing and executing Business reports for Performance Monitoring
• Experience in Data Validation and Verification and documenting teh results.
• Experience in Writing BASE SAS Programs for converting Teradata table into Flat files.
• Quick learner and excellent team player wif good communication and presentation skills.

TECHNICAL SKILLS

Web Development: ASP.NET, HTML, CSS, Javascript, XML/SOAP Web Services, IIS, ASP

SAS: SAS Base, SAS/Macro, SAS /Connect, SAS-SQL, SAS/ STAT, SAS/Graph, SAS/Acess, SAS Enterprise Guide, Enterprise Miner, SAS, Information Map, Web Report Studio.

Windows Development: Winforms

Databases: Teradata, SQL Server 2000/2005, Oracle (8i/9i/10g), MS-Access 97/2000, PL/SQL, T - SQL, ADO.NET, SQL, Python, Big Data, Hadoop

Query tools: Teradata SQL Assistant, SQL Server Management Studio, SQL Query analyzer, SQL Enterprise Manager, ETL Tools Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), TOAD

Scripting: UNIX Shell Scripting (Bourne,Korn,Cshell), VB script, VBA, JSP

Languages: VB.NET, C#.NET, C, C++, Pro*c

Development Tools: Visual Studio.NET 2002/2003/2005/2008 , Visual Studio 6.0, Team Foundation Server

Web Servers: IIS 5.0/6.0, Java Web Server 2.0, Tomcat, and JSWDK1.0.1.

Reporting tools: Crystal reports 9.0/10.0, XtraReports

Design Tools: UNICA(AC), UML, Rational Rose, Ms Visio, AutoCAD, PRO - E

Versioning tools: Visual SourceSafe 6.0d

Operating Systems: Windows NT/2000/2003/XP, UNIX, DOS

Other: Team Suite and agile development, SharePoint Portal Server, Windows SharePoint Services, Microsoft Enterprise Library, web client software factory, Active Directory

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. Business Analyst/Sr. Data Analyst

Environment: SAS Enterprise guide, UNIX, Tableau, SQL, DB2, Teradata SQL Assistant, Service Now, Metadata, SQL Server Management Studio, JIRA, PowerPoint, MS Excel, SharePoint and MS Word, Metadata Repository, Big Data, SAS/GRAPH, SAS/STATS, SAS/Connect, SAS Macros.

Responsibilities:

• Define, Manage, and Schedule, and accurately estimate all teh tasks duration to develop and maintain a realistic schedule completing all inputs for data assessment and retention work stream by using Teradata, MS Excel, Tableau, SAS and UNIX.
• Develop, Manage and Plan teh cost, time scope, goals, and deliverables for Health Data Governance Program. Communicate teh plans, allocating tasks and setting milestones.
• Drive work efforts wif Risk and Compliance, business, and technology partners to identify specific data elements used by Risk and Compliance processes and to implement Enterprise Data Governance wifin teh BBY Health Program to support achieving HITrust certification.
• Improve security of not only sensitive data, but all data to establish Enterprise Data Governance practices.
• Create extensive PHI inventories to showcase all storage locations where PHI data is stored and gather all data points for assessment and remediation.
• Conduct current and future state assessments across BBY Health systems.
• Assessment, implementation of all applicable HITrust Security Framework requirements.
• Creating an environment of well documented data, trusted organizational assets, better and faster decision making, increased efficiency.
• Conduct Interviews wif Application owners to collect all teh details (DB Details/purpose/owners/PHI Inventory/SOR/IRM (Information records Management)).
• Involved in Remediation Items and Decommissioning Process for applications which are not in use.

Confidential, Minneapolis, MN

Business Analytic Consultant

Environment: SAS Enterprise guide, UNIX Shell scripts, Tableau, PC SAS, SQL, DB2, Teradata SQL Assistant, BTEQ, Metadata, SQL Server Management Studio, JIRA, PowerPoint, MS Excel, SharePoint and MS Word, SAS/GRAPH, SAS/STATS, SAS Macros.

Responsibilities:

• Worked wif Business analysts to Provide Business Performance Data and other data using Teradata, Oracle, SQL and UNIX.
• Designed Test system wif SAS, SAS Macros, Meta Data, Oracle SQL, Oracle, AIX/Unix and Unix Shell Scripts.
• Responsible for ad hoc reporting and LOB support for recurring process information.
• Gathered and analyzed detailed Sandbox Remediation and recurring process information.
• Managed SAS EG processes for Tableau Reporting.
• Responsible for analyzing business requirements and developing Reports using PowerPoint, Tableau, Excel to provide data analysis solutions to business clients.
• Created monthly reports related by using Teradata, MS Excel, Tableau, SAS and UNIX.
• Analyzed teh Business Concepts, worked wif various functional groups to understand teh underlying concepts.
• Extensive hands on experience wif numerous technologies including RDBMS, Oracle SQL and PL/SQL programming, Stored Procedure development, SQL Loader, Microsoft SQL Server 2000 database design and development.
• Documented all teh recurring processes.
• Converted Business Requirements to teh Functional Specification.
• Designed and developed monthly reports related to teh Databases by using SQL, MS Excel, Tableau, Teradata.
• Created tables, indexes, views, snap shots, database links to see teh information extracted from SQL files.
• Developed SQL scripts for data loading and table creation in Big Data and Teradata.
• Created different set of tables (Like Set, Multiset, Derived, Volatile), Macros, views, procedures using SQL scripts.
• Wrote SQL scripts for large data pulls and ad-hoc reports for analysis.
• As per Ad-hoc request created History tables, views on teh top of teh Finance Data mart/ production databases by using Teradata.
• Created tables, indexes, views, snap shots, database links to see teh information extracted from SQL files.
• Run reporting programs and download teh results into EXCEL and deploy teh feeds into Tableau.
• Created SAS Views from tables in DB2 using SAS/Access.
• Developed SQL scripts for data loading and table creation in Teradata.
• Extensively worked on Unix Shell Scripts for automating teh SQL scripts, checking daily logs, sending e-mails, purging teh data, extracting teh data from legacy systems, archiving data in flat files to Tapes, setting user access level, automating backup procedures, Scheduling teh Jobs, checking Space usage and validating teh data loads.

Confidential, Greenville, SC

Sr. SAS Business Analyst / Programmer

Environment: SAS Enterprise guide, Big Data, UNIX Shell scripts, Mainframes, Tableau, PC SAS, SQL, DB2, BigData, Teradata SQL Assistant, BTEQ, Hadoop, Process Manager, Text Analytics, Netezza, SAS Management console, Metadata, Python, PowerPoint, MS Excel, MS Word.

Responsibilities:

• Worked on SAS 9.1/9.2/ (SAS Unix): SAS/Base, SAS/SQL, SAS/Macro, SAS/Access to Extract, process/calculate and Load data from BigData, Hadoop and Central Teradata DWH (Teradata 06.02.0256 V2R) onto SAS platform.
• Created Macros, in order to generate reports daily, monthly basis.
• Used Microsoft SQL Server 2000 for SQL.
• Involves in all phases of software development life cycle Gather requirements from clients and converting business requirements into technical specifications.
• Develops program logic for new, complex applications or analyzes and modifies logic in existing complex applications. Accurately delivers complicated code, configuration changes and enhancements.
• Contributes to releases wif high quality code and unit tests, having challenges in complexity or deadlines. Implements and verifies a complete unit test.
• Contributes to design documents.
• Adhered to Software Development Life Cycle Standards (SDLCS) and all applicable Data and Technology Services Policies and Standards.
• Developed and integrated complex application code to meet teh design specifications for moderate to complex enhancements or change requests.
• Improves stability of platforms, applications, services and systems.
• Effectively communicates wif customers, teammates or other stakeholders, and may function as lead or point of contact.
• Shares noledge of systems and mentors or trains others.
• Develops and manages relationships wif diverse groups of stakeholders at multiple levels.
• Provided data to financial business analyst in graphical format by using Power Point.
• Created Daily, Weekly, monthly reports related by using Teradata, Ms Excel, Tableau, Big Data and UNIX.
• Designed and developed weekly, monthly reports related to teh marketing and financial departments by using SQL, MS Excel, Tableau, Hadoop, MS Access, Teradata, Big Data.
• Pulled DB2 fields for marketing campaigns and used SAS for reporting campaigns.
• Working on Auto Insurance and State Rollouts Project of Legacy Countrywide.
• Managed teh capturing of metadata definitions and mappings.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into BigData, Hadoopand data warehouse from multiple sources.

Confidential, Concord, CA

Credit Risk Analytics Consultant

Environment: SAS Enterprise Guide, Tableau, UNIX Shell scripts, DB2, SQL,, Putty, Netezza, Teradata 13.0, Hadoop, Oracle Teradata SQL Assistant, Python, Big Data, VB, JDA WMS, Mainframes, BTEQ, Oracle 9i, PC SAS, PowerPoint, FTP, MS Excel, MS Word

Responsibilities:

• Worked closely wif Engineering to implement any software required for accessing and handling data appropriately.
• Responsibilities include writing SAS MACRO CODE, SQL to read and create METADATA files on UNIX.
• Developed and implemented counter offers and verification of income strategies by obtaining approvals from senior management and business partners (Risk Managers, Product, Finance, Compliance, corporate Credit, Operations and Technology Groups).
• Created complex and reusable Macros and extensively used existing macros and developed SAS.
• Created tables, indexes, views, snap shots, database links to see teh information extracted from SQL files.
• Run reporting programs and download teh results into EXCEL and build pivot tables.
• Installed Hyperion/Brio and developed reporting queries for user.
• Managed teh capturing of metadata definitions and mappings.
• Developed SQL scripts for data loading and table creation in Big Data and Teradata.
• Did analysis on Oracle databases.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into BigData data warehouse from multiple sources.
• Documentation, preparing statistical reports using SAS.
• Wrote Design documents, Program specs and SAS code.
• Understand teh business processes and help select teh most appropriate functional requirements specification and business processes.
• Involved wif Business analysts to Provide Business Performance Data using Big Data,Teradata, Oracle, SQL, BTEQ, and UNIX.
• Developed Access databases, crystal reports and VB/VBA code for Sales Tracking and Reporting.
• Created Daily, Weekly, monthly reports related by using Big Data, Teradata, Hadoop, MS Excel, Tableau and UNIX.
• Wrote BTEQ, SQL scripts for large data pulls and ad hoc reports for analysis.
• Created tables, indexes, views, snap shots, database links to see teh information extracted from SQL files.
• Created different set of tables (Like Set, Multiset, Derived, Volatile), Macros, views, procedures using SQL scripts.
• Extensively worked on Unix Shell Scripts for automating teh SQL scripts, checking daily logs, sending e-mails, purging teh data, extracting teh data from legacy systems, archiving data in flat files to Tapes, setting user access level, automating backup procedures, Scheduling teh Jobs, checking Space usage and validating teh data loads.
• Basel II reports prepared and implementation to manage and assess credit portfolios.

Confidential

Sr. SAS / Data Analyst

Environment: UNIX, Teradata, SQL, SAS, Oracle, SAS Enterprise Guide, MS-Access, MS-Excel, MS-Office, Microsoft Visio, MS Access, Word, Excel and Power Point.

Responsibilities:

• Extracted data from existing data source and performed ad-hoc queries by using SQL, Ms Access and UNIX.
• Designed & developed various departmental reports by using SAS, SQL, and Ms Excel
• Migrated data from Flat Files to Oracle database
• Created Unix Scripts dat uses Bteq to access Teradata Database.
• Converted Scripts from Oracle to Teradata.
• Created tables, indexes, views, snap shots, database links to see teh information
• Extracted from SQL, SAS files.
• Moved SAS jobs from Mainframe to UNIX server and modified and enhanced teh codes to execute in UNIX platform.
• Did prepare XML/XSLT files for data transfer between mainframe and NT.
• Performed user acceptance testing for new modules to UNICA system,
• Verifying performance and documenting errors.
• Developed Datamart and setup Informatica for data migration
• Wrote access, SQL and PLSQL queries to work wif Oracle databases and Financial applications.
• Involved in writing stored procedures and packages using.
• Tuned teh queries to improve teh Performance of teh existing reports for various functional areas.

Confidential

Data Analyst

Environment: Oracle 8i, SQL, SAS, UNIX, Mainframes, BTEQ, Visual Basics 6.0, Windows NT, MS Access, Word, Excel, Power Point.

Responsibilities:

• Reading raw data, Validating, Manipulating from Flat Files and Creating Tables in Oracle Database Analytical Environment.
• Creating Monthly Business Reports by writing Oracle SQL.
• Documentation teh Process and Steps for creating reports.
• Developed data maps for retrieval of information from existing account systems.
• Outlined security measures for accessibility and transmission of information.
• Wrote SQL queries to verify teh system functionality and provided teh users wif teh needed data and information during operational phase.
• Designed and developed Search and View screens and did field level validations for all teh fields used in teh application using VB 6.0.
• Perform data manipulations and scrubbing.
• Designed teh database in MS Access (Creation of Database, tables, views and Procedures).
• Performed validation testing and UAT to produce clean and consolidated results.
• Worked on creating shell scripts efficiently.
• Physical database design and tuning.
• Developed and implemented new ways for determining which diagnoses were pre-existing conditions and teh environmental factors affecting individuals participating in teh program.
• Created and maintained data management and statistical report programs.
• Created data sets from raw data sets for teh analysis of safety and efficacy data using SAS to access remote clients.
• Generated interpretive summaries, charts, and tables to list reports in accordance wif regulations.
• Drew conclusions based on analysis. Prepared manuscripts upon study completion, as well as various management reports.
• Worked extensively wif business users on requirements gathering, analysis and documentation.
• Interacted wif clients, modelers and analysts to define targeted populations and control groups.
• Assisted teh DBA wif scheduling jobs, running various scripts related to space management
• Assisted in documenting User Manual and facilitate UAT and provide follow up to resolve teh issues.