We provide IT Staff Augmentation Services!

Sql Server Developer Resume

Richardson, TX

PROFESSIONAL SUMMARY:

  • 9+ years of IT experience in all phases of Data warehouse life cycle involving Analysis, Design, Development, Coding, Testing and Production Support of Business Intelligence Projects.
  • Strong knowledge in data warehouse concepts and data modeling .
  • Have extensive knowledge in BI Technologies like Informatica Power Center, MS SQL Server (SSIS), Teradata and Oracle.
  • Extensive experience with T - SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity .
  • Hands on experience on various SQL Server Service s like Integration Services ( SSIS ), Analysis Services ( SSAS ), and Reporting Services ( SSRS ).
  • Expertise in Enterprise Data Warehouse, Data Integration, Data Marts and Data Migration projects.
  • Familiarity with entity-relationship/multidimensional modeling (star schema, snowflake schema).
  • Experience in development and design of RDBMS -OLTP, dimensional modeling using data modeling tool ERWIN, MS Visio .
  • Have domain knowledge in Health care, Insurance, Telecom, Wireless, Manufacturing, Retail, Financial, Sales and Marketing .
  • Experience in integration of data source like Teradata, Oracle, Flat Files, Sales Force and XML
  • Developed ETL Strategies using an ideal mix of Database based Loading Strategies and Informatica.
  • Experienced in Data governance of data profiling, linage, completeness, Cleansing, Standards, accuracy, quality and validation of data .
  • Experience with ABC data model for data control.
  • Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
  • Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
  • Involved in the full development lifecycle ( SDLC ) from requirements gathering through development and support using Informatica Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Developed Complex mappings from varied transformation logics like Unconnected/Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy, SQL, TC,XML and many more.
  • Proficient in performance tuning on informatica components as well as on database end.
  • Worked on Slowly Changing Dimensions (SCD) Type 1, 2, 3 to keep track of historical data.
  • Good in writing Unix Shell Scripts.
  • Worked on Water fall model / Agile Scrum methodologies in all projects.
  • Experienced in creating jobs for data load using scheduling and tools Control-M and Redwood Cronacle
  • Created high level and low level design documents and provide solutions for the requirements.
  • Involved in code reviews, architectural reviews and peer reviews of project and maintained documentation as per client standards.
  • Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
  • Strong Team working spirit and relationship management skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, SSIS, DTS

Data Modeling: Erwin 4.0/3.x, MS Visio ( OLAP / OLTP)

Databases: Oracle 12c/11g/10g/9i/8i/7.x, Teradata v2r5/v2r6/12/13/14, MS SQL Server 2012/2010

Business Intelligence: Cognos 7/8/10, Cognos Report Net 1.1, Business Objects 5.0, SSRS

Languages: SQL, PL/SQL, C, C++,C#,T-SQL, VB.Net

Load Utilities: MLoad, Fast Export, BTEQ, Fast load, SQL Loader

Tools: Toad 9.1, QC, Control-M, Cronacle, SQL Developer, Visual Studio

Version Control: SVN, Tortoise CVS, DELL Share Point

Operating System: Windows 2000/2003/XP/7/8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

SQL Server Developer

Responsibilities:

  • Coordinate with Business Analysts and Data Stewardship team to understand business requirements.
  • Involved in Project planning, DEV Effort estimation.
  • ETL, data profiling, data quality and clean ups for SSIS packages.
  • Developed C# scripting for packages
  • Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
  • Created SSIS packages to populate data from various data sources.
  • Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
  • Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries .
  • Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS .
  • Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
  • Involved with Data Stewardship Team for designing, documenting and configuring Informatica Data Quality environment for management of data.
  • Writing, updating and supporting reports using TSQL.
  • Incorporated Reusable objects for data validation to ensure data quality.
  • Incorporated ABC data model for controlling data flow in EDW.
  • Conducted data import and export operations using the DTS wizard.
  • Automated D ata warehouse and DataMart refreshes using Maestro .
  • Responsible for resolving recurring incidents permanently, performing break fixes .
  • Defect Analysis and Defect Prevention Activities.
  • Worked on SQL Server optimization including indexing and query optimization.
  • Responsible for ON Demand loads as per business user request.
  • Monitoring various loads like Daily, Weekly, halfrly, yearly Loads using Incremental Loading strategy.
  • Responsible for migrating the code between environments and Involved in UAT Testing.
  • Coordinate with all support teams like PST, Migration,QA, DBAs and Infa Admins during deployments.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements.

Environment: - MS SQL Server2012/2010, Team Foundation Server, Microsoft SharePoint Server(MOSS 2012), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2012, Windows XP, T-SQL, VB.Net

Confidential, Philadelphia, PA

SSIS Developer

