Ms Sql Server / Ssis / Ssrs Developer Resume
Providence, RI
PROFESSIONAL SUMMARY:
- Around 8 years of experience as SQL Developer, MSBI experience in analysis, design, development and implementation of application.
- Excellent understanding of full Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
- Expertise in Business Intelligence in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
- Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
- Experienced in creating complex SSIS and DTS packages for ETL purposes.
- Implemented complicated transformations to be used in SSIS packages.
- Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
- Proficient in Developing various complex DTS/ETL packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data, SQL server 2005/2008/2012 by using multiple transformations provided by SSIS.
- Developed ETL process using SSIS with various data flow, control flow and stored procedures for work order validation process.
- Experienced in working with Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, multicast, and Derived column, Union All, Merge Join, Merge and SCD to load data into SQL Server destination.
- Expertise in For Loop, for each Loop and Sequence Containers and other common transformations like Audit, Cache, Fuzzy Grouping, Fuzzy lookup, Pivot and Un - Pivot.
- Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS.
- Designing and Deployment of Reports for the End-User requests using Report Models & SSRS
- Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Drill down Reports, Drill Through, Maps, Chats using SSRS. Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, Sub-Reports and navigation of reports etc.
- Managed Alerts for successful or unsuccessful completion of Scheduled Jobs in SSRS.
- Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
- Experienced in using T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
- Have Good communication and Interpersonal skills, hardworking, dedication at work and result oriented as an individual and in a team.
TECHNICAL SKILLS:
DBMS & RDBMS: SQL Server 2005/2008/2012, ORACLE i9/10g, Ms-Access, MySQL, DB2
Languages: C, T-SQL, C#, VB.NET, SQL, HTML,XML
Operating Systems: Windows 2008/2012 R2 Advanced Server, NT & Windows 9x, Linux, Unix
SQL Server Tools: Business Intelligence Development Studios(BIDS), SQL Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard
ETL Tools: SQL Server Integration Services(SSIS)
OLAP Tools: SQL Server Analysis Services(SSAS)
Reporting Tools: SQL Server Reporting Services(SSRS), MS Excel
Other Tools: Visual Studios, MS office, Visio Word, Outlook
WORK EXPERIENCE:
Confidential, Providence, RI
MS SQL Server / SSIS / SSRS Developer
Responsibilities:
- Gathered requirements from the business users, created technical specification documents.
- Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2005/2008.
- Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse.
- Installed MS SQL Server 2008 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server 2005/2008 R2.
- Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005).
- Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005/2008 R2.
- Involved in setting up and implementation of the 2005/2008 reporting server.
- Created complex reports using SSRS 2005/2008 R2 from the OLAP cubes for end user analysis.
- Migrated reports from MS SQL Server Reporting Services R2.
- Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2005/2008 R2 using data from a variety of sources.
- Wrote T-SQL queries, Store Procedures and used them to build packages.
- Scheduled the reports on capacity levels of different servers to run on daily/weekly/monthly basis and email the results to the business users in the required format.
- Scheduled tasks to run every day to update changes in the base tables.
- Added/modified Users, Groups, folders and rights.
- Designed and implemented Stored Procedures and Triggers for automating tasks.
- Managed all indexing, debugging, optimization and performance tuning using T-SQL.
- Created/modified SQL Joins, sub-queries, and other T-SQL and PL/SQL code to implement business rules.
Environment: Microsoft SQL Server 2005 and SQL server 2008R2, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, Business Objects, Windows Server, MS Visio, Oracle 9i, MS Excel.
Confidential, Manalapan, NJ
SQL BI Developer
Responsibilities:
- Participated in requirement gathering, cube design, application design and SSAS development.
- Constructed cubes based on data volumes mostly adhering to Star Schema.
- Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
- Implemented SQL Server OLAP services (SSAS) for building the data cubes.
- Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data.
- Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
- Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
- Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
- Designed and implemented fact, dimensions and SSAS cubes using dimensional data modelling standards in SQL server 2012/ Business intelligence development studio.
- Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
- Created and designed SSAS cube and promoted to production using XMLA scripts.
- Designed and implemented parameterized, drill-through, drill-down, and tabular reports on SSRS using SSAS cube for performance point.
- Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
- Created and scheduled SSIS package to nightly process the SSAS cube based on oracle data mart tables updates.
- Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.
- Implemented/Developed multi parameterized reports in Report Builder and SSRS using SSAS cube allowing users to make selections before executing the reports and making it more users friendly.
- Worked with SQL profiler to improve and enhance the MDX query execution time as a part of performance tuning process.
- Wrote several complex stored procedures for efficient handling of the application.
- Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012.
- Involved in the designing, development, modification and enhancing the database structures and database objects.
Environment: s: SQL Server 2012/2008 R2, T-SQL, SSRS, SSAS, SSIS, MS Visio, performance point services, Power Pivot, Report Builder, Excel, and Windows.
Confidential, New York, NY
MS SQL Server / SSIS / SSRS Developer
Responsibilities:
- Created Stored Procedures, Functions and Triggers using TSQL to migrate the data.
- Created SSIS packages to clean the incoming data including address and to find out if the address is valid or not.
- Performed data analysis and designed source to destination mapping.
- Involved in migration of data from main frame server to SQL Server database using Target Adapter.
- Designed and developed Matrix and Tabular reports with Drill Down, Drill Through, Parameterized, Sub Reports and Drop down menu option using SSRS 2005.
- Developed reports with Charts and Multiple Datasets using Reporting Services (SSRS).
- Created reports that included formatting options such as Grouping, Sorting, Parameter prompts.
- Created a stored procedure to automate the execution of all the stored procedures and to schedule the jobs.
- Installed SQL Server, applied service packs and hot fixes.
- Developed SSIS packages not only for Initial Data Loads but also for incremental/delta load.
- Created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
- Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically
- Performed tasks like Backup, Restore, Data Profiling using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler and SQL Server agent.
- Created .Net windows application to display all the data from different tables in grid view based on the search.
- Used Merge Join extensively to load the data from production database to operational database and to perform basic de duplication.
- Involved in writing functional specification document that has all the details of the work done to migrate the data
Environment: Microsoft SQL Server 2005, T-SQL, SSIS, SSRS, BI studio 2005, Windows server 2003, Visual Source Safe, Visual Studio 2008, Erwin.
Confidential
SQL Server/SSIS/SSRS Developer
Responsibilities:
- Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs.
- Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.
- Designed and Developed SSIS Packages to import and export data from MS Excel, XML, SQL Server 2008, Flat files, DB2 and used SSIS Package Configuration, Expressions, passing variables dynamically, logging, Event Handler.
- Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.
- Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
- Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
- Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
- Integrated SQL Server 2005 reporting services (SSRS) with Microsoft Office Share point Server to automatically deliver reports to the Share Point portal.
- Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
- Created Drill-through reports, parameterized reports and linked reports using SSRS and were integrated in the Performance point server.
- Creating and maintaining various subscriptions in the Report Manager for the reports.
- Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.
Environment: MS SQL Server 2008R2, SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio, Team Foundation Server, C#, Visual Source Safe (VSS), Oracle, Pl/SQL, Share Point, MS Project, MS Access 2003/2007.
Confidential
SQL Developer
Responsibilities:
- Well versed in all phases of the Software Testing Life Cycle (STLC), software Development Life Cycle (SDLC), Waterfall model, V-model, and Agile.
- Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.
- Verified process flow by writing and executing SQL queries and stored procedures using Oracle SQL.
- Usage of new compression Techniques in SQL Server 2008 R2 for Backup and Restore Jobs.
- Implemented Database Mirroring and Transactional Replication as a part of DR plan.
- Strong experience in Data warehousing and ETL using Informatica Power Center 9.
- Well versed in developing the complex SQL queries, unions, and multiple table joins and experience with views.
- Advanced in Linux System. Develop workflows using task developer and workflow designer and monitored the results using workflow monitor.
- Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
- Creating and Maintaining Database Maintenance Plans.
- Modified Stored Procedures and complex T-SQL Queries to improve query execution process.
- Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
- Tune slow running queries using SQL Server Profiler.
- Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
- Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
- Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
- Created Clustered and Non-Clustered Indexes to improve the performance of database access.
- Created and managed databases across Development and Production instances using SQL Server Management Studio.
- Involved in Capacity Planning, Database Normalization and De-normalization process.
- Involved in Logical and Physical Data Modelling Process using MS Visio.
- Use MS Visual Source Safe as a Version Control System.
- Involved in Change Data Capture process.
- Monitoring Event Viewer, SQL Error Logs and Log File Viewer for Software and hardware related errors.
Environment: Microsoft SQL Server 2008/2008 R2/2005, MS Windows Server, MS Visual Source Safe, IIS, XML.