SUMMARY:

• Strong in Data warehousing concepts, Entity - Relationship modeling, Dimensional modeling like Star schema and Snow flake schema methodologies.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in corporate-wide-ETL solutions using Abinito.
• Extensively used Transform components, Dataset components, Validate & Sort components.
• Developed graphs in Abinitio to load the data from various sources into Data Warehouse using different components like Reformat, Sort, Rollup, Filter by expression, Partition by key, Read hdfs etc.
• Having experience in Performance Tuning of graphs.
• Good in understanding Business processes/requirements and translating them into Technical Requirements.
• Having a good hold on secondary research with a wealth of knowledge on various databases covering diverse industries
• Databases include Capital IQ, Thomson One, SNL Financial, Factiva, LexisNexis, IDC, Gartner, Forrester, IBIS World, OneSource, HIMSS, Billian’s, BMI, Technavio etc.
• Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Ability to put consistent efforts over long period of time.

TECHNICAL SKILLS:

• Good knowledge on ETL tools like Abinitio, SSIS etc.
• Hands-on in Microsoft Office Suite (Excel and PowerPoint) and other business-related systems
• Hands on in SAS BASE, SQL
• Currently pursuing Python programming
• Good knowledge in Microstrategy Desktop
• Known Computer Languages like C, Data structures with C, C++ etc.
• Strong analytical and problem solving skills with the ability to effectively resolve moderately complex situations and issues with data tables

PROFESSIONAL EXPERIENCE:

Confidential

Analyst

Technologies: Abinitio, Oracle, UNIX

Responsibilities:

• Understanding the project requirement and creating low level and high level design document
• Developed Ab-Initio graphs for ETL (Extract, Transform and Load) of various data feeds coming into the system from different source systems and transforming them as per the business rules and finally loading the transformed data into the data marts by using various components like Reformat, Redefine Format, Rollup, Scan, Input Table, Output Table, Partition By Expression, Partition by Key and Sort, Merge, Concatenate, Gather, Dedup, Replicate etc..
• Read data from hadoop source through Read HDFs component
• Worked with various Ab Initio Parallelism techniques and implemented Ab Initio Graphs using Parallelism Techniques
• Designing graphs through mapping documents in order to load data into the tables using transformations.
• Fixing the Defects by analyzing the root causes of the defect and arriving at the resolution before modifying the graphs.
• Involved in code migration from Development to QC and finally to PROD.
• Co-ordination and knowledge sharing amongst team members.
• Involved in production support

Confidential

Technologies: Abinitio, Oracle, UNIX

Responsibilities:

• Develop Ab Initio graphs and provide support in case of graph failure.
• Create PSETs for all the graphs.
• Involved in coding and preparing design documents.
• Analysis and detailed unit test cases document.

Confidential

Technologies: Abinitio, Oracle My role in this project is to develop the following modules:

Responsibilities:

• Understanding the project requirement and creating low level and high level design document
• Developed Ab-Initio graphs for ETL (Extract, Transform and Load) of various data feeds coming into the system from different source systems and transforming them as per the business rules and finally loading the transformed data into the data marts by using various components like Reformat, Redefine Format, Rollup, Scan, Input Table, Output Table, Partition By Expression, Partition by Key and Sort, Merge, Concatenate, Gather, Dedup, Replicate etc..
• Create PSETs for all the graphs.
• Involved in coding and preparing design documents.
• Analysis and detailed unit test cases document.

Confidential

Technologies: Abinitio, Oracle

Responsibilities:

• Primary objective of this project is to automate the manual process to validate the reason for failed transactions for Investment banking process.
• This application mainly tracks the erroneous/ under update / failed transactions for the existing customer transactions and as per the business requirement updates are made to such records apart from validating the transactions against the master data that we get from the servers.

Confidential

Business Analyst

Responsibilities:

• We do get research requests which are categorized mainly in several different categories like Industry Analysis, Formatted/structured research, Document delivery, Screening, Unformatted/Advanced research.
• Industry Analysis- Here we prepare industry reports.
• By analyzing different industries and deriving the current trends, market sizing, growth forecast, competitor analysis etc.
• Formatted request- Here a proper format/template is followed while working on the deliverable.
• We prepare specific company briefing books, which includes all the company information like History, Background, Financials, M&A activities, Strategy, SWOT analysis, Competitive Landscape, Analyst comments, Key executives, recent key developments, Events etc.
• Also, various bios are prepared for company key executives.
• We use different data bases to analyze and extract the required information.

Databases used: Capital IQ, Hoovers, Factiva, OneSource, BoardEx, Avention, GlobalData (SWOT), MarketLine, AM Best reports - Experian reports and Zoom company reports from LexisNexis, 10K Wizard, D&B GRS.

Confidential

Media Analyst/Associate

Tools: Factiva, Critical Mention, Radian 6, Print media, Broadcast media, and the online media, SAS

Responsibilities:

• As an Associate data mining is my forte, and I’m responsible for Analyzing the Market for specific company and related industry information.
• Using this data I was creating/generating timely reports by summarizing and organizing the obtained data with, correct Formatting and Quality Checking
• Analyzing the market includes constant monitoring and performing fairly primary but mainly secondary research on various media like, Print, Broadcast, and the Online media and also on social media networks like Twitter, Facebook, LinkedIn etc. and video sharing sites like YouTube, Dailymotion etc. for existing and new clients
• Print media includes newspapers, magazines, journals, newsletters, and other printed material
• Broadcast media includes radio, television etc.
• Online or internet media includes web portals, newsgroups, podcasts, weblogs and RSS feeds
• Data collected from the sources includes both technical and non-technical info which should match the Guidelines/Info provided by the clients.
• Various Search Engines like Google and even Tools like Factiva, Radian6, Critical Mention etc. are being used in order to collect specific and relevant data
• Report creation mainly includes a process of Compiling the data, Collating it, Bucketing, Assigning Tones for each description etc. and also sending this organized data to client’s Sales Force Team
• And with the aid of MS-Excel Data Measurement for the generation of graphs and charts etc. is done, where the data collected is measured by abiding various instructions provided by the client

Confidential

Responsibilities:

• Both the projects mainly requires the generation of timely reports with a brief description of market analysis which is done as per the client instructions
• Constantly being in touch with the clients through mails for delivering quality service
• Often as and then, special/adhoc reports being prepared/generated/created as per client request by capturing breaking news, like product launch or quarterly earnings etc.
• Information for the reports is generated by rigorous research on the topic using Google by applying Boolean search technique and also by using various tools mentioned above