We provide IT Staff Augmentation Services!

Analyst/ssis - Informatica Etl/sql Server Developer Resume

4.00/5 (Submit Your Rating)

Jersey City Nj, UsA

CAREER SUMMARY:

  • Over 12 years of IT experience in Complete SDLC including Requirement Analysis, Design, Development, Testing and Implementation.
  • Strong Expertise in SQL Server 2005/2008 components such as SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).
  • Experience in creating databases, stored procedures, user defined functions, Cursors, views, triggers, derived tables, common table expressions (CTEs) and indexes to facilitate efficient data manipulation and data consistency.
  • Strong ETL experience of using Informatica 9.6 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager.
  • Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
  • Modified and redesigned existing database by adding tables and relationships to support online system in the development database.
  • Experience in extracting, transforming and loading (ETL) data from various sources using SSIS, SQL Server Import / Export wizard, Bulk Insert Task and Bulk Copy Program (BCP).
  • Experience in attaching Data files and Transaction log Files to the databases.
  • Experience in taking Backups and restoring Databases.
  • Strong Experience in creating Parameterized Reports using SSRS 2005/2008.
  • Experience in automating the system by creating Jobs and Maintenance plans.
  • Designed data model. Written mapping documents.
  • Optimizing SQL queries. Written technical/functional specifications.
  • Created checks and constraints to maintain data integrity.
  • Expertise in Oracle database, PL/SQL, SQL*plus, procedures.
  • Worked with one of the largest data warehousing projects in Europe.
  • Team player with excellent communication and problem solving skills.
  • Has good exposure to domains such as finance, health care and hospitality.
  • Effective interpersonal, conflict resolution skills. Team oriented, technically motivated and creative.
  • Worked closely in association with .NET application development team.
  • Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

SKILL:

Databases: Oracle 8i/9i, MS SQL Server 2005/2008/2008 R2, MS Access, MySQL

T: SQL, BCP, SQL Agent, SSIS, SSRS, SSAS, MS Visio 2003, SQL*plus, Oracle Forms, Oracle Reports, Business Objects, MS Office 2007, HP Quality Center 10.0, Informatica Power Center 9.6.1.

Operating Systems: Windows XP, Windows Server 2003, Windows NT, Windows 98

Web technologies: HTML, JavaScript, CSS, DHTML, IIS, PHP

Version Management Tools: Team Foundation Server, Visual Source Safe

Business Intelligence: Confidential s PerformancePoint Server 2007 (PPS)

EXPERTISE AREA:

  • User interactions, requirement gathering and analysis
  • Created, Implemented and maintained coding standards for SQL server/SSIS.
  • Involved in Code reviews.
  • Sharing the knowledge and skills with the members.
  • Creating daily team schedules to ensure appropriate coverage of work activities.
  • Training and grooming of new resources
  • Designing data model
  • Wrote Oracle PL/SQL procedures and triggers
  • Production support in a live environment
  • Interacted with various team members to ensure requirement clarifications and issue resolution
  • Data analysis

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ, USA

Analyst/SSIS - Informatica ETL/SQL Server developer

Responsibilities:

  • Involved in Quarter/Monthly closing activities.
  • Successfully implemented Integration of Confidential ’s using Informatica.
  • Developed, deployed, and monitored SSIS Packages.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Communicated with business customers to discuss the issues and requirements.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
  • Identified problems in existing production data and developed one time scripts to correct them.

Environment: Informatica 9.6.1, SQL Server 2005/2008, SSIS 2005/2008, TFS

Confidential, Jersey City, NJ

Analyst/SQL Server/SSIS/SSRS Lead

Responsibilities:

  • Coordinating change management and release management.
  • Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
  • Experience in importing/exporting data between different sources like Oracle/Excel/Flat files etc. using SSIS utility.
  • Developed, deployed, and monitored SSIS Packages.
  • Experience in creating configuration files to deploy the SSIS packages across all environments.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • The SSIS Packages include, a Master Package which executes a number of Child Packages.
  • Created parameterized reports, Drill down and Drill through reports using SSRS.
  • Optimized query performance by creating indexes.
  • Maintained the database schema in source code control.

Environment: SQL Server 2005/2008, SSIS 2005/2008, TFS,

Confidential, Dover, NH

SQL Server/ETL

