SUMMARY

• 8 years of experience in programming as an SQL Developer in Analysis, Design and Implementation of Business Applications.
• Expertise in Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with Good knowledge in SQL Server Analysis Services (SSAS).
• Implementation and technical expertise in Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert.
• Extensive working experience in usage of SSIS Control Flow items.
• Good exposure to all phases of the Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Extensive Experience in Customization of forms and reports and development of Conversions, Interfaces.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and index updates.
• Extensive experience in SQL, PL/SQL Developing.
• Expert in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Transferred and retrieved data to and from FTP Servers to Oracle Database.
• Experience with SSRS Report Server, Report Manager and SSRS deployment Process Working Experience in preparing documentation as per organizational standards, designing, implementing, and maintaining complex database applications in financial environments.
• Worked with stored procedures, triggers and fluency in PL/SQL.
• Extensive experience in Performance Tuning of SQL queries & Views.
• Performed unit testing, system testing and UAT testing.
• Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS

Script and Query Languages: T - SQL, PL/SQL, XML, HTML, VBSCRIPT

SQL Tools: SSIS, SSRS, BUSINESS INTEGELLIENCE STUDIO BIDS, SSMS, VISUAL STUDIO, SSDT, SQL SERVER MANAGEMENT STUDIO(SSMS)

Databases design and Data Modelling tools: MS Visio, ERWIN, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization techniques.

Operating systems: WINDOWS 7/10, LINUX, UNIX

Databases: Microsoft SQL Server 2014/2012/2008 R2/2008, MySQL, Oracle, DB2, Teradata, MS Access.

Others: MS OFFICE, JIRA, POWER PIVOT, QLIKVIEW, MS ACESS, WATERFALL AND AGILE METHODOLOGY, TFS, GIT, EXCEL.

PROFESSIONAL EXPERIENCE

Sr. SQL Developer

Confidential - New York City, NY

Responsibilities:

• Worked with Stored Procedures, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Used SSIS and T-SQL stored procedures to transfer data from source databases to staging area and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurations for SSIS packages. Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Created reconsolidation reports for conversion purpose using various joins.
• Created packages using the various control flow task such as data flow task, execute SQL task, Execute package task, File System task.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, Oracle, MS Access, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL, MS SQL Server DTS, Upgrade Advisor, DTS Designer Tools.

SQL Developer

Confidential - Hackensack, NJ

Responsibilities:

• Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert.
• Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS 2012).
• Designed Data Mapping documents, DDL scripts, Data Dictionary and meta data of the models and maintained them. Created Error and Performance reports on SSIS Packages.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed SSIS packages for File Transfer from one location to the other using FTP task.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using Business Object and Crystal reports.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Conducted weekly Crystal Reports training session for the reports team.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, SQL Server 2012, SSRS 2012, SSIS 2012, Excel, T-SQL, Windows 2008/XP, C#, ASP.NET, Visual studio

SQL Developer

Confidential - Boston, MA

Responsibilities:

• Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
• Worked and maintained SQL Stored Procedures, functions, and triggers for updating customer usage information in the database
• Merge tables and created views to support reporting requests using SQL Server
• Troubleshoot data and functionality issues related to reports, and SSIS packages
• Used several transformations in Data Flow including Derived-Column, Script, Lookup, Data Conversion, and Conditional-Split to categorize data for other departments
• Created complex SSIS packages using proper control and data flow elements with error handling
• Designed Data flows, Workflows and jobs to load data from source to target
• Performed Documentation for all kinds of reports and SSIS packages
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS)
• Design daily table reports, matrix reports, sub-reports based on business needs using SSRS
• Created Reports using SSRS. Identified the data source and defined them to build the data source views
• Created reports in SSRS with properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Designed and created report templates, bar graphs, and pie charts based on financial data for analyzing performance counters using SSRS
• Created reports using features like drill down, drill through, parameterized reports. Developed yearly, quarterly, monthly sales reports and scheduled the reports to run on daily and weekly basis in report manager and also email them to project manager to review in Excel sheet

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, MS Access, Enterprise Manager, Management Studio, SQL Server, T-SQL, SSRS, SSAS, SSIS Packages, ETL, ODBC, Excel, Data Integrator, OLAP, OLTP

SQL Developer

Confidential

Responsibilities:

• Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
• Created SQL Server Reports and designing stylish report layout parameterized, performance, Ad-hoc reports.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Worked with Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions
• Used SSIS and T-SQL stored procedures to transfer data from source databases to staging area and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurations for SSIS packages.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, and Views.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2012/2008/2005.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS)
• Worked with business users to understand metric definitions, presentation, and usage needs.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, MS Access, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL, MS SQL Server DTS, Upgrade Advisor, DTS Designer Tools.