SUMMARY

• Over 10 years of strong experience in software design, development, analysis, optimization, data modeling and business intelligence tools using MS SQL Server 2016/ 2012/2008/2005
• Strong experience in MS SQL Server 2016/ 2012/2008/2005 working with business intelligence tools in SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).
• Expert at basic and advanced report creation (table, chart, matrix report, web reporting) along with excellent experience in report serving architecture.
• Expert in creating standard, cross - tab, sub-report and drill down reports using Crystal Reports XI.
• Expert in creating, configuring, and fine-tuning ETL (Extract, Transform, Load) workflows designed in SSIS.
• Proficient in high level design of ETL SSIS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Highly experienced with the Full Life Cycle and Methodology for implementing OLAP (Online Analytical Processing) data warehouses (star and snow flake schemas) and business intelligence reporting systems.
• Proficient in cube designing in business intelligence development studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, and calculations using SSAS.
• Excellent experience in developing complex stored procedures, efficient triggers, required functions, creating indexes, and indexed views for improving performance.
• Proficient in monitoring SQL Server Performance using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard and Windows Performance Monitor.
• Excellent communication skills, organizing skills, excellent listener, and capable of handling responsibilities independently as well as a proactive team member.
• Strong time management skills in handling multiple projects and deadlines under minimal supervision. Proven ability to adopt new technologies in minimum time and with little training.

TECHNICAL SKILLS

• MS SQL Server 2016/ 2012/2008/2005 , Microsoft Reporting services 2012/2008/2005
• Microsoft Integrating Services 2016/ 2012/2008/2005 , Microsoft Analysis Services 2008/2005
• Windows 2000/2003 Advanced Server, Windows Exchange Server 2003, Windows XP
• Unix, Linux, MySQL, MS-Access, Oracle 9.i, Confidential, T-SQL, .NET, Java, HTML, DHTML, XML
• Java Script, MS Visual studio 2017/2015/2008/2005 , ERWIN 7.1.

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Server Developer

Responsibilities:

• Used Tibco Data Virtualization to create logical views to integrate and secure data across disparate data sources.
• Used config files in 2008 SSIS and Integration services Catalog in 2016 SSIS to ease the process of moving the packages across servers (deployment to production).
• Working with Business Analysts to understand the Business and to review requirements, propose, design, and implement solutions.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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.
• Monitored and optimized queries by looking at Execution Plan, SQL Profilers, Activity Monitor for better tuning of the database.
• Used SSIS project deployment as well as individual package deployment using parameters, environments, environment variable and SSIDB Catolog.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for supporting Data Warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Tuned several slow running queries. Implemented Indexes and re-indexed to achieve time performance.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.

Environment: MS SQL Server 2008/2012/2016 ,TDV, SQL Server Reporting Services 2008/2012, SQL Server Integration Services 2008/2012/2016 , SQL Server Analysis Services 2008/2012, MS Excel, MS Windows Server 2003, Oracle 11g/10g/9i.

Confidential, NYC

Business Intelligence Developer

Responsibilities:

• Working with Business Analysts to understand the Business and to review requirements, propose, design, and implement solutions.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for supporting Data Warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Used config files in 2008 SSIS and Integration services Catalog in 2016 SSIS to ease the process of moving the packages across servers (deployment to production).
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Monitored and optimized queries by looking at Execution Plan, SQL Profilers, Activity Monitor for better tuning of the database.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Used SSIS project deployment as well as individual package deployment using parameters, environments, environment variable and SSIDB Catolog.

Environment: MS SQL Server 2008/2012/2016 , SQL Server Reporting Services 2008/2012, SQL Server Integration Services 2008/2012/2016 , SQL Server Analysis Services 2008/2012, MS Excel, MS Windows Server 2003, Oracle 11g/10g/9i.

Confidential, Jersey City, NJ

Report Analyst

Responsibilities:

• Working with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Working in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Writing complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
• Used conditional formatting to change the behavior of the report depending upon the requirement. Created standard report Subscriptions and Data Driven report Subscriptions.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Used config files in SSIS to ease the process of moving the packages across servers (development to production).
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Monitored, optimized and did Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: MS SQL Server 2008/2012, SQL Server Reporting Services 2008/2012, SQL Server Integration Services 2008/2012, SQL Server Analysis Services 2008/2012, MS Excel, MS Windows Server 2003, Oracle 10g/9i.

Confidential, Yonkers, NY

Report Analyst

Responsibilities:

• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports. Debugged and deployed reports in SSRS.
• Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
• Created Standard, cross-tab, sub reports and drill down reports using Crystal Reports XI for different departments according to user requirements.
• Created SSIS Packages for extracting data from Excel and MS SQL Server, transforming and loading to SQL Server 2008R2/2012.
• Used config files in SSIS to ease the process of moving the packages across servers.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for hospital reports and for Data Warehouse.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Gathered Requirements from the end user and writing the report specification for easy implementation of reports and for reports repository.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
• Reviewed final reports with end user and updating the reports and documentation according to their requirements.

Environment: MS SQL Server 2005, MS SQL Server 2008, MS SQL Server 2008 R2, MS SQL Server reporting services 2005(SSRS), MS SQL Server reporting services 2008(SSRS), SharePoint, Crystal Reports 2011, Integration Services (SSIS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003, Infomaker 11.5

Confidential, Stamford, CT

MS SQL Server Developer

Responsibilities:

• Created SSIS Packages for extracting data from Excel and MySQL, transforming and loading to SQL Server 2005.
• Created SSIS packages to import and export data from Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages
• Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
• Monitored, optimized and did Performance Tuning using SQL Profilers and Activity Monitor.
• Created star schema in SSAS to develop ad-hoc reports for the hospital as per their requirements using SSRS in MS SQL 2005.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for supporting Data Warehouse.
• Wrote MDX to create name sets and calculated members and created reports by dragging data from cube in SSAS.
• Created and rebuild multi-dimensional cubes using SSAS for business reporting process.
• Reviewed Cube with end user and changing the cube and documentation according to their requirements.
• Gathered Requirements from the end user and creating the structure of the schema and data for database tables.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2008

Environment: MS SQL Server 2008/2005, MS SQL Server reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), MySQL, T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003, SQLyog, MS Visio.