Responsibilities:

  • Actively participated in gathering requirements along with DBA and technical manager.
  • Coordinating with offshore - onsite team.
  • Sharing the knowledge and skills with the members.
  • Created templates for SSIS. This includes Configuration, Audit and SSIS Logging to enable team members to take the same as base for their further developments.
  • Created complex SSIS packages using control and data flow elements.
  • Wrote queries to check the validations.
  • Created SSIS packages and included different kind of transformations like conditional split, data conversion, derived column, sort, lookup and multicast.
  • Handled slowly changing dimensions to maintain the history of the data.
  • Created Deployment scripts for deployment of Source code on server using batch files.
  • Transferring data between XML file and SQL server.
  • Fine tune queries.
  • Involved in code reviews.
  • Used TFS for version control and for source code check-in.
  • Scheduled job using SQL Agent.

Environment: Java, MS SQL Server 2008, SSIS, T-SQL, .NET, Share Point, TFS

Confidential, Fort Worth, TX

Team Lead/SQL Database/ETL Developer

Responsibilities:

  • Lead the NTSP team. Shared the knowledge with team members.
  • Created Mapping documents between different data sources to EDW.
  • Coordinating with offshore - onsite team.
  • Created standard templates for SSIS. This includes Configuration, Audit and SSIS Logging to enable team members to take the same as base for their further developments.
  • Created complex SSIS packages using proper control and data flow elements.
  • Created, Implemented and maintained coding standards for SSIS/SQL server.
  • Created SSIS packages and included different kind of transformations like data conversion, derived column and sort.
  • Used Lookup Transformation to get the data from reference data sets (SSIS)
  • Handled slowly changing dimensions to maintain the history of the data.
  • Created Deployment scripts for deployment of Source code on server.
  • Developed various codes including SSIS Audit/Logging, Batch wise processing (based on Patients) of Facts, MDfs/Delta processing, Parallel processing etc...
  • Transferring data between XML document and SQL server.
  • Configured alerts, operators and jobs.
  • Fine tuning stored procedures and queries.
  • Involved in code reviews.
  • Used TFS for version control and for source code check-in.

Environment: Confidential SQL Server 2005/2008 R2, T-SQL, SSIS, Confidential Access, Windows Server 2003

Confidential, Seattle, WA

SQL Database Developer/ETL Developer

Responsibilities:

  • Created databases, stored procedures.
  • Created dimensions and hierarchies using PerformancePoint Server 2007.
  • Wrote queries to check the validations.
  • Created SSIS packages and included different kind of transformations like conditional split, data conversion, derived column, sort, lookup and multicast.
  • Wrote technical and functional documentation for SSIS packages.
  • Created excel pivots for the data validations.
  • Created test cases for new development and involved in regression testing.
  • Created database backups using LiteSpeed.
  • Created deployment guides.
  • Scheduled job using SQL Agent.
  • Created reports using report designer and setting up connection information & define query.
  • Used TFS for version control and for source code check-in.

Environment: Confidential SQL Server 2005/2008, T-SQL, Confidential PerformancePoint Server, SSIS, SSRS, ASP.net, Confidential Access, Windows Server 2003

Confidential, Madison, WI

Data Architect/SSIS

Responsibilities:

  • Designed data model.
  • Developed the E-R diagrams.
  • Developed data dictionaries as part of data modeling.
  • Created new tables, constraints and views.
  • Created staging to landing and landing to target mapping document.
  • Developed necessary SQL scripts to generate test data.
  • Developed SQL scripts (using SQL queries) for validating data between staging, landing and target.
  • Optimizing SQL queries.
  • Partly involved in performance tuning.
  • Created test cases.
  • Performed unit and integration testing.

Environment: Confidential SQL Server 2005, T-SQL, SSIS ETL, DB2, Confidential Visio 2003, Confidential Share Point Server

Confidential

SQL Server expert in CIT

Responsibilities:

  • Responsible for preparing scripts using SQL procedures and functions to generate data.
  • Involved in initial effort estimation of ERS 2007A.
  • Reviewed test specifications to ensure coverage of requirements.
  • Interacted with various teams (these are development, deployment, FQT and On-site).
  • Involved in training new personnel.
  • Scheduled job using SQL Agent.
  • Involved in preparing test cases.

Environment: Oracle 9i, SQL Server, T-SQL, UNIX, OWB ETL, Java, XML, Business Objects

Confidential

SQL Server expert

Responsibilities:

  • Generated scripts for creating data for performance testing using SQL queries and procedures.
  • Generated stats pack to gather system wide statistics for performance testing and tuning.
  • Interacted with various teams (these are development, deployment, FQT and On-site).
  • Involved in preparing test cases.
  • Reviewed test specifications to ensure coverage of requirements.
  • Involved in functional & integration testing to meet software requirements.

Environment: Oracle 9i, SQL Server, UNIX, OWB ETL, Java, XML, Business Objects

We'd love your feedback!