IT Experience

7 Years 4months

Technologies

• SQL Server Development of stored procedures functions
• Query Tuning Performance Optimization including Index Creation
• Business Intelligence ETL development using SSIS Informatica, SSRS SSAS
• Custom Code Writing in C /Java.
• DB Modelling Report Creation.
• Bigdata

Tools known

• Microsoft IDE
• Pig Scripting
• JAVA
• HQL
• Hortonworks
• Fusion charts
• Microsoft BIDS
• Toad

Areas of Interest

• Big Data
• Data engineering

Domain

Role

Cards Domain

Tech. Analyst

Insurance

Software Engg.

Manufacturing

CI Executive

Healthcare Analytics

Software Engg.

Confidential

Sentiment Analysis

Overview:

Amex wants to analyze the trend of customers' view about various marketing schemes or discounts. We are analyzing customer care professional notes so we can see trend of issues faced by customers, sentiment of customers etc.

Tools used:

Hortonworks Hadoop, pig scripting, java, hive scripts and Tableau reports

My Technical Contributions:

Currently I'm working on integration of java code which will perform sentiment analysis and its integration with pig.

Working on proof of concept to connect Tableau reports with Hive and writing Hql queries.

Non Tech Contribution

Working with business on reporting parameters.

Confidential

American Express

Methodologies:

Waterfall phase 1 2 and Agile phase 3

Overview:

As financial organization my client has to be compliant against State/Federal rules for abandon property. In this project the manual process was automated resulting in more accurate and faster results. Also, reporting capability was also introduced. A generic framework for application of rules had been developed so upcoming state/federal rules can be introduced by matter of configuration.

Tools used:

• ETL Development: Informatica SSIS
• Report Development : SSRS
• Database programming : SQL Server 2008 R2 DB2
• Programming: C .net Java Shell

My Technical Contributions:

• Technical feasibility study and creation of Prototypes.
• Developing High level technical flow from requirements
• DB programming stored procedure creation
• ETL development
• Test support Release
• Warranty Support

Non Tech Contribution

• Mentoring 4 people team in performing Dynamic ETL based on business logic in stored procedures
• Code review.

Confidential

American Express

Methodologies:

Agile

Overview:

Business wants an automated solution to replace manual process of B2B orders placed by clients. Processing B2B orders is high volume but low margin business and there is SLA attached to each order. B2B clients send orders in file.

Tools used:

DB2 Stored Procedure , Ruby IBM Sterling Integrator middleware.

My Technical Contributions:

• Propose flow diagrams.
• Involved in DB model design.
• DB programming stored procedure creation in DB2.
• Provided automated workaround to operations team in Ruby.
• Report development in Sterling Integrator using translation map.
• Test support.
• Release roadmap

Non Tech Contribution

• Helped B2B operations team to standardize the business flow
• Developed Excel sheets using formulas for operations team to standardize end client interaction and information request.
• Co-ordination with UI development team
• Played role of backup Scrum Master.

Confidential

American Express

Methodologies:

Waterfall Phase1 Agile Phase2

Overview:

Unclaimed/Unused Card Amount of Expired Card needs to be merged with General Ledger. This project connects the card data ware house to pull expired cards and apply compliance rules.

Tools used:

• SQL Server 2008 R2 DB Programming
• SSIS SQL 2008 R2
• C programming

My Technical Contributions:

• Requirement understanding and analysis from technical prospective.
• Created POC seeking the complexity of requirements in SSIS
• Developing High level technical flow from requirements
• DB programming stored procedure creation in SQL server
• Report development.
• SQL Query optimization.
• Test support Release
• Warranty Support

Non Tech Contribution

Co-ordination with UI development team

Team member.

Confidential

American Express

Methodologies:

Waterfall

Overview:

Customer's privacy policies needs to be migrated all new cards issued to same person

Tools used:

• SSIS SQL 2008 R2
• SQL Server 2008 R2 DB Programming SSRS

My Technical Contributions:

• Requirement understanding and analysis from technical prospective.
• Developing High level technical flow from requirements.
• DB model analysis and design discussion.
• DB programming stored procedure creation in SQL server
• Report development.
• SQL Query optimization.
• Test support Release
• Warranty Support

Non Tech Contribution

• Creating SDLC documentation.
• Mentoring guiding 5 people team.

Confidential

Methodologies:

Waterfall

Overview:

The basic need for this project was to increase the user friendliness and aim was to provide required data in minimal clicks to the clients. This project was driven by rebranding.

Tools used:

DB Programming SSRS

My Technical Contributions:

• Requirement understanding and analysis from technical prospective.
• Report development.
• SQL Query optimization.
• Test support Release
• Warranty Support

Non Tech Contribution

Creating SDLC documentation

Development of real-time reports for Lean Assessment

Methodologies:

Waterfall

Overview:

The performance of Manufacturing plant can be increased by implementing Lean techniques. In this project real time manufacturing good practices are captured and analytics reports were provided to business.

Tools used:

• SSIS for ETL ELT development
• SQL DB Programming
• SSRS
• VB for Macro creation

My Technical Contributions:

• Application's technical flow design.
• Report development.
• Integration of SSIS with machine logs as source.
• SQL Query optimization.
• Test support Release
• Warranty Support

Non Tech Contribution

Creating SDLC documentation.

Team mentoring.

Confidential

Methodologies:

Waterfall

Overview:

Performance of the Contact Centre will decide reach of Health Care Services to common people. We developed CCVIEW in order to track the performance of Call Centre on near real time. In this application Informatica based ETL solution was developed to move data from Transaction OLTP database to OLAP database. T-SQL based stored procedures ad-hoc queries were developed to fetch the data from OLAP database to application.

Tools used:

• ETL using Informatica
• SQL Server MS SQL server 2005
• SSAS for OLAB cubes

My Technical Contributions:

• Created Low level design artifacts.
• ETL Development : Informatica.
• SQL Query development Stored Procedures Dynamic SQL Query .
• SQL Query optimization.
• Test support Release

Non Tech Contribution

• Client interaction
• Requirement gathering by creating POC.
• Creating Client Demos presentation.
• Creating SDLC documentation.

Confidential

Methodologies:

Waterfall

Overview:

Health Care Analytics is a web based analysis tool in the health care domain which allows users to view various Critical Reports on a real time basis. User can define his custom metric and parameters and point the tool to the source containing data, the tool will automatically format the data in format the data to draw graphs.

Tools used:

SQL SERVER 2005 ETL DB Development

SSRS Fusion-Charts

My Technical Contributions:

• Stored Procedures Dynamic SQL Query using SQL Server MySql.
• SSRS development.
• Fusion Chart Development.
• ETL Development using : SSIS Informatica

Non Tech Contribution

Requirement gathering by using iterative model.

Business Management System BMS

Methodologies:

Waterfall

Overview:

BMS is a business analysis tool has been developed to track various businesses and show their performance on the dashboard. MCC includes Business management system to attach metrics to various businesses and Dashboard to show the performance of business.

Tools used:

SQL Server 2005, SSIS, Java Script, XML, Web Services Fusion-Charts.

My Technical Contributions:

• ETL development using SSIS including WebService based DataLookup
• SQL Development Stored procedure Views
• SQL query optimization
• Fusion Chart development and customization using JavaScript.
• Worked in Product development team.
• Creating Proof of concept using multiple open source database.