Data Architect with SSIS and SQL server 2014 experience
Last active: 6 months ago
9+ years of experience in analysis, design, development, implementation and production support in areas of Database, ETL, and analytics using ER Studio, SAS, OLAP and Report Development.
Extensive knowledge of relational and dimensional data model, star schema and Snow Flake schema and Kimball Methodologies.
Expertise in developing Conceptual, Logical and physical data models and maintaining it with version control
Proficient in translating user requirements to physical data model, generate data definition language using ER Studio CASE tool.
Experience designing Geographical Information System database tables to be compatible with map layers using SDO and SDE
In depth knowledge of Dimension tables, Fact and summary tables, slowly Changing Dimensions, Conformed Dimensions, and Metadata Management (MDM).
Has extensive experience with Data warehousing, Data architecture, Data Modeling, Data Analysis, Data Mapping & and Data Staging efforts
Experienced developing multi star schema with secondary dimension tables.
In depth knowledge of database concepts Entity relationships, Database constraints, data types.
Expertise in designing and developing Enterprise Information and Content Architecture Models.
Experienced in collaborating with application teams and database administrators and design the optimal solution to fit the requirements
Experienced in database performance tuning by using query optimization techniques, identifying need of indices and implementing them.
A team player as well as experienced in working independently.
Quick learner with ability to rapidly achieve organizational integration, assimilate job requirements, employ new ideas, concepts, methods.
Expertise in preparation of checklists, performance and scalability evaluation, stability and best practices procedures.
Ability to work under tight schedules and achieved great results with commitment and quality.
Excellent leadership, facilitation, interpersonal and communication skills.
Expertise in managing team and resolving conflicts.
Strong customer focus with ability to nurture customer relationship at all levels.
Good problem solving skills, ability to learn quickly and adapt easily to new systems.
Data Modeling Tools : ER Studio, Toad Data Modeler, MS Visio
Databases : Oracle 10g, 11g, DB2, MS SQL Server 2005, 2008, MS Access, IBM oz/60, DB2/UDB, SYBASE, SQL Server Ver 8 R2,RDBMSs
Spatial Tools : ArcGIS, Oracle SDO
Mainframe Display Tools : Rumba, BlueZone mainframe
Data Analytics Tools : IBM TM1, SPSS, SAS Forecast Studio, Enterprise Miner
ETL Tools : Informatica Power Center, IBM DataStage, SSIS
Data analysis tools : Toad for Data Analysts 2.6, Toad 10.5, SQL Plus editor, MS Excel, MS Word, IBM Cognos.
Reporting Tools : Crystal Reports 8, SAP Business Objects, SSRS
BS in Computer Science
Work Experience # 1: CSX Technology, Jacksonville, Florida (Aug 10 – Till Date)
Role: Data Architect/SSIS,PL/SQL Developer
Incrementally develop conceptual, logical and physical data models for new database objects using ER/Studio CASE tool
Maintain existing database objects, from software engineer provided requirements or data definition language (DDL) using ER/Studio Computer Aided Software Engineering (CASE) tool
Lead database design sessions and capture data requirements for software engineering or re-engineering projects
Collaborate with database administrators on storage requirements, performance strategy; primary and foreign key constraints, placement of tables within table spaces, indexing strategy, and DDL implementation.
Ensure the integrity of all CSX production databases through a structured change control process
Advocate for Data Management principles and capabilities within the organization
Design, develop and deploy SSIS packages for MOAC application which is the backbone of CSX financial operations
Perform COBOL mainframe program impact analysis for re-engineering legacy systems like LMS, XL1, WMS
Write DRDA queries for a seamless transition from legacy systems to modern database platforms as part of a transition state
Environment: ER Studio Data Architect, Oracle 11g, DB2, SQL Server, MS Visio, Toad MS Office, UNIX, Oracle SQL, DB2 SQL, ArcGIS
Work Experience # 2: Citigroup, Jacksonville, Florida. (May 10 – August 10)
Role: Senior ETL Developer
Involved in business requirements mapping to the data model.
Built data mining data models for the credit monitoring alert systems using IBM TM1 and SPSS.
Involved in IBM Data Stage data mappings.