Ms Ssis/ssrs Developer Resume
NY
SUMMARY
- 5+ years of experience in Data Design and Development on Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005, T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
- Hands on experience in complex Stored Procedures, Views, effective functions, Constraints, Querying, Joins, Keys, Indexes and appropriate Triggers to assist efficient data manipulation and data consistency.
- Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
- Worked on performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
- Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
- Experienced in writing Parameterized Queries for generating reports, Formatting report layout, reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008R2/2012.
- Extracted, transformed and loaded data from various heterogeneous data sources and destinations using several SSIS components.
- Experience in Error and Event Handling, Logging for SSIS Packages.
- Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Query execution plan etc.
- Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
- Extensive experience in creating several reports such as Drill Down Reports, Parameterized Reports, Linked Reports, Sub Reports, Matrix Reports and Chart reports using SQL Server Reporting Services/Crystal Reports.
- Worked on building cubes by defining Partitions, aggregations and Key Performance Indicators using SQL Server Analysis Services (SSAS).
- Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
- Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
TECHNICAL SKILLS
Databases: MS SQL Server 2014, 2012, 2008 R2, 2008, Oracle, MS Access
OLAP/Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), MDX, SAP BI 4.0/4.2, Power BI, Tableau.
ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica.
Other Tools: Microsoft Office, MS Visio, JIRA, Business Intelligence Development Studio(BIDS)
Programming languages: SQL, PL/SQL, T-SQL, COBOL, C#, VB Script.
Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling
Operating Systems: UNIX(Solaris/Linux/AIX), TFS
PROFESSIONAL EXPERIENCE
Confidential, NY
MS SSIS/SSRS Developer
Responsibilities:
- Worked with Business to understand requirements and actively participated in building data warehouse by getting data from multiple sources.
- Involved in upgrading from SQL server 2008 R2 to SQL server 2012.
- Used Informatica as Data Integration and Data Migration tool.
- Loaded Data ware House Fact Tables and Dimension tables of type 1 and type 2 attributes using SSIS Transformations like Lookup, Merge Join with Conditional Split and also using T-SQL 2008 Merge Statement.
- Prepare statistics and other related material to enhance the quarterly sales.
- Used source analysis and reporting requirements to formulate ETL architecture with Informatica.
- Created complex SSIS Packages to extract data from Oracle, SQL Server, excel files, flat files then transform and load into data warehouse.
- Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
- Involved in the development of enhancements using PL/SQL and COBOL.
- Used XML Configuration and Environment Variables to deploy SSIS packages without modifications across different environments.
- Created a stored procedure template combined with HTML, to create easy reports reducing the work time on SSRS.
- Created multiple views of reports using Power BI.
- Designed and deployed several SSRS reports such as Drill down reports, Drill through reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports, linked reports, Sub reports.
- Worked on ad hoc queries and reports to support information requests of the business
- Created joins and sub-queries for complex queries involving multiple tables. Generated matrix reports, tabular reports, drill down, drill through, sub reports and multi-parameterized reports.
- Performed modifications to SQL code used to deliver data to downstream application interfaces.
- Demonstrated solid SSRS and SQL skills to coordinate changes to existing reports and develop new intraday and batch reports needed.
- Developed dashboards using calculations, parameters, calculated fields and hierarchies in tableau.
- Created different parameterized reports consisting of report criteria in various reports to minimize the report execution time and to limit the no of records required.
- Worked on creating and maintaining SSAS Databases which includes creating new cubes, dimensions, and calculated measures, partitioning and building MDX queries.
- Developed SSRS reports to pull data from cubes.
- Developed scripts to create and schedule jobs using SQL server agent, Monitored production jobs by designing alerts on failure.
- Performed conversions on SAP Business Objects universes and reports from 4.0 to 4.2
- Unit tested migrated reports and universes and performed issue resolution during UAT.
Environment: SQL Server Management Studio 2008R2/2012/2014, Microsoft Visual Studio 2008/2012, Informatica 9.5.1, SSAS, SSRS, SSIS, Tableau, SAP Business Objects.
Confidential, Charlotte NC
SQL Developer
Responsibilities:
- Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2008/2012 and flat files.
- Responsible for creating and modifying T-SQL stored procedures/triggers for validating the integrity of the data.
- Created indexed views, and appropriate indexes to reduce the running time for complex queries.
- Monitoring logs to ensure the completeness of batch processes, scripts and processes. Created linked servers to connect OLE DB data sources and providers.
- Used basic Script Task for renaming the file names, storing row count values into User Variables.
- Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from and to various RDBMS and Non-RDBMS sources and destinations.
- Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.
- Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Look-up, Conditional Split, Merge Join, Multicast, Union All, Derived Column, Data Conversion, For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, and Precedence Constraint) to achieve business requirements.
- Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
- Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS).
- Collected detailed requirements and created SSRS templates.
- Designed and developed several enterprise reports (SSRS/Crystal Reports) using the data from ETL Loads and heterogeneous sources.
- Created different parameterized reports for operational purposes based on the reporting criteria.
- Created Matrix reports for the management to have high level of knowledge on different categories in any specific period.
- Designed and developed multiple reports such as Ad-hoc, Drill Down, Drill Through, Sub-Reports, Linked Reports, including stylish Graphs and Charts.
- Blended data from multiple data sets by using linking feature in Tableau Desktop.
- Generated reports using different Variables, Expressions and Functions using SSRS 2008 R2.
- Deployed generated reports each week, month and Quarter into the Report Server allowing users to access reports through browser.
Environment: T-SQL, MS SQL Server 2008 R2, MS SQL Server Integration Services 2008 R2, MS SQL Server Reporting services 2008 R2, Tableau, Visual Studio 2008, Windows XP, MS Office 2010.
Confidential, KY
SSRS/SSIS Developer
Responsibilities:
- Installed and Configured SQL Server 2008.
- Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
- Performance Monitor to track the size of your SQL Server database transaction logs and set up alerts to notify the server before the transaction log fills, thus averting problems that might otherwise seriously affect users and applications.
- Created Stored Procedures, Triggers, Functions, client specific Views for the Application. Extensive testing on the Performance of the Stored Procedures.
- Optimized SQL queries for efficiency and provided queries and procedures for the front-end application.
- Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.
- Created ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
- Converted existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
- Generated reports with dynamic grouping and dynamic sorting as well as running values.
- Migrated DTS packages from SQL Server 2005 to SQL Server 2008.
- Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions etc. for better performance during package execution.
- Scheduled SSIS Packages for loading Facts and Dimensions.
Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, ETL, DTS, Performance Point Server, ASP.Net, C#, Visio 2008, SQL Server Query Analyzer, SQL Profiler,, MS Access.
Confidential
SQL Developer
Responsibilities:
- Performed data migration from SQL server 2005 to SQL Server 2008.
- Created SSRS reports for the provider and vendor and making sure the payments were processed correctly
- Performed data conversion from flat files into a normalized data structure.
- Defined many constraints, indexes and views.
- Scheduled multiple jobs for SSIS packages and which performed integration from different flat files/excel files into the database.
- Worked on backup of master and system databases and restored them whenever necessary.
- Created SSIS packages to validate, extract, transform and load data into the database and make necessary actions by keeping the stored procedures in the execute SQL tasks.
- Executed data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
- Worked in Agile development methodology environment.
- Worked on normalizing the data by making sure there is no redundancy over multiple tables and placed them in a single table.
- Applied necessary indexes based on the execution plan.
Environment: Visual Studio 2005, MS SQL Server 2005/2008/2008 R2 SQL Server 2005/2008, SSRS 2005, SSIS 2005, BIDS, MS Visio.
