With more than 8 years of experience as SAS/ETL developer working on a multi-million dollar financial, Manufacturing and food & retail domains, by sourcing data from multiple data sources and using SAS DI studio for ETL process, SAS MIP for data Modeling, SAS BRM for stage allocation, Reporting is performed using SAS Visual Analytics and orchestrating the entire process using Shell/Python scripting.
With more than 10 years of experience as an Architect on multi-million dollar telecom solutions by dealing with applications development of statistical and billing data from telecom operator across the globe.
Possess outstanding analytical and problem solving skills. Proactive, Innovative, Challenge Oriented. Possess the ability to demonstrate both as an individual and as part of a team with excellent communication, interpersonal skills and ability to handle multiple projects at one time.
Experience in analyzing, designing and developing Extraction, Transformation and Load (ETL) processes for building business specific data marts, OLAP cubes for reporting and other various data integration projects to build data marts from enterprise data sources and fully integrate the SAS Business Intelligence suite.
Skills
SAS Skills
SAS Studio, SAS Enterprise Guide, SAS Management console, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Enterprise Miner, SAS Forecast Studio, SAS Add-in for Microsoft Office, SAS Information Delivery Portal, SAS XML Mapper
ERWin, Rational Clearcase V6.x, Dev Ops, Git, Jira
Environment (UNIX): SAS Enterprise platform - SAS/Macros, SAS-Data Integration Studio, SAS Enterprise Guide, SAS Management console, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Add-in for Microsoft Office, SAS XML Mapper, SAS EMiner, SAS Forecast Studio, SAS/SQL, TOAD for Data Modeler, Angular, Git, Jira.
Environment (Windows and UNIX): C, C++, Java , Visual Studio , Eclipse, Clearcase, MHWeb, Jira.
Delivery, Mapper, MSC, Requirements gathering, Type
Disaster recovery, Mark, MYSQL, Risk Management, Type 2
Experience
07/2017 to Current
Sr. SAS DeveloperOptech – Pontiac, MI,
BMO is one of the early adaptors of the SAS Risk Technology solutions.
Architected and build custom solutions to meet the internal business needs and comply with the audit requirements for IFRS9/CECL/FWST solutions.
The platform is also used to persist the forecasted risk data into target state in highly confidential DataMart for the business users for regulatory reporting.
During the process the market economics data is fed into the process and the modeled results are used for marketing communications to either notify the account holders (or) promote new products based on the stage allocations.
Responsibilities:.
Implement the Risk Technology solutions for IFRS9/CECL/FWST platforms using SAS applications suite by sourcing data from various data sources and using SAS DI studio for ETL process, SAS MIP for data Modeling, SAS BRM for stage allocation, Reporting is performed using SAS Visual Analytics and orchestrating the entire process using SAS RFW/SAS IRM/ shell scripting.
Implemented highly complex queries in SAS/SQL for calculating the ECL and various other risk technology parameters.
Designed & Implemented custom process workflows and decision points where the business user can either approve/reject/reprocess the workflows.
Contributed to design and implementation of Waterfall process for month-month/qtr-qtr/year-year & other sensitivity runs.
Worked with business to help them understand the implementations and help them with complex SQL/SAS queries.
Contributed to the data quality (CEDQ) process for audit needs.
Performance tuning of SQL queries to help processes complete the OLTP in a timely manner on various databases – Teradata, Oracle, PostgreSQL.
MS SQL Server.
Proactively involved in building the control process for various Sprints to make the release cycles and Risk Technology platform efficient.
Involved in the disaster recovery server (DR) accommodating the predictive sensitivity analysis.
Design SAS DI jobs that are used in the ETL process with data from IDP source tables.
Use the SAS Model implementation platform (MIP) to model the source data to produce output data with expected scenarios.
Apply desired scenario weights (using SAS business rules manager) to the data to perform stage allocations on the data at instrument level.
Perform secondary administrative tasks on multiple platforms and databases.
Support the business teams with ECL (Expected Credit Loss) analysis and final numbers.
Work with business in orchestrating the 18 portfolio runs using SAS RFW, SAS IRM work flows and shell scripting.
Work closely with business and SAS partners in requirements gathering efforts.
Help teams during deployment activities across SIT/UAT/Production/DR environments.
Environment (Linux): SAS Data Integration Studio, SAS Model Implementation Platform, SAS Risk and Finance Workbench, SAS Infrastructure for Risk Management, SAS Business Rules Manager, SAS Visual Analytics, SAS Web Report Studio, SAS Stored Processes, PostgreSQL, Teradata, Python, Linux, Shell scripting, SAS Enterprise Guide, SAS Base, SAS Access, SAS Macros, MS Office applications, Jira, BitBucket, Git, Confluence.
02/2014 to 07/2017
SAS Developer/ETL DeveloperAmazon.Com, Inc. – San Diego, CA,
Contributed to Corporate Treasury Risk Technology platform to build data marts for corporate regulatory reporting to provide accurate reporting of eLedger balances.
Involved in creating SAS metadata objects for uploading the newly created SAS datasets into the data marts for various products.
Created SAS Macros/programs for the new business products using the newly acquired data in the various forms like flat files, CSV, XML, Excel files and other data sources like Oracle, Teradata.
Create staging datasets, derivations and transformations datasets and finally load them to target data marts in Netezza based on the KBEs for Treasury reporting analytics.
Responsibilities:.
Involved in the building data marts from enterprise data sources spread across platforms of the SAS Data Integration Studio.
Architected some of the processes like SCD Type 2 to perform In-database using User Written code and leveraging the same to the business need.
Worked on complex business logic and implement the same in SAS DI across multiple products & workflows.
Involved in Migration and Release cycles to support the corporate agile model using JIRA.
Performance tuning of SQL queries to help processes complete the OLTP in a timely manner on various databases – Teradata, Oracle, PostgreSQL.
Perform secondary administrative tasks on multiple platforms and databases.
Involved in CFT meetings and decision making process.
On-demand support from SSPM during the release cycles.
Used SVN/Git/Jira for Version control and change release.
Perform tasks of user authentications, deploying jobs for scheduling using SAS Management Console.
Created new schedules in LSF using SAS Management Console.
Performed complete development and unit testing of the newly created ETL code in test environment and bench mark newly created metadata jobs before integrating to the data warehouse in order to build efficient data marts.
Provided solutions on Dataflux jobs into the mainstream of SAS DI processes for issues on false complete jobs.
Performed new library definitions for new data sources for FSR RDR project.
Extensively worked on SQL queries for creating new table structures and complex table Views to support the business products.
Environment (Windows and LINUX): SAS 9.3 Enterprise platform – SAS/Macros, SAS-Data Integration Studio, SAS Enterprise Guide, SAS Management console, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Add-in for Microsoft Office, SAS XML Mapper, SAS EMiner, SAS Forecast Studio, SAS/SQL, TOAD for Data Modeler, Netezza, PostgreSQL, Oracle, Teradata, Pivotal Greenplum, JIRA, HP ALM – Quality Center, MS Excel, Java, SVN, HP Service Manager.
DataFlux Data Management Studio – dfPower Studio, dfPower Architect, Git, Jira.
12/2011 to 02/2014
SAS Developer/ETL DeveloperPANASONIC – City, STATE,
As a SAS ETL developer, by sourcing the TLDs ( Transactional Data ) of a quick service restaurant and created a predicted algorithm to predict the sales for 15 minute interval for a given day and instruct the kitchen crew to produce the items for upcoming orders.
This is to enhance the customer experience by reducing the wait time for customer coming in for dine-in and drive-thru.
The predictive algorithm also helped the restaurant to reduce the food waste.
The solution is deployed in popular restaurant chain across USA and Canada.
Responsibilities:.
Created the SAS datasets by sourcing the TLDs in XML format , Kitchen equipment ioT data including the POS sales transactions in Json and flat file format using SAS Data Integration Studio.
By combining the production and sales with the expiry interval of each food type, measured the current inventory by using SAS Enterprise Miner.
With the predictive algorithm in the combination of the current inventory, developed an angular framework to trigger the notifications to crew facing screen to cook certain food items which are required for JIT serving customer.
Involved in various customer business meetings and decision making processes.
Used Git/Jira for Version control and change release.
Worked on merging of the existing SAS ETL code as Metadata job objects and stored into the custom repositories of SAS Data Integration Studio.
Performed remote submission for enterprise jobs.
Performed complete development and unit testing of the newly created ETL code in test environment and bench mark newly created metadata jobs before integrating to the data warehouse in order to build efficient data marts.
Expertise in creating the mapping models for mapping the business models with star schema logical database model using SAS Information Map Studio.
Worked on administration and configuration of SAS Web Report Studio and Information Delivery Portal to create new users and authorizations and configuring the Mail Servers for the same.
11/2000 to 11/2011
Solution ArchitectEricsson AB – City, STATE,
Ericsson AB is the European based telecom giant having product line of Enterprise , PSTN and Mobile switches with various product suites such as MSC, BSC, HLR and Wire line switches.
Responsibilities:.
Architect and design various solutions including but not limited to HLR, BSC, MSC nodes.
Involved in development of new features for Enterprise switches.
Collaboration with different vendors of Ericsson to bring the solution under one umbrella.
Mentoring and training the junior and new joiners into the team by inducting them to the product.
Involved in meetings at different levels from end customer to partners and vendors.
Used ClearCase for Version control and change release.
Developed applications in C, C++ & Java.
Education and Training
Expected in 05/1997 to to
Bachelor of Science: Information Technology National Institute of Technology - INDIA, GPA:
Additional Information
Experience in architecting the data marts, OLAP cubes for fast & flexible reporting of pre-summarized large datasets and decision support systems using SAS Data Integration Studio, Enterprise Guide and OLAP Cube studio for the business users.
Expertize in Performance tuning of SQL queries to help processes complete the OLAP/OLTP in a timely manner across various databases – SQL Server 2012, Postgresql, MySQL.
Involved in metadata jobs migration from dev/test environment to production servers using the packages facility and version control tools like Git.
Extensive experience in using various SAS modules – SAS/Base, SAS/Stat, SAS/Macros, SAS/Access, SAS/Connect, SAS/Graph, SAS/ODS and SAS/SQL(pass-through facility) on Windows and UNIX environments in order to accomplish financial Data Analysis and preparation of SAS datasets, multi-dimensional reports, tables, listings, summaries and graphs according to the corporate guidelines and project requirements.
Expertise in performing data transformations of financial/enterprise transactions, model scoring and generate SAS datasets that are used across teams and Developed standard operating procedures.
Created Pivot tables in Excel and charts/tables in PPT files using the OLAP cubes for the business users using the SAS Add-in for MS Office plug-in facility.
Created stored processes to help the users to access/execute the jobs remotely and generate custom reports. Worked on administration and configuration of SAS Web Report Studio and Information Delivery Portal to create new users and authorizations and configuring Mail Servers. Created dashboards for business users in SAS Portal.
Extensively used ERWin/Toad Data Modeling Tools for building the data models in grand schema.
Involved in various process improvement projects (using Six Sigma methodology), data cleansing by automating redundant tasks using scripting languages – PERL/XML/Shell/JavaScript/VB script across the teams.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.