We provide IT Staff Augmentation Services!

Sr. Msbi Developer / Sql Ssis Ssrs Ssas Resume

3.00/5 (Submit Your Rating)

Auburn Hills, MI

SUMMARY

  • Around 8 years of IT industry experience with Microsoft SQL Server 2000/2005/2008 , SSIS/SSRS as SQL Developer.
  • Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
  • Experience in developing the applications usingT - SQL Programming (DDL, DML, and DCL).
  • Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
  • Extensive experience in Performance Monitoring and Tuning of SQL Statements, Sub Queries, Joins and Functions.
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
  • Expert in working with Business Intelligence Development Studio (BIDS), that includes SSIS, SSRS.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Expertise in developing reports using SQL Server Reporting Services and MS Excel spreadsheets.
  • Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Sub reports and formatting them using both SSRS 2005/2008.
  • Extensive use of AgileMethodologies, including ExtremeProgramming, Test-Driven Development and Scrum.
  • Knowledge and exposure to perform database backup and recovery using Log Shipping and Database Mirroring techniques.
  • Experienced in creating Transformations and Mappings using Informatica Power center, Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets
  • Expert in creating high level dashboards using SQL Server Reporting Services.
  • Excellent command on Insurance/Financial (BNFS) Domain along with deep Conceptual and Practical Knowledge.
  • Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

Operating Systems: Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows NT, Windows 95/98/2000 XP/Unix

Databases: MYSQL Server 2000/20 R2/ 2012, MS Excel/MSWord/MS Access

Database Tools: SQL Enterprise Manager, SQL Profiler, Power Shell, DTS Import/Export, SQL Client Configuration utility, MS OLAP Services, SSMS, SQL Server BIDS/SSDT(SQL Server 2012)

Modeling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modeling, ER Diagrams, MS Visio, Rational Rose

ETL Tools: Experienced working with SSDT/BIDS-DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS).

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Development skills: Transact SQL (T-SQL)

Languages: C#, ASP.Net/ADO.Net, HTML, XML, XSLT, core java

PROFESSIONAL EXPERIENCE

Confidential - Auburn Hills, MI

SR. MSBI Developer / SQL SSIS SSRS SSAS

Responsibilities:

  • Developed Logical and physical data model using ERWIN and mapped the data into database objects.
  • Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Used SSIS to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Problem identification, troubleshooting, resolution, and index tuning databases.
  • Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.
  • Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2012/2008, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007.

Confidential, Irving, TX

SQL Server/BI Developer

Responsibilities:

  • Worked with Business Analysts to understand the requirements.
  • Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT, and Production Move)
  • Perform ETL processes using SSIS tool for SQL Server.
  • Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server & flat files.
  • Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as Mapplets, and Schedule jobs.
  • Design/Develop complex queries efficiently as per the given business requirements.
  • Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
  • Worked on Table Partitioning to load current and historical data.
  • Worked with Business users to understand the Business Logics as per the need.
  • Worked with Financial data to calculate Comp.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, COSMOS etc. to SQL Server usingSSIS/DTS using various features like data conversion etc
  • Develop views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries for complex queries involving multiple tables.
  • Used various transformation tasks to create ETL packages for data conversion.
  • Loaded flat files data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
  • Implemented changes in Cubes (SSAS) as per the requirement.
  • Created a cube in existing system and their respective Facts and Dimensions, Relationship and Partitioning.
  • Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze performance of System.
  • Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins)
  • Generated reports using SQL server reporting services (SSRS)
  • Scheduled Jobs and Alerting using SQL Server Agent.
  • Design/Develop Test Plans, Test Cases and documentation of various processes involved.
  • Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.
  • Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
  • Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
  • Responsible for maintaining and supporting production databases.
  • Created standard report subscriptions.
  • Created report snapshots and cache for better performance.
  • Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
  • Perform /coordinated end to end Migration process in TEST /PROD ENV.
  • Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
  • Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
  • Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.

Environment: SSIS/SSRS/SSAS, SQL Server 2008, Microsoft Visual Stuidio.NET 2008, VB.NET Query Analyzer, Tera Data Windows 7, Team Foundation Server (TFS) NET Framework 2.0.

Confidential, Atlanta, GA

SQL Developer/SSIS Developer/SSRS Developer

Responsibilities:

  • Created SSIS packages for importing the Excel layouts into the database using SSIS.
  • Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
  • Loaded data from ODS to Data Warehouse using SSIS packages.
  • Experience in SSIS script tasks, Look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
  • Using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
  • Designed and Developed matrix, tabular and parametric Reports using SSRS 2012.
  • Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
  • Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
  • Improved data load performance by analyzing database design and query plans.
  • Modified and Create Joins to Improve the Database and execution speed.
  • Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
  • Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.

Environment: SQL Server 2012,SQL Server R2 2012,SSIS, SSRS, SSAS, Visual Source Safe 2012, Erwin 4.0, MS Excel 2007, C#, VB.Net, Windows Server 2010.

Confidential

MS SQL Server and ASP.NET Developer (SSRS/SSIS)

Responsibilities:

  • Designed and developed database solutions based on functional requirements.
  • Web module development and deployment using ASP.net MVC3.0 with jQuery.
  • Implemented theme library with CSS classes and skins.
  • Made integration with file server from web code to write attachments on a file server.
  • Implemented database solutions that met expected quality standards.
  • Monitored project status to meet milestones and resolve issues that might impact on quality or the ability to deliver to timescales or estimates.
  • Implemented session tracking and auto save page data using times.
  • Implemented single signon with parent frame application.
  • Produced technical design documents for the schema and stored procedure specifications.
  • Troubleshoot production, real-time performance and concurrency issues.
  • Deliver work on time and to specification, with minimal supervision.
  • Created Stored Procedures, User Defined Functions, Views and TSQL Scripting for complex business logic.
  • Created Stored Procedures which generated the necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon the requirements.
  • Responsible for migration of data from SQL Server 2005 to SQL 2008.
  • Migrated heterogeneous databases to MS SQL Server 2008.
  • Designed and created different ETL packages using SSIS from Oracle source to SQL server as destination.
  • Created SSIS Packages to export and import data from Text files, CSV files and Excel Spreadsheets.
  • Designed and implemented SSIS packages for data integration and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them.
  • User N-tier architecture to plug reports to presentation layer using Report viewer control.
  • Extensively worked on Cross tabbed and Matrix reports using SSRS.
  • Designed and implemented indexing to optimize transactional and reporting performance.
  • Implemented data integration processes to handle XML file generation or processing.
  • Used XPATH and XQUERY for XML parsing and Coordinated with web development team in .Net framework programming solutions.Created XML schemas to validate data feeds.
  • Integrated ASP.Net Web Pages to the SQL Server 2008 Back End.

Environment: Windows XP, MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, MS SQL Integration Services 2008, T-SQL, .NET, VSTS

Confidential

Junior Developer

Responsibilities:

  • Coding & manual testing
  • Involved in creating, deploying and configuring reports according the requirements.
  • Involved in writing scripts for the clients requirements for generating reports.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
  • Involved in creating, deploying and configuring reports according the requirements.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Fixed reports and bugs in stored procedures.
  • As a DBA involved in maintaining the Database Backups for the team using SQL lite speed backups, database performance tuning, using migration methodologies for improvement.
  • Documented the flow of the project.

Environment: SQL Server 2005, SSIS, SSRS, Business Intelligence Development Studio (BIDS), Microsoft visual studio.NET 2008.

We'd love your feedback!