We provide IT Staff Augmentation Services!

Database Developer/analyst Resume

West Des Moines, IA

PROFESSIONAL SUMMARY:

  • Around 7 years of experience in Analysis, Design, Development, Implementation and Migrating of Business Applications using teh SQL Server and Oracle relational databases management system on various platforms.
  • Experience with multi file systems and larger dataset (processing 5 TB every day)
  • Strong expertise in analyzing and bug fixing
  • Exceptional Problem solving skills
  • Experience in ETL development on different environment
  • Worked with Data Modeling both Physical & Logical using SQL Data modular
  • Proven ability to plan, coordinate and implement Full Life Cycle of software development and maintenance projects.
  • Strong expertise in Transact SQL, Oracle PL/SQL, SQL*PLUS, Pro*C, back - end programming like Packages, Functions, Stored Procedures, Database Triggers
  • Experience in creation of ETL Mappings and Transformations SSIS to move data from multiple sources into target area.
  • Proficient in Performance Tuning and maintain Large Volume of Data includes Oracle database/SQL Server and Data Mart.
  • Created complex and simple ETL transformation using Informatica, Powercenter. Tuned teh sessions and transformations in production.
  • Strong in Database Design, Creation, Migration, Upgrading, Performance Tuning, Logical and Physical Design, Database Tuning, Backup and Recovery Activities, Installation and Upgrade of Database.
  • Experience in migrating teh data from Legacy system to SQL Server / Oracle Database and also involved in teh upgrades.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/ 8i, MS-SQL Server 2005/2000/2008, MS Access, Teradata, MySql

Oracle ERP: Retail Merchandising Systems (RMS), Retail Data warehouse Management (RDM)

Customized Tools: Momentis Vendor Management in SQL Server, Allocation (JDA Arthur) in Oracle PL/SQL

Languages: PL/SQL, SQL,, UNIX (K/B/C), Java, XML, SSIS/DTS PackagesDataModeling: SQL Data Modular

Data Warehousing: Ab Initio, ETL/Informatica 7/7.1, AWM, ADDM.

Tools: Erwin 4.0, Developer 2000/6i/9i, Forms 6i, Reports 6i, TOAD, SQL*Plus, SQL*Loader, Explain Plan, Import/Export,, MS OFFICE

Reporting Tools: Business Objects XI/5(BOXI)

OperatingSystem: Sun Solaris, Windows 9x/2000/NT

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines IA

Database Developer/Analyst

Responsibilities:

  • Created teh complex SSIS Package in Bisiness Intelengence Development Studio(BIDS)
  • Extract Transformed and loading(ETL) to teh newly built loading table
  • Scrubbed teh attributes from various source system and mapped with destination
  • Created teh database tables to load teh data from different sources and updated based on business rules
  • Pulled teh data from various source like SQL server, Oracle and Teradata
  • Created teh required attributes based on teh Micro strategy team since teh reporting has to be shifted from SAS to Micro Strategy
  • Identifying teh sources attributes required by reporting team and mapped as per business requirements.
  • Worked in Unit testing for teh SSIS package before deploying to testing team
  • Gatheird requirements consulting with Micro Strategy team and update accordingly
  • Worked on Teradata to capture teh records and executed teh result to determine for new platform.
  • Used Oracle as a source for capturing teh records and mapped with destination newly built server
  • Scrubbed teh attributes and set teh status to track teh Mortgage records
  • Updated Mortgage data, loan data, sales data from various source as SQL, Teradata and Oracle
  • Participated in code reviews, Team Meeting and in corporate teh comments for development
  • Followed teh SSIS process flow designed by system analyst to get teh scope of teh project
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh SSAS cubes.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Environment: SQL Server Management Studio 2008, Microsoft visual studio 2010, Business Intelegence Development Studio 2010, Teradata Client/ SQL Assistance 14.1, TOAD, Microsoft office 2010, windows server 2008, Windows 2000/XP/NT.

Confidential

SQL Developer/ Programmer

Responsibilities:

  • Very Strong hands-on experience with PL SQL debugging
  • Worked as SQL programmer with hands on experience in writing complex stored procedures and packages.
  • Worked on existing framework procedures and packages with new business logics.
  • Commented on complex and huge package of approximately 7800 lines as per teh business requirement
  • Analyzed teh business requirement and gave feedback to teh team.
  • Involved in code testing and peer evaluation.
  • Worked with QA team for knowledge transfer of development for testing.
  • Analyzed teh systems, business units in order to define teh requirements, while working with Business Analysts.
  • Developed and supported multiple applications on oracle and SQL
  • Worked with data modeling (Facts and Dimensions table) and Entity Relationship
  • Created database objects like tables, views and writing joins and sub queries
  • Bug fixing
  • Participated in code peer reviews and ensure teh code written complies with teh company standards
  • Participated in meetings and discussions with functional/ technical leads to understand teh requirements and work out teh design
  • Worked with test team to resolve back end related issues
  • Worked in agile/Iterative development and MMIS environment

