We provide IT Staff Augmentation Services!

Sr. Analyst Sql/ssis/ssrs Developer Resume

Long Beach, CA

SUMMARY

  • Total 11 plus years of experience in Software development process including Analysis, Feasibility Study, System Analysis, Functional Analysis, Coding, Testing, and maintenance.
  • Over 7 years of experience in SSIS, developing reports using SSRS (SQL Server 2008 R2/2012), Crystal Reports 2008/2011
  • Experienced in ETL (Extraction, Transformation and loading) packages designing, development, debugging, deploying and testing using BIDS, SSDT in SSIS for migration of data between legacy systems, ERP to SQL Server 2008 R2/2012.
  • Strong knowledge in T - SQL scripting in constructing staging tables, joins, stored procedures, views, indexes, triggers for data extraction and reports.
  • Thorough knowledge and understanding of Multi Dimensional Data Modeling, Star, Snow-Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP and other Data-Warehousing concepts.
  • Administer and Maintain teh BI environments and provide day-to-day operational support, Proficient in database archival backups and restores.
  • Support deployment to QA and production environment, Provide technical support to application development teams. Experience in Data Cleansing and Data Conversion transformations.
  • Experienced in Software Development Life Cycle Methodology: Requirements through Deployment.
  • Experiencedin creating and troubleshooting SSIS packages to import/export data toSQLServer from various sources like Excel, Text, XML and Oracle using different transformation methods like conditional split, Sort, merge join, derived column and other transformations.
  • Hands on experience in developing, troubleshooting Tabular, Matrix, cascading parameters, drill through, drill down, sub reports and KPI reports using SQLserver Reporting Services (SSRS).
  • Experienced in performing Incremental Loads and Data cleaning in SSIS, SCD, Change Data Capture (CDC), handling errors, logging using Event Handlers using SSIS.
  • Experienced in gathering report requirements, developing reports and report scheduling etc. administration of SSRS environment (user security, report scheduling)
  • Around 4 years of experience in Programming Expertise in developing Windows, Web-based applications based on VB.NET, C#.NET, ASP.NET, ADO.NET, AJAX, XML, WPF, WCF Services, SOAP based Web Services under teh Microsoft .NET Framework.
  • Good experience in using databases MS SQL Server 2008 R2/ 2012, Oracle 9i, Informix (7.0).
  • Around 3 years of experience in OOPS with C, C++ on Solaris (9.0), Perl scripting and Pro *C.
  • Proficiency in using tools like Visual Source Safe, Team Foundation Server.
  • Trained on SAP Business Intelligence Warehouse (7.0) Data modeling, Extraction, Transformations, Data Loading and SAP Business Objects reports using WEBI Rich Client 4.0, Xcelsius / Dashboard Designer for both SAP and Non SAP sources.

TECHNICAL SKILLS

MSBI Tools: SSIS, SSAS, SSRS

Business Objects: SAP Business Objects XI4.0 sp4/ 3.1/ XI3.0, Universe Design, Webi 4.0, Live office, Dashboards, Crystal Reports 2008/2011 .

Languages: C, C++, Pro *C, C#.Net, VB.NET, PL/SQL.

Data warehouse Tools: SAP Business Intelligence Warehouse (7.0), MSBI SSAS.

Web Development: HTML, DHTML

.NET Technologies: ASP.NET (3.5/ 4.0/4.5), ADO.NET, XML Web Services. WPF, WCF.

DBMS: MSSQL Server 2008 R2, 2012, Oracle10g/9i, SAP R3, DB2, Informix

Web/App Servers: IIS (7.0/8.0), BEA Tuxedo (6.5), Apache - Tomcat (5.0), SharePoint

Scripting Languages: Perl, UNIX Shell, VBScript, Java Script.

Tools: Autosys, IServe, MS Project, Clear Case, Klocwork, VSS, MS TFS

PROFESSIONAL EXPERIENCE

Confidential, Long Beach CA

Sr. Analyst SQL/SSIS/SSRS Developer

