SUMMARY:

• A data driven and result - oriented professional with over 12 years of experience in software technology to deliver and support analytics solutions in various business domains such as Banking, Insurance, Credit Cards, Oil & Gas & Healthcare.
• Confidential professional work experience in generating business value from enterprise data using Data extraction, transfer, Load, ETL, data migration, data cleaning, Data Aggregation, Data modelling, Data Analysis and data visualization.
• Technical expertise on latest technologies such as Advanced Confidential, Big Data, Hadoop, HIVE, SQOOP, Informatica, SAS Visual Analytics, SAS, SAS Enterprise Guide, SAS Management Console, SAS DI Studio.
• Extensive experience to work with cross functional departments (Sale, Supply, maintenance, operation, IT) in an organization to manage master data efficiently and appropriately.

TECHNICAL SKILLS:

SAS Tools: SAS Visual Analytics, SAS Enterprise Guide, SAS DI Studio, SAS Management Console, SAS/Access, SAS Connect, SAS/ETL, SAS/HDAT, SAS HADOOP, SAS 9.x

Reporting tools: SAS Visual Analytics, SAS Enterprise Guide, SAS Management console, SAS Scheduler, MS- Excel, SAS BI Platform, MS-VISIO, Erwin Data modeler, PowerDesigner

Database: Hadoop Confidential, Oracle 10g, MS SQL Server, DB2, Teradata, SQL Server, MS Access, SAS/Access to RDBMS, SAS/Connect, SAS/Share, SAS OLAP, IBM DB2

Operating Systems: Windows 95/98/XP/Vista/Win 7/8/10, UNIX, LINUX (Redhat)

Batch Server: UNIX, Putty, SSH, and SAS scripting, Unix Shell Scripting.

Office Tools: MS-OFFICE, Word, Excel, PowerPoint, MS ACCESS, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Integration Consultant (SAS), Houston, TX

Responsibilities:

• Perform business data analysis and initiate conversations with all stakeholders planning on using company's data in different ways possible to generate business values.
• Work with Enterprise data Architects across department to understand sale, supply, maintenance, repair and operations data to effectively manage master data.
• Continuously monitor business applications and data captured to align it with master data. Guide applications developers/architects to design applications compatible with master data requirements.
• Prepared common data model for different segments in the organization using galaxy schema having more than 4 fact table and more than 10 dimension tables.
• Prepared complex data model for enterprise data consolidation and to prepare Common data model architecture to support future business needs.
• Lead team to design and build visualization reports using SAS Visual Analytics on Data Builder/Data Preparation, Report Designer and Data Exploration.
• SAS Developers to design corporate role based access to various Analytics solutions based on company’s data security model (using SAS Group based policy and SAS VA collection for dashboards).
• Setup connectivity to Oracle/Hadoop Confidential and other databases using SAS/ACCESS, PROC SQL, SQL PASS to access data directly for implicit and explicit processing.
• Read data from Hadoop Confidential & Oracle by writing new SAS programs using SQL Pass through facility and Libname methods to create study specific SAS datasets, which are used as source datasets for report generating programs in SAS VA.
• Work extensively in sorting, merging, concatenating and modifying SAS data sets using BASE SAS to generate appropriate SAS datasets to be loaded to SAS LASR Analytics server.
• Experience working with structured, semi-structured and unstructured data sets, determining key take away and communicating them pictorially to generate business values
• Build interactive SAS Visual Analytics (SAS VA) reports (dashboards) showcasing the utilization of company’s people and assets to derive opportunity for optimizing utilization and reducing operating costs.
• Administer SAS Products and servers (physical, virtual memory) using Management console, SAS Enterprise guide, Unix Shell Scripts, Unix Cron, SAS Schedule Manager.
• Administer user access to SAS VA reports. Manage access levels to secure vs public reports.
• Administer SAS Analytics LASR server for physical and virtual memory utilizations spread across root and worker nodes in SAS high-performance deployment on Hadoop.
• Start, stop SAS LASR Analytics servers. Load, unload register and de-register tables loaded to SAS LASR servers.
• Administer SAS VA LASR servers and various development and prod environments. Administer report and SAS dataset migration to Dev/QA and Prod environments.
• Worked with IT team to deploy SAS Products such as Base SAS (v9.4), SAS Enterprise Guide (7.11), SAS Management Console, SAS Visual Analytics (v7.3) and Hortonworks Hadoop cluster in a private data center.

Tech lead /Sr. Scrum master

Confidential, San Jose, CA

Responsibilities:

• Worked with technical team on Cisco's private Confidential to deploy enterprise IT PaaS Platforms/applications and Infrastructure services.
• Worked as Agile PM/Scrum master to kick start Agile/Scrum framework journey with team deploying Confidential and Platform Services.
• Instructed core agile principles of collaboration, prioritization, team accountability and visibility; ensuring consistent application of scrum methodologies across the enterprise.
• Lead Scrum Sprint ceremonies such as: Sprint planning, daily stand-up meetings, Product backlog Grooming, Sprint retrospectives and Sprint review sessions.
• Have enacted key initiatives such as preparing Sprint Calendar, Teaming Agreement, Resource point vs Story points to help team learn Scrum framework gradually and at pace consistent with Team’s Sprint performance.
• Worked with Product Owner to refine product backlog to meet project vision & business expectation.
• Conducted Spike sessions during the sprint to elicit information for unknown requirements to help product owner write future requirements as User stories.
• Resolved issues affecting team’s velocity by extensively working to reduce from each sprint, thereby increasing team’s Velocity by 30% in a span on 4 Sprint duration.
• Conducted Sprint retrospectives using innovative techniques to help overcome recurring issues impacting team’s performance.
• Helped team to understand concept of sizing (estimating) user stories by planning poker and Fibonacci series method
• Enacted change to remove impediments and helped team to increase quality of deliverables by over 30%.
• Met goal of addressing and resolving issues within 24 hours by removing impediments faced by the team or by managing stake holder’s expectation correctly.
• Hands on experience in using CA Agile Central (Rally) to track, manage & facilitate Scrum ceremonies.

