Sql/bi Developer (ssis/ssrs/ssas) Resume
Mountain View, CA
SUMMARY
- Over 8+ years of experience as Microsoft BI developer, database developer and data analystwith Microsoft SQL Server 2012/2008 R2/2008/2005, SSIS/SSRS/SSAS,OLTP, and OLAP (Different environment such as Production, UAT, and development) in various domain.
- Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
- Expert in designing (development) and deployment of SSIS package from various sources like MS access, oracle,BD2,excel, Microsoft sequel server, flat file, and XML.
- Proficient in performing various SSIS data transformation task such as Look - ups, Fuzzy Look-ups, Aggregate Functions, Merge Join, Conditional Spilt, Data Conversion, Derived Column, Event Handlers, and Error Handlers etc.
- Proficient in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages using SQL server agent.
- Expert in creating various types ofcomplex reports using SSRS (SQL server reporting services) such as Drill-Down, Parameterized, Cascading, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
- Expert in Designing and deploying reports on the portal as per the end user requests using web interface and report manager.
- Experienced in reporting services configuration manager to configure and maintain Report Manager, Report server, Send emails to the end user, and Scheduling reports.
- Expert in web development using HTML, CSS, Java Script, AJAX and ColdFuison to display the reports on the web interface.
- Very Good experience in Creating OLAP cubes,Drill Down reports and Sub Reports using SSAS SQL server analysis Services.
- Proficient in Data mining models, deploying and Processing SSAS objects.
- Good Understanding of Data marts, Data warehouse, Operational Data Store (ODS), OLAP, Data modeling like Dimensional data modeling, Start Schema Modeling, Snow-Flake Modeling, Fact and Dimensional table using SSAS.
- Proficient with T-SQL (DDL, DML, DCL, and TCL) in implementing Complex Stored Procedure, Indexes, Views, Table Variables, Triggers, Nested Queries, Joins, Cursors, and user and system defined functions
- Good knowledge of Team Foundation Server, Crystal Reports, and Share Point.
- Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
- Expert in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans
- Excellent understanding of Normalization/De-normalization, Normal Form and database design methodology. Expertise in using data modeling tool like MS Visio, Bizagi, Visual Paradigm for logical and physical design of database.
- Skilled in designing logical and physical data modeling using Visual Paradigm and Bizagi data modeling tool.
- Experience in developing web applications using ASP.Net, ADO.Net and Web Services Involved in 24/7 production support and also experienced in testing environment.
- Worked with Business Analysts, Web development team, and users on database solutions
- Expert with different phase of project life cycle (analysis, design, implementation, testing, and debugging new/existing client-server based applications.
- Strong communication, management, and team player capabilities.
- Excellent problem solving, multitasking, business analytical, and critical thinking with the ability to work on fast based environment.
- Good Knowledge of implementing iterative Software Development Life Cycle (SDLC) using Rational Unified Process (RUP), agile, waterfall, Extreme Programming (XP), and Scrum.
- Working Knowledge of .Net Framework 2.0 (VB.NET and C#.NET), ISS 6.0 and 7.0.
TECHNICAL SKILLS
Modeling Tool: ERWin, MS Visio, Visual Paradigm, Bizagi
Methodologies: SDLC Waterfall, RUP (Rational Unified Process),XP (Extreme programming), Cost/Benefit, Scrum, Agile methodology.
BI Tool: SSIS, SSAS, SSRS, Report Builder 2.0/3.0, Tableau
Database Tools: SQL Server Management studio, Enterprise Manager, Profiler, SQLServer Business Intelligent studio (BIDS), TOAD for Oracle.
GUI /Tools: Lotus Notes, MS Word, MS Excel, MS PowerPoint, MS Project, SAS.
Database & Query Tools: SQL Server 2012/2008/R2/2005, Oracle 11g/10g, TOAD for Oracle,MS Access.
Markup Language: XML, HTML, java script, Web services, CSS, AJAX, ColdFusion.
Defect Tracking/ Testing: Load Runner, Win Runner, Quick Test Pro (QTP), Quality Centre (QC).
Operating Systems: DOS 6.22, Windows 98/95, Windows XP, UNIX, Windows 2007.
PROFESSIONAL EXPERIENCE
Confidential, Virginia Beach, VA
SQL Server BI Developer
Responsibilities:
- Gathered end users requirements, Developed Logical Model, and implemented requirements using SQL server 2012/2008 R2.
- Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
- Developed working documents to support findings and assign specific tasks.
- Performed Data Analysis and Data Profiling using complex SQL on various source system including Oracle and Teradata.
- Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
- Developed working documents to support findings and assign specific tasks
- Worked closely with project stakeholder and staff to understand requirement specifications new applications and redesigning existing applications.
- Created Technical Piece of SRS (Software Requirement Specification) Document.
- Prepared project Progress Report and Status Reports and submitted it to upper management on weekly basis.
- Created Data Flow Diagram (DFD) and Flow Charts to display the flow of information in the new system.
- Developed SQL scripts for administration task.
- Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
- Used .NET provider Data Reader Source Task to Read from RDBMS sources.
- Developed web-applications using ASP.NET MVC, C#, AJAX&JQuery.
- Used PowerShell for DevOps in Windows-based systems.
- Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
- Imported data from different databases (oracle, MS access etc.), build and scheduled packages, and defined integration flow using SSIS (SQL server Integration Services).
- Created ETL (Extract, Transform, and Load) packages to validate and load data in to data warehouse, database, and data marts.
- Designed and implemented fact, dimensions and SSAS cubes using dimensional data modeling standards in SQL server 2012/2008 R2.
- Developed SSAS Cubes from scratch.
- Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
- DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions.
- Designed and implemented parameterized, drill-through, drill-down, and tabular reports using SSRS.
- Developed crossed reports, sub-reports and matrix in SSRS.
- Created complex queries to build the dataset required for developing the SSRS reports.
- Implemented/Developed multi parameterized reports using Report Builder and SSRS allowing users to make selections before executing the reports and making it more user friendly.
- Displayed reports in Webpages using Coldfusion, JavaScript and AJAX.
- Provided 2 weeks training as a part of knowledge transfer on SSRS and SSIS to the client in order to modify existing and develop their own ad-hoc reports and SSIS package.
- Designed, developed and implemented database systems and Store Procedures based on Client requirements.
- Involved in database Schema Design, development and executed store procedures Using Batch files.
- Worked closely on Coldfusion administrator to establish connections with databases.
- Created and established user friendly website in IIS 7.0 to access reports in all production, Testing and Development servers.
- Implemented the project using Agile methodology.
Environment: s: SQL Server 2012/2008 R2, T-SQL, Windows 7, SSRS, SSAS, SSIS, Coldfusion, Jeera Dashboard, MS Visio
Confidential, Charlotte, NC
SQL Server Developer/BI Developer
Responsibilities:
- Developed use cases from requirements and created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams.
- Created Data Flow diagrams and flow charts to display the flow of information in the system and make users understand the functionalities.
- Worked with design and admin team to design physical database and its modifications.
- Responsible for project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
- Performed Data Analysis and Data profiling using SQL on various sources.
- Developed the application using Visual Studio 2010 with C# to display timesheet and generate reports.
- Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, Configuring optimizations and securing the web application.
- Worked within the Cloud for integration processes.
- Performed DevOps for Linux Mac and Windows platforms.
- Created ETL SSIS packages both design and code to process data to client databases.
- Created SSIS template for developing SSIS packages to dynamically deploy the packages into the development, Testing, and production environments.
- Designed and developed SSAS cubes, fact and dimensional table using dimensional data modeling standards using SSAS.
- Created different format of the reports using SSRS as per the end user and business requirements.
- Worked on Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
- Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
- Performed system testing for the SSIS packages and SSRS reports.
- Used Notification services to generate error messages and notify users through e-mails.
- Design, develop and implement database systems and store procedures based on client requirements.
- Optimize database systems for performance efficiency.
- Ensure data quality and integrity in databases by DBCC command.
- Designed physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for warehouse system.
- Worked on DBA task such as providing access, established ODBC connection.
Environment: s: SQL Server 2008 R2, T-SQL, Windows 7, SSRS, SSAS, SSIS, UML, Visio
Confidential, MOUNTAIN VIEW, CA
SQL/BI Developer (SSIS/SSRS/SSAS)
Responsibilities:
- Documentation of developed BI solution as a part of knowledge transformation.
- Analysis of business requirement and various source systems for data and metadata information.
- Responsible for preparing technical specification based on functional requirement.
- Prepared unit test cases based on functional and technical specifications.
- Developed Web forms using C# and ASP.NET
- Implemented and executed SSIS 2008 packages to import/export data from the different source to perform the ETL process.
- Used different SSIS transformations such as RecordSet destination, ForEach Loop container, Multicast Transformation,DerivedColumn Transformation to create new column, ConditionalSplit Transformation to split data flow using Business Intelligence Development Studio (BIDS).
- Created SSIS package which implements DataProfiling using SSIS Expressions, Variables, Expressions and SQL Server based Package configurations
- Modified the existing SSIS packages to increase the performance of the packages.
- Created and modified the existing SSRS reports based on T-SQL using Business Intelligence Development studio (BIDS).
- Used and defined reportsParameters, created ParameterCascading to populate sub-reports,drill down reports, and drill through reports.
- Created PerformancePoint based Dashboards having WebParts of SSRS Report, Pie Chart, Funnel Chart, and bar charts.
- Reviewed, performed unit andsystem testing, and fixed bugs for SSIS package, and reports using SQL 2008 Business Intelligence Development studios.
- Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
- Created drill down and sub reports from SSAS cubes that can be browsed on web.
- Created/wrotestore procedure, functions, views, index to handle database automation task.
- Developed Database structures, store procedures, DDL triggers and user definedfunctions tooptimize the database performances.
Environment: s: SQL Server 2008 R2, MS ACCESS, Oracle 10g, T-SQL, Windows 7, SSRS, SSAS, SSIS.
Confidential, Houston, TX
SQL Developer/Business Analyst/SSRS
Responsibilities:
- Gathered requirements and preparedbusiness requirement documents (BRD).
- Developed and maintained all operational and technical flows using Visio and Power point.
- Working closely with the Senior Management to understand their requirements and maintain and enhance the database accordingly.
- Taking weekly export of the database and preparing reports, graphs and charts in SSRS.
- Troubleshoot database related issues in a timely manner.
- Ensure data quality and integrity in database using DBCC command.
- Design of the database and tables.
- Involved in ER diagrams and mapping the data into database objects.
- Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
- Maintained database performance such as tuning, backup, restoration and disaster recovery.
- Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
- Built table relationships and wrote stored procedures to clean the existing data.
- Provide support in handling faults and issues.
- Maintenance and enhancement of the production database.
- Responsible for translating business requirement document (BRD) intofunctional specifications and test plans.
- Performed Regression Testing and created test scenarios for User Acceptance Testing (UAT)
Environment: s: SQL Server 2008, MS access, DB2 T-SQL, Windows XP
Confidential
SQL/BI Developer/ DBA
Responsibilities:
- Participated with business analysts in order to gather requirements for design and implementation of database. Performed basic DBA activities like Backup and Restore.
- Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
- Responsible for migration of packages from SQL Server 2005 to SQL Server 2008 using SSIS
- Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
- Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
- Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
- Developed report specifications, created and modified reports using SSRS 2005.
- Scheduled reports and exported in PDF, Word and Excel format.
- Created drill down and sub reports from SSAS cubes that can be browsed on web.
- Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with SSIS and also prepared ETLmappingprocesses and maintained the mapping documents.
- Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation for the data mart of OLTP and OLAP databases.
- Identified slow running query and optimization of storedprocedures and performed testing on applications for performance, data integrity using SQL Profiler.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
- Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.
Environment: s: SQL Server 2005, Oracle10g, DB2, MS Access, Excel T-SQL, Windows XP
Confidential
SQL Developer/ DBA/ Business Analyst
Responsibilities:
- Documented the project works and process.
- Attended Weekly and daily Status Meeting.
- Prepared Daily and weekly dashboard, prepared business requirement documents along with system Requirement documents and Technical Document for Project development.
- Communicate team with the customer needs, specifications, design targets, task performance and supports.
- Identify the Impacted components by Impact Analysis.
- Analyzing the Low Level Design with existing & revised changes.
- Managed and coordinate with remote user for change request and optimization of application.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Optimized query performance by creating indexes.
- Monitored database system and execution time.
- Created users and roles and assigned permissions to them.
- Created web interface to display the table’s data to the end users.
- Scheduled jobs, alerts and designed and implemented user log in and security.
- EstablishedODBCconnection for database.
- Worked with various business groups while developing applications, assisted with design, installed SQL server clients in different environment.
- Performed Production support and on call duties.
- Resolved deadlocks issues with the databases / servers on a real-time basis.
- Prepared unit test cases for system testing.
Environment: s: SQL Server 2005, T-SQL, Windows XP, Quality Center, QTP