Responsibilities:

  • Working in Supporting Team to handle change requests and incidents pertaining to operational data source (ODS), Enterprise Data Warehouse(EW), DataMart, Business Intelligence.
  • Monitor daily, weekly and monthly loading jobs and execution of Adhoc jobs.
  • Handling job failures by identifying potential causes and worked with DBA, Configuration and Development teams to resolve teh issues.
  • Developed scripts to load missed records into destination database tables.
  • Developed Data Quality checking queries to ensure teh source and destination data is in synch.
  • Modified packages which are taking long time to improve performance and reduce loading time.
  • Created Views to provide restricted access to users.
  • Developed new packages for Ad hoc loading of data and creation of batch files.
  • Developed interactive reports to display data in Dash Boards.
  • Modified batch files to implement package configuration changes.

Environment: MS SQL Server-2008 R2/2012 Enterprise Edition, Windows server 2012, SSIS, SSAS, SSRS, EDW, ODS, T-SQL, BIDS, SSDT, SQL Profiler, C#.Net, OLAP, OLTP, Erwin, Office-2007, MS Excel, Visual Source Safe.

Confidential, Irving TX

SQL/ SSIS/ SSRS Developer

Responsibilities:

  • Developed Stored Procedures, Views and Temporary/Staging Tables as per teh requirement.
  • Extensively involved in designing teh SSIS packages to export data from flat file source, XML, Excel sources to SQL Server database.
  • Created SSIS Packages to implement Change Data Capture Controls.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Pulling data on a daily basis from OLTP database to OLAP or staging database using teh SSIS packages.
  • Worked with various SSIS packages which involve Transactions, Restart ability and rollback techniques. Used Bulk Copy Program (BCP) to import and export large amount of datain and out ofSQLServer Databases.
  • Implemented Event Handlers and Error Handlers during creation of SSIS packages, Data cleansing and notified process results to various users.
  • Monitored nightly and weekly loads of Full/Incremental/Daily Loads and support all scheduled ETL jobs for data
  • Used Configuration Files in SSIS to ease teh process of moving teh packages across servers.
  • Generated Tabular reports, Cross Tabs, Drill down, Charts, Scorecards, KPI ‘s using SSRS..
  • Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
  • Created reports to retrieve data using Stored Procedures that accept parameters.
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)/ SQL Server Data Tools for both OLTP, OLAP databases.
  • Generated Sub-Reports, Drill Through -Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Deployed reports in to Report Manager.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Reviewed & Tested packages, fixing bugs using SQL 2008 R2 Business Intelligence Development Studio and SQL 2012 SQL Server Data Tools.
  • Interact with internal and external stakeholders in teh project - with Operation group, Production group, Change Management group, IT group, User Acceptance group

Environment: Windows server 2012, MS SQL Server-2008 R2/2012 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, BIDS,SSDT, SQL Profiler, C#.Net, OLAP, OLTP, Erwin, Office-2007, MS Excel, Visual Source Safe.

Confidential, AL

SQL/ SSIS/ SSRS Developer

Responsibilities:

  • Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
  • Used ETL to implement teh SCD transformation, to maintain historical data in data warehouse.
  • Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
  • Developed and deployed data transfers packages using SSIS, also maintained teh jobs running on Servers.
  • Performed teh task of data transfer from files in remote server to folders in another server using FTP.
  • Responsible for creating database objects like tables, Views, Joins, Store Procedure, Triggers, Functions etc. using T-SQL to store data and to maintain database efficiently.
  • Extensively used Execute SQL Task, Data flow Task, Look up, Script component, Union All etc in SSIS packages.
  • Monitored nightly and weekly loads of Full/Incremental/Daily Loads and support all scheduled ETL jobs for data.
  • Implemented Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.
  • Created SSIS Packages to perform filtering operations and to import teh data on daily basis from teh OLTP system, Staging DB to Data warehouse.
  • Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
  • Used calculations, sorts, filters and sections to enhance data presentation in reports. Created many Cascaded parameters in teh reports using SQL SSRS.
  • Developed many Tabular Reports, Matrix Reports, Drill down Reports, trend analysis reports and Charts using SQL Server Reporting Services (SSRS). Also created many multi valued parameters in teh reports.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008 R2.
  • Generated Reports using Global Variables, Expressions and Functions for teh reports.
  • Reviewed & Tested packages, fixing bugs using SQL 2008 R2 Business Intelligence Development Studio.

Environment: Windows server 2008, MS SQL Server-2008R2 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, BIDS, SQL Profiler, C#.Net, OLTP,TFS, MS Excel

