Objective

• Looking for a Software developer opportunity so I can use my technical and analytical skills to help business to reach their timeline and be competitive.

SUMMARY

• Over six years of IT experience as MS SQL Server Developer 2016/2014/2012/2008 R2/2005 in Industry verticals like Insurance and Manufacturing.
• Experience in Design and optimization of OLTP, OLAP tools, Created SSAS Cubes using Star and Snowflake schema.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Knowledge of writing MDX queries to work with cube data’s.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Created basic python scripts that can do the test automation (which can compare the data between Excel and database)
• Knowledge of create important objects like complex User Defined Store Procedures, Views, User Defined Functions and Triggers
• Build complex SSIS packages to automate processes for the DWH team
• Used Agile technique and waterfall as well to manage the Project
• Build Dashboard SSRS reports and created Subscription to users so they can make important decisions
• Also Build Drill Down and Drill Through reports using SSRS
• Automate process for the End Users So they can run SSRS report that can trigger SSIS and see how data loads from their main frame to direct DWH

TECHNICAL SKILLS

Database development using T: SQL with MS SQL SERVER 2008/2008R 2/2012/2014/2016

Microsoft Access: 2010/2013, SSIS (ETL Development), SSRS (Reporting Development), SSAS (Cube Development), CSS, HTML, Python 3.4.3, MS Office 2016, Autosys Job Scheduler

Operating System: Windows XP,7, 8, 10, Visual Studio 2010/2012/2013/2015 , TFS (Source Control)

PROFESSIONAL EXPERIENCE

Confidential, Berwyn, PA

BI Developer

Responsibilities:

• Worked with SSIS using different task and containers in order to automate the process.
• Also, worked with their Generic DBI tool so we can schedule email delivery including the snapshot reports and excel reports to the investment analyst.
• Built POINT/RIM Model Validation SSRS master report for the Quantitative research department.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.
• 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/ 2008R2/2005.
• Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Working closely with network team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Had to stay on PROD Support for once a month

Confidential, Jersey City, NJ

SQL Developer \Data Analyst

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T - SQL code and SQL joins for applications.
• Developed various T-SQL stored procedures, functions and packages.
• Migrated data from Heterogeneous Data Sources and legacy system (Oracle, Access, and Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Analyzed existing logicaldatamodel (LDM) and made appropriate changes to make it compatible with business requirements.
• Worked on identifying facts, dimensions and various other concepts of dimensionalmodeling, which are used for datawarehousing projects.
• Optimized existing procedures for better query performance.
• Processed cube to perform incremental updates.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.

Confidential, Lumberton, NJ

SQL developer DBA\ (SSIS)

Responsibilities:

• Responsible for Conceptual, logical and physical design for in-house application development.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Creation of views to facilitate easy user interface implementation, and triggers on tables to facilitate consistent data entry into the database.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Configured SQL Mail agent for sending automated alerts/email.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.

Confidential, RTP, NC

BA SQL Developer /SSIS/Application developer

Responsibilities:

• Used visual studio 2010 to doing database development and integration development and also used AutosysJil files to create job scheduling for integration and Java.
• Created BNTC (Best Number to Call) and BTTC (Best Time to Call) files for the business by using database and integration backend and java and MSP in front hand tool
• Developed a multi-tier, end-to-end and customer facing application to automate the process for a paper based system
• Design and develop all components of the application from database design to interactive user interface
• Used Agile methodology to achieve Goal by using regular scrums and Sprints.
• Used multiple Transformation like Sort, Data Conversion, Conditional Split, Derived Column, Lookup, Merge and Multi Cast while creating SSIS Packages.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.Performed Documentation for all kind of SSIS packages.
• Also, Up for the Production Support 24/7. So the whole system is running Up to date.
• Design and styling using HTML and CSS
• Created database in SQL
• Used phpmyadmin for programming and ajax for advance control
• Integrated with another automated system to share data using database federation technique to merge two databases into a single database.