SUMMARY:

• In - depth expertise in working across multiple functional and technical groups, educating technical and non-technical stakeholders, managing expectations, facilitating negotiations and establishing departmental priorities
• Proficient in designing & developing and maintaining SAS, SQL Data Warehouses Systems while working with database developers, administrators and business managers to ensure data systems conform to enterprise data architecture and expectations, including data governance best practice adoption
• Expertise in implementing Data Warehouse solutions including identification of technology to solve various business problems and resolving scalability issues for various platform in USA
• Successful in developing and implementing strategies to gather information from operational databases so data can be included in the warehouse. Worked extensively in data analysis and interpretation of Big data.
• Introduced best-in-class Business Intelligence (BI) architecture design including three-tier data architecture, version control with automated deployments, high performance/scalable data stores, and establishing a single source of truth across organization
• Serving as a working lead across all phases of the analytic project lifecycle, providing supervision and guidance to the team as needed, including requirement gathering requirements from internal customers

TECHNICAL SKILLS:

Languages: SAS, SQL, SAS Enterprise Guide, Tableau, Alteryx, Python

Databases: AWS Redshift, Teradata, IBM DB2, SQL Server 2008, IBM Netezza, Oracle 11G, MySQL, SQL Analyzer, MS-Access

SAS Skills: SAS - V 9.4, V 9.3, SAS/SQL, SAS/MACRO, SAS/REPORTS, SAS/ACCESS, SAS/ODSSAS/EG, SAS/Graph

Operating System: Windows98/2000/XP, MS DOS, MSOffice (Word, outlook)

Version Control Tools: VSS, TFS- Team Foundation Server, SCM

Accessing methods: Sales Force, Microsoft SQL Management Studio

Utilities: HelpSTAR, ALM, Share point

Domain: Healthcare and Banking

WORK EXPERIENCE:

Confidential

Senior Developer

Responsibilities:

• Conducting proper designing and implementing SAS programs that improve business functionality and implementing Enterprise Systems Solutions
• Data analysis on core customer data which is used to support critical business processes across the enterprise.
• Implementing technologies that reduce costs, increase performance and affect the bottom line.
• Following multiplatform Windows, UNIX, client/server environment while using shell scripts and run SAS on background.
• Automating processes and reports using shell scripting for invocation/Windows Scripts, SAS Macros
• Providing ADHOC reporting support by analysis and resolution to correct errors for QA
• Developing automation techniques to significantly reduce manual workloads, increase accuracy, and improve speed of data availability
• In sourcing and subsequently right-shoring the Business Intelligence (BI) and Data Warehouse (DW) developmentcapability supporting the organization’s frontline teams.
• Leading the project to replace a legacy Business Intelligence (BI) database solution with a fully dimensionally modelled data warehouse reporting and analytics solution on-time and within budget.
• Defining the architecture and strategy for Business Intelligence (BI) and Analytics within the Client and Origination Technology department
• Gathering and analyzing requirements for the enterprise-wide Data Warehouse.
• Using the Agile approach, participated in scrum meetings, developed user stories including acceptance criteria.
• Developing and delivering a Data Governance capability, including stakeholder engagement & mobilization and supporting processes and procedures.
• Crafting an overall Data Quality strategy, with business and technical objectives, to improve the accuracy and value of data.
• Managing Business Intelligence (BI), including engaging with senior management and subject matter experts towards creating a vision and roadmap.
• Contributing to data analysis strategy, master plan, impact analysis of the data while providing solutions range from database object design, development, data loads and transformations.
• Understanding the business requirements and system architecture; checking software development right from study, analysis, design, coding, testing, delivery, implementation, and post implementation activities.
• Strong working experience in Scrum/Agile framework and Waterfall project methodologies.

Confidential

Environment: SAS 9.4, Python, Alteryx, Toad data point, Putty, ORACLE 11G.

Responsibilities:

