add photo
Kiran
kkreddi@outlook.com
775-291-3720
San Jose, CA 95101
Programmer Consultant
24 years experience W2
0
Recommendations
Average rating
126
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
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