Aswani is an accomplished solutions oriented data warehouse architect with notable success in directing a board range of IT initiatives while participating in team leading, analysis and implementation of data warehouse solutions in direct support of business objectives.
Qualifications
Certifications
Microsoft Certified Technology Specialist - SQL Server 2005
MCP ID - 6262409
Informatica Certified Developer - Informatica 8
Technical Skills
Skills
.NET, ASP.NET 1.1, ASP.NET, academic, go live, Ad, AP, API, Apollo, Application Development, approach, Architect, Asset Management, Backup, benchmarking, BI, Business intelligence, CA, Concept, consultant, Contract Management, Conversion, Client, clients, Data Migration, Data mining, data modeling, data warehouse, databases, Database, Data warehousing, Dec, Decision support, Delivery, Department of Health, Designing, dimensions, Email, engineer, Erwin, ETL, ETL 5.2.2, Government, HTML 5, IBM, IIS, Informatica 9.1.0, Informatica 8.6.1, Informatica, insurance, Java, JDBC, Leadership, Lotus Notes, marketing, C#, MCP, Microsoft Certified, Microsoft Project, Microsoft Visio, Windows, 2000, Migration, Modeling, MySQL, MySQL 5.0, MySQL 5.6, NPFIT, enterprise, next, NHS, Oracle, Developer, POS, PostgreSQL, processes, coding, Project Management, quality, Relational Database, reporting, Reporting 4, Requirements gathering, retail, Sales 5, Sales, servers, Visual Source Safe, MS SQL Server, SQL SERVER, Microsoft SQL Server, SQL, SQL 2000, statistics, supervision, tables, Teradata, Tomcat, trainer, troubleshoot, troubleshooting, Type 2, User Interface, Validation, VC++, Visual Studio, wise, written
Accomplishments
Informatica - 8 Mapping Design Informatica Corporation - 2012 Industry Verticals: Banking and Financial Services Insurance Retail Health Care E-Commerce High Technology Project Details: Rackspace - Financial DataMart Project Description Rackspace is the world's #1 managed hosting company.
Rackspace's CFO team would like to have a unified view of their managed hosting and cloud business's financial information with a capability to perform drill down to the individual usage events that contribute to a given invoice using OCDM and OBIA.
Work Experience
01/2010 to
Data Migration DeveloperAccenture Contractor Jobs – , ,
To develop ETL packages using different ETL Tools - For Extraction and Transformation - Informatica Powercenter - Customer specific solution Loading - SSIS based in-house solution - Generic solution Environment Informatica Power Center 8.6.0, SQL SERVER 2005, SQL 2000, SQL Server Integration Services 2005, Data Transformation Services 2000 Team size NA (Project size - 20) Project Location Chennai Project Name - Apollo CUI Project Description Apollo CUI is a Common User Interface developed for Microsoft for its Contract Management, Engagement Management, Resource Management, and Time & Expense Management.
Client Microsoft Start Date 05.
01/2008 to
Team member - BIExl – , ,
Contributed in different roles to the project to cater the timely needs of the project: 1.
SQL BI Developer - Using SSRS, I have done coding for one of the mission critical reports of the application which involves Microsoft's most critical data like Microsoft Sales Data (MS Sales & Reporting Modules) 2.
Designed and Developed SSIS packages used to migrate data from OLTP database to a reporting database used for Reporting purpose.
Environment SQL Server 2005 Integration Services(SSIS),SQL Server 2005, SQL Server 2005 Reporting Services Project Location Hyderabad.
to
Lead Architect / Delivery manager – Anaheim, CA, India
Gather initial requirements and carve out a solution approach and deliver statement of work for the project Define the ground rules for architectural migration Establish code migration process and devise appropriate code review methods to ensure quality delivery of the solution Environment PostgreSQL, Cassandra, HDFS, Informatica Power center 9.5, SQL Server Integration Services 2012, Java Team size Rackspace is the world's #1 managed hosting company.
Rackspace has built a Data warehouse on SQL Server which could not be scaled cost effectively beyond a certain size due to various factors.
Therefore, they have internally devised an elastic data warehouse solution called Analytical Compute Grid which internally hosts PostgreSQL, Cassandra and Hadoop data stores and scales up/down on its down.
Informatica power center does not have an ability for its transformations to use JDBC driver to connect to the databases except for Java transformation.
Hence, it was taking extensive amounts of time to perform development of ETL packages.
In an attempt to reduce the efforts to perform coding, new custom transformations are needed to be designed in VC++ and Java to leverage the capabilities of Informatica API to build easy to use transformations Client Rackspace Start Date 12 Jul 2014 End Date 10 Aug 2014 Role.
to
Technical LeadExl – Auburn, , India US
Start Date 01 June 2013 End Date NA Role Data Architect for Development; Specialist for support.
Responsibilities Involved in Designing Data marts, ETL and Reporting Solutions for Analytics Dashboards Environment Jaspersoft ETL 5.2.2, JasperReports 5.5, MySQL 5.6 Team size Bayview Asset Management - EDC India Project Description Bayview Asset Management is a full service mortgage investment firm with expertise in the analysis and management of distressed and performing mortgages.
They provide a wide range of products and services, including top-rated residential and commercial special servicing and residential and commercial mortgage investing.
As such they have a wide range of analytics that are provided by their in-house Data warehouse solution.
We provide EDC services for Bayview asset management for maintenance of their Data Warehouse.
Client Bayview Asset management Start Date 26 Dec 2012 End Date 22 Nov 2013 Role Responsibilities 1.
Impart Technical Leadership to Analytics Division of Bayview Asset Management.
2.
Requirements gathering, Feasibility Study, Proof of Concept, Design and Technical supervision of Development and Delivery of Data Integration solutions that help the data flow between different layers of Bayview Asset Management's IT system.
3.
Perform troubleshooting and performance tuning as necessary for any maintenance issues.
4.
Involved in technical brainstorming sessions for their next generation Data warehouse.
Environment Informatica Power Center 8.6.1, 9.1.0, SQL Server 2008, SQL SERVER 2005, Oracle 10i, Lotus Notes Team size 4 - 2 (India), 2 (US).
to
Project DescriptionFedex – Raytown, , India US
MyKala is the cloud-based technology platform to support an integrated multi-tenancy system for loyalty reward, analytic reporting and marketing offer system across retail industries.
MyKala BI is the analytical reporting solution that helps client monitor their performance in integrated dashboards like - Members, Sales and promotions dashboards.
Start Date.
01 November 2013.
End Date.
to
Lead ArchitectBickford Senior Living – Costa Mesa, , India US
Involved in requirements gathering and high level design of the DataMart and Report requirements.
Managed the delivery and helped team troubleshoot the issues in ETL Development, Report Development and Delivery of the solution Environment Jaspersoft ETL 5.2.2, Jasper Reports 5.5, MySQL 5.6, Groovy, HTML 5 Team size MyKala Development and Sustenance Project Description MyKala is the cloud-based technology platform to support an integrated multi-tenancy system for loyalty reward, analytic reporting and marketing offer system across retail industries.
The solution encompasses building a user and a business portal, mobile applications and integrating with iOS and Android platform by building applications.
We also integrated with Rules Engine built by FICO, Email Marketing system by Exact Target, POS system by NCR, Loyalty Cards by Opticard seamlessly.
to
Lead Architect – San Francisco, , India US
Responsibilities Design and Develop the Fraud DataMart to support fraud reporting Build Fraud Decision support database to run Fraud Detection rules and detect potential fraud Build OLTP database to support build a Sentinel Case manager application to help manage Fraud cases and outcomes.
Build Fraud Subject Area into Long Term Care Data EDW to support current and future enhancements.
Build SSIS packages to perform data integration between different databases Environment Teradata 13, SQL Server Integration Services 2008, MySQL, HTML 5, Groovy, Tomcat, IIS, QlikView Team size Fuzion Analytics is a data mining and analytic services organization dedicated to serving the informational needs of the Long-Term Care (LTC) insurance industry.
Fuzion Analytics provides carriers with different offerings like: CATALYST: Data mining and predictive modeling PULSE: Business intelligence reporting, industry benchmarking services SENTINEL: Fraud detection and case management Fuzion's analytic fraud detection framework, Sentinel, is composed of complementary components designed specifically to fit the fraud needs of Long-Term Care.
The Sentinel Framework is designed specifically to analyze LTC claims and identify fraud as early in the claim process as possible to minimize losses and maximize returns.
Fuzion's fraud identification services allow for analysis where very few cases of fraud have been documented, offering insight that has not been available to many carriers until now.
In addition to these capabilities, Fuzion offers fraud reporting services that will allow you to capture and analyze all fraud-related statistics and gain a better understanding of how fraud is affecting your business and how well it is being managed throughout claim processes.
Client Fuzion Analytics Start Date 01 November 2013 End Date 25 April 2014 Role.
to
Solutions Architect – Kahului, , India US
Responsible for requirements gathering and design of the transformations.
Environment PostgreSQL, Cassandra, HDFS, Informatica Power center 9.5, VC++, Java Team size Project Description Fuzion Analytics is a data mining and analytic services organization dedicated to serving the informational needs of the Long-Term Care (LTC) insurance industry.
Fuzion Analytics provides carriers with different offerings like: CATALYST: Data mining and predictive modeling PULSE: Business intelligence reporting, industry benchmarking services SENTINEL: Fraud detection and case management Fuzion's analytic fraud detection framework, Sentinel, is composed of complementary components designed specifically to fit the fraud needs of Long-Term Care.
The Sentinel Framework is designed specifically to analyze LTC claims and identify fraud as early in the claim process as possible to minimize losses and maximize returns.
Fuzion's fraud identification services allow for analysis where very few cases of fraud have been documented, offering insight that has not been available to many carriers until now.
In addition to these capabilities, Fuzion offers fraud reporting services that will allow you to capture and analyze all fraud-related statistics and gain a better understanding of how fraud is affecting your business and how well it is being managed throughout claim processes.
Client Fuzion Analytics Start Date 01 November 2013 End Date 25 April 2014 Role.
to
Fedex – , ,
Received Customer delight award and employee of the year award from Accion Labs Received Best trainer award for the training imparted on Informatica Power center which helped projects being moved to India from the UK helping NHS account reach Real Key Milestone within minimal maintenance costs.
Received Accolades award for commitment in helping CSC NHS Account to go live with a large Acute Hospital trust.
Received Feather in my Cap award for the Report Model delivered to Microsoft client.
Won three silver medals for academic excellence during undergraduate education Presented seven technical papers at different national level technical paper contests during undergraduate education.
to
Solutions Architect/Delivery managerCambridge Associates Llc – San Francisco, CA, India
Responsibilities Devised the implementation process, solution architecture, environment sizing Oversee code development and delivery Performed requirements gathering for enhancement of data model for OBIA to bring in descriptive flex fields from EBS and define custom hierarchies for account rollups Responsible for the delivery of the project Environment Oracle BI applications, Oracle communications Data model, ODI, OBIEE, Oracle 11g Team size Rackspace - Refactoring Data warehousing through Tools Migration Project Description Rackspace is the world's #1 managed hosting company.
Rackspace has built a Data warehouse on SQL Server which could not be scaled cost effectively beyond a certain size due to various factors.
Therefore, they have internally devised an elastic data warehouse solution called Analytical Compute Grid which internally hosts PostgreSQL, Cassandra and Hadoop data stores and scales up/down on its down.
This project is to move their Data warehouse from SQL Server to ACG and all of their ETL code written from SSIS to Informatica.
This can be broadly classified into two parts: Architecture migration - Architecture migration involves analyzing the existing SQL Server based architecture and identify the appropriate location for the data for each of these existing components in relational, columnar or HDFS data stores and perform data modeling for the same.
Code migration - Reverse engineer the existing SSIS code to build Source to target mapping specifications and sit with appropriate business users and assess any changes to the existing needs and build new specifications and then using the same, write new ETL code in Informatica.
Client Rackspace Hosting Start Date 29 April 2014 End Date Till Date Role.
10/2014 to 01/1
Solutions ArchitectHawaiian Telcom – , ,
04/2012 to 01/1
Lead Developer – Austin, TX, India US
NHS - Snowdonia DW - Development and Snowdonia - Sustenance Project Description There are two different areas in this project: Design and Development of Data warehouse for reporting the data migration results Build-wise uplift and maintenance of existing Data migration solution - Snowdonia As part of Design and Development of Data warehouse, we are required to design and develop a data warehouse that provides reports on: General Data quality of the source system of the customer Reconciliation Report for the Deployment team and Customer to identify the way how data has flown through Snowdonia.
Unprocessed Reports to report on the records that were not processed beyond integrity check phase detailing the exact cause of failure of each record.
Validation Error reports to report on the records that failed business rules at a record level, across records, and also across datasets.
Data profiling reports for the customer to show the data's profile looked for the customer.
The scope of this project was to develop a DW + Report Model + Canned Reports As part of Snowdonia - Sustenance stream, the task is to uplift the Snowdonia solution to cater for each build of the target system.
Client Connecting for Health (NHS, Department of Health, UK Government) Start Date DW - For the DW stream Deputy Development Lead - Snowdonia - For the sustenance stream Responsibilities Involved in the Requirements gathering phase through the Development phase for the Data warehouse project.
Responsible for Designing mappings that populate and maintain different conforming Type 2 dimensions, Fact tables and Aggregate fact tables.
Involved in the Design phase of the Report model and few canned Reports.
In the sustenance stream, responsible for scoping, task allocation, design of solutions for Change requests and Deployment.
Also acts as an Offshore Backup for the onsite Lead Informatica Administrator.
Responsible for maintaining Repository health.
Developed solutions for setup of solution at the client site through Informatica, In-house tool for master movement of code, setup of end to end runs and standard health check.
Also upgraded three servers from Informatica 8.6.1 to Informatica 9.1.0 HF2.
Environment Informatica Power Center 8.6.1, 9.1.0, Oracle 10g/11g, SQL Server 2008, Windows Server 2008 Team size 7 (Overall team - 25) Project Location Chennai Project Name: - Snowdonia - Development Project Description Snowdonia is a code name for a generic data migration solution to migrate data from different versions of a legacy PAS system named iPM to CSC's enterprise solution - Lorenzo Regional Care.
This solution enables CSC to perform migration of existing data into Lorenzo Regional Care database within no time after performing all the validations incorporated in Lorenzo Regional Care application.
This migration is performed in three phases - Extraction of data - This phase involves extracting data from different source tables to necessary staging tables.
Post this step, the data is suitably extracted - verifying all integrity constraints and all record specific business rules to a Staging Database Transformation of data - Data in the staging database is further transformed in the manner to suit the target system, by performing further checks on business rules, which involves, across record and across dataset validations and final corrections of data before the data is written to specifically formatted flat files Loading of data - This phase involves, picking up of these flat files and after a second phase of integrity, business rule and other target system specific validations before the records are suitably loaded into the target system with all the proper integrity relations setup.
Client Connecting for Health (NHS, Department of Health, UK Government) Start Date 14 January 2010 End Date 31 March 2012 Role Informatica Developer & ETL architect Responsibilities To design generic Data Migration solution for extract and transformation solution alongside Solution Architect and Informatica Professional Services consultant Develop Generic Mappings and Workflows for the verification of data quality and extraction of data from Source to staging system and staging system to flat files.
Environment Informatica Power Center 8.6.1, Oracle 10g/11g, SQL Server 2008, SQL SERVER 2005, Windows Server 2008 Team size 2 (Project size - 28) Project Location Solihull UK (Till 09 Dec 2011).
02/2014 to 10/2014
Data Integration Practice LeadPublicis Groupe – , ,
12/2012 to 02/2014
Principal ConsultantPublicis Groupe – , ,
12/2011 to 12/2012
Senior Software Engineer – , ,
04/2011 to 12/2011
Senior Software Engineer – , ,
CSC UK.
01/2011 to 04/2012
Bickford Senior Living – , ,
NHS - Data Migration - Development Project Description NHS Data Migration project is a part of the CSC Alliance program for NHS's NPFIT - National Program for IT.
The primary deliverable of the program is "Lorenzo" - an enterprise HealthCare Platform.
The solution is provided to replace existing products used by different healthcare trusts.
As part of our project, we migrate from different source systems to Lorenzo.
This is normally accomplished in two steps: a) Extraction and transformation of data from sources - to a flat file b) Use the flat file to load to the target system Lorenzo - using an in-house solution.
Our solution is to generate flat files as per the target systems' specifications and mimicking UI Validations.
Client Connecting for Health (NHS, Department of Health, UK Government) Start Date 21 November 2008 End Date.
01/2010 to 04/2011
Software EngineerWillis Towers Watson – , ,
12/2006 to 11/2008
Project EngineerDavid Evans And Associates – , ,
05/2008 to 01/1
Team Member - RM, CM / Module Leader – , ,
Responsible for doing bug fixes in the resource management module.
As Module Leader for Resource Management Module, responsible for work allocation, status update, daily discussions with clients etc., Environment NET framework 3.0,NET framework 2.0, WCF, ASP.NET, C#, SQL Server 2005, Microsoft Team Foundation Server 2005 (MSTS 2005), Team Size 3 (Handled Team) ; 60 (Total Project Team) Project Location Hyderabad Project Name - Antipiracy Conversion & Sustenance Project Description This project is an extension of the previous Antipiracy project.
This project contained some customizations made for the EMEA region as well as changes that were needed to be made to Report model and some of the SSIS packages apart from performance fixes.
Client Microsoft Start Date.
01/2008 to 01/1
BI Developer – , ,
Key contributor to bring about changes in Canned Reports, Ad hoc report model, Fixing bugs in SSIS packages and also performance tuning SSIS packages.
Environment SQL Server 2005 Integration Services(SSIS),SQL Server 2005,MS SQL Server 2005 Reporting Services, SQL Server Analysis Services 2005 Project Location Hyderabad Project Name - Piracy and Sales Intelligence Global (Antipiracy) Project Description Piracy and Sales Intelligence Global is the application that has been developed to replace all existing Antipiracy Suite applications (Hotline, Sherlock, Spyglass and Metrics) and create one integrated system that will be adopted and used by the WW LCA AP teams.
And other than the AP Suite The application is a Tracking system actions and actions taken by LCA staff members.
It helps in providing information to support cases, which are initiated against the parties.
The application consists of different modules like: 1.
Lead Intake 2.
Party and Party Case 3.
Reporting 4.
MS Sales 5.
Admin Client Microsoft Start Date 10 April 2007 End Date.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
