Data Sales
Resume:
Akhil A Shah
adh022@r.postjobfree.com
Summary:
● 16+ years of strong IT experience in Analysis, Design, Development, Implementation, modeling, Testing and support.
● 9+ years of extensive ETL implementation experience using Informatica PowerCenter 7.x/8.x/9.x, Oracle 11g/10g/9/8, Netezza 4.6, MS SQL server 2000/7.0, DB2, Informix, MS Access 97/2007
● Proficient in SDLC, Conceptual Data Base Designing, DWH concepts, dimensional Star Schema and Snowflakes Schema and Extended Star Schema (SAP BI/BW).
● Bill Inmon and Ralph Kimball Architecture.
● Expertise in Business Analysis, Requirement Analysis and documentation.
● Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels.
● Social Analytics/Graphs.
● Experience in Data Integration and Conversion.
● Immigration Status: US Citizen
Skills:
● Tools: Actuate ERD Pro 6/7, WEBI 4.0, Crystal Reports Enterprise, Informatica 7.x/8.x/9.x, Python, Jupyter notebooks.
● Databases: Amazon Redshift/Athena, PostgreSQL, Oracle 8/9/10g/11, Netezza 4.x/6.x, SQL Server, DB2, Avaya CMS, Access 97-2007.
● Programming Languages: VBA, SQL, Python
Certifications:
Big Data and Social Analytics, Massachusetts Institute of Technology Certified ScrumMaster (CSM) for Agile Software Development. Education:
Masters of Science in Space Systems, Florida Institute of Technology (In Progress). Bachelors in Mathematics, University of Rochester. Experience:
Aug 2018 – Mar 2020 Capgemini
As part of the Insights and Data (I&D) group, we engage with clients with needs in Data Integration, Analysis/Analytics, and Business Process Design. I have worked with clients like Johnson and Johnson and NBC Universal.
Manager/Technical Business Analyst
Johnson & Johnson (Pharmaceuticals)
Project Summary: Xarelto Marketing Team at J&J wanted to generalize their Analytics collections to understand their market penetration compared to the competitors. To do this, Medical Education Poll 1
Akhil A Shah
adh022@r.postjobfree.com
data was integrated and matched with the Sales data from several sources of Healthcare Professionals (HCP) to get an accurate view. This valued statistics would be used for future focus areas as well as predictions. This Analytics was published using Qlik Sense. I worked on providing these ready Data Sources to Qlik Sense for consumption.
● Extensive use of PostgreSQL to analyze data from Medical Education events and Sales data.
● Provided Data Views to the Dashboard team for Visualization.
● Held JAD sessions with Stakeholders and the Analytics team to go over User Stories.
● Created Business Process and Architectural Diagrams.
● Helped create a Data Governance process to integrate this new data in J&J ecosystem. Johnson & Johnson (Surgical Devices)
Project Summary: Capgemini’s engagement here was to formalize a Persistent Data Storage on Redshift Database hosted on AWS based on the existing loosely held Architecture. Sales/Device Data from the multiple Vendors was sent to AWS S3 Buckets for downstream consumption. The Development was to be done using CI/CD using Jenkins.
● Extensive use of PostgreSQL to analyse SD Sales Data.
● Made changes to existing AWS Athena data objects to further refine with new entities.
● Created new User-Stories in JIRA and held JAD sessions with all Stakeholders.
● Managed Off-Shore team.
● Worked with the Infrastructure team to add new data elements to existing data objects.
● Updated existing Business Process diagrams.
NBC Universal
Project Summary: The Marketing Team use commercial applications to determine Neisen TV Show Ratings for their research to determine future time-slots. Objective of this project was to build in-house applications that replicate the functionality of these commercial applications without breaking a process. I played the role of Technical Business Analyst.
● Created new User-Stories in JIRA and shared with the off-shore dev team.
● Wrote backend SQL queries to do functional testing.
● Helped with a PoC to move existing Data Mart to SnowFlake.
● Interacted with the Market Research team to understand new requirements and demonstrate current functionality of the application.
Mar 2014 – Nov 2017 Bank of America, NY (Through Tata Consultancy Services) As a Sr. Consultant with TCS, I was involved in projects in two different LOBs: Operational Loss, and Risk and Compliance.
Solutions Architect/Technical Analyst
Operational Loss:
2
Akhil A Shah
adh022@r.postjobfree.com
Project Summary: As part of Operational Loss, we designed and built a FINRA compliant Business Process framework to integrate existing Enterprise Applications (EAI). The end state of the framework would be to build automation to drive these processes using RPA.
● Designing new solutions and PoCs.
● Created Permit To Build / Permit To Operate (PTO/PTB) compliant HLDs and LLDs.
● Presented HLDs and supporting documents in the Architectural Review Board (ARB) process meetings.
● Extensively used Visio to create Business Process Diagrams to integrate Enterprise Application for Regulatory and Compliance testing. These documents were consumed by both end-users and the Testing team.
● Writing Business Requirement Specifications/User Stories in JIRA.
● Ran periodic requirement gathering meetings with users/stakeholders. Risk and Compliance:
Project Summary: As part of the Risk and Compliance team, we maintain Application DW which houses the entire Trade Lifecycle data. This data comprises of Fixed Income, Equities and Derivatives. This data is consumed by the Risk and Surveillance models. Processes are frequently updated to reflect newer/updated Govt. Regulations. As part of the DW team, I was involved in maintaining data structures for APR and EMEA region.
● Prepared HLD, LLD for new and existing process.
● Technical enhancements to existing processes.
● Performed post production analysis data reconciliation.
● Involved in FINRA Regulatory reporting enhancements for mandatory reporting of Wash-Trade and Front-Running Trade surveillances.
● Liaised with Equities and Fixed Income subject matter experts to understand business and systems requirements, process workflows.
● Spearhead an initiative which included changing the data feed from an old source to a new.
● Updated Functional Specs for existing process as well as documenting new ones.
● Incorporated new up-stream integration with NASDAQ-SMARTS into existing architecture. Jan 2013 – Feb 2014 Nationwide Investments Group, Columbus, Ohio Sr. Consultant
Project Summary: The NW Investments Group manages the premiums paid by the NW customers in Fixed Income assets. As a part of the Solution Design team I focus on enhancements of existing flows and writing new flows.
● Prepared high level design and ETL process flow diagrams.
● Prepared solution to read Unstructured data without using special transformations.
● Created new ETL standards.
● Help create Identity Management process.
● Suggested and implemented changes in code migration to cut down migration time.
● Prepared DFD diagrams.
3
Akhil A Shah
adh022@r.postjobfree.com
● Assisted with testing strategy such as generating mock up data and expected results.
● Created Reusable transformation.
● Mentor staff in Informatica.
● Wrote logic to write out Hash-Values for data comparison.
● Perform data analysis using SQL analytical functions and excel. April 2012 – Jun 2012 JP Morgan Chase (Through TCS), Columbus, Ohio Sr.Consultant
Project Summary: Digital Marketing is a new initiative take by the bank to re-strategize customer retention and acquiring new business. When finished, it would be part of new a revamped iCDW with size ranging from 35 to 40 Terabytes (TB)at the end of the first year. iCDW is an extension of the famous IBM’s BDW architecture.
● Prepared high level design and ETL process flow diagrams.
● Help set up infrastructure and re-architect existing process to accommodate additional sources.
● Created a solution to consume files with changing layouts on weekly basis.
● Wrote Informatica flows to populate Teradata tables using TPT utility.
● Assisted with testing strategy.
● Initiated creation of Break Fix Environment and Performance Testing (PT) Environments.
● Closely worked with INFA IDQ teams to profile huge files to see data patterns.
● Maintained and trouble shoot existing flows--table size ranged between 500GB to 1 TB.
● Wrote free hand SQL to perform data analysis.
● Wrote Source to Target Mapping documents.
Nov 09 – Mar 2012 Information Control Corporation (ICC) Summary:
ICC is software Vendor Company which provide software solutions such as Business Intelligence, Technology Infrastructure, and Software Development to Fortune 1000 companies. I worked with Clients like Wendy’s and Nationwide during my time with ICC. Apr 2011 – Dec 2011 Nationwide Insurance (RADS), Columbus, OH Sr. Developer/Tech Lead
Project Summary: Reporting and Data Services (RADS) is a part of NW Finance. RADS maintain a HA (high availability) databases which are always up with strict SLAs. Being part of RADS, I work on many concurrent projects: Some new coding and some changing existing code with new business logic using Agile Scrum Development Methodology.
● Initiated creation of Metadata.
● Prepared high level design and ETL process flows document.
● Wrote Informatica flows to populate HA Oracle tables.
● Created ETL flows using PL/SQL.
● Created Story Cards for a very high visibility project. 4
Akhil A Shah
adh022@r.postjobfree.com
● Assisted NW Staff with optimizing Informtica flows.
● Performed QA and code review.
Jan 2010 – Mar 2011 Nationwide Insurance (ECIF), Columbus, OH Sr. Informatica Developer/Junior ETL Architect
Project Summary: As a part of ETL Team, we designed a solution to replicate existing Near Real Time DB2 MDM table updates to Netezza Data Warehousing Appliance. The objective of this project was to repoint the costly ad-hoc queries and queries from SOA Applications from DB2 to Netezza. The MDM tables were loaded during using IBM CDC tool so the end result was to repoint CDC to UNIX environment which would feed Near Real Time transaction files to Informatica 8.6.
● Prepared high level design and ETL process flows document.
● Designed an ETL solution to consume CDC Flat Files in an orderly fashion.
● Wrote Informatica flows to read Flat Files and write out to Netezza.
● Did initial loads using Power Exchange Plugin for Netezza. Pushed 1 Terabyte (TB) of data using Session Partioning.
● Wrote Pilot flows using Session on Grid (SONG) functionality.
● Provided technical tips to optimize Informatica mappings and workflows.
● Coached junior staff with Pushdown Optimization.
● Updated standards for the ETL and Data Warehouse Processes.
● Advised NW Management to make certain Infrastructure Changes in Informatica environment.
● Created Re-usable Transformations.
● Mentored/Trained existing NW staff with Informatica.
● Scheduled Informatica flows using Maestro Tivoli Scheduler.
● Made changes to those CDC flows to fit in newer Data Model changes. (MDM 8 MDM 9)
● Worked with the QA team to resolve data issues due to Code Page differences in NZ and DB2.
● Performed QA and code review.
Nov 2009 – Dec 2009 Wendy’s, Dublin, OH
Sr. Informatica Developer/SQL Developer
Project Summary: Developed new mappings and enhanced existing mappings/workflows in informatica to suit the new Business Requirement and flow conversions from IBM Data warehousing Tool to Informatica 8.6.
● Created Mappings using relational source and targets such as Oracle, DB2, and Sql Server.
● Established ETL design documentation, lead and coached a distributed team in all phases of ETL implementation.
● Mentored other junior Informatica developers with their coding needs.
● Worked on batch scripts and JAVA/GROOVY scripts and called the scripts in Informatica. Performed work with SQL, EMBEDDED SQL, and query optimization. Worked on file transfer mechanisms.
● Worked with Flat Files by unique file name generation and creating multiple files. 5
Akhil A Shah
adh022@r.postjobfree.com
● Performed QA and code review.
May 2008 – Oct 2009 JP Morgan Chase, Columbus, OH
Informatica/SQL Developer
Project Summary: As a part of BI team I was involved in building a Data Warehouse. Projects include collecting Near Real-Time call centre data by region to display it on dashboard, Call Centre Metrics, Agent Compensation, Sales data, Job Requisition reporting data, creating Star Schema for Service To Sales (STS) Data, and Employee Headcount data. Source systems include Avaya CMS, SQL Server, Oracle, DB2, Flat Files and Excel. The data was extracted using Informatica 8.1/8.6. Presentation was done using ESSBASE and COGNOS.
● Physically and Logically designed data mart using Star Schema.
● Created a process to collect daily Sales data which would be verified to be ftp over to an external vendor.
● Created a multiple step process to build a Type II Employee Headcount Dimension (SCD).
● Created a process to collect New Job Requests data. The results of which were reported to the CFO.
● Maintaining and enhancing Real-Time call center data process on three regions. Source included Flat Files provided by IEX.
● Managed and altered process which Collected Call Center data. Reportable metrics included Avg Handle Time (AHT), Abandonment Call (ABN) Counts etc. Data extracted from Avaya CMS.
● Created, Maintained and enhanced Agent Compensation Data.
● Used various Transformations such as Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner, Sequence Generator, and Update Strategy.
● Tuned mappings for performance.
● Defined standards for the ETL process and Data Warehouse.
● Involved in DEV to UAT migration.
Jan 2008 – Apr 2008 British Petroleum, Whiting, IN Informatica Developer
Project Summary: Refinery warehousing project was developed in an effort to stream line the entire process of contractor and Employee billing and to effectively maintain parts inventory. This would ensure timely and actual billing as well as ordering the parts for the refinery as required. The work prior to this was done using Excel and MS Access which lead to lot of inconsistencies in data along with having unrestricted access to vital information. Sources included Oracle 9/10, MS Access/Excel and Flat Files. This data was extracted using Informatica (8.1)and was staged in Oracle 9. The implementation of DWH was done in SAP/BW.
● Wrote Functional Specs of over all ETL architecture.
● Rigorous Data Analysis using SQL and Data Profiler in Informatica.
● Did ad hoc reporting using Oracle.
● Physically implemented the design of Staging Data bases.
● Created methodology for Delta Extraction.
6
Akhil A Shah
adh022@r.postjobfree.com
● Created Audit Table to maintain row count compliances.
● Created mappings to simulate Delta Extraction.
● Used various Transformations such as Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner, Sequence Generator, and Update Strategy.
● Used special functions provided by Informatica to mask Social Security Numbers.
● Ran queries pre and post load audit queries in Oracle for data compliancy.
● Involved in writing Unit Testing methodologies.
● Created Parameter Files.
July 05 – Nov 07 Home Depot, Columbus, OH
Sales Associate/Kitchen designer
Main focus on customer service, designing and selling kitchens.
● Design elegant and functional kitchens based on budget specifications and specific customer needs.
● Exceeded sales target frequently. Converted more than 75%of leads into sales.
● Built client relationship, leading to repeat and new sales through referrals.
● Reduced shrink through process innovation.
● Strategical placement of merchandise, leading to higher customer traffic and higher revenues. Mar 2005 – June 2005 Deloitte, Sacramento, CA
Actuate/SQL Developer
Work Summary: Developed new reports and altered the old reports to suit the need for new functionality for CADDIS (California Department of Disability Services). CADDIS is the branch of State Govt. of California, which undertakes the task from providing medications to lending money to the needy for their monthly expenditures and keeping track of the same. Responsibilities:
● Gathered requirements for the CADDIS application with the functional leads and users of the application.
● Proper implementation of the Business Logic to extract the data from Oracle 9 DB based on the requirements.
● Wrote packages in Oracle and called them from Actuate ERD Pro 6.
● Adding and altering Libraries to Actuate 6 to meet the company standards.
● Analyzed development database schema and tuned complex SQL queries in Oracle using TOAD.
● Generated ERDs using TOAD.
● Analyzed, tuned and sometimes rewrote the entire packages for their preexisting reports for faster execution.
● Created Detail-Summary Reports using Hyper Linking.
● Extensive usage of Sequential and Group Sections. 7
Akhil A Shah
adh022@r.postjobfree.com
Sept 2004 – Nov 2004 Source One Consulting, Lawrenceville, NJ MS-Access/VBA Programmer
Responsibilities: Designing and developing a Data-Entry application for a waste management company to generate monthly, quarterly and, annual reports. Modify and error checking an application used for insurance billing which has already been developed. Used SQL Server in the back-end. Feb 2000 – Nov 2002 Xerox Corporations, Rochester, NY Programmer/Analyst
Project Summary: Developed various integrated solutions for financial analysis using MS-Access as a front-end and Oracle database as a back-end.
Responsibilities:
● Developed and administered a secured financial application. Resulted in better financial reporting.
● Developed an application to update mainframe asset information. Resulted in accurate client billing.
● Developed an application using (mda) with user Groups and Roles, Set Privileges for the users.
● Wrote SQL queries in Access to extract relevant data for ad hoc reporting.
● Created Macros which would fire queries sequentially to implement the business logic for applications.
● Built an application for the Contract Database (CDB) to improve the accuracy of Equipment Serial Numbers data entry to 100%.Resulted in increased revenue.
● Cleaned data in CDB to maintain consistency.
● Created reports using Actuate to present to senior management. 8
Contact this candidate