Environment: SQL Server Management Studio 2008, Oracle 11g, TOAD, SQL*PlusScripts, Sun Solaris 9/8, Windows 2000/NT., Microsoft office 2010

Confidential, South San Francisco, CA

SQL Server Developer/Data Analyst

Responsibilities:

  • Very Strong hands-on experience with SQL (Sql Server and Oracle)
  • Worked through teh existing data analyze to find gaps and leaks and document teh end to end flow.
  • Worked with heterogeneous database, excel files and flat files
  • Developed Business Objects reports and excel reports
  • Strong knowledge of Master Data Management(MDM) system
  • Analyzed thousands of SQL complex queries and explain to end to end flow
  • Report teh findings to teh team
  • Updates teh database hubs, create extracts, back up log files and DB tables
  • Worked with DataFlux jobs and analyzed for end to end flow.
  • Analyzed Merge and split of teh records from source systems
  • Worked for standardization of attributes in teh database
  • Worked with clients to identify business objectives and to define workflow and business process changes
  • Gatheird information and developed mapping based on teh requirements.
  • Strong expertise with communicating and working with Business System Analysts and Business Users
  • Strong analytical and problem-solving skills
  • Created complex SSIS package to capture teh records from various sources
  • Extracted teh source system files from various source and mapped with destination using SSIS
  • Worked through process flow to get teh scope of SSIS project
  • Expert in creating Star schema cubes using SSAS.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh SSAS cubes.

Environment: SQL server Management studio 2008, DF power studio version 8.2, df power architect 8.2, windows 2007, Microsoft visual studio 2008(SSIS)

Confidential, San Francisco, CA

SQL Developer/Data Analyst

Responsibilities:

  • Extensive work experience with SQL Server as a part of database development team
  • Worked closely with Business Analyst for bug fixing and reporting on Business Objects and Excel
  • Developed and coded multiple SSIS dataflow for CRM (Customer Relationship model), Vendor Management and Purchase Order models
  • Worked with SSIS tasks, data flow objects, in SSIS
  • Created stored triggers, procedures and functions as required in Oracle Pl/Sql and T-Sql
  • Worked with heterogeneous database, excel files and flat files on SSIS
  • Owned multiple SSIS packages and gave support to teh same
  • Working Knowledge on Microsoft Visual Studio.
  • Worked on both Unix and Windows operating system
  • Worked with secure FTP for transferring teh files
  • Was primary point of contact for major models
  • Worked on scheduling teh packages on windows(Windows scheduler) and unix (crontab)
  • Gave multiple bug fixes for existing packages based on teh user requirement
  • Worked with tuning of SSIS packages for better performance
  • Worked with VB script and T-sql packages within SSIS
  • Developed Business Objects reports and excel reports
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

Environment: Oracle 10g/9i/8, PL/SQL, ETL, SQl Server 2005/2000, TOAD, SQL*Plus, Shell Scripts, Windows 2000/NT, Business Objects XI, Microsoft Visual Studio 2008.

Confidential, San Jose, CA

SQL Developer/Data Analyst

Responsibilities:

  • Extensive work experience with Ab Initio GDE as a part of UBI team (User Behavior Intelligent)
  • Developed multi partition/parallel graphs based on business requirements to process around 5TB of daily data
  • Worked with map tuning and gave support and maintained teh production maps.
  • Worked with transformations like aggregator, update strategy, connected and unconnected lookups, filter and routers based on teh requirements.
  • Designed and developed Ab Initio graphs for analytical/investigation purposes
  • Worked with high volume data set
  • Used FTP and secure FTP in shell scripts to transfer multi files to different servers
  • Extensively Worked with Microsoft Visual Studio 2008.
  • Worked with data modeling (Facts and Dimensions table)
  • Oracle and Teradata databases used as source for GDE along with multi files
  • Gatheird information and developed mapping based on teh requirements.
  • Worked with multiple components like scan, scan with rollup, gather, sort, filter by expression etc in GDE
  • Used Ab Initio programming language to process large amounts of data in GDE
  • Developed perl scripts to generate files to be used by Ab Initio GDE
  • Worked with clients to identify business objectives and to define workflow and business process changes
  • Provide on-going development and production support for data pull, utilizing Ab Initio and SQL
  • Wrote and updated technical documentation
  • Prepared and executed unit and integration test plans
  • Supported and maintained existing graphs