• Responsible for gathering requirements, create use case and functional requirement documents.
• Work closely with Business Analysts for developing Data Mappings based on the requirements document.
• Explore multiple design options & choose optimal and best high level/ low level design.
• Performing SAS Coding activities which involves macro programming for development and testing various projects using Oracle, Greenplum & SQL server databases.
• Converting the SAS Script into Python and Alteryx script based on the business need.
• Conducting activities pertaining to data analysis, profiling, reporting, assessment, cleansing, and mapping
• Participating in project estimation, requirement analysis, approach plan preparation, review and bug triage meetings
• Designing solutions for non-functional data requirements such as SLAs, historical archiving, privacy & security
• Building and maintaining master data dictionary while working with clients, DBAs and developers to design, test, implement and support the data model and architecture
• Interfacing with clients and developers to design, test, implement and support reports in BI platforms while creating and supporting any needed stored procedures/complex SQL as necessary
• Functioning as key partner with Business Analytics team while acting as a strategic leader with the skills to influence, collaborate and deploy innovative solutions
• Liaising with vendors and external support on issues such as upgrades, technical problems and solutions
• Managing projects including planning, design, build, test, and deployment; monitoring the progress and integration of multiple tasks and projects.

Confidential

Senior System analyst

Environment: SAS 9.4, SAS 9.3, Tableau, Alteryx, Salesforce, IBM NETEZZA, ORACLE 11G, Advanced SASAmazon Web Service, IBM DB2, Teradata.

Responsibilities:

• Leading the data warehouse project planning, data modeling, maintenance, development, and enhancements
• Conducting activities pertaining to data analysis, profiling, reporting, assessment, cleansing, and mapping
• Participating in project estimation, requirement analysis, approach plan preparation, review and bug triage meetings
• Designing solutions for non-functional data requirements such as SLAs, historical archiving, privacy & security
• Building and maintaining master data dictionary while working with clients, DBAs and developers to design, test, implement and support the data model and architecture
• Interfacing with clients and developers to design, test, implement and support reports in BI platforms while creating and supporting any needed stored procedures/complex SQL as necessary
• Functioning as key partner with Business Analytics team while acting as a strategic leader with the skills to influence, collaborate and deploy innovative solutions
• Liaising with vendors and external support on issues such as upgrades, technical problems and solutions
• Managing projects including planning, design, build, test, and deployment; monitoring the progress and integration of multiple tasks and projects.
• Providing regular status updates to the appropriate parties; evolving into a subject-matter expert, can easily liaise between IT and other departments
• Contributing to data analysis strategy, master plan, impact analysis of the data while providing solutions range from database object design, development, data loads and transformations
• Understanding the business requirements and system architecture; checking software development right from study, analysis, design, coding, testing, delivery, implementation, and post implementation activities.

Confidential

Developer - Enterprise Information Management

Environment: SAS 9.3, IBM NETEZZA, ORACLE 11G, IBM CDC, SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/SQL, PROC SQL, SAS/BI, IBM DB2

Responsibilities:

• Offered Business Intelligence (BI) design, development and implementation, documentation and deployment of complex data architectures emphasizing Data Warehousing, Data Integration, and Data Management technologies
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules
• Conducted Root Cause Analysis for any failures and come up with solutions to prevent such failures in future
• Designed and implemented solutions to prevent such failures in future, led programing, Unit Test Plan, SIT test cases; utilized SAS Procedures, Macros, and other SAS application for data extraction, data cleansing, data loading and reporting
• Used various SAS report generating procedures such as PROC REPORT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC COPY, PROC SUMMARY, PROC IMPORT led Data Manipulated by Merging Appending and sorting datasets; wrote complex routines for data validations, data extraction, transformation and loading to target decision support systems using MS Excel, Pivot tables, SAS on various environments and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility
• Led preparation of reports, tables, listings and graphs, led SQL with SAS
• Experience in CDISC SDTM mapping from raw datasets.
• Involved in creation and validation for SDTM and ADam datasets, tables, and listing.
• Created macros to ensure the variables are as per CDISC guidelines.
• Initiated the creation of new data warehouse system using IBM CDC and IBM Netezza for data storage
• Used SAS ODS to report outputs in different formats like PDF, Excel.