SUMMARY:

• Overall 11+ years of IT experience that includes MS SQL and Business Intelligence including SSRS/SSIS/SSAS (6+ years) and Mainframes platform (5 years)
• Well versed with all stages of SLDC such as analysis and requirement gathering, design, development, implementation, estimation, testing and maintenance of software applications primarily using Microsoft BI tools SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).
• Have experience working on T - SQL using SQL Server 2008/2008 R2/2012
• Have experience creating SQL Server Objects (Stored Procedures, User Defined Functions, Views, Triggers and SQL Server Agent Jobs).
• Have experience in query optimization and performance tuning.
• Have experience designing, developing, configuring, error handling and deployment of SSIS (2008/2012) Packages.
• Design of scalable, reusable, and low maintenance ETL templates.
• Have experience creating complex SSIS packages to extract data from various sources to staging and other target environments with incremental/full load. Designed and developed SSIS packages to validate, extract, transform and load data to data warehouse tables (Dimension/Facts), data marts.
• Extensive experience in Database design and development of applications using SQL Server Reporting Services (SSRS), Integration Services (SSIS), Normalization/De-normalization concepts and have knowledge in SQL Server Analysis Services (SSAS), MDX queries, OLAP Cubes.
• Have experience creating Database Unit Tests to automate testing of database objects.
• Have experience working on SSRS reporting tool, creating sub reports, parameterized reports, cascading reports, drill down reports, drill through reports and interactive reports
• Have experience with SSRS configuration, SSRS subscriptions, deployment and use of report manager to grant or restrict user access to reports.
• Possess good analytical, interpersonal, communication, problem solving skills and also an active team player.
• Have experience using Visio to design Data Flow Diagrams.
• Experienced programmer analyst with strong analytical, designing, programming and debugging skills
• Have done requirements gathering besides doing business function analysis coming up with High and Low Level Design
• Sound functional knowledge of Banking involving Credit Cards, Insurance and Health care
• Have done coordination, implementation, Integration, System and Acceptance testing of critical commercial applications
• Good communications and interpersonal skills.
• Excellent problem solving and debugging capability.
• Self-motivated, excellent team player and willing to assume responsibility.

TECHNICAL SKILLS:

Databases: SQL Server 2012/2008 R2/2008

Operating systems: Windows 7/XP/2000/98

Tools: SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS(SQL Server Analysis Services), MS Visio, DTS

Others: SQL Profiler, Query Analyzer, Database Tuning wizard

Mainframe Skills: TSO/ISPF, SPUFI, QMF, SYNCSORT, INSYNC, COBOL, JCL, C, Easytrieve, Assembler, XPEDITER, CHANGEMAN, JOBTRAC, CONTROL-M, ENDEAVOR, REMEDY, STARTEAM, Quality Center, Trace master, DB2, VSAM, IMS DB/DC, CICS

Big Data: Hadoop Stack: HDFS, MapReduce, YARN, Pig, Hive, UDF’s, HQL, HBase, Sqoop, Flume, Oozie

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr SQL Server Developer

Responsibilities:

• Create databases with all necessary permissions, importing all SQL server objects from existing DB to new DB.
• Creation of SQL objects SQL Stored Procedures, Views, User Defined Functions, along with T-SQL queries.
• Data migration from text files, DB2, excel files to SQL server.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes
• Creation of Stored Procedure is done with proper transaction and error handling.
• Creation of SSIS packages to load and transform transactional and master data from one server to another server.
• Creation of database unit tests in MS Visual Studio 2013 for SIT, unit tests are created for all Stored Procedures.
• Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular Confidential depending on requirements.
• Worked on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration.
• Prepare functional analysis document post discussion with client/Business Analyst.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS 2012.
• Prepare technical analysis document based on the requirement gathering done.
• Prepare estimation of work to be done.
• Provide weekly status of work done to team and management.

Platform & Skill: SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Database Tuning wizard.

Confidential, CA

Sr SQL Server Developer

Responsibilities:

