We provide IT Staff Augmentation Services!

Sr. Sql Ssis/ssrs Developer Resume

Boston, MA

SUMMARY:

  • Over 8 years of experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Extract Transform Load (ETL) and Data Transformation Services (DTS).
  • Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL Server 2000/2005/2008 .
  • Expert in all areas of SQL Server development including tables, user functions, views, indexes, stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
  • Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
  • Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
  • Expertise in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
  • 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.
  • Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill down, Top N, Summary and Sub reports and formatting them.
  • Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS 2005.
  • Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
  • Experience in code optimization and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
  • Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance
  • Expert in working with SSIS for creating packages to transform data from different OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL
  • Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
  • Experience in implementing different types of Replication models like Snapshot, Merge, Transactional and Peer to Peer.
  • Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
  • Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
  • Good experience building star schema and snowflake schema depending on the business data requirements.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

SQL Server Tool: Enterprise Manager, Profiler, Query Analyzer, DTS, SSIS, SSRS, SSAS.

RDBMS: MS SQL Server 2000/2005, MS Access

Data Modeling: Erwin

ETL: DTS, SSIS

Programming Languages: T-SQL, VB scripts, C, Java

Application Development: HTML, XML, CSS, .NET, C#

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating Systems: Windows 2003 Advanced Server/Windows 95/98/200/XP-pro, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. SQL SSIS/SSRS Developer

Responsibilities:

  • Created ETL to load transactional data to GameStop Data Warehouse and built analysis services database to provide summarized data to Targit client for dashboards.
  • Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
  • Created custom Measure groups (calculated members) in cube to implement business logic
  • Worked on an In-Built ETL Tool METAL for developing Complex SSIS packages
  • Designed and deployed SSAS cube for reporting P&L's in an effective and efficient way to users and to overcome the drawbacks of excel pivots.
  • Created scopes in the cube to provide flexibility for users to see revenue in their local currencies.
  • Created roles and implemented security at department level to allow/restrict users to view data depending on the departments they belong to.
  • Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
  • Created dimensions in the performance point server.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Imported data into performance point server from relational database through csv files
  • Consolidated data from OLTP databases in to OLAP using SSIS as ETL.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load
  • Created parameterized stored procedures to implement business logic.
  • Created reports using SSRS from various sources like SQL Server 2005/2008 and Cubes from Analysis Services
  • Created views on database for better performance and security.
  • Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server.
  • Created SQL jobs and scheduled them for nightly loads.
  • Created SSIS package to get data from Sharepoint and load Cubes.
  • Implemented pre-validation and post-validation for the data imports.
  • Created archival jobs to archive last # iterations of data.
  • Extensively used Event Handlers and Error Handling in SSIS packages and notified process results to various users using send email Task
  • Tuned the performance by making use of clustered and non-clustered indexes.
  • Published reports to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
  • Monitor SQL Error logs /schedule tasks/database activity/eliminate blocking & deadlocks /user counts and connections/locks etc.
  • Report writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 9.0
  • Performing query plans and making sure each and every query is using appropriate useful indexes.
  • Used SQL profiler for monitoring memory, processor, Disk I/O, SQL Queries.

Environment: SQL Server 7.0/2008/2005 Enterprise Edition, Visual Studio 2005,DB2, AS400, Microsoft Visual Basic, SSAS,VBScript, XML, Microsoft Visio, Windows 2003 R2,, Reporting Services (SSRS 2005/2008), Integration Services (SSIS 2005/2008), MS Office 2007, DQ Analyzer, MS Access.

Confidential, Fairfax, VA

Sr. SQL SSIS/SSRS Developer

Responsibilities:

  • Wrote complex stored procedure, queries, triggers, functions, indexes, user-defined functions and cursors for the application.
  • Created SSIS packages using SSIS designer for export heterogeneous data from OLE DB source (Oracle), Excel spreadsheet to SQL Server 2005.
  • Created the cubes and dimensions. Also defined relationships between measure groups and dimensions.
  • Implemented the calculations to aggregate physical measures.
  • Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
  • Created different Parameterized Reports (SSRS 2000/2005/2008 ) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
  • Used SSAS MDX to extract data from cubes and created MDX script for representing cube calculations.
  • Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created partitions (employed storage modes and usage based optimization), calculated members, KPI's and perspectives to enhance the cube's utilization. Also used MDX to query them.
  • Involved in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and developed Cubes using the identified Fact and dimension tables in SSAS
  • Worked with SQL Server Analysis Services (SSAS) that delivers Online Analytical Processing (OLAP) and data mining functionality for business intelligence applications
  • Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager
  • Developed, monitored, deployed, scheduling jobs, alerting and maintaining SSIS packages
  • Conceptualized and designed logical and physical data models using ERWIN.
  • Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files

Environment: MS SQL Server 2005 Enterprise Edition, MS Analysis Services 2005, Analysis Services 2000, MS Access, SSIS, Erwin 4.1, Windows XP Professional, SQL Sentry, Net Backup, SQL Server Profiler, Import/Export Wizard. VB and ASP.NET

Confidential, Chicago, IL

SQL SSIS/SSRS Developer

Responsibilities:

  • Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development standards and conventions
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Developed data mart using Star schema. Reviewed the current data mart and OLAP cubes, proposed corrections and enhancements.
  • Developed new mappings using SSIS look up, aggregation, transformations to meet the business case.
  • Ran Informatica sessions and batches using UNIX Shell script.
  • Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
  • Created DTS Packages and converted DTS packages to SSIS 2005
  • Created DTSX packages to import and export data from Excel spreadsheets, PeopleSoft and text files.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Developed, monitored and deployed SSIS packages, also responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages
  • Experience in Report Builder in SSRS 2005 and 2008. Involved in migration and Conversion of Reports from SSRS .
  • Used SSAS MDX to extract data from cubes and created MDX script for representing Cube calculation.
  • Used SSRS report catalog to store the configuration, security and caching information for the report server.
  • Delivered the final SSRS report using the request handler.
  • Created Tabular, Charts, graphs and sub reports etc as per customer requirements using SSRS
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Involved in development & deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.

Environment: SQL Server 2005 Enterprise Edition, Informatica 7.1.2, Oracle 9i, Teradata, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Windows 2003, IIS 5.0, MOSS, Microsoft Reporting Service, BO XI R2.

Confidential, Everett, MA

SQL SSIS/SSRS Developer

Responsibilities:

  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
  • Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
  • Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
  • Converted data types using derived column and data conversion transformation.
  • Developed SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs)
  • Generated complex custom Reports using SSRS 2008 as per the customer requirement
  • Created SSIS Packages for incremental loading and slowly changing dimensions.
  • Developed cubes for reporting based on the business requirements using SSAS 2008
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Used various control flow tasks like FTP, Bulk insert task, Transfer job task, For each container etc and used different data flow tasks in SSIS
  • Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
  • Created SSAS measures, dimensions attribute relationships and hierarchies.
  • Designed SSAS cubes, named calculations for dimensions.
  • Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS 2008/2012.
  • Developed several Complex Reports using SQL Server Reporting Services (SSRS).
  • Identified and Defined Key Performance Indicators in SSAS
  • Generated complex custom Reports using SSRS 2005 as per the customer requirement
  • Created SSRS reports using report parameters, drop-down parameters, multi-valued parameters.
  • Worked with SSIS to import, export and transform the data between the linked servers
  • Experience in using Multi Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards Score Cards

Environment: Microsoft SQL Server 2005, SSIS 2005, SSRS 2005, SSAS 2005, Visual Studio 2005/2008, Microsoft Office Performance Point Server, Planning Business Modeler, Microsoft Office share point 2007, Targit, windows 2003/XP/vista,, .NET Framework, C#, VB, ASP.NET, ADO.NET.

Confidential

SQL SSIS/SSRS Developer

Responsibilities:

  • Developed the billing transaction and integrated with the order processing system which includes order confirmation, deliveries, goods issued and billing.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
  • Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Involved in developing of stored procedures and Functions.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
  • Worked extensively on SSAS storage and partitions, aggregations and calculations.
  • Developed various reports to display orders, deliveries, pending bills from shipped orders and outstanding dues.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
  • Involved in writing SQL, PL/SQL.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Designed SSAS Cube and developed MDX queries for Analysis
  • Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production
  • Performance tuned the existing SSAS cubes in order to minimize the processing time

Environment: Oracle 7.3 Forms 4.5, Reports2.5, PL/SQL and Win NT, Report Builder 2.0 SQL Sentry, Database Engine Tuning Advisor, Windows Event Viewer, SQL Server Configuration manager, SQL Server Profiler, Import/Export Wizard, Crystal Report, Erwin, companion, Idera, TSM/TDP

Hire Now