We provide IT Staff Augmentation Services!

Bi developer-ssis, Ssrs/sql developer Resume

Wilson, NC

SUMMARY:

  • A result - oriented professional with over 10 Years’ experience in application development & Enhancement, delivery and client relationship management in banking domain.
  • Extensive experience in business information systems primarily focusing on developing database solutions with business Intelligence tools using SQL Server 2014/ 2012 as a developer / Integration / Reports/Data ware house developer.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
  • Experience in Trouble Shooting, Performance tuning of reports and resolving Report issues.
  • Great interpersonal skills, exceptional problem-solving ability.
  • Excellent understanding of SDLC and Agile methodologies and best practices.
  • An excellent team player & technically strong person who have capability to work with business users, project managers, team leads and architects to maintaining healthy environment in the project.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012, DB2

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio.

Operating Systems: Windows 10, Windows 7, Windows Vista/XP/2003/2000, NT & IBM Mainframes

Languages: T-SQL, C#.NET,VB.NET,COBOL

Office Tools: Microsoft Office, MS Outlook

WORK EXPERIENCE:

Confidential, Wilson, NC

BI Developer-SSIS, SSRS/SQL Developer

Responsibilities:

  • Actively involved in the gathering and analysis the requirements and responsible for writing Business Approach Documents (B.A.D) and Technical documents for projects.
  • Creating SSIS packages and/or build solutions as per requirements in Development/Maintenance projects.
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
  • Conducting peer review meetings with Clients to review the build solutions.
  • Supporting System Integration testing and User Acceptance Testing.
  • Carrying out Conference calls with Project Stakeholders for Status updates.
  • Preparing appropriate Testing Environment and Testing of developed code and Preparation of Test Result Documents.
  • Deployment of the application solutions in the production environment.
  • Providing Post Implementation Support.
  • As part of Maintenance projects, responsible for troubleshooting and fixing the existing issue and Enhancements.
  • Prepare and manage documentation on TFS.
  • Creating Knowledge Transfer (KT) documents on various complex business processes, which are very helpful for understanding the Business to the Clients as well as Team members.

Development Environment: MS SQL Server 2014/2012, SQL Server BIDS: Integration Services (SSIS), Reporting Service (SSRS), TFS, MS Excel, Microsoft Outlook, CA Workstation.

Confidential, Plantation, FL

SQL Server & Data Warehouse Developer

Responsibilities:

  • Gathered requirements from stakeholders for implementing Data Integration.
  • Implemented various PDI Steps and Jobs in cleansing and load the data as per the business needs.
  • Using SOAP Web Services and REST Services calls data gets load into OLTP Database tables.
  • Designed custom processes to import data into database and ETL.
  • Created ETLs to fetch data from OLTP databases and load into Staging Tables. Further, creating outbound files to Downstream Applications.
  • Used the data Integration tool for designing ETL jobs in the process of migrating data from SQL Server to Warehouse.
  • Involved in Code reviews for testing the converted data along with QA team.
  • Involved in preparing test plans, unit testing, system integration testing.
  • Responsible for scheduling the jobs in Test and Production Environments.
  • Involved in creation of various automation processes to existing system.

Development Environment: MS SQL Server 2014/2012, Integration Services (SSIS), T-SQL, CA7, Informatica, SharePoint

Confidential

Mainframe Developer

Responsibilities:

  • Involved in the development of COBOL Programs for CIS - Batch Monitoring tool.
  • Preparing Approach documents and Low Level design document (LLD).
  • Preparing Test Scenarios.
  • Unit Testing of Developed code.
  • Promoted components to deploy them into Production using Changeman.
  • Preparing the Automated tools, this will reduce the Manual efforts and tedious process.

Development Environment: COBOL, JCL, REXX, Easytrieve, DB2, FILE AID, SPUFI, DFSORT.

Confidential

Mainframe Developer

Responsibilities:

  • Analyzing the Design Documents and business requirement documents.
  • Developing the application as per the requirement documents.
  • Testing the code changes.
  • Scheduling and monitoring the jobs in production.
  • Support the application by providing production support 24x6.
  • Preparing the Adhoc Queries and generating the reports as per business requirements.
  • Acted as the Module Lead for the CA/ACA Benpos Application which is a team of 5.
  • Preparing the Automated tools, this will reduce the Manual efforts and tedious process.

Environment: COBOL, JCL, CICS, REXX, DB2, TSO/ISPF, VSAM, DFSORT SPUFI, QMF.

Hire Now