SSRS Developer Resume

SUMMARY

4+ years of IT experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data mart design, OLAP/OLTP and client /server applications
Experienced with all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, and production supporting on various platforms like UNIX, Window XP/7
Experience in gathering, analyzing and documenting business requirements, functional requirements, designing and developing the mapping based on the requirements
Experience in managing complex data sets including maintenance.
Strong knowledge with Microsoft Office Tool (Excel, Access, PowerPoint, Word).
Strong knowledge of Power BI Desktop.
Experience with data manipulation and analysis using SQL Server Reporting Services (SSRS).
Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reportsSSRS.
Configured and deployed SSRS reports to Share point.
Created packages inSSIS with error handling.
Great knowledge of SSIS Workflows.
Strong knowledge on RDBMS concept, Data mart, Star Schema and Snow Flake Schema modeling, data modeling, Fact tables and Dimensional tables.
Provide support and problem resolution for reporting and application issues
Experience in writing complex SQL queries, and stored procedures.
Great Knowledge of ETL Tools and Technologies via SQL Server Integration Services (SSIS), Informatica and Informatica Client tools
Experience in writing complex SQL queries involving multiple table's inner and outer joins, stored procedures.
Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs usingSSRSinBusiness intelligence development studio BIDS.
Strong knowledge of Power BI.
Understanding of PowerView, PowerQuery and PowerMap.
Great knowledge of J2EE, JDBC, JSP and ASP.
Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
Created bar and line charts and matrix reports usingSSRS
Experience in creating complex Stored Procedures and T - SQL Queries in SQL-Server.
Eager to accept new challenges with an attention to detail and can adapt readily to the demands of the job.
Excellent record in meeting deadlines and ability to handle multiple projects simultaneously.
Analytical and Technical aptitude with the ability to solve complex problems
Strong interpersonal skills with ability to interact with end-users, managers and technical personnel.
Involved in Unit Testing, Integration testing and QA Validation.

TECHNICAL SKILLS

ETL Tools: SQL Server Integration Services (Visual Studio 2017/2015/2012/2008 )

Reporting Tools: SQL Server Reporting Services (2015/2012/2008 R2), SQL server management studio 2018

RDBMS: SQL Server 2017/2015, SQL Server 2008/2005

Operating Systems: WINDOWS 7/XP/2000/98

Office Applications: Microsoft Word, Excel, Access, Project, Power Point (2003/2007/2010 )

PROFESSIONAL EXPERIENCE

SSRS Developer

Confidential

Responsibilities:

Involved in interacting with Business Analyst, Senior Team Members and End Users in analyzing the requirements
Creating End to End Design and Solution for the Delivery Dashboard with the refresh rate of every 5 minutes.
Implementing Reports, Documents and Creating Automatic Subscriptions in MSTR.
Supporting the System 24x7 and being on top of issues by giving up-to date solutions.

Environment: SQL-Server as Database. Microstrategy and SSRS 2012, SQL Agent for Scheduling Jobs. SQL-Server Management Studio 2014

SSRS Developer

Confidential

Responsibilities:

Interacted with end users inidentifying the requirementsand developed a detailed design document including technical specification.
Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files.
Interacted in weekly meetings with IT Manager to give status updates on projects.
Optimal utilization of object-reusability features like reusable transformations, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
Involved in creating Sessions, Tasks, Workflows and worklets using Workflow manager.
Worked with Data modeler in developing STAR Schemas
Involved in performance tuning and query optimization.
Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.
Responsible for monitoring sessions that are running, scheduled, completed and failed.

Environment: Informatica 5.x/6.x as ETL Tool. Oracle 9i, MS-Access, SQL Server 2008, MS Access 2010, SQL*Loader, SQL, PL/SQL, Windows XP.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship