Sr.ms/sql Ssrs Reports Developer Resume
IL
SUMMARY
- 8+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2005/2008/2008 R2/2012.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2 and 2012).
- Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
- Expertise in SQL Server 2005 Reporting Services (SSRS), SQL Server 2005 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
- Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
- Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
- Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
- Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
- Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
- Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
- Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
- Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012
- Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
- Strong experience with T-SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
- Ability to work in all stages of System Development Life Cycle (SDLC).
- Experience in Error handling and debugging coding issues and troubleshoot production problems.
- Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
- Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
- Experience in .NET/C# application development environment to use SQL Server Databases.
- Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
- Experience in working with Database setup, partitions and maintenance.
- Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services..
- Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
- Experience in managing large data sets on MS Excel 2013
- Provided application security support for SQL applications with ADO.NET
- Skilled in design of logical and physical data modeling using Erwin data modeling tool.
- Worked with Business Analysts, Web development team, and users on database solutions.
TECHNICAL SKILLS
Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, XML, HTML, Visual Basic 6.0
Databases: MS SQL Server, 2012,2008R2,2008,2005, MS Access
DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.
Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007
Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, Microsoft Office, Excel Power Pivot, Excel Data Explorer, Tableau.
Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.
PROFESSIONAL EXPERIENCE
Confidential, IL
Sr.MS/SQL SSRS Reports Developer
Responsibilities:
- CreatedViewsto restrict access to data ina table.
- Optimized the database by creating variousclustered, non-clustered indexes.
- DevelopedETL jobsto load information intoData Warehousefrom differentrelational databasesandflat files.
- ConfigureSSISPackage for run time Parameters and Configuration file.
- Developed some scripts in C#.Net used in ETL Process that works as transformation.
- Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
- Used variousSSIStaskssuch asConditional Split, Derived Column, which were used forData Scrubbing, data validationchecksduring Staging, before loading the data into theData warehouse.
- Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP
- Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services.
- Actively participated ininteraction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
- CreatedETL metadata reportsusing SSRS, reports include like execution times for the SSISpackages, Failure reports with error description.
- Developed an automated report subscription process usingSSRS.
- Involved inReport Design and Coding for StandardTabular type reports,includingDrill downandDrill throughfunctionality and Graphical presentations such asChartsusingSSRS.
- CreatedStored ProceduresandT-SQLcodefor complex business logic.
- Implemented cell level security in cubes to restrict users of one region viewing data of another region using SSAS.
- Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.
- Worked with Installation/Management of MS Team Foundation Server and TFS Migration processes
- Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa
- ImplementedType 2Slowly Changing Dimensionto maintain Dimension History.
- Worked extensively withSlowly Changing Dimensionandlookup Transformationfor implementingInsertsandUpdates.
- CreatedSSISpackagesto load data intoData Warehouseusing Various SSISTasks likeExecuteSQLTask, bulk insert task, data flow task, file system task.
- CreatedSummary Reports, Sub Reports, and Drill-down ReportsusingSSRS.
- Designed and developedmatrix and tabular reportswithdrill down, drill throughusingSSRS.
- Scheduled reports fordaily, weekly, monthly reportsfor executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL ServerReporting services (SSRS).
Environment: MS SQL Server 2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, C#, ASP.Net, Informatica, MDX, Shell Scripting, DTS, MS Visio, UDB, Erwin.
Confidential, Jersey City, NJ
Sr.MS SQL/BI Developer
Responsibilities:
- Gathered user requirements to develop the business logic and analyzed and designed database solutions.
- Defined Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each Vendor system interfacing with the High Point system.
- Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in MS SQL Server 2008.
- Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.
- Generated SQL Server Database objects including Tables, Views and Indexes.
- Created and modified stored procedures, triggers and queries for automating various interface tasks using T-SQL.
- Analyze and Created SSAS cube and set up role based security in the cube.
- Defined Testing strategies and designed Test Plans to test each system Interface output and validated output data from each Interface based on respective Test Plans.
- Ensured the quality of the output for each system Interface by conducting Meetings with the respective vendors to review the output and obtain continuous feedback.
- Identified and defined Key Performance indicators (KPIs) for vendor reporting.
- Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
- Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
- Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
- Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
- Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
- Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
- Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
- Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
- Supports the development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.
Environment: SQL Server 2008, Microsoft SQL Server Enterprise Manager,SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft Data Transformation Services (DTS) Query Analyzer, T-SQL, Microsoft Visio Professional 2002, SQL Profiler, Microsoft BI, Microsoft SSAS, Microsoft SSRS, Microsoft SSIS, Transact-SQL, Microsoft BIDS, Microsoft Visual Studio, Power Pivot, DAX, Pro Clarity, BI architecture, Cosmos, Dashboard, Microsoft Performance Point, Nintex, PPS, Stsadm, Caml, Enterprise search, Power View, Visualization, Microsoft technologies BIA, MDS, KPI, MDX, MaxL, Slowly changing dimensions, ESSCMD, BSO, Essbase
Confidential, SAINT LOUIS MO
Sr.MS/SQL SSRS Reports Developer
Responsibilities:
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
- DDL Scripts for generating Tables, Views, Functions.
- Analyzed and designed software and database solutions.
- Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
- Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
- Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
- Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
- Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
- Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
- Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Configured Reporting Services in SQL Server 2008.
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
- Created different Power Pivot reports as per the client requirement.
- A web-based dynamic product registration and tracking system linked through ODBC to corporate DBMS.
- Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
- Created checks and constraints to maintain data integrity.
- Migrated and resolved conversion errors for Performance Point Server reports to Share point 2010 Business Intelligence platform.
- Resolved significant PPS connection string issues with import process.
- Used Tableau to visually analyze data and create concise and actionable dashboards.
- Created visually compelling and actionable interactive reports and dashboards.
- Created backup scripts to take periodic backups for the content on Tableau server.
- Provided DBA assistance in Share point 2007 to Share point 2010 conversion.
- Worked with Business Analysts, Developers and customers to resolve and escalate project issues.
- Gathered the business system requirements and act as a SME for the system and business and created status reports.
- Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.
Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012 , TSQL, Visual Studio 2008,Oracle, SSRS, SSIS, Erwin.
Confidential
Sr.MS SQL/BI Developer
Responsibilities:
- Managed the migration of SQL Server 2000 databases to SQL Server 2005
- Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
- Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
- Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
- Developed various operational, drill-through and drill-down reports using SSRS.
- Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
- Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
- Involved in the Data modeling, Physical Design of Database using tools like Erwin.
- Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.
- Performing Replication (snapshot and transactional).
- Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
- Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005 Analysis Services.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
- Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
- Configured replication servers and transactional replication between production & standby server for disaster recovery
- Created calculated measures and dimension members using multi-dimensional expression (MDX).
- Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
Environment: SQL Server 2000/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Oracle 9i/8i, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access.
Confidential
MS SQL BI Developer
Responsibilities:
- Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
- Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
- Deployed SSIS packages and Reports to Production Servers.
- Upgraded databases from SQL Server 2000 to SQL Server 2005.
- Responsible for the design and development of .Net web applications for firm's Solutions.
- Migrated data using ETL Tool in SSIS.
- Maintained system monitoring jobs and provide high availability support.
- Created partition table for very large database for good performance.
- Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
- Participated Databases Architecture and data Modoling design.
- Performing DBA functions, installing, configuring and supporting database systems.
- Reported all events and requirements through established reporting mechanisms in SSRS.
- Fully supported change management procedures.
- Reviewed and developed data models and database designs with development teams
- Wrote store procedures for some job automations.
- Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
- Experience in testing to rename the table to a temporary table by using sp rename.
- Experience in creating new table script to test the existing table.
- Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
- Designed and developed OLAP using MS SQL Server Analysis Services
- Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
- In charge of converting data using SQL Server 2005 using SSIS.
Environment: MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services 2005, C#, ASP.NET,VB.NET, OLAP, Erwin, DTS/SSIS,BIDS
Confidential
SQL Server Developer
Responsibilities:
- Createdpartition tablefor very large database for good performance.
- Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
- Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL andDTS/SSIS
- DeployedSSISpackages and Reports to Production Servers.
- Migrated data using ETL Tool inSSIS.
- Maintained system monitoring jobs and providehigh availability support.
- Worked on Migration of packages from DTS usingSQL Server Integration Service (SSIS).
- ParticipatedDatabases Architectureanddata modelingdesign.
- Performing DBA functions, installing, configuring and supporting database systems.
- Reported all events and requirements through established reporting mechanisms inSSRS.
- Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
- Designed and developedMS SQL ServerReporting Services(SSRS)under SQL Server 2005
- Reviewed and developeddata models and database designswith development teams
- Wrotestore proceduresfor some job automations.
- Generated test data andtested databaseto meet the functionalities deliverables in the project documentation and specifications.
- Involved in creation of Data warehouse Cubes inSQL Server Analysis Service (SSAS).
- Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).
Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity,C#,ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.