Data Sql Server
Resume:
Bhasker.susarla
Work Authorization EAD
Objective
Seeking challenging position as a Data Architect//Data Modeler/Data
Analyst/ ETL Developer in the field
of Data Warehouse and Database design
Summary of Qualifications
. Data Modeling - Conceptual, Logical and Physical Modeling for Online
Transaction Processing and Online Analytical Processing (OLTP & OLAP).
. Having knowledge in IBM Insurance Application Architecture (IAA) Data
Model
and IBM Insurance Information Warehouse (IIW) Data Model
. Having knowledge in ER Modeling, Dimensional Modeling (Star Schema,
Snowflake Schema) and Data Warehousing, OLAP tools.
. Proficient in Relational and Dimensional (Star schema, Snowflake schema)
data models.
. Experience in gathering business requirements, use-case and requirement
analysis.
. Experience in MORTGAGE Domain.
. Involved in JAD sessions with data analysts, developers, user interface
personnel and end users.
. Proficient in Normalization/Denormalization techniques in
relational/dimensional database environments.
. Experience in Design and implementation of ETL Informatica methodology
for Data Extraction, Transformation and Loading..
. Worked in creating UML diagrams from user requirements using Rational
Rose.
. Proficient in using Rational Clear Quest and Clear Case to manage change
management and configuration management.
. Involved in the critical design review of the finalized database model.
. Good communication and presentation skills. Experienced in working with
business users as well as senior management.
. Worked on Siebel CRM (Call center, IVR) Module.
. Experienced in SQL and PL/SQL programming, Stored Procedures, Functions,
Packages, Triggers, performance tuning and optimization.
. Having Good knowledge IBM IAA/IIW
. Having good knowledge in SAS applications
. Experience with Teradata SQL and Teradata Utilities (ETL Data Migration
Tools).
. Worked on Various Methodologies ( Rad, water fall and Agile).
. Worked with QA Team for testing the data as per the requirement.
Qualifications:
Master of Science.
Post Graduate Diploma in Computer Applications
Skills
. Languages: C, C++, HTML, SQL, T-SQL.
. DBMS: SQL Server 2000, 2005, Oracle 7/8/9, Teradata, Sybase 12, MS
Access, DB2.
. Analysis/ Design Tools: Erwin, Sybase Power Designer, ER Studio, MS
Visio, Rational Rose, Oracle Designer 6/8, Oracle Financial Analyzer 6/8,
Rational Clear Quest, Rational Clear Case
. Operating System: Windows NT 4.0/3.51. Mainframe.
. ETL TOOLS : Data stage 7X, informatica 7.1,8.1. SQL Server DTS
Packages, SSIS.
. BI tools ; Siebel analytics 7.8,Obiee 10.1.3, Micro strategy.
Certifications
MCITP from Microsoft (2005 and 2008)
TERADATA from Capital One University
PROFESSIONAL EXPERIENCE
CFSSC (Child Family Support) Feb
11 to Till Date
Columbia, SC
Data Analyst
This Project is Child welfare Support Project. We are getting data from
Different counties(42 counties) to the Data warehouse. The Data from the
counties are different source systems. Analyzed source data with target
Data.
. Exp rience in Gathering data requirements.
. Redefined many attributes and relationships in the reverse engineered
model and cleansing of tables and columns
. Performed Gap Analysis.
. Worked with various data bases and schemas
. Defline FACT and DIMENTIONS,
. Tested Data Movement Data warehouse to Data Mart with Reference
Business Rules.
. Mapped the data Elements between Source and Targets.
. Worked with various data inspection tools.(SSIS and TALEND).
Environment:
SQL Server 2008 R2, SSRS, SSIS, SSAS, MS Office, Erwin, Windows
XP, Windows 2003, UNIX.
BCBSMA, Oct 10 to
Feb 11
Boston, MA
Data Analyst
The present project is a Medical Insurance project is called SMART
MIGRATION. The Project is to build a Centralize data warehouse. The data is
consisting of data about old customers as well as new customers from three
different sources . The old customer's data were to be extracted from the
existing database. In addition, new customers were added by promotional
schemes which were being offered as part of the company's policy to expand
business.
. Expanded Physical Data Model (PDM) for the OLTP application using
Erwin.
. Designed and built relational databases.
. Maintained and updated the database b y deleting and removing old
data.
. Mapped the data between Source and Targets.
. Used Erwin to transform data requirements into data models.
. Used Star Schema and Snow flake schema methodologies in building and
designing the logical data model in the dimensional Models.
. Performed Reverse Engineering of the current application using ERWin,
and developed Logical and Physical data models for Central Model
consolidation.
. Redefined many attributes and relationships in the reverse engineered
model and cleansed unwanted tables/columns as part of Data Analysis
responsibilities.
. Defined and processed the facts, dimensions.
. Creating databases for OLAP Metadata Catalog tables.
. Worked with various data bases and schemas.
. Good experience in data analysis querying and writing in SQL and TOAD.
. Very good in understanding the relationships and the data types.
. Worked with ETL to create source to target mappings (S2T)
. Worked with data inspection tools.
. Developed Reports in OBIEE.
. Involved in Supporting Data Modeling of an Enterprise Siebel
Analytics(BI) Data Model
. Involved in the critical design review of the finalized database
model.
.
Environment: NETZAA, SQL Server, Toad, IRAAD, Informatica 8.1.1
OBIEE, MS Office, SQL Server, HTML, Erwin, Windows XP, UNIX.
Capital One, Plano TX
Sr Data Analyst/Modeler/ETL Teradata Specialist
Dec,09 to Sep 10
The objective of this project is to build a central repository DATA
WAREHOUSE (MDW AUTO) in Teardata from two Different systems (BOA & CCB)
.
The warehouse that could support COF( Capital One Finance) do business
tomorrow and for the various reporting and information needs.
. Analyzed business requirements, system requirements, Data Mapping
requirement specifications interacting with client, developers and QA
team.
. Hands on experience in Writing and Executing MLOAD and FAST LOAD
Scripts for TERATADA
. Validated Source data with Target Data in Teradata.
. Used Erwin to transform data requirements into data models.
. Used forward engineering for creating databases for OLAP Metadata
Catalog tables.
. Redefined many attributes and relationships in the reverse engineered
model and cleansed unwanted tables/columns as part of Data Analysis
responsibilities.
. Extensively used CASE & CAST functions for Data Cleansing.
. Created Tables in Teradata.
. Collected Statistics for Tables and Columns.
. Collected Skewratio for Created Tables(PI).
. Granted Permission to different Users to Table which I was created.
. Experience in using Teradata Utilities like Fast load and MOLOAD for
data loads.
. Extensively used EXPLAIN in analyzing the SQL query execution flow.
Using this analysis
. tuned SQL queries to use Teradata resources efficiently.
. Performing Data validations, Data Profiling and Data Cleansing for
Teradata Database.
. Used MS EXCEL and MS ACCESS for Data CLEANSING.
. Participated in Integration & status meeting, mentor QA resources and
create Test metrics
. Performed all aspects of verification, validation including
functional, regression, system testing
. Used SQL tools to run SQL queries and validate the data loaded in to
the target tables.
. Strong ability in developing advanced SQL queries to extract,
manipulate, and/or calculate information to fulfill data and reporting
requirements including identifying the tables and columns from which
data is extracted.
. Created Test input requirements and prepared the test data for Data
Driven testing.
. Involved in extensive DATA validation using SQL queries and back-end
testing.
. Validated SAS Reports.
. Worked on data profiling and data validation to ensure the accuracy of
the data between the warehouse and source systems.
. Tested the different sources such as Flat files, Main Frame Legacy
Flat Files, SQL server 2005 and Oracle to load into the Teradata data
warehouse.
. Mapped the data between Source and Targets
. Tested Data movement and Data validation from various source's to Data
Warehouse Tables in Abnatio.
. Performed UAT testing.
. Tested the different sources such as Flat files, Main Frame Legacy
Flat Files, SQL server 2005 and Oracle to load into the Teradata data
warehouse.
. Tested Data Movement Data warehouse to Data Mart with Reference
Business Rules.
. Extensively used Excel advanced functions.
. Performed the database testing by writing the SQL queries to validate
the data.
. Experience in using Passport an application for CCB.
Environment::
SQL Server 2005,Oracle9i, Teradata 12.0, Quality Center, SAS 9.1, Ms
Office, HTML, Erwin,
Windows XP, Unix, Putty, Business Objects, Abnatio, Passport
(Application for CCB).
MEDICA
Minneapolis, MN
Mar 07 to Dec 09
Data Modeler/ Data Analyst
The present project is a Medical Insurance project is called UP MIGRATION.
The Project is to build a Centralize data warehouse. The data is consisting
of data about old customers as well as new customers from three different
sources (PRIME, ACIS AND COSMOS). The old customer's data were to be
extracted from the existing database. In addition, new customers were added
by promotional schemes which were being offered as part of the company's
policy to expand business.
Role
. Participated in JAD session with business users and sponsors to
understand and document the business requirements in alignment to the
financial goals of the company.
. Created the conceptual model for the data warehouse with emphasis on
insurance (life and health), mutual funds and annuity using
EMBARCADERO ER Studio data modeling tool.
. Reviewed the conceptual EDW (Enterprise Data Warehouse) data model
with business users, App Dev and Information architects to make sure
all the requirements are fully covered.
. Analyzed existing logical data model (LDM) and made appropriate
changes to make it compatible with business requirements.
. Expanded Physical Data Model (PDM) for the OLTP application using
ERwin.
. Designed and built relational databases.
. Maintained and updated the database by deleting and removing old data.
. Mapped the data between Source and Targets.
. Part of team conducting logical data analysis and data modeling JAD
sessions, communicated data-related standards.
. Coordinate with Business Leaders and Project Managers to assure the
solutions are complying with business strategies and are according to
the IT strategic plan.
. Part of the team responsible for the analysis, design and
implementation of the business solution.
. Extensively used both Star Schema and Snow flake schema methodologies
in building
and designing the logical data model in both Type1 and Type2
Dimensional Models.
. Prepared business case for the data mart and then developed and
deployed it.
. Used Erwin to transform data requirements into data models.
. Used forward engineering for creating databases for OLAP Metadata
Catalog tables.
. Used Star Schema and Snow flake schema methodologies in building and
designing the logical data model in the dimensional Models.
. Performed Reverse Engineering of the current application using ERWin,
and developed Logical and Physical data models for Central Model
consolidation.
. Redefined many attributes and relationships in the reverse engineered
model and cleansed unwanted tables/columns as part of Data Analysis
responsibilities.
. Defined and processed the facts, dimensions.
. Creating databases for OLAP Metadata Catalog tables.
. Worked with various data bases and schemas.
. Good experience in data analysis querying and writing in SQL and TOAD.
. Very good in understanding the relationships and the data types.
. Worked with ETL to create source to target mappings (S2T)
. Worked with data inspection tools.
. Developed Reports in OBIEE.
. Involved in Supporting Data Modeling of an Enterprise Siebel
Analytics(BI) Data Model
. Involved in the critical design review of the finalized database
model.
Environment:: Oracle9I/10g, SQL Server, AQT and Toad, IRAAD, Informatica
7.1 & 8.1.1
Siebel Analytics, OBIEE, MS Office, SQL Server, HTML, Erwin, Ultra Edit,
Windows XP, UNIX, Putty, Telnet.
Wells Fargo,
Jul 06 to Feb 07
Des Moines, IA
Data Modeler/Data Analyst / Teradata Specialist
The objective of this project is to build a central repository DATA
WAREHOUSE from historic data from various different sources or systems.
The warehouse that could support Wells Fargo do business tomorrow and for
the various reporting and information needs. Data was spread out in
multiple and diverse sources in databases located in different systems (
CCG,.WFF & WFHM). The requirement demanded an integrated, unified data
pool that was truly subject-oriented, time-variant and nonvolatile.
Dimensional modeling using the star schema architecture was implemented to
achieve the task
Role:
. Gathered and Translated business requirements into detailed, technical
specifications, new features, and enhancements to existing technical
business functionality
. Part of the team responsible for the analysis, design and
implementation of the business solution.
. Involved in gathering user requirements along with Business Analyst.
. Mapped the data between Source and Targets
. Used MSVISIO for Creating of Process flow diagrams.
. As a part of Data Analysis Redefined many attributes and
relationships in the reverse engineered model and cleansing of tables
and columns
. Preparing the Gap Analysis
. Understood existing data model and documented which is affecting the
performance of the system
. Extensively participated in JAD Sessions, communicated data-related
standards.
. Worked with Sybase Power Designer tool for relational database
designs
. Designed and developed many Tables and Stored Procedures on Sybase
. Involved in logical and physical designs and transforms logical models
into physical implementations.
. Created data model for the star schema using ERwin, created DDL
scripts for static dimensions and ETL Mappings using DataStages.
. Hands on experience in different types of Mortgages.
. worked with BTEQ utility for update and manipulation of data.
. worked with MLOAD utility for Data updates.
. Loaded data into Teradata using ETL DataStage, FastLoad, BTEQ,
FastExport,
MultiLoad, and Korn shell scripts.
. Experience in Data Extraction and Conversion.
. Hands on experience in designing database in teradata
. Analyzed business requirements, transformed data, and mapped source
data using the Teradata Financial Services Logical Data Model tool,
from the source system to the Teradata Physical Data Model
. Involved in validating and Business Rule Translation.
. Involved in leveraging the SQL and Unix utilities to perform ad hoc
analysis.
. Involved in summarizing the complex technical information via
graphics and analysis
. Involved in Supporting Data Modeling of an Enterprise Siebel
Analytics(BI) Data Model.
. Worked with various tools for data inspection.
. Mapped the Elements for Call Center Module.
. Mapped the service Level reporting Elements.(to switch between Talk
time and Queue time).
. Mapped the Elements for interactive voice response(IVR, VRU) such as
average AHT,
average DELAY, CALLS HANDELD for service level reporting.
. Developed Reports in Siebel Analytics.
. Initiated Use Case Analysis using UML, for use case deliverables and
their inter-relationships
. Worked with the implementation team from the design to the
implementation phase
. Utilized ERwin's reverse engineering and target database schema
conversion process.
. Involved in different team review meetings.
. Good experience in data analysis querying and writing in SQL and TOAD.
Environments: Erwin4.0, Sybase, Oracle9I/10g, Teradata, SQL Server, Power
play,
MS Visio, db2, DataStages, Siebel Analytics.
United Health Group,
Jun 05 to Jun 06
Plymouth, MN
Data Modeler /Data Analyst
The objective in this project was to build a data warehouse consisting of
data about old customers as well as new customers. The old customer's data
were to be extracted from the existing database. In addition, new customers
were added by promotional schemes which were being offered as part of the
company's policy to expand business. The new database helped in evaluating
critical business performance parameters.
Role
. Part of the team responsible for the analysis, design and
implementation of the business solution.
. Gathered and Translated business requirements into detailed,
production-level technical specifications, new features, and
enhancements to existing technical business functionality
. Involved in gathering user requirements along with Business Analyst.
. Extensively used both Star Schema and Snow flake schema methodologies
in building
and designing the logical data model in both Type1 and Type2
Dimensional Models.
. Part of team conducting logical data analysis and data modeling JAD
sessions, communicated data-related standards.
. Provided architecture/development for initial load programs to migrate
production databases from Oracle data marts to Teradata data
warehouse, as well as ETL framework to supply continuous updates to
the data warehouse.
. Creating mapping document between Source and Targets
. Did analysis in the data flow for source data and target data as per
business rules .
. Prepared business case for the data mart and then developed and
deployed it.
. Used Erwin to transform data requirements into data models.
. Used forward engineering for creating databases for OLAP Metadata
Catalog tables.
. Used Star Schema and Snow flake schema methodologies in building and
designing the logical data model in the dimensional Models.
. Write and enforce Oracle programming standards (SQL, PL/SQL, embedded
SQL).
. Performed Reverse Engineering of the current application using ERWin,
and developed Logical and Physical data models for Central Model
consolidation.
. Redefined many attributes and relationships in the reverse engineered
model and cleansed unwanted tables/columns as part of Data Analysis
responsibilities.
. Defined and processed the facts, dimensions.
. Creating databases for OLAP Metadata Catalog tables
. Created a corporate Metadata Repository.
. Developed Reports in Siebel Analytics.
. Involved in the critical design review of the finalized database
model.
. Worked extensively in data analysis by quarrying in SQL and PlSql
. Provisions were made for ad hoc querying and reporting using Crystal
Reports 9, T-SQL.
Environments: Linux, Erwin4.0, Embarcadero,Sybase, Oracle9I, Teradata,
Siebel Analytics, SAS.
Aegis Mortgage,
Jun 04- May 05
Houston, TX.
Data Modeler
The task of this project was to build a central repository of historic data
warehouse that could support the various reporting and information needs.
Data was spread out in multiple and diverse sources in databases located in
different regions. The requirement demanded an integrated, unified data
pool that was truly subject-oriented, time-variant and nonvolatile.
Dimensional modeling using the star schema architecture was implemented to
achieve the task.
Role
. Involved in gathering user requirements along with Business Analyst.
. Redefined many attributes and relationships in the reverse engineered
model and cleansed unwanted tables/columns as part of Data Analysis
responsibilities.
. Defined and processed the facts, dimensions.
. Used Star Schema and Snow flake schema methodologies in building and
designing the logical data model in the dimensional Models.
. Part of the team responsible for the analysis, design and
implementation of the business solution.
. Gathered and Translated business requirements into detailed,
production-level technical specifications, new features, and
enhancements to existing technical business functionality
. Prepared business case for the data mart and then developed and
deployed it.
. Part of team conducting logical data analysis and data modeling JAD
sessions, communicated data-related standards.
. Designing and Developing PL/SQL Procedures, functions, and packages to
create Summary tables.
. Used forward engineering for creating databases for OLAP Metadata
Catalog tables.
. Redefined many attributes and relationships in the reverse engineered
model and cleansed unwanted tables/columns as part of Data Analysis
responsibilities.
. Involved in Building Insurance Data warehouse
. Defined and processed the facts, dimensions.
. Provided architecture/development for initial load programs to migrate
. production databases from Oracle data marts to Teradata data
warehouse as well as ETL framework to supply continuous updates to
the data warehouse
. Involved in the critical design review of the finalized database
model.
. Created users, groups and repositories for Teradata. Granted access to
view, edit repository to these users based on their roles and
responsibilities.
. Responsible for maintaining security data in Teradata repository and
make it available
to users with different permissions.
. Used MSVISIO for Creating of Process flow diagrams.
. Prepared ER Diagrams with MSVISIO.
. Created ER MODELLING diagrams.
. Intigreated with XML.
. Created Organizational strectures with MSVISIO
. Provisions were made for ad hoc querying and reporting using Crystal
Reports 9, T-SQL.
Environments: Linux, Power Designer, ER Studio, MSVisio COGNOS Powerplay,
Sybase, Teradata COGNOS Impromptu, Crystal Reports 9.
First Horizon Pharmaceutical Corporation
Sep 03 to may 04
Alpharetta Georgia.
Data Modeler
First Horizon Pharmaceutical Corporation is a specialty pharmaceutical
company that markets and sells brand name prescription products. Data
warehouse and sales datamart was developed for analyzing their sales with
health partners. System involves multiple sources and platforms including
DB2, Oracle, and user feeds.
Role:
. Responsible for logical and physical data modeling, database design,
star schema, snow flake schema design, data analysis, documentation,
implementation and support.
. Involved in requirement gathering and database design and
implementation of star-schema, snowflake schema/dimensional data
warehouse using ERwin.
. Initiated Use Case Analysis using UML, which provided the framework
for potential use case deliverables and their inter-relationships.
. Involved in the study of the business logic and understanding the
physical system and the terms and condition for sales data mart.
. Striking a balance between scope of the project and user requirements
by ensuring that it covered minimum user requirements without making
it too complex to handle.
. Requirement gathering from the users. A series of meetings were
conducted with the business system users to gather the requirements
for reporting.
. Requirement analysis was done to determine how the proposed
enhancements would affect the current system.
. Design and developments of the changes and enhancements. The existing
submission and refining programs were enhanced to incorporate the new
calculations.
. Interacted with end users to identify key dimensions and measures that
were relevant quantitative.
. Involved in logical and physical designs and transforms logical models
into physical implementations.
. Utilized ERwin's reverse engineering and target database schema
conversion process.
Involved in different team review meetings.
Did unit testing and tuned for better performance.
Environment: Oracle, DB2, SQL Server, Teradata, Erwin, Crystal Reports,
Rational Rose, Rational Requisite Pro, Win NT/2000
WALMART,
May 02 to Aug 03
Bentonville, AR
Data Modeler
The task of this project was to create a Data mart/OLAP server for a
planning, projection and modeling system that was able to support various
planning and forecasting needs. This Planning and Modeling functionality
was provided through a proper implementation of Oracle Financial Analyzer.
Consolidation of data from various sources was done to make effective use
of the results that were generated through complex actuarial calculations
in the Planning and Projection process. Scenario Planning and Multi-
dimensional reporting was undertaken for the efficient processing of data
and value added decision support for the top management..
Role:
. Understood basic business analysts concepts for logical data
modeling, data flow processing and data base design.
. Responsible for logical and physical data modeling, database
design, star schema, snow flake schema design, data analysis,
documentation, implementation and support.
. Interface with users and business analysts to gather information
and requirements.
. Data modeling and design of databases using ER Studio, Oracle
Designer.
. Forward Engineering for creating tables using Oracle Designer 8i
. Converting the Teradata Server database into Oracle 8i database.
Written several SQL, PL/SQL programs for the same.
. Performance tuning of the database, which includes indexes, and
optimizing SQL statements, monitoring the server.
. Involved in managing the replication environment.
. Defined and processed the facts, dimensions.
. Involved in requirement gathering and database design and
implementation of star-schema, snowflake schema/dimensional data
warehouse using ER Studio.
. Created various types of reports including pie charts, Cross tab,
3D in Crystal Reports 8.
. Developed various Unix shell scripts to run batch jobs for loading
data
. Used XML for metadata exchange between various proprietary systems
. Created documentation and test cases, worked with users for new
module enhancements and testing.
. Did unit testing and tuned for better performance
Environment: Oracle Express 6.3.0.1.0, Oracle Financial Analyzer
6.3, Oracle 8i, Windows NT 3.5/4.0, Unix shell, ER Studio, Crystal
Reports 8, XML, SQL, PL-SQL, Teradata, Oracle Designer 8i
ICICI Bank, INDIA
Jun 00- Mar 02
Data Modeler
This project was for the Credit Card Division of a leading Bank. Customer-
centric data warehouse to analyze transactions across finance, marketing,
risk, collections, and consumer relations was developed. The project deal
with database management such as security, performance tuning, writing
queries, triggers. .
Role:
. Installed and configured SQL Server7.0 Servers and clients
. Designed and developed the databases
. Created a logical design and physical design of the data warehouse
using star schema
. Configured the DTS packages to run in periodic intervals.
. Extensively worked with DTS to load the data from source systems.
. Writing stored procedures and triggers extensively and working very
closely with developers, Business Analyst and end users to generate
various audit reports and troubleshoot their query problems and
connectivity problems.
. Created tables, views, triggers, stored procedures and indexes.
. Created integrity rules and defaults.
. Created ftp connections, database connections for the sources and
targets.
. Maintained security and data integrity of the database
Environment: SQL server 7.0, Windows NT
GM Indosoft (I) Ltd, Apr'98 - May 00
Hyderabad, India
Oracle Developer
This module of Financial Package facilitates to user create or open
accounts (along with their grouping) entering daily financial transactions
such as day books (cash book, Bank Book or Journal Book) and automatic
preparation of Financial Statements (like Profit and Loss Account and
Balance Sheet), giving financial reports which helps management in decision
making such as List of Sundry Debtors and List of Creditors outstanding (as
on some date), other financial reports for such as trial balance, Receipts
and Payments etc.
Responsibilities:
. Involved in the creation of database setup in Oracle
. Responsible for the design and development of the System.
. Involved in Coding and Testing of the System.
. Technical Documentation
. Generated the Reports in Dev-2000, as per the requirements of the
company.
Environment: Oracle 7.3, D2K, VB6,Crystal Reports, Unix and Windows NT
Contact this candidate