Environment: Microsoft Visual Studio 2008, Ab Initio GDE, Teradata client SQL Assistant, Oracle 10g, ETL, MySql, SQL*Plus,, Sun Solaris 9/8, AIX, Windows 2000/NT, perl

Confidential, San Francisco, CA

System Analyst and SQL Developer

Responsibilities:

  • Developed and Supported multiple applications SQL Server
  • Migrated Sales Audit application from Oracle 9i to 10g with improved performance
  • Migrated Purchase Order and Vendor Management related applications from Sql Server
  • Developed and Upgraded DTS packages to SSIS from SQL Server
  • Experience in guiding and developing various business processes(ETL) on these applications
  • Strong expertise with communicating and working with Business System Analysts and Business Users
  • Strong analytical and problem-solving skills
  • Prepared technical Specifications and Unit Test Plans
  • Responsible for integration of Oracle Retail products with Legacy systems
  • Excellent knowledge of Oracle queries and Pl/Sql coding
  • Wrote PL/SQL procedures, packages and triggers as required
  • Participated in Conference Room Pilots (CRP’s)
  • Excellent knowledge of Transact SQL and developing Procedures, Triggers using transact SQL
  • Developed and Migrated DTS Packages using VB script, Batch scripts, Linked servers and Transact SQL
  • Maintained teh users, address groups and classifications of DTS/SSIS packages
  • Strong knowledge and understanding of structured analysis and technical design techniques
  • Strong working knowledge in inventory control, Merchandising, Sales audit, Purchasing, Shipping and Order Management
  • Expertise in working PCI compliance systems
  • Designed and Developed Real time data ETL from sql server to oracle using e*gate util (Eways) (with XML Publication and Java )
  • Build small data warehouse to populate data from transaction tables, Optimized for reporting
  • Scheduling jobs windows scheduler
  • Performed software Unit Testing and wrote Test cases as required
  • Excel programming (VB Script) to access data and validating data
  • Documenting and writing design document after collecting teh requirement from Business users
  • Developing ETL Process for a large database from Oracle to SQL Server and vice versa
  • Analyzed teh systems, business units in order to define teh requirements, while working with Business Analysts.
  • Debugging, bug fixing and to provide teh patch to end user for teh problem fix.
  • Preparation of technical specifications for teh development of Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
  • Developed stored procedures and triggers for teh back end interfaces using PL/SQL.
  • Performance tuning of teh database and its objects.
  • Perform exports/imports of teh database and creating views and Materialized views
  • Creating and Managing primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms.
  • Involved in Logical & Physical Database Layout Design.
  • Provided user and production support.
  • Worked in EAM( Enterprise Assets Management) v 10

Environment:, SQL Server 2005/2000/7Oracle 11g/10g/9i/8, PL/SQL, ETL, Sql Server 2005/2000/7, TOAD, SQL*Plus, Shell Scripts, Sun Solaris 9/8, AIX, Windows 2000/NT, Momentis, Sales Audit, Forms 6i, Business Objects XI/5, Microstatergy

Confidential, Mountain View, CA

Database Developer

Responsibilities:

  • Analyzed teh systems, business units in order to define teh requirements, while working with Business Analysts.
  • Developed Mappings using various transformations like connected/unconnected Lookups, Filters, Aggregators, Update strategy, Routers, Joiners depending upon requirement in teh Informatica Designer
  • Wrote PL/SQL procedures, packages, triggers and Oracle Forms as required.
  • Preparation of technical specifications for teh development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
  • Developed stored procedures and triggers for teh back end interfaces using PL/SQL.
  • Good knowledge of Pricing, Inventory and Purchase Order process
  • Performance tuning of teh database and its objects.
  • Perform exports/imports of teh database
  • Performed Unit Testing and wrote test cases as required.
  • Wrote user documents on ETL scripts
  • Experience in developing HTML Pages
  • Creating and Managing primary data base objects such as Tables, Views, Indexes, Sequences, Synonyms.
  • Involved in Logical & Physical Database Layout Design.
  • Configured tnsnames.ora and listener.ora for multiple Oracle Homes for windows as well as unix.
  • Extensively worked in Workflow Manager and in teh performance tuning of teh ETL programs and processes.
  • Wrote Korn Shell and Bourne Shell Scripts for retrieving data from Oracle Database.
  • Worked on some of teh DBA support tasks and used metalink to solve problems.
  • Helped design DDL scripts for data loading using DBlink and created DBlink for teh same.
  • Created scripts for tablespaces, users, and roles for application and owned them.

Environment: Oracle 9i, PL/SQL, Informatica Powercenter 7.1, ETL, TOAD, SQL*Plus, Perl/Shell Scripts, Sun Solaris 9/8, HP-UX, Windows 2000/NT.

Hire Now