SUMMARY

• Dynamic, motivated team player, result - focused, and action oriented Senior Technology Analyst offering an experience of 6.7 yrs in the IT industry in different domain including, Business Intelligence, Data Warehousing, Data management & Analyst experience.
• Worked in banking, financial services, Health & Life Insurance, Risk Compliance domain.
• Proven ability to successfully analyze and implement business requirement on project and well averse with entire software development Life cycle.
• Mostly worked with business team in preparing Business requirement document along with Requirement elicitation, Data modeling, Application Design, Impact analysis, FSD, Gap Analysis, implementation, data validation, deploying and maintenance.
• Adept in data analysis, data mining, processing, manipulation, integration and transformation.
• Knowledge on the Agile methodology.
• Involved in Understanding and translating the business requirements and to High Level and Low level design for ETL processes inSAS, Informatica, MSBI Tool.
• Good experience in ETL methodology, workflow development, Analysis and Reporting mechanisms using SQL Server Business Intelligence Tools SSIS, SSAS, SSRS and SQL Server databases.
• Proficient in usingT - SQLand dynamic programming for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing in SQL Server 2005/ 2008/2012.
• Extensively involved in Clinical Data Analysis and preparation of SAS Datasets, reports, tables, listings, summaries and graphs according to the Standard Operating Procedures.
• Extensive knowledge in SAS tools like SAS/Base, SAS/DI, SAS/ECM, SAS/Web Report studio, SAS/Scheduler, SAS/SQL, SAS/Macros, SAS/Graphs, SAS/Stat and SAS/ODS.
• Knowledge on Data ware house concepts.
• Experienced in importing and exporting Data from SAS,
• Worked on hive tool to analyze Hadoop data lake ecosystem data.
• Created and maintained SAS macros, Procedure and utilities.
• Extensive experience in data analysis and reporting.
• Excellent analytical and problem solving skills.
• Ability to manage (Multiple) project tasks, subject matter expert both at Onsite and offshore location.
• SAS Certified Programmer.
• Microsoft Certified (SQL Server - Implementation and Maintenance)
• Won certificate of excellence award & good ratings for outstanding performance in Team.
• A Case study paper published on ‘SAS and its interaction with Cloud System’ in current company internal Knowledge Portal.
• Case study published on Converting MSBI - SSRS reports (RDL file) into report viewer (.net solution i.e. RDLC file).
• Build Audit Reporting, Batch optimization Automation tool used for Reporting process by multiple applications.
• Build Global Analytical Portal for Application Maintenance team that can be used for Data Analytics, metrics and reporting.
• Quick learner and excellent team player, consistently meeting deadlines and can work under pressure.
• Good knowledge about ETL techniques used to the extraction, transformation and loading of data among different databases.
• Strong command over UNIX shells scripting.
• Experience in working with extraction transformation and loading(ETL) process using SQL and PL/SQL
• Strong knowledge in performance tuning for handing large volume of data and improvising the performance of data.
• Expert in the process improvements and the SAS query tuning techniques.
• Good experience on scheduling the jobs on the Autosys production scheduler.
• Good knowledge in the AML KYC Risk management applications and their processing
• Developed Ad hoc reports used for analytics process.

TECHNICAL SKILLS

Operating System: Windows ( XP, 7, 10), LINUX, UNIX

Technology: MSBI & Power BI, SAS, PL/SQL,T-SQL and Dynamic programming, UNIX Scripting, Informatica, Hadoop

Tool: Worked: MSBI Tool (SSIS,SSAS,SSRS), SAS/EG,SAS/DI,SAS Management Control, Flow Manager, HIVE, Microsoft Visio, SQL Server Studio, Oracle10g/Toad10.6,Informatica9.1,SAS ECM/DI Web application, SAS Web report studio, Tableau

Databases: Teradata, Oracle, DB2,SQL Server

PROFESSIONAL EXPERIENCE

Confidential

SAS Programmer

Responsibilities:

• Gathering functional requirement as per the specification and data mapping document, analyze and create technical design
• Proof of concept (POC) developed to validate proposed solution and reduce technical risk at initial stage of project
• Walkthrough each module designs of the project to the Client
• Involved in Design Documentation, Build, UAT and promotion of Code to Production environment
• Data Model Designing using Visio Data Modelling Tool
• Creation of scripts using UNIX scripts
• Create the SAS ETL programs to read the raw files into SAS datasets and store them in the SAS data warehouse
• Extract the data from the SAS data warehouse and the Enterprise Information Warehouse to create the Audit Rewards business reports
• Create the SAS Macros to avoid the redundant SAS coding
• Create the one-off programs (Adhoc programs) as per business requests
• Creation of Procedure and macros in Base SAS and SAS DI
• Connection developing between SAS-DI and Microsoft Dynamics using Cloud System.
• Supported one time data migration
• Responsible for the creation of analysis datasets and clinical study report displays
• Involved with the validation of analysis datasets, tables and listings
• Act as coordinator from offshore and coordinate with onshore team.
• Tuning of Queries for Performance improvements inSAS