• Design and development of SSIS package to extract data from oracle source and load data in target SQL server tables.
• Design and develop parameterized and customized SSRS report to pull data from SQL server table loaded using SSIS package.
• Ensure SSRS dashboard report generated on daily basis with details of Control - M jobs and send across to customer for analysis, used subscriptions within SSRS to send mails.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Ensure timely completion of production issue related tickets within given SLA’s.
• Responsible for task assignment, estimation and allocation to team members.
• Ensure proper co-ordination with team members to ensure completion of assigned tasks within stipulated Confidential .
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse.
• Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, and multicasting.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which including data validation checks during Staging, before loading the data into the Data warehouse.
• Designed SSIS packages to load data from different sources Text files, Excel to staging and staging to Data warehouse.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions and Functions, Sorting the data and Subtotals for the reports using SSRS.
• Involved in preparation of database unit test cases for SQL Server objects using Microsoft Visual Studio 2010 DB Projects.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Script task component and established iterative load for faster retrieval & to improve performance.
• Coding & Unit Testing of Modules developed.
• Conducting System & Regression Testing.

Platform & Skill: SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Database Tuning wizard.

Confidential, Mellon, NY

SQL Server Developer

Responsibilities:

• Design SSIS packages to load data from various sources with transformations, cleansing and validations applied to data before loading data into target environment.
• Implemented use of various sources like OLEDB, Excel, Flat File, Xml etc.
• Implemented use of various transformations like Lookup, Multicast, SCD, Data Conversion, Conditional Split, Script Component etc.
• Design and Develop SSIS packages for various personal lines LOB’s
• Creation of SQL objects like Stored Procedures, Views, T-SQL queries and User Defined Functions making extensive use of it within SSIS packages.
• Stored Procedures are designed with proper transaction and error handling (Try and Catch statements).
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS)
• Created Confidential Dimensions on OLAP Cubes using SSAS.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Design and developed parameterized report in SSRS for financial reconciliation.
• Ensure fixes for PROD bugs within stipulated Confidential frame.
• Prepare analysis document based on requirement gathering post discussion with client/Business Analyst.
• Created and Modified Stored Procedures, Triggers, Tables, Views and also making use of Merge Statements instead of Cursors in T-SQL
• Prepare estimates of the work projected.
• Prepare deployment artifacts for (Model Office/UAT/PROD) environments along with deployment deliverables and work with DBA to ensure successful deployment.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Perform Peer to Peer code reviews.
• Provide daily status of team work to management.

Platform & Skill: MS SQL Server 2008R2, T-SQL, SSIS, SSRS, SSAS, Import and Export Data wizard, SQL Query Analyzer, SQL Profiler.

Confidential, CA

Programmer Analyst

Responsibilities:

• Developed and enhanced the programs using COBOL, JCL, DB2, VSAM, COOLGEN, REXX, Easytrieve
• Involved in coding and testing activities which included Unit, System and User Acceptance Testing
• Analyzed the requirements and prepared HLD and LLD specification documentation
• Development of SQR Batch Processes
• Implementation of modified/newly created elements into production using Changeman
• Preparing SOX documentation for each task/project
• Providing Root Cause Analysis for incident management
• Preparation of Weekly Status Report, Defect Tracker
• Perform all quality check reviews in requirement delivery and ensure to deliver best quality
• Provide management & technical leadership in design, development and delivery as per technical specifications
• Involved in Batch and online testing
• Creation of test data & test plan for various scenarios

Platform & Skill: Z/OS, IMS DB/DC, TSO/ISPF, COBOL, JCL, COOLGEN, CICS, INSYNC, CHANGEMAN, Control-M, VSAM, REMEDY, REXX, Easytrieve, XPEDITER, NDM.

Confidential

Application Developer

Responsibilities:

• Developed and enhanced the programs using COBOL, JCL, VSAM, DB2, XPEDITER, and CHANGEMAN.
• Evaluating the requirements to translate to technical specifications
• Effort estimation based on the technical specifications including resource forecasting
• Creating change request in Infoman for scheduled as well as adhoc implementation requests.
• Monitoring jobs in JOBTRAC
• Creating reports in AXIOM region.
• Monitoring load jobs in Control-M
• Routing Production Tickets to appropriate departments using Manage now
• Done Reengineering to the Production jobs to reduce the CPU Confidential
• Creating High Level and Low Level Technical Specifications and Design documents
• Mentoring new resources into the team
• Supporting coding and testing activities which included Unit, System and User Acceptance Testing
• Carrying out impact analysis for modifying the related PROCs and JCLs for upgrade
• Providing permanent fixes to the Production related problems.
• Created deliverables including design documents, estimates and unit test results.

Platform & Skill: Z/OS, OS/390, TSO/ISPF, COBOL, JCL, INSYNC, CHANGEMAN, XPEDITER, JOBTRAC, INFOMAN, CONTROL-M, DB2, VSAM, NDM.