SUMMARY

• Highly motivated, tech - savy professional with 10+ years of work experience in US Banking and Healthcare verticals
• Expertise in different activities of MIS Rationalization & Standardization, Self Service, Data Modeling, Data Mapping, Data Profiling, Data Quality, Data Management,, Data Analysis and exploration.
• Good Hands on experience in data mining activity from different data bases Oracle, Tera data, SQL Server and DB2 using SAS and SQL
• Build complex queries in SQL for critical data analysis and ad-hoc questions
• Strong technical skills in SQL, SAS and Teradata environments
• Expert in requirements gathering, documentation & convert business requirements into technical specifications.
• Build High level design documents(HLD) for the project and add detailed information such as Entity, Subject Area’s, Source to Target mapping docs and other process flow
• Strong Banking and Financial Experience with different LOB’s such as Retail, Credit Card, Campaign Management and Auto Lending
• Developed Risk to Finance reports and make sure that both are aligned for further reporting needs
• Understanding the business requirements and guide the team members to complete the complex specifications/ projects.
• Able to manage project individually and also motivate team towards organization objective.
• Expert in requirements gathering, documentation & convert business requirements into technical specifications.
• Expert in designing analytical data warehouse (ADW) environment for all the analytical and reporting needs for an organization.
• Involved in designing Conceptual, Logical and Physical data models while setting up Analytical data warehouse
• Quick in understanding data, data environment & Problem solving skills
• BASE SAS Certified Programmer (Issued on 31MAR2008)

TECHNICAL SKILLS

Languages: SQL, Teradata, SAS Revolutionary R and Hadoop

Data Base: Oracle, SQL Server, MS Access and Teradata

Reporting Tools: Cognos and Tableau

PROFESSIONAL EXPERIENCE

Confidential

Risk Data Analyst

Responsibilities:

• Responsible for create robust reporting environment for Risk Analytics for both Card and Auto lending businesses
• Gathering Requirements from business and document as per the HLD guide line in order to implement in data environment
• Build a test cases in the Agile environment and make sure that developed environment is more robust
• Responsible for reviewing all the Data mappings, Data Quality, Data Profiling, Meta data management and data validations for end to end project
• Make sure that CCAR and OCC Regulatory reporting need to be performed from the designed data environments
• Uses advanced techniques to optimize the space, query time, loading time and other ETL activities
• Specialized in converting business requirements to technical specifications
• Built robust process for reporting starting from generating a report to till delivery to the end users through automated process
• Designing a controls and placed them into process to make sure that BCBS requirements to be implemented
• Detailed validation steps on each report to make sure that accuracy is consistent
• Extensively support on all business/Policy/Strategy team ad-hoc’s for their needs
• Data validation, process control, compliance and documentation
• Support and engage with Corporate, Controllers and Finance for periodic submission of data used for regulatory reporting purposes
• Good understanding of regulatory compliance requirements surrounding BASEL, Risk Appetite and stress testing
• Develop SAS/SQL queries based upon documented business requirements to transform customer data and to create audience lists

Confidential

Senior Data Analyst

Responsibilities:

• Project Initiation, Project Management and Project Plan Preparation
• Requirements gathering and prepare High Level documentation (HLD).
• Convert business requirements into technical specifications.
• Providing effective solution and robust architecture to existing processes
• Direct interaction with Partners and process owners of LATAM
• End to End Project Delivery involves development, Testing and UAT activities
• Many transformation are used while designing end to job to modify data into desired format
• Implement integrity, validation and audit while designing job
• Leverage LSF tool to schedule the job in order to execute w/o any manual intervention
• Built Indexes on final data marts for quick response to our queries
• Generate Automated Validation Reports to identify accuracy of data in process flow
• Extensively uses Transformations like Table Loader, File Reader, File Writer, Frequency, Summary Tables, Fact Lookup, Loop, Return Code Check, Splitter, SCD’s, Lookup, Create Match Code…etc.
• Deploy and redeploy jobs for the purpose of schedule after design or modifying job

Confidential

Senior Data Analyst

Responsibilities:

• Prepare Monthly BAU Reports Generation and Ad hoc projects/reports
• MIS Rationalization and Standardization across Retail Bank NA Teams
• Create robust data marts with all business key metrics which will help AAS Teams for their Analytical Work
• Drive the campaigns successfully by measuring campaign effectiveness and tracking on weekly and monthly basis
• Specialized in Affiliate Marketing Campaigns and Reporting
• Post Campaign Analysis and Reporting for retail products
• Migrate Manual MIS into Self Service tools to make more user friendly to the users
• Educate partners in different technologies in order to introduce self service tools
• Work with other technology teams like Cognos and Qlikview
• Guiding team members and teach them different real time scenarios
• Recognize efforts of team members and make sure that reward them accordingly
• Direct interaction with Partners and end to end project management
• Extensively used SQL, Teradata, BASE SAS, SAS SQL, SAS MACROS and intermediately Cognos

Confidential

Data Warehouse Analyst

Responsibilities:

• Requirements Gathering, Rationalization & Documentation
• Understand existing environment, different systems and provide effective solution
• Apply Data modeling techniques on Raw files in order to process data effectively and loading into target tables
• Rationalize variables, Remove Duplicates & un wanted variables across all lines of businesses
• Analyze historical data in current system and load it into new data warehouse
• Learned and Created SAS Data Integration Studio Packages to perform ETL Process from Source to Target Tables
• Create Analytical Data marts on top of the data warehouse in order to support Analytics and business teams for their BAU Reporting activities
• Data mapping source to target based on the business requirements
• Direct attributes to Fact and Dimension tables in order to create robust architecture
• Apply slowly changing Dimensions while load data from source to target
• Involved in creating Data Dictionary and High Level Design documentation

Confidential

Data Analyst

Responsibilities:

• Competitor analysis and Monthly Dash board creation across different area’s
• Performing data analysis and providing the insights to customer by analyzing the data in a granular level.
• Extract data from multiple sources and applying data validation checks in order to generate accurate reports and dashboards.
• Tracking patient prescription claims and perform patient longitudinal analysis
• Incorporate complex logic on data using SAS in order to track customer is consuming the same drug during treatment period
• Automate the end to end process of dashboard creations using SAS macro’s programming
• Involved in preparing decks to the directors taking with the key metrics
• Gathering the Feedback and suggestion from the stake holders, make them satisfied by implementing those enhancements.
• Expanded the scope of our team responsibilities to the different branded teams
• Getting more business from same customer by presenting our deliverables to the other stake holders in BMS.
• Using SAS Macro’s to import data into SAS and automate the process to decrease the manual intervention.
• Exporting SAS datasets into the mdb, .txt, .csv and .xls… etc using the various types of exporting methods.
• Generating simple reports using the Proc Report, Proc Tabulate, Proc Means and other Procedures also.
• Performing data analysis and providing the insights to customer by analyzing the data in a granular level.

Confidential

Data Analyst

Responsibilities:

• Extracting data from the Warehouse/SQL server/Flat files using SAS and SQL
• Performing data analysis and generating the summary reports
• Creates/Modifying the input files using SAS for the customer reporting Tools.
• Automating the standard process to reduce manual interventions using SAS
• Updating the database as per the customer requirement using SQL Queries
• Preparing the demo database for the purpose of training.
• Working independently on all projects. Never missed TAT and Accuracy.
• Performing importing and exporting the data using SAS and convert data in a required format.
• Data cleansing, analyzing and generating statistics report on database.
• Extensively working with onshore team members to deliver the projects in quick turnaround time