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
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling.
• 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.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• 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: 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.
• Designed/build/deployed the SSIS package to import data from different data sources and performed ETL process before loading the data in to data warehouse using SQL server integration services (SSIS).
• 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.
• Worked in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• 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: 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