Confidential

SAS Programmer

Responsibilities:

• Worked on Technical Solution for data processing and implementation of Functional requirement
• Part of Requirement Gathering and documented High Level Design document
• Part of client walkthrough on modules, Proof of concept (POC) developed to validate proposed solution and reduce technical risk at initial stage of project
• Coding, Integration testing and promotion of Code to Production environment
• Connection developing between SAS-DI and Acturis Database (SDW) using DSN, SQL and UNIX scripts
• Worked with the statistical reporting procedures used for regular data collection and data analysis
• Extensively used the SAS/MACROS for creating SAS reusable programs which can be modified according to the timely requirements
• Used macros for integrating the complex business rules and audit reports
• Involved in moving large datasets across Mainframes and SAS
• Created complex stored procedures and developed dynamic SQL Queries to adopt dynamic environment
• Designed and developed MI reports to meet the specified business requirements by using BASE SAS queries and UNIX
• Implemented SAS performance tuning techniques to reduce the CPU hours
• Worked on FTP process for transferring huge SAS data files to the Mainframe IS2000 system

Confidential

Informatica/Teradata Programmer

Responsibilities:

• Part of Requirement and impact analysis
• Documented High level and detailed design document
• Views build for loading ODM extract to tactical tables using Teradata technology.
• Linkage of source data, aggregation of balance and creation of mappings and work flows using Informatica.
• ETL jobs build using Informatica 9.1 for processing the FATCA data
• Part of SQL tuning for better performance

Confidential

Business Analyst

Responsibilities:

• Part of the Business team as Business Analyst at the onsite location
• Build data reports using different SAS Output delivery system like HTML,PDF,RTF for the request receiving from multiple AML KYC team
• Automated some of the process using SAS stored procedure and SAS macros
• Experience in Gap analysis of existing AML KYC application and other reporting process
• Communicate client’s business requirements by constructing easy-to-understand data and process models to development team
• Provide input and reworked on existing data reporting process of AML KYC system to make it more automated.
• Providing the reports according to the requirements of the business team with minimal risk
• Involved in Dashboard creation using SAS & MS-Excel for summarized Customer Dynamic interview data based on which team perform risk analysis
• Created Analysis Datasets, Tables, Listings and Graphs as primary programmer
• Documented all Programs for accurate historical record and future reference.
• Participated in project meetings for updating the research findings.
• Demonstrated excellent problem solving skills and willingness to take decisions on regular basis

Confidential

Technical Consultant

Responsibilities:

• Onsite Coordinator and SAS consultant at the onsite location
• Involved in Requirement sessions, prepared data dictionary and data structure document, provided expertise on target topics for better process
• Prepared the ACS Data model using Visio tool to demonstrate the entire process workflow and the DataMart design in Hadoop and SAS environment
• Create a SAS based reporting platform to pull the key statistics for the Financial reporting
• Dashboard created for the Key statistics metric required for Financial reporting and Market trend analysis
• Build SAS sql pass-through code to connect Hadoop from SAS and build MDS required for analysis
• Part of Build, data validation, Unit testing, UAT, code deployment in production environment
• Implemented SAS performance tuning techniques to handle billions of records and reduce processing time
• Involved in Regular update calls with the relevant stakeholders and the users to get there feedback
• Organize daily touch base call with the offshore consultant onwork progressand potential issues.

Confidential

Data Scientist

Responsibilities:

• Involved in Interacting with the user for gathering business requirements and working on Data model and Design (Functional & Technical) document for the Application.
• Responsible for designing, development of SSIS Packages using various control flow tasks and dataflow tasks for performing ETL operations.
• Experience in deployment of SSIS packages into different environment using configurations for deployments to different environments.
• Responsible for scheduling SSIS jobs to automate the processes using Batch Scheduler.
• Performing analysis on different data points and creating SSRS/SSAS reports using pie charts, bars etc. for business analysis purpose.
• Troubleshooting the long running queries and stored procedures to improve the performance by using optimization techniques such as Normalization, Indexing, query tuning, pre data load.
• Optimized data collection procedures and SSRS/SSAS reports to show calculated metrics by weekly, monthly, and quarterly basis on the Portal used for Analytics by business users.
• Created Parameterized, drill down and drill through reports using SSRS and published on SharePoint Dashboard.
• Analyze critical application metrics to identify root cause and propose resolution to improve application stability that reduce cost.
• Converted SSRS Reports to .net report viewer solution in order to publish on IAS server.
• Involved in Project Release and migration calls.