SSRS Developer
Thomson Reuters
Keywords
Microsoft SQL Servers
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Transact-SQL
Team Foundation Server
Windows Servers
Data Analysis
Microsoft Azure
C Sharp (Programming Language)
Skills
Microsoft SQL Server 2000/2005/2008/2012, SSIS, SSRS, MS, MS EXCEL, Microsoft Office SharePoint server 2007/2010/2013 Performance Point Server, ProClarity analysis server, Tuning T-SQL, PL, SQL Complex Queries, Very Large databases, VLDB, SQL Server 2005/2008/2012/2014, integration services, MS SQL Server 2000/2005/2008R2/2012/2014, Powerpivot, Excel, Multidimensional Expressions, MDX, SQL Server, Power Shell, Power BI, OLE DB, Oracle, Teradata, flat file, interface layer, ASP.NET, C#, SQL Server (2000/2005/2008/2008, recursive CTEs, CTE, temporary tables, effective DDL/DML Triggers, DMVs, DMFs, DTA, ITW, Performance, Performance Point Server, ProClarity, SQL Server 2014/2012/2008/2008R2/2005, Oracle 8i/9i/10g/11g, MYSQL, Database, SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services, DTS, ETL, Bulk Insert, BCP, ODBC, Business Intelligence Development Studio, BIDS, SQL CMD, Report Builder, Focus, T-SQL, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, UML, XML, XMLA OLAP SQL Server Reporting Services, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau, Tortoise SVN, Visual Source Safe, VSS, Team Foundation Server (TFS), Windows Server 2000/2003/2008/2012, MS DOS, Unix, Linux, Data mining, regression, data analysis, Selenium, test scripts, regression testing, QTP, Scrum, system integration testing, integration testing, test suite, SQL Server 2016/2014/2012, OLTP, SSRS 2008R2, 2012, 2014, Windows Server 2008, VS 2010/2012, J Unit, SQL Server Reporting Services, Microsoft SQL Server, SQL Agent, SSIS packages, SQL programming objects, stored procedures, T-SQL queries, PDF, CSV, SSRS 2008 R2, SQL Server 2008 Reports Writer, SQL, SQL Server 2012 tools, SQL Server Profiler, SQL Server Visual Studio, Relational Database, Dictionaries, Data Integrity, Parameterized, Sql Server Reporting Services 2012, Analytics, business logic, API, SQL Server Development, Transact-SQL, User Defined Functions, UDF, query optimization, UAT, Views, database theory, SQL Server 2012/2014, Oracle DB, SQL DB, MS Azure, Dynamic SQL, Reporting Services, PowerBI, SQL queries, Informatica 9.1, SSRS 2008R2, SQL Server 2008, common table expressions, SQL tuning, SharePoint 2010, TFS, SQL Server 2014/2012/2008R2/2005 Enterprise Edition, VB Script, Enterprise manager, MS PowerPoint, MOSS, MS Project, MS Access 2008, Software Development Life Cycle, SDLC, SQL Server 2005, SQL Server Integration Services (SSIS) 2008, SSIS Dataflow, Data Conversion, checksum, azure, cloud, HDInsight, Data Warehouse, Star Schema, Microsoft Office Share point Server, SQL Server 2008 Reporting Services, SSRS 2008, cursor, SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio, Net framework, MS Visual Source Safe, Windows Server 2003
Project history
04/2018
-
10/2018
Thomson Reuters is one of the world's most trusted provider of answers, helping professionals make
confident decisions and run better businesses.
Responsibilities:
* Responsible for SQL Server Reporting Services Planning, Architecture, Training, Support and
Administration in Development, Test and Production Environments.
* Extracting and transforming data within Business Intelligence environment.
* Worked with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.
* Designed and developed SQL programming objects, including stored procedures, user defined
functions, and common table expressions
* Used Performance Point Server (PPS)to create interactive reports with an ability to drill down
into details
* Perform unit level analysis on all work done before handing over to the testing team
* Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
* Create SSRS reports according to user requirements and technical standards
* Customize output formats from SSRS to Excel, PDF, and CSV.
* Creating Report-Models for ad-hoc reporting and analysis.
* Developed Query for generating drill down reports in SSRS 2008 R2
* SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
* Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL
Server Visual Studio.
* Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database
Models, Data Dictionaries, and Data Integrity.
* Create different SSRS Reports based on the user's requirement. All kinds like ad-hoc reports,
* Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids
using Sql Server Reporting Services 2012.
Environment: SQL Server 2016/2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power BI,
Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel.
confident decisions and run better businesses.
Responsibilities:
* Responsible for SQL Server Reporting Services Planning, Architecture, Training, Support and
Administration in Development, Test and Production Environments.
* Extracting and transforming data within Business Intelligence environment.
* Worked with Microsoft SQL Server, including SQL Agent jobs, SSIS packages.
* Designed and developed SQL programming objects, including stored procedures, user defined
functions, and common table expressions
* Used Performance Point Server (PPS)to create interactive reports with an ability to drill down
into details
* Perform unit level analysis on all work done before handing over to the testing team
* Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
* Create SSRS reports according to user requirements and technical standards
* Customize output formats from SSRS to Excel, PDF, and CSV.
* Creating Report-Models for ad-hoc reporting and analysis.
* Developed Query for generating drill down reports in SSRS 2008 R2
* SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
* Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL
Server Visual Studio.
* Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database
Models, Data Dictionaries, and Data Integrity.
* Create different SSRS Reports based on the user's requirement. All kinds like ad-hoc reports,
* Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids
using Sql Server Reporting Services 2012.
Environment: SQL Server 2016/2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power BI,
Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel.
09/2017
-
03/2018
SQL BI (SSIS) Developer
Immense Analytics
Immense Analytics has partnered with DataGravity to bring their data-aware storage platform to
clients. Immense Analytics offers installation, configuration and maintenance of their award-winning
products.
Responsibilities:
* Delivered high quality, innovative BI solutions in a fast-paced environment
* Designing Data Model and implementing changes in the earlier phase of the project to
accommodate business logic and dynamic nature of the front-end application.
* Designed and developed ETL solutions for multiple source systems
* Designed, developed and supported BI-related database applications spanning multiple lines of
business with loan and leasing applications.
* Performed complex data analysis to identify trends, patterns, and opportunities
* Created SSIS packages to extract, load and transform the data from flat files to database
tables, API to database
* Extensively for the Pre-Prime product team
* Strong SQL Server Development skills including writing Transact-SQL (T-SQL) Queries, Stored
Procedures, User Defined Functions (UDF), Views, Calculation Views, Indexes, and User Defined
Data Types strictly following the Data Integrity using Constrains, Rules and Default.
* Experience in performance tuning, query optimization, Database Maintenance plans
* Performed Unit & IT testing& conducted UAT sessions with end users.
* Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks
and indexes configurations.
* Use Cosmos products in developing internal applications and presentations.
* Experiences in developing Normalization, Stored Procedures, Views, ETL processes, relational
database theory and Complex Queries on SQL Server 2012/2014.
* Analyzing the sources, transforming data, mapping the data and loading the data into targets
using Informatica Power Center Designer.
* Created several SSIS Packages from different data sources like CSV Files, Excel Files, Oracle
DB, SQL DB, MS Azure.
* Used multiple transformations in SSIS to meet the business requirements by extracting data from
transactional source systems, transform and finally load into the Staging Data base.
* Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
* Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored
procedures in existing application, to identify slow running query etc.
* Excellent in creating reports with SQL Server Reporting Services (SSRS) and Power BI
* Used SSRS and power BI to create reports, Parameterized Reports, Drill down & Drill through
Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
* Experience in creating Parameterized Reports using Dynamic SQL i.e. Stored Procedures.
* Provided reporting and analytic solutions to the organization in the form of Reporting Services
reports and Analysis Services cubes.
* Using the above query results from Cosmos, creating reports in PowerBI, Ads pulse to show the
metrics by server and procedure name, by server etc.
* Managed complex issues quickly using problem solving techniques such as problem (KT), process
and data analysis
* Developed the T-SQL programs and Involved in performance tuning of SQL queries and stored
procedures using SQL techniques and queries for faster retrieval.
* Involved in performance tuning of SSIS Packages.
Environment: SQL Server 2016/2014/2012, OLTP, Informatica 9.1, PL/SQL, OLAP, SSIS, SSRS 2008R2,
2012, 2014, Power Shell, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel.
clients. Immense Analytics offers installation, configuration and maintenance of their award-winning
products.
Responsibilities:
* Delivered high quality, innovative BI solutions in a fast-paced environment
* Designing Data Model and implementing changes in the earlier phase of the project to
accommodate business logic and dynamic nature of the front-end application.
* Designed and developed ETL solutions for multiple source systems
* Designed, developed and supported BI-related database applications spanning multiple lines of
business with loan and leasing applications.
* Performed complex data analysis to identify trends, patterns, and opportunities
* Created SSIS packages to extract, load and transform the data from flat files to database
tables, API to database
* Extensively for the Pre-Prime product team
* Strong SQL Server Development skills including writing Transact-SQL (T-SQL) Queries, Stored
Procedures, User Defined Functions (UDF), Views, Calculation Views, Indexes, and User Defined
Data Types strictly following the Data Integrity using Constrains, Rules and Default.
* Experience in performance tuning, query optimization, Database Maintenance plans
* Performed Unit & IT testing& conducted UAT sessions with end users.
* Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks
and indexes configurations.
* Use Cosmos products in developing internal applications and presentations.
* Experiences in developing Normalization, Stored Procedures, Views, ETL processes, relational
database theory and Complex Queries on SQL Server 2012/2014.
* Analyzing the sources, transforming data, mapping the data and loading the data into targets
using Informatica Power Center Designer.
* Created several SSIS Packages from different data sources like CSV Files, Excel Files, Oracle
DB, SQL DB, MS Azure.
* Used multiple transformations in SSIS to meet the business requirements by extracting data from
transactional source systems, transform and finally load into the Staging Data base.
* Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
* Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored
procedures in existing application, to identify slow running query etc.
* Excellent in creating reports with SQL Server Reporting Services (SSRS) and Power BI
* Used SSRS and power BI to create reports, Parameterized Reports, Drill down & Drill through
Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
* Experience in creating Parameterized Reports using Dynamic SQL i.e. Stored Procedures.
* Provided reporting and analytic solutions to the organization in the form of Reporting Services
reports and Analysis Services cubes.
* Using the above query results from Cosmos, creating reports in PowerBI, Ads pulse to show the
metrics by server and procedure name, by server etc.
* Managed complex issues quickly using problem solving techniques such as problem (KT), process
and data analysis
* Developed the T-SQL programs and Involved in performance tuning of SQL queries and stored
procedures using SQL techniques and queries for faster retrieval.
* Involved in performance tuning of SSIS Packages.
Environment: SQL Server 2016/2014/2012, OLTP, Informatica 9.1, PL/SQL, OLAP, SSIS, SSRS 2008R2,
2012, 2014, Power Shell, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel.
07/2015
-
07/2017
SQL Developer
Kartrocket (Shiprocket 360)
Shiprocket 360 is an end to end commerce enablement solution which helps offline and online
retailers build their omnichannel solution. Shiprocket 360 helps to create a seamless journey for
customers across all sales channels based on their interest, reaction, and past interactions.
Responsibilities:
* Involved in migration of SQL Server 2008 to 2012/2014.
* SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
* Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL
Server Visual Studio.
* Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database
Models, Data Dictionaries, and Data Integrity.
* Create different SSRS Reports based on the user's requirement. All kinds like ad-hoc reports,
* Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids
using Sql Server Reporting Services 2012.
* Designed SSIS Packages to transfer data from various sources of the Company into the database
that was modeled and designed.
* Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data
during transferring, and archived data files for different DBMS.
* Defined best practices for Tableau report development.
* Defined best practices for Tableau report development and effectively used data blending
feature in tableau.
* Create Master Package to run different other ETL in one Master package.
* Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and
functions used for designing SSIS packages.
* Bug fixes in SSIS, SSRS and stored procedures as necessary.
* Perform T-SQL tuning and optimizing queries for and SSIS packages.
* Created SSIS process design architecting the flow of data from various sources to target.
* Use of SharePoint 2010 and TFS to store all the related work and report the same by creating
Tasks in TFS
Environment: SQL Server 2014/2012/2008R2/2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB
Script, Tableau, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, MOSS 2007, MS Project, MS
Access 2008 & Windows Server 2008, Oracle.
retailers build their omnichannel solution. Shiprocket 360 helps to create a seamless journey for
customers across all sales channels based on their interest, reaction, and past interactions.
Responsibilities:
* Involved in migration of SQL Server 2008 to 2012/2014.
* SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
* Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL
Server Visual Studio.
* Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database
Models, Data Dictionaries, and Data Integrity.
* Create different SSRS Reports based on the user's requirement. All kinds like ad-hoc reports,
* Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids
using Sql Server Reporting Services 2012.
* Designed SSIS Packages to transfer data from various sources of the Company into the database
that was modeled and designed.
* Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data
during transferring, and archived data files for different DBMS.
* Defined best practices for Tableau report development.
* Defined best practices for Tableau report development and effectively used data blending
feature in tableau.
* Create Master Package to run different other ETL in one Master package.
* Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and
functions used for designing SSIS packages.
* Bug fixes in SSIS, SSRS and stored procedures as necessary.
* Perform T-SQL tuning and optimizing queries for and SSIS packages.
* Created SSIS process design architecting the flow of data from various sources to target.
* Use of SharePoint 2010 and TFS to store all the related work and report the same by creating
Tasks in TFS
Environment: SQL Server 2014/2012/2008R2/2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB
Script, Tableau, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, MOSS 2007, MS Project, MS
Access 2008 & Windows Server 2008, Oracle.
08/2013
-
06/2015
Jr. Developer (SSIS, SSRS)
Zostel
Zostel is one of the largest networks of backpackers' hostels founded in India, and one of the
country's first. The chain of hostels has presence across 36 locations in India and Nepal
Responsibilities:
* Involved in complete Software Development Life Cycle (SDLC).
* Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005
and Flat files.
* Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting
process, issues and errors using SQL Server Integration Services (SSIS) 2008.
* Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and
executing the packages in both the environments (Development and Production).
* Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and
Fuzzy Lookups etc.
* Implemented Event Handlers and Error Handling in SSIS packages.
* Created SSIS packages for Data Conversion using data conversion transformation.
* Configured the loading of data into slowly changing dimensions using slowly Changing Dimension
Wizard. Also implemented checksum SCD method to load the data into date warehouse.
* Wrote T-SQL queries using inner join, outer join, and self joins, merge join. And also
implemented functionality for removing duplicate records like using CTE and ranking function.
* Use Window azure to deploy the application on cloud and managing the session. Worked on Azure
Data Factory for Extract & Load data.
* Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow
Manager.
* Experience on extracting data from Azure HDInsight and publish the transformed data into
AzureSQL Data Warehouse and build reports on BI platform.
* Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake
schema.
* Calculated measures and dimension members using multi-dimensional expression (MDX).
* Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing
Dimensions, Hierarchies and adding the Aggregations to the Cube.
* Created reports using stored procedure and Experience in building Reports on Analysis Services
cubes.
* Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point
Server and published them Via Microsoft Office Share point Server (MOSS).
* Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
* Developed a High level dashboard using SSRS 2008.
* Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
* Involved in upgrading from SQL Server 2005 to SQL Server 2008.
* Responsible for writing T-SQL code for creating cursor and handling data validations.
Environment: SQL Server 2008/2005 Enterprise Edition, T-SQL, SQL Server Business Intelligence
Development Studio (SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual
Source Safe and Windows Server 2003.
country's first. The chain of hostels has presence across 36 locations in India and Nepal
Responsibilities:
* Involved in complete Software Development Life Cycle (SDLC).
* Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005
and Flat files.
* Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting
process, issues and errors using SQL Server Integration Services (SSIS) 2008.
* Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and
executing the packages in both the environments (Development and Production).
* Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and
Fuzzy Lookups etc.
* Implemented Event Handlers and Error Handling in SSIS packages.
* Created SSIS packages for Data Conversion using data conversion transformation.
* Configured the loading of data into slowly changing dimensions using slowly Changing Dimension
Wizard. Also implemented checksum SCD method to load the data into date warehouse.
* Wrote T-SQL queries using inner join, outer join, and self joins, merge join. And also
implemented functionality for removing duplicate records like using CTE and ranking function.
* Use Window azure to deploy the application on cloud and managing the session. Worked on Azure
Data Factory for Extract & Load data.
* Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow
Manager.
* Experience on extracting data from Azure HDInsight and publish the transformed data into
AzureSQL Data Warehouse and build reports on BI platform.
* Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake
schema.
* Calculated measures and dimension members using multi-dimensional expression (MDX).
* Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing
Dimensions, Hierarchies and adding the Aggregations to the Cube.
* Created reports using stored procedure and Experience in building Reports on Analysis Services
cubes.
* Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point
Server and published them Via Microsoft Office Share point Server (MOSS).
* Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
* Developed a High level dashboard using SSRS 2008.
* Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
* Involved in upgrading from SQL Server 2005 to SQL Server 2008.
* Responsible for writing T-SQL code for creating cursor and handling data validations.
Environment: SQL Server 2008/2005 Enterprise Edition, T-SQL, SQL Server Business Intelligence
Development Studio (SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual
Source Safe and Windows Server 2003.
Local Availability
Only available in these countries:
USA
