PROFESSIONAL SUMMARY:

• Strong analytical thinker with 7 years of Software Development experience in Open Text (HP) Exstream Dialogue, SQL, SOAP UI, IT Service Management, expertise in Business Processes, SAS Enterprise Miner and Project Management with the professional consultative approach in problem solving
• Proven ability to learn and apply new information quickly, with profound knowledge and outstanding achievements
• Leadership qualities. Consistently gained increased responsibility through employment and academic pursuit.
• Sound judgment and solid decision - making skills.
• Effectively managed Off-shore team of 10 members.

TECHNICAL SKILLS:

HP: Open Text Exstream Dialogue Versions 8.3, 8.6, 9, 9.5, Quality and Command Center

Software: SOAP UI, XML, SQL, UNIX, BMC Remedy, MS Project, Visio, SharePoint, PowerPoint, Java, HTML

BI: SAS 9.3, Enterprise Miner, SSIS, SSRS, Advanced Excel, Macros, Big Data, Notepad++

SAP: SAP ECC 6.0, Netweaver BW, BEx Analyzer, Business Objects, Crystal Reports, Web Intelligence

Insurance Domain: ACORD and Guidewire forms, Quote, Declaration, ID cards, Cancellation Notices

Bank Domain: Whole Sale banking, Clearing and Settlement, S.W.I.F.T message and CLS Bank operations

PROFESSIONAL EXPERIENCE:

HP Exstream Dialogue Developer

Confidential, Columbus, OH

Responsibilities:

• Pioneered in developing HTML Email templates using Container design and e-delivery thru Command Center
• Built a complete end-end application in Dialogue database and generated forms & statements
• Created new applications, complex pages with repeating rows and tables, documents, pub files, output queues, formulas, functions, simple to use and modify Dynamic Logos on the pages
• Provided elegant solution to the pages like copy this page and flow to specific flow pages using the flow frames
• Performed unit testing using PDF viewer and obtained the concurrence on the final design using UAT
• Handled Incident Management & Change Management on a daily basis and ensured timely delivery with 100% quality
• Gathered and implemented over 200 user requirements, prepared the ETL design document, designed the process, prepared technical specs, performed unit testing for the delivery of application using HP Exstream Dialogue
• Worked with Business team on frequent changes and updates on Guidewire/Agency Portal requirements. Proposed a standard format for the design across various lines of business viz. Farm Ranch, Auto, Homeowners, Dwelling Fire
• Created weekly request in SOAP in L1 to check for errors and rendered the Quotes, Declarations and Forms
• Worked in Scrum projects using Agile and built a complete end to end application in Dialogue database & generated over 200 forms and statements
• Driven the weekly HPX Excellence meeting and trained the team of 20 with the latest process updates and innovation
• Initiated code review process to approve 10 sprint forms per week and Defect report meetings periodically and track them all using Jira

Business/Database Analyst

Confidential, Denver, CO

Responsibilities:

• Driven on-call technical supports and serviced at least 25 Police Departments on a daily basis that yielded great profits
• Processed over 2 billion records per day and assured all the projects are delivered on time
• Innovated stored procedures in SQL that processed the crime data effectively and increased the profitability by 40%
• Automated the entire ETL process in SSIS package that enabled the team to handle over 100 projects swiftly
• Managed Police Departments of all over the U.S. to ensure accurate data is uploaded in RAIDS and ATAC RAIDS
• Improved the efficiency by incorporating industry best practices such as proper documentation and knowledge sharing

Management Consultant Intern

Confidential, Irving, TX

Responsibilities:

• Organized a focused group and conducted individual interview with the employees to assess the situation
• Developed strategies and initiated new ideas to solve employer branding problem
• Led international team of 3 to work on the solution tool-kit with the implementation methodology that exceeded the CEO’s expectation and received appreciation for the implementation

Product Analyst

Confidential

Responsibilities:

• Increased production rate for 3 quarters in a row by establishing stable processes and IT operations across the payments and messaging application systems in the IT Service Management Portfolio
• Resolved high severity transaction issue within SLA by finding a missing message in MQ and avoided the financial impact of $10 million to the company
• Received Star of the Month Award twice for excellent performance in project implementation and promoted from Trainee to Analyst within 8 months of hire
• Coordinated with geographically dispersed, international crew of 25 and implemented over 200 critical changes in fast-paced environment successfully
• Applied data mining techniques in generating reports on a daily basis and decision making on go/no go projects

Research Data Analyst Intern

Confidential

Responsibilities:

• Pioneered in redesign of national weather prediction model in UNIX with renowned scientist Dr. U. N. Sinha
• Extracted data to preprocess from Confidential for Environmental Prediction ( Confidential ) dataset with shell script & C using India’s first parallel computing
• Compared customer demographics between competitors in book selling
• Identified the favorable factors influence the purchase using Log Likelihood by creating models like Poisson Regression and Exponential Beta in SAS code and used SQL to select data from dataset
• Found out customers from a specific region are 1.12 times more likely to buy from Confidential and Confidential

Confidential

Responsibilities:

• Cleaned the data and explored using SAS Enterprise Miner with a strong ability in statistical analysis
• Predicted the business implications about behavioral data on customers visiting the website using the champ model NN and suggested ways to improve the business
• Identified profitable customers using various model comparison techniques in SAS EM
• Incorporated best marketing strategies like pricing, positioning for the Harvard case study of Good Year’s Aquatred
• Developed a new product idea of Baked Sweet Potato Chips for Frito-Lays with demand analysis and target market
• Analyzed and made recommendations to optimize Wal-Mart operations in Indian market
• Created queries, OLAP reports in BEx query designer and in Web Intelligence
• Performed ETL process and ABC classification
• Developed a Crystal Report Dashboard Design using Xcelsius
• Created project charter and project plan for the construction of the city library