Analyst/ssis - Informatica Etl/sql Server Developer Resume
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