SUMMARY

• Over 7 years of IT experience in analysis, design, implementation & administration of business intelligence solutions with Microsoft SQL server 2012/2008R 2/2008/2005/2000 in development, testing & production environment.
• Extensive experience in Requirement Analysis, Work flow analysis, Design, Development & Implementation, Testing & Deployment of complete software development life cycle (SDLC) in field of Desktop Applications, Microsoft web and client/server technologies.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Extensive experiences in developing Stored Procedures, Functions, Views, Triggers, XML and Complex Queries on SQL Server 2012/2008R 2/2008/2005/2000 /7.0, Oracle.
• Expert in T - SQL Programming, query optimization and performance tuning.
• Proficient in using SQL Profiler, creating Execution Plan, Performance Monitor and DBCC Commands.
• Expert database designer and fluent in all aspects of database development including, design, normalization and optimization.
• Highly proficient in design and development of SQL Server Integration Services (SSIS) packages, importing and exporting of data and using various control flow task and data flow transformation.
• Hands on experience in cleaning and scrubbing of data with Lookup and Fuzzy Lookup transformations.
• Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using SQL Reporting Services (SSRS).
• Highly proficient in handling parameterized, drill down, drill through and chart reports using SSRS.
• Expert in dimensional data modeling, and cube development, partition, aggregation and optimization using SSAS.
• Highly Proficient in designing MDX in accessing cubes and hands-on experience in query structuring, performance optimization.
• Excellent command in deploying analysis projects using SQL Server Analysis services.
• Experienced in design and scheduling integration packages using SSIS.
• Successfully performed SCD transformation and deployed SSIS package with security.
• Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational database modeling and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• DTS applications moving data between different types of databases and legacy systems.
• Ability to work in groups and an open attitude towards learning.
• A team player and have the ability to work effectively with senior management in accomplishing objectives and able to deliver results and meet deadlines.
• Excellent communication and strong analytical skills.

TECHNICAL SKILLS

Database: MS SQL Server 2012/2008R 2/2008/2005/2000 , MS Access, MySQL, Oracle 9i, 10g.

Database Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services(DTS), ETL, Query Builder, BCP, Bulk Insert, SSIS,SSAS,SSRS, BIDS,VSS, Crystal Reports, ERWIN.

Languages: C, C++, Java, Java Script, T-SQL, PL/SQL, PHP,VB.net, ASP.net, HTML, XML

Operating Systems: Windows Family, UNIX, LINUX, IOS

Case Tools: MS Office 2007/2003, MS Excel 2007/2003, MS Outlook 2007/2003, MS Visio, SharePoint Server 2007.

PROFESSIONAL EXPERIENCE

Confidential, San Leandro, CA

SQL/BI Developer

Responsibilities:

• Gathered business requirements and prepared FSD’s which included the technical changes related to the ETL scripts and backend tables.
• Created system’s process flow, Logical and E-R diagrams with the help of MS Visio.
• Worked extensively with T-SQL creating objects like Table, Stored Procedures, Views and UDF, making frequent use of While/For Loop, If/Else, Case, Coalesce, Sub Query, Joins, Dynamic Query, CTE, Temp Tables etc in order to build ETL scripts to transform the data according to the company standards.
• Monitored performance and optimizing SQL queries for maximum efficiency using system stored procedures, log file views, activity monitor, and SQL profiler.
• Created SQL server job, troubleshoot SSIS packages and configured them according to the servers.
• Used SSIS Packages and the batch process to extract, transform and load data from multiple input sources like Oracle databases, DB2, flat files and excel sheets into SQL Server 2008 Staging Database.
• Implemented various types of SSIS Transforms in packages including slowly changing dimension, aggregate, fuzzy lookup, conditional split, row count, derived column etc. and handled erroneous output using event handlers.
• Implemented the advanced storage designs like MOLAP, HOLAP and ROLAP based on the frequency of use of data.
• Created Hierarchies and Attribute Relationships to force SSAS to create more Aggregation Objects.
• Extended the functionality of cubes by creating Perspectives, Key Performance Indicators (KPI’s), Calculated Members and assigning appropriate Processing Modes.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Designed reports to include charts and logos that complies with the organizations culture and polices of reporting and documentation.
• Created various sub-reports, drill down, drill through, linked and parameterized reports for business analysis.
• Scheduled delivery of several reports to multiple users through the use of subscriptions in several different formats like Excel, PDF and Text.
• Participated in BCP fail over and fail back process which included the log shipping of production server to the BCP server.
• Was responsible for Preparing and Deploying the Game plan for Business Continuity Process for various Production and Development Servers which included Replication of the Databases, Migration of Packages & Scripts.
• Worked with Change Management Team for proper approvals and auditing for Deployment and Production changes.

Environment: MS SQL Server Integration services 2008 (SSIS), MS SQL Server Reporting Services, PETL, XML, T-SQL, MS Visio, Windows 7, Putty.

Confidential, Sacramento, CA

SQL/BI Developer

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Migrate reports from Dev to Production
• Provide on call support after reports are deployed to production
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQL Server 20 R2, SSIS, SSRS, SSAS, OLAP, OLTP Performance Point Server, SQL Server Business intelligence Development Studio(BIDS), T-SQL, C#, MS Excel, Windows 2000 Server, T-SQL.

Confidential, Nashville, TN

MS SQL Server Developer/ETL Developer

Responsibilities:

• Work with business analyst to identify and understand source data systems.
• Map source system data to the data warehouse, data marts.
• Created complex SSIS packages to extract data and scheduled Jobs to call the packages using SQL server agent.
• Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Cache Transform and Derived column while developing the packages.
• Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.
• Scheduled database jobs for automation of DBA tasks using SQL Server Agent.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Worked on SSIS to import the data from different format.
• Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Worked on Team Foundation Server for Version Control.
• Created various Tabular and Matrix Reports using SSRS.
• Proficiently created Reports based on the requirements using SSRS 2008.
• Configured the report viewing security for various users at various levels using Report Manager.
• Successfully worked with Report Server and configured into SQL Server 2008.
• Created Batch files to run the script in development, production environment.

Environment: MS SQL Server 2012, MS SQL Server Integration services 2012 (SSIS), MS SQL Server Reporting Services, MS SQL Server 2008R2,MS SQL Server 2005, PETL, XML, T-SQL, MS Visio, Windows 7

Confidential

SQL Developer

Responsibilities:

• Participated in gathering Business Requirements and System Specification from system users.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources into the data warehouse.
• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLE DB Source, Excel Spreadsheet, text files into Enterprise Data Warehouse.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Created star schema in SSAS and developed SSRS reports based on the cube.
• Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to other.
• Involved in scheduling SSIS packages to run on routine basis and monitor the error log for any errors.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: MS SQL Server 2008 Management Studio, SSIS, SSRS, SSAS, T-SQL, MS Access, Windows Server 2008, MS Visio 2009.