Confidential

Technical Lead/Scrum Master

Responsibilities:

• Assessed migration readiness of existing SAS 9.2 client platform by doing deep dive and impact analysis.
• Executed SAS Migration Utility to check existing SAS products installed and migration readiness of each to version to 9.4.
• Planned migration plan with resource mapping, cost estimates, dependency chart, test schedules.
• Lead end to end system testing / validation testing / regression testing of SAS programs, SAS Reports & jobs.
• Automated new and existing jobs and perform upgrades, patches hotfix, backup, and maintenance release installations of the SAS environments.
• Created new SAS programs and fine-tuned existing SAS programs for better performance in SAS 9.4 by using SAS PROC, SQL MACROS, SAS SQL, SAS Connect, SAS ACCESS.
• Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information.
• 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.
• Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information
• Build SAS datasets from clinical database and developed programs using the LIBNAME statement & SAS Views to extract & report error statistics.
• Develop SAS macros, templates and utilities for data cleaning and reporting.
• Used various components of an INPUT and INFILE statements to process raw data files
• Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT etc.
• Prepared Unix shell scripts for starting and stopping SAS services like Metadata server etc. and also mid-tier services like SAS application service, Web logic SAS Managed server.
• Successfully deployed two tier SAS Development and UAT environment to plan future upgrades and code release smoothly

Confidential

Data Integration Consultant

Responsibilities:

• Responsible for Initial design for data extraction, data transfer and data load (ETL) from source systems to load into existing Confidential Internet Banking application and database.
• Designed end to end ETL flow to extract tables from source and load to staging zone, moving refined and consolidated data to transfer zone, and then loading finalized consolidated data into OLTP & OLAP database.
• Prepared conceptual & physical data entity relationship diagram to define enterprise wide data architecture.
• Held meetings with data architects and database administrators to help define “as-is” data and “to-be” system processes and proposed Databases.
• Lead team of onshore and offshore developers to design, develop and support ETL and data migration & data visualization schedules.
• Lead team to create and generate business intelligence reports to generate business values.
• Design scheduled migration process merging 6 million active HBoS customers with existing Confidential Internet Banking application and database.
• Played active part in preparing database design, data modeling, and data validation during ETL process using SAS DI Studio and mainframes batch jobs.
• Extensive experience working with OLTP & OLAP data bases and in designing dimensions and facts models in star schema, Snow flake Schema, Galaxy Schema’s.
• Prepared detailed to design to migrate customer’s data from source to target using ETL process in various migration cycles such as Bulk Migration, Reverse migration, On demand migration, ad-hoc migration.
• Planned bulk data migration, reverse Migration, ad-hoc migration & integration strategies with DBA’s on complex data migration releases spread across months.
• Prepared Tech Specs documents and liaised with Test teams to verify QA test cases & test scripts and plan System testing, Integration testing and UAT plans.
• Prepared activity diagram, screen flow diagrams and flowchart for various modules of internet banking
• Prepared data modeling to create Use Cases, work flow, system designs.
• Managed system design, development, and enhancement and testing of business critical applications.

Confidential

Data Migration Analyst

Responsibilities:

• Designed detailed architecture to migrate existing legacy users to new Digital platform using multiple regular migration schedules.
• Transitioned the delivery of Internet banking and public websites to new platform while upgrading underlying infrastructure.
• Deployed new features such as faster payment, two factor authentication, fraud protection as well as compliance & regulatory initiatives
• Held meetings with data architects and database administrators to help define as-is data and system process and proposed Database and upgraded systems/applications requirements.
• Lead a team of onshore and offshore members with around 10 onshore and 30+ members at offshore.
• Planned implementation strategy with DBA’s on complex data migration releases.
• Planned Data Migration, Reverse Migration, Bulk Migration strategies with DBA’s and System Analysts
• Worked closely with DB2 Technical Architect and DBA’s for planning, management & implementation of DB2 z/OS high availability solution & upgrade to DB2 V8 z/OS, for Internet Banking applications.

Confidential

IT Analyst / Programmer

Responsibilities:

• As Module lead responsible for requirement analysis, development, testing and coordination with the clients.
• A key member in preparing the system HLD and LLD.
• Accepting production incidents within accepted SLA and analyzing incidents to classify as defect/Change
• Investigations of change requests and making appropriate code changes to fix the problem.
• Raising request with configuration manager for production release and tracking CR/defect to production implementation.
• Accepting new requirements and passing it on the team members.
• Guiding team members to write exhaustive test scripts to test new requirements.
• Liaising with different stake holders to plan implementation.
• Working on system enhancements/changes requests on periodic basis.

Confidential

Systems Analyst / Programmer

Responsibilities:

• Worked as team member with primary responsibility of analysis, design and coding for incidents being raised.
• Engaged in Maintenance and Support of the existing systems
• Taking up enhancements/changes on periodic basis for existing systems.
• Preparing Unit Test Plans, test cases and executing them.
• Worked on change requests as raised by clients.
• Understanding technical specification document and transferring it to code.