Responsibilities:

  • Coordinate with Business Analysts to understand business requirements.
  • Involved in Project planning, Effort estimation.
  • Participated in Data model reviews and DA Forms .
  • Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.
  • Created SSIS packages to populate data from Flat Files, Excel Files
  • Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
  • Worked with Meta-Data Driven SSIS Packages to pull the data from Sources and load to Data mart.
  • Followed Agile Methodology in the project with Stories, weekly Sprints and Scrum calls.
  • Prepared SRS and TDS documents and publish the same for architectural review.
  • Tracking end to end development cycle from requirements gathering, high level design, detailed design, coding, testing, migration, deployment and production support.
  • Created parameter files in order to pull data from Oracle Source environment.
  • Responsible for creation of stored procedures to load hierarchies from Oracle environment.
  • Writing SQL Server stored procedures using TSQL
  • Incorporated ETL logic to process the input records only once in a day.
  • Incorporated Reusable objects for data validation to ensure data quality.
  • Implemented Slowly Changing Dimensions - Type2 for data loading.
  • Improved performance of the sessions by creating partitions .
  • Implemented full push down optimization while loading data to final base table.
  • Developed workflow tasks like Email, Event wait, Event Raise, Timer, Command and Decision.
  • Worked on Performance tuning in order improve load timings.
  • Worked on UNIX scripts to move files across different environments.
  • Responsible for loading data till package layer to help reporting folks.
  • Built Unit Test Cases while testing data in DEV environment.
  • Responsible for Peer Review, Architectural review of the project to get sign off in dev. environment.
  • Guided QA team to build test cases and create queries to systematically proceed with testing.
  • Responsible for migrating the code between environments and Involved in SIT & UAT Testing
  • Automated load process by creating job chains using Control-M
  • Responsible for production deployment activities.
  • Coordinate with all support teams like PST, Migration, DBAs and Informatica Administrators during production deployment.
  • Performed Root cause analysis for pre and post production issues and provided shadow support.
  • Prepared SRS, TDS, MD 120, Code review, Peer review documents.

Environment: MS SQL Server2008/2010, Team Foundation Server, Microsoft SharePoint Server(MOSS 2010), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2008, Windows XP, T-SQL, VB.Net

Confidential

Sr. ETL Developer / Team lead

Responsibilities:

  • Interacted with business analysts, data architects to develop ETL flow.
  • Responsible for collecting, managing and documenting the Requirements.
  • Prepared Design and Development plan for the project.
  • Responsible for SFDC data connectivity with informatica environment.
  • Worked with flat file connections and directories.
  • Used UNIX shell scripts for pre-staging activities.
  • Responsible for pre requisites of development activities
  • Setup the development and QA environment
  • Extracted data from Oracle, SFDC, flat files and transformed data using Source qualifier, Expression, Sequence Generator, Sorter and Router transformations.
  • Involved in Performance tuning at mapping and session level.
  • Built CDC logic on data warehouse tables.
  • Developed mapplets, worklets for data validation.
  • Implemented global tieouts for data validation.
  • Extensively involved in creating Teradata BTEQ scripts in UNIX environment.
  • Involved in Performance tuning at mapping and session level.
  • Implemented global tieouts for data validation.
  • Used shell scripts for pre-staging activities.
  • Responsible for writing/documenting the unit test cases .
  • Adhere to the quality code standards described by the client.
  • Worked on UNIX scripts to troubleshoot QA and production issues.
  • Automated daily load process using Control-M.
  • Responsible for deployment activities.
  • Facilitating KT sessions to team for knowledge sharing.
  • Timely status monitoring/ risk tracking to manager.

Environment: Informatica 9.6 / 9.1, Oracle 11g, TOAD, Cognos, Teradata 13, Erwin, Unix Shell scripting, Control-M, Quality Center, Dell Share point.

Confidential

Sr. ETL Developer / Team lead

Responsibilities:

  • Requirement analysis, effort estimation and design .
  • Involved in preparation of the application design documents based on functionality required
  • Involved in E2E development cycle from requirement analysis, high level design, detailed design, coding, unit testing and integration testing.
  • Responsible for development activities.
  • Incorporated mappings, sessions, workflows using various transformations as per project flow.
  • Developed Mapplets, Worklets and Reusable Transformations for reusability.
  • Identified performance bottlenecks in sources, targets, mappings, transformations and sessions to optimize session performance.
  • Developed Unix shell scripts to extract data from source files, move files between environments.
  • Responsible in Writing and executing Test Cases and Test Scripts.
  • Responsible to migrate the code from DEV to QA to PROD .
  • Prepared required docs for migration of code & Adhere to Change Request process.
  • Responsible for improving load timings and Involved in upgradation activities.
  • Responsible for production support and stabilization of project.

Environment: - Informatica 9.1/8.6.1, Oracle 11g, TOAD, Teradata 12, Unix Shell scripting, Control-M, Quality Center, Dell Share point.

Confidential

Sr. ETL Developer / Team lead

Responsibilities:

  • Analyzed the change request from business.
  • Impact analysis and Effort estimation for enhancements.
  • Analyze the particular mappings and corresponding workflows where enhancement requested.
  • Building and enhancement of informatica mappings.
  • Tracking end to end development cycle from requirement analysis, high level design, detailed design, coding, unit testing and integration testing.
  • Developed Mapplets, Worklets and Reusable Transformations for reusability.
  • Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
  • Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
  • Defect Analysis and Defect Prevention Activities.
  • Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
  • Integrating the change request to the existing system.
  • User acceptance testing support and issue resolution
  • Prepared technical Specification document and Migration document.
  • Provided support in code migration to different environments (Dev, SIT, Prod) and Implementation.
  • Trained few new joiners in the team on Informatica tool as well as understanding the business of the project.

Environment: - Informatica 8.6.1, Teradata, UNIX, Thumble weed server, Control-M, FTP, MS Visio, Oracle 10g, TOAD, Quality Center, Business objects

Confidential

Sr. ETL Developer / Team lead

Responsibilities:

  • Requirement analysis, effort estimation and design creation.
  • Interacted with Report Users and Business Analysts to understand and document the Requirements and translate those to Technical Specifications for Designing the Informatica Mappings.
  • Responsible for development activities.
  • Created UNIX scripts for passing mapping parameter values.
  • Developed Mappings that extract data form ODS (Operational Data Store) to Data mart and Monitored The Daily and Weekly Loads.
  • Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading strategy.
  • Automated daily load reports to send messages to the concerned personal in case of process failures And discrepancies.

Environment: Informatica 8.6.1, Oracle 9i/10g, TOAD, Teradata, FTP, SFTP, Control-M

Confidential

ETL Developer/ Team lead

Responsibilities:

  • Actively participating in agile process development process.
  • Prepared technical Specification document and Migration document.
  • Coordinate with onsite coordinator in understanding requirements.
  • Sourced data from Oracle, flat file environment.
  • Worked on Extraction, Transformation and Loading of data using Informatica.
  • Develop Informatica Mappings, Sessions and Workflows.
  • Wrote TD Bteq scripts to move data between stages, intermediate, Inc, base, package tables.
  • Prepared test plans and test scripts.
  • Involved in code migration and production implementations.
  • Worked on reporting views creation.
  • Responsible for scheduling and tracking of work assigned to the team members.
  • Ensure project and process quality metrics achieved.
  • Prepared SRS, TDS, MD 120, Code review, Peer review documents.
  • Maintained all the documents in clear case with Version control in CVS.
  • Prepared migration, job chains, production support documents .
  • Automated load process using Redwood Cronacle.

Environment: - Informatica 8.6, Oracle 9i/10g, TOAD, Teradata, FTP, SFTP, Cronacle, BO, Cognos

Confidential

ETL Developer/ Team lead

Responsibilities:

  • Interacted with business users in solving issues in existing application and improvements.
  • Monitored production jobs and taken care to complete within SLA limits.
  • Worked on support tickets.
  • Impact and Root cause analysis
  • Involved in upgrade activities
  • Defect Analysis and Defect Prevention Activities.
  • Facilitating KT sessions for the team for knowledge sharing.
  • Estimated impact on enhancement requests.
  • Debug issues on Congos reporting environment.
  • Generate adhoc reports on timely basis as per client request.
  • Timely status monitoring/ risk tracking and reporting to manager.
  • Using project schedule and work breakdown structure to guide team in the implementation of the project.

Environment: - Informatica 8.1/8.6, Oracle, SQL, PLSQL, Teradata, UNIX, FTP, Cronacle, Cognos, Cognos report net.

Confidential

ETL Developer/ Team lead

Responsibilities:

  • Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.
  • Based on the requirements, used various transformations like Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
  • Worked on enhancements of different modules of EDHR
  • Estimated impact analysis and root cause analysis for issue fix.
  • Developed and maintained stored procedures, functions using PL/SQL.
  • Responsible to load reporting views .
  • Involved in Integration Testing .
  • Informatica Code Migration to different environments and Production.
  • Defect Analysis and Defect Prevention Activities.
  • Deployment and post release support.
  • Performance Improvement of respective application and Knowledge Management.
  • Worked on cube environment of different modules.
  • Generated standalone, drill through reports.

Environment: Informatica 7.1/8.1, Oracle, SQL, PLSQL, Teradata, FTP, Red wood, Cognos, Cognos report net, Cognos Cube

Hire Now