Uploaded File
add photo
Kiran
kkreddi@outlook.com
775-291-3720
San Jose, CA 95101
Sernior .NET Developer
22 years experience W2
0
Recommendations
Average rating
19
Profile views
Summary

  • A talented and industrious Software Engineer & Business Intelligence Architect with experience across Investment Banking Retail Banking and Insurance domains. A strategic operator who designs and develops efficient software solutions which support business processes and are in alignment with organisational objectives. Committed to delivering complete functionality supported by exceptional performance. Confident with exceptional communication and interpersonal skills which are used to work both collaboratively and independently to achieve results. Intelligent with the adaptability to integrate easily into diverse technical multi-functional teams to deliver significant business benefit. Areas of Expertise: Data Processing (Structured, Semi-Structured & Unstructured)
  • Systems Application Architecture Support
  • Application Development Lifecycle
  • Source-to-Target Data Mapping, Design & Review
  • Software Engineering Principles
  • Business Process Analysis & Automation
  • Requirements Analysis
  • Design & Coding
  • Testing & Implementation
  • Optimizing ETL Workflows
  • Database
  • Storage Management
  • Mainframe Environment
  • Resolution of DB2, CICS & VSAM Issues
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • Report Writing using SSRS
  • Creation of Reports: Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
  • Developing, Monitoring, Extracting & Transforming Data using DTS / SSIS, Import Export Wizard and Bulk Insert
  • High Level Design of ETL DTS & SSIS Packages for Integrating Data using OLE DB Connection from Heterogeneous Sources (Excel, CSV, Oracle, Flat File, Text Format Data) using Multiple Transformations provided by SSIS (Data Conversion, Conditional Split, Bulk Insert, Merge and Union All
  • Developing Reports on SSRS on SQL Server (2000 / 2005 / 2008)
  • Writing Expressions in SSRS and Expert to Fine Tune Reports
  • Creating Numerous Drill Through and Drill Down Reports using SSRS
  • Creation of Database, Tables, Stored Procedures, DDL / DML Triggers, Views, User Defined Data Types, Functions, Cursors and Indexes using T-SQL
  • Creating and Managing Database Objects like Tables, Views
  • Data Conversion and Data Migration using SSIS and DTS Services across various Databases (Oracle, MS Access and Flat Files)
  • T-SQL in SQL Server 2000 / 2005 and 2008 Platforms
  • Performance Tuning and Query Optimization Performance Point Server 2007, Designing Dashboards, Scorecards and Reports using Multiple KPIs, OLAP Charts and SSRS Reports with PPS
  • Maintenance and Administration of SSIS by Creating Jobs, Alerts, SQL Mail Agent and Scheduling DTS / SSIS Packages
  • SQL Server DTS and SSIS (Integration Service) Package Design, Construction & Deployment
  • Transforming Data between Servers using Tools such as BCP, DTS and SSIS
  • Creating Packages to Transfer Data between Oracle, MS Access and Flat Files to SQL Server using DTS / SSIS
  • Creation of Parameterized Reports
  • Creation of Star Schema and Snow Flake Schema
  • Data Architecture (Data Ingestion Pipeline Design, Hadoop Information Architecture, Data Modeling, Data Mining, Machine Learning, Advanced Data Processing
  • Dashboard Reporting (Reporting Services, Report Model, Report Builder) Technical Competencies: Career

Experience
Programmer Consultant
Information Technology
Jan 2008 - Jan 2013
  • AVP Leading global financial management & advisory company presence in 44 countries across 6 continents. Excels in planning-based financial advice and management for individuals and small businesses. Top global underwriter of debt and equity securities 8 years running. Leading strategic advisor to corporations, governments, institutions and individuals worldwide. Operates, through Merrill Lynch Asset Management, one of the world's largest mutual fund groups.
  • Current project executed for Global Markets and Investment Banking (GMIST) Project: Consolidated Data Repository (CDR) - a comprehensive database holding daily trading of securities information, which is then passed to other applications as databases (datamarts), primarily performed using BAS written RPG programs, or MS SSIS 2014 Utility. Collaborating with users, team lead, DBAs and technical manager, promoting clear lines of communication to achieve a full understanding of system requirements and prepared BRS and DS Document Developing DTSX packages to extract, transform and load into the CDR from OLTP database and designing dynamic SSIS packages to transfer and validate data across platforms and archive data files Supporting system-wide replication tasks including monitoring, alerting and issue resolution
  • Responsible for documentation of system-related activities providing technical system documentation Designing service broker workflow to process incoming files and load into SQL Server database Key player in the migration from SQL Server 2005 to 2014 and SSIS / SSRS 2005 to 2014 and designing SSIS packages to ETL existing data into SQL Server from other environments Designing, developing, debugging and testing reports in SSRS Creating Parameterized reports and Linked reports, demonstrating a deep knowledge of report serving architecture (table, chart and matrix report)
  • Other tasks including: converting DTS application to SQL SSIS, creating reports, developing dashboard reports, generation of drill down and drill through reports, design and creation of table schema, storing procedures for use in Data QC, using Joins and sub-queries for complex queries Environment: MS SQL Server2005/2008/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# TFS (Share Point), C#/Visual Basic6.0/VB.net, VB Script and Windows 2008 Server Project: Custody Clearing & Settlement, Inventory Control System - involving maintenance and development of in-house inventory control system which clears and settles securities within the DTC and FED.
  • Applications include MICS ONL (Online) and SETALLID (Online Settlement). Majority of daily settlements effected with the system issuing settlement instructions to the FED and DTC which triggers the movement of securities Developed systems to handle increase in trade volume and manage settlement operations more efficiently Project: Physical Securities - involving maintenance and development of in-house Physical Securities system which settles securities with DTC. Systems being handled are: CAP, PAL and Abandoned Property Performed detailed analysis and provided timely information to resolve real-time issues Prepared BRS and DSD Documents for enhancements and development of new programs Designed and developed COBOL programs: Batch and Online, RPCs and Stored Procedures Undertook Unit and System testing of newly developed and / or changed components Performed tuning of online transactions using tools such as TMON and Main View
  • Generated ad hoc reports to business users using Business Intelligence Tools
  • Environment: Scala, Python, Java, .NET (C#), MS SQL server, MS SSIS BI, MS SSRS, MVS/ESA, OS/390, COBOL, JCL, CICS, DB2, VSAM, REXX, Easytrieve, SAS, FILEAID, QMF, PLATINUM, INTERTEST, BMC AR/CTL, MQ Series, .NET (C#), TMON, Main View, Unix
Stored Procedure SSIS .NET C# DB2 Cobol CICS OLAP SQL Server SQL Asset Management Java SSRS Triggers Python UNIX IBM Websphere MQ MS TFS Visual Basic Project Management JCL VSAM
Remove Skill
Technical Lead
Information Technology
Mar 2006 - May 2008
  • (Client: Branch Banking and Trust (BB&T) - Wilson, NC BB&T is a prolific, highly profitable financial holding company with $109.2Bn in assets and 1400 offices in 11 states. Active player in the rapid consolidation of the financial services industry and successful in increasing its assets through the acquisition of many other banks
  • Project: Data Migration & Risk Management Systems (RMS)
  • Data Migration - on acquisition of Mainstreet Bank, First Citizen Bank and Coastal Federal Bank, performing conversion to migrate all customers and accounts to BB&T applications
  • RMS - involving the extraction, transformation and loading of data from various applications, for use in Credit Risk Monitoring and Regulatory purposes Researched and understood both target and source systems then planned and prepared Business Specifications Document for migration of data from source system to target system Active role in high level mapping sessions, involved in migration design, construction, testing and full volume rehearsal and other tasks including: data mapping, data quality assessment, data cleansing, credit risk management reports, ETL data, IQA and EQA involvement and 24/7 production support Environment: MVS/ESA, OS/390, COBOL, JCL, CICS, DB2, VSAM, REXX, FILEAID, PC Data Map, Glad Stone, SAS, Easytrieve, .NET (C#)
No skills were added
Remove Skill
Programmer Consultant
Information Technology
Aug 2001 - Mar 2006
AVP Team Member/Module Leader/Tech Lead
No skills were added
Remove Skill
Aug 2001 - Aug 2001
Tata Consultancy Services Tools Group - (Client: BB&T, Wilson, NC) (Client: ING, Hartford, CT) (Client: Merrill Lynch, Jacksonville, FL)
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Masters' in Business Administration
not provided
Bachelors' in Chemical Engineering
not provided
ISIM, Insurance
Banking Fundamentals and Investment Banking
Certifications
CCA Spark and Hadoop Developer (License: 100-016-051 expires
Skills
.NET
2013
5
Asset Management
2013
5
C#
2013
5
CICS
2013
5
Cobol
2013
5
DB2
2013
5
IBM Websphere MQ
2013
5
Java
2013
5
JCL
2013
5
MS TFS
2013
5
OLAP
2013
5
Project Management
2013
5
Python
2013
5
SQL
2013
5
SQL Server
2013
5
SSIS
2013
5
SSRS
2013
5
Stored Procedure
2013
5
Triggers
2013
5
UNIX
2013
5
Visual Basic
2013
5
VSAM
2013
5
Application Development
0
1
Applications Architecture
0
1
Business Intelligence
0
1
Data Architecture
0
1
Data Mapping
0
1
Data Migration
0
1
Data Mining
0
1
Data Modeling
0
1
ETL
0
1
Information Architecture
0
1
jQuery
0
1
Oracle
0
1
Requirement Analysis
0
1
Snowflake
0
1
Software Engineer
0
1
Star Schema
0
1
Storage Management
0
1
T-SQL
0
1