Ms Sql Server Ssis\ssas Developer Resume
Morristown, NJ
SUMMARY
- Over 10 years of experience in IT Industry as Microsoft SQL Server Business Intelligence Developer in Investment, Finance, Energy, Healthcare, HR, and Insurance.
- Highly experienced in MS SQL Server 2012/2010/2008 R2/2008/2005 Business Intelligence stack MS SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
- Extensively worked on Data Extractions, Transformations, and Loading (ETL) from various data sources like MS - Excel, MS-Access, Oracle, DB2 to MS SQL Server using the Microsoft DTS/SSIS/BCP Utility/Bulk Insert.
- Experience in creating, executing, and deploying SSIS packages as well as in configuring files, Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
- Proficient in generating reports using Crystal Reports and MS Excel. Also have expertise in generating drill down reports, parameterized reports, linked reports, sub reports, Ad-hoc reports, data driven subscription reports, matrix dynamics and filters, charts using SQL Server Reporting Services (SSRS 2000/2005/2008 ).
- Resourceful, highly motivated, and well-organized withdemonstrated ability to structure information, analyze data relationships, and extract meaningful business insights.
- Quick learner and good performer both in team and independent job environments, excellent communication and analytical skills.
TECHNICAL SKILLS
Microsoft BI Toolsets: SQL Server 2012/2010/2008 R2/2008/2005, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS).
Databases: MS SQL Server 2012/2010/2008 R2/2008/2005, MySQL, DBase, MS-Access
Operating Systems: Windows 95/98/NT/ Novell/2000/2003/XP/Vista/2007, UNIX
Microsoft Applications: MS-Office Suite 2003/2007, MS- Project 2003, MS- Visio 2003/2007
Languages: T-SQL, Visual Basic 6.0, C#
PROFESSIONAL EXPERIENCE
Confidential, Morristown, NJ
MS SQL SERVER SSIS\SSAS DEVELOPER
Responsibilities:
- Modify existing ETL/SSIS packages as per the requirement by using different data transformations such as derived column, conditional split, look up, script task etc.
- Using Task Factory transformations (third party tool) for the enhancement in SSIS packages.
- Creating SSIS packages by using SSIS 2008 R2 and SSIS 2010 to extract data from Data warehouse and creating staging tables as well as maintain Data mart.
- Modify existing cubes in SSAS for new enhancement. Deploy xmla for cube changes to all DEV, INT, QA and PROD environment.
- Interacting with business users, upload the new text files as per their requirement and process the cube(SSAS) in QA for the business testing.
- Created views and modified existing views for cube, store procedures, Mapping the tables by using joins, involved in writing T-SQL, triggers, using indexes, constraints and business rules wherever applicable.
- Created error and performance reports on ETL/SSIS packages, Jobs, stored procedures and triggers.
- DeployingSSISpackages from various sources likeBIDS, Management Studio, file systems etc.
- Creating configuration Files, Command Files, Log files and map them to the certain network drive.
- Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
- Using Star Team and Build Forge for maintaining or version controlling for the all the development.
- Scheduling all the SSIS jobs thru third party tool Tivoli. Interacting with Tivoli team for all new SSIS jobs or any update in the schedule for existing SSIS jobs.
Environment: SQL server 2012/2010/2008 R2, BIDS, SSIS 2010
Confidential, Princeton, NJ
MS SQL SERVER SSIS DEVELOPER
Responsibilities:
- Responsible for creating ETL/SSIS packages as ETL tool to extract data from JDE and transfer to SAP for Finance and Human Resources.
- Interacting with finance and HR department to get the proper requirement to extract data from JDE.
- Mapping the tables by using joins, T-SQL, create store procedures.
- Create ETL/SSIS packages by using various data transformations such as look up, merge join, sort, derived columns, union all etc.
- Created error and performance reports on ETL/SSIS packages, Jobs, stored procedures and triggers.
- Modify existing ETL/SSIS packages as per requirement to extract data from JDE
- Extensively used ETL/SSIS Import/Export Wizard, for performing the ETL operations.
- DeployingSSISpackages from various sources likeBIDS, Management Studio, file systems etc.
- Configured the ETL/SSIS Packages usingEnvironment Variables for Dynamic Selection of DevelopmentandProduction Environment
- Schedule the SSIS jobs by using SQL server agent, maintain all the scheduled jobs.
Environment: SQL server 2008, SSIS package, T- SQL, SAP finance/HR
Confidential, NEWARK, NJ
MS SQL SERVER SSRS/SSIS DEVELOPER
Responsibilities:
- Created Crystal reports, SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
- Interacted with Sales and Marketing reps to gather business requirements
- Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
- Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
- Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
- Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
- Used SSRS to format and schedule interactive reports on daily/weekly & monthly basis.
- Worked on with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.
Environment: MS SQL Server 2008,MS SQL Server Integration Services2008, MS SQL Server Analysis Services 2008, MS SQL Server Reporting Services 2008, T-SQL, MS-Excel, XML, Windows 2000/2003/NT/XP
Confidential, Addison, NY
MS SQL Server / SSRS /SSIS Developer
Responsibilities:
- Responsible for creating the reports based on the requirements using SSRS 2005.
- Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
- Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
- Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
- Actively supported business users for change requests.
- Monitored performance and optimized SQL queries for maximum efficiency.
- Identified and defined the Datasets for the report generation.
- Wrote the queries for the drill down reports.
- Planned the complete Back-up of various Databases for Disaster recovery scenarios.
- Identified and added the report parameters.
- Uploaded reports on to the report manager and organized them in folders.
- Delivered the reports using ‘pulled’ and ‘pushed’ methodologies.
- Formatted the reports using the Global variables and expressions.
- Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
- Deployed the generated reports on to the server.
- Fine tuned the database objects and server to ensure efficient data retrieval.
Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2008, ASP.Net, MS Excel, Window XP, Toad
Confidential, FRANKLIN LAKES, NJ
SQL SERVER DEVELOPER / SSRS/SSIS/SSAS DEVELOPER
Responsibilities:
- Participated in designing and developing Data Warehouses, Data marts and cubes in Business Intelligence environment using multi-dimensional models such as Star Schema.
- Used SSIS to create ETL packages to extract, transform and load data to data warehouse databases.
- Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
- Complex business requirements were transformed into ETL's using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, Lookup.
- Defined OLAP cubes based on fact tables and dimension tables to suit a range of report/analysis requirements with SQL Server 2008 Analysis Services (SSAS).
- Constructed Cubes based on data volumes mostly adhering to Star Schema.
- Created Advanced Business Intelligence applications i.e. KPI, Calculation and Storage modes, Aggregation, Perspective and Calculated Measures.
- Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
- Generated very high level SSRS 2008 reports from the OLTP and OLAP cubes.
- Involved in the performance tuning for the OLAP Business Intelligence environment.
Environment: MS SQL Server 2008, MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008, Oracle 9i / 10g, XML, Windows XP, MS Office, Excel 2003/2007
Confidential, New York
SQL DEVELOPER
Responsibilities:
- Responsible for creating reports based on the requirements usingSSRS 2005.
- CreatedSSISPackages usingSSIS Designerforexport heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
- DesignedETL packagesdealing with different data sources (SQL Server, Flat Files, and XMLsetc) and loaded the data into target data sources by performing different kinds of transformations(For loop,bulk insert, Data flow, Data mining, FTP, XML tasks, etc)usingSQL Server Integration Services (SSIS).
- MigratedDTS packagestoSQL Server Integration Services (SSIS)and modified the packages accordingly using the advanced features of SQL Server Integration Service.
- DeployingSSISpackages from various sources likeBIDS, Management Studio, file systems etc.
- Monitored performance andoptimized SQL queriesfor maximum efficiency.
- Converted very complex RPTs ofCrystal Reportsinto RDLs ofSSRSmanually
- Deployed the generated reports on to the server.
- Responsible for scheduling thesubscription reportswith the subscription report wizard.
- Developed stored procedures and usedSSIS2005.
- Designed and implemented SQL Server database objects (stored procedures, functions, views and complexT-SQL/queries) to support data integration (SSIS), reporting and various business processes.
- Configured the SSIS Packages usingEnvironment Variables for Dynamic Selection of DevelopmentandProduction Environment
- Created SSIS Packages forIncremental LoadingandSlowly changing dimensions
Environment: SQL Server 2005/2008, T-SQL, XML, MS Power Point, MS Project and Windows 2003 Server
Confidential, COLUMBUS, OH
MS SQL SERVER DEVELOPER
Responsibilities:
- Developed stored procedures, advanced queries, trigger by using T-SQL to extract the data from legacy system to the MS SQL Server 2000.
- Used DDL and DML for writing triggers, stored procedures, and data manipulation.
- Involved in Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
- Automated many operations by scheduling multiple DTS packages using jobs.
- Involved in Database design, Creation and Maintenance of Databases.
- Designed & implemented Stored Procedures and Triggers for Automating Tasks.
- Defined Check constraints, Business Rules, Indexes and Views.
- Created DTS Packages to reload tables from Excel data files.
- Optimized and tuned SQL Queries.
Environment: SQL Server 7.0/2000, Windows 2000, Visual Basic 6.0, Oracle 8i, Erwin