Confidential, Harrisburg, PA

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Designed packages using Transformations Sort, Merge, Merge Join, Union, Union ALL, Lookup, Aggregate, OLE DB Command and Derived Column.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes to store data to OLAP databases.
  • Developed new mappings using SSIS Look Up/Aggregation transformations to match teh needs of teh business case.
  • Used Configuration Files in SSIS to ease teh process of moving teh packages across servers.
  • Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
  • Developed forms on share-point to show data from data-sources to Clients and enabling them to edit teh data and update teh data in teh data-sources and allowing inserting data into teh data-sources.
  • Created reports on to Share-Point and Report Server and set teh data-driven subscriptions for these reports.
  • Deployed generated reports of each quarter onto teh Report Server to access it through browser.
  • Designed and developed Data Warehouses, Data marts using Multi-dimensional models such as Star Schema and Snow Flake Schema for developing cubes.
  • Generated reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
  • Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
  • Formatted teh SSRS reports using teh Global variables, expressions and Functions.
  • Created Jobs Performance report that queries system tables to track teh duration of each job and weekly-average duration using SSRS.
  • Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Maintained teh consistency of data by performing Data Profiling and Data Cleansing.
  • Created teh documents and packages in Team Foundation Server as a version control.

Environment: Windows server 2008, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, BIDS, C#.Net, OLAP, OLTP

Confidential

MSBIDeveloper/ SQL developer

Responsibilities:

  • Analyzedrequirements and designed normalized and de-normalized tables and relationships usingSDLCmethodology and DataModeling.
  • Designed complexT-SQL queries,User Defined Functions,Stored ProceduresandTriggersinSQLServer 2008 followed by analysis and testing of those database objects before deployment to teh production server
  • Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints
  • Optimizedthe performance of queries with modification in T-SQL queries,creating sub queries, establishing joins and creatingindexes wherever necessary.
  • Developed ETL Transformations usingDataConversion, Audit, Derived Columns, Lookups, Merge, Merge Join, Slowly Changing Dimension transformation. Scheduled theETLprocesses on SSIS serverand managed integration server
  • Worked withSQLServer Agentto create jobs and monitoring them
  • Worked on Huge Data Transfers from & toSQLServer Databases using utilities / tools like SSIS, BCP, BULK INSERTetc.
  • Developed, monitored and deployed SSIS packages for ETL flow tovalidate, extract, transform and load data into database.
  • Managed and monitored teh system utilization by using teh query optimizer and checking teh execution plan.
  • Deployed reports projects SSRS anddeveloped KPI's which halped teh Business users for easy understanding.
  • Designed and Developedmultiple Enterprise reports using SSRS fromboth OLTP andOLAP databases
  • Executed different Ad-hocreports usingMSSQLSSRS.
  • Tested teh reports and fixed bugs in teh stored procedures.Involved in scheduling teh reports and setting security for reports.
  • Administered interface to organize reports and data sources, schedule report execution and delivery,and track report history using SSRS.

Environment: Windows server 2008, IIS 7.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, BIDS, SQL Profiler, C#.Net, OLAP, OLTP, Office-2007, MS Excel

Confidential

ETL / SQL Server Developer/Reporting Services

Responsibilities:

  • Designed SSIS packages to migrate teh data from Development Database to Application Database (OLAP).
  • Involved in Waterfall Methodology SDLC of teh project right from planning phase.
  • Designed teh databases in SQL server 2005 based on teh existing business rules
  • Designed teh staging database for validating purposes where rows went to different tables based on if teh row was inserted or updated. Utilized SSIS to perform these validations.
  • Worked with many SSIS tasks to perform auditing, SQL tasks, and for each loop containers to process multiple rows of information from teh Control Flow.
  • Utilized several SSIS transformations to perform ETL of data from source to destinations.
  • Managed XML and Sql server package configurations and security issues on SSIS ETL packages in regards to user authentication and DTSX file storage.
  • Implemented Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.
  • Created Reports using SQL Server Reporting Services based on teh Business Requirements Document.
  • Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize teh run time.
  • Created Common Table expressions in stored procedures for better performance and to automate teh process of validating teh data being returned.
  • Created drill down, linked, and sub reports using SQL server reporting services
  • Coordinated with DBA in creating and managing database objects: tables, views, user defined functions, cursors, triggers, stored procedures. And also created constraints and roles.

Environment: Windows 7.0, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, BIDS, SQL Profiler, C#.Net, OLAP, OLTP, Erwin, Office-2007, MS Excel

Hire Now