SUMMARY

• Strong experience in Database design, development and maintenance of database applications on SQL Server 2005/2008/2008 R2/2012 in OLTP/OLAP/ BI environment.
• Created various stylish reports using SSRS and used all types of report representations. Expertise in deploying the reports, subscriptions, managing the report server.
• Developed and deployed various SSIS packages and used various transformations.
• Worked extensively on Job scheduling, send mail tasks. Developed various cubes, used various MDX queries for measures and developed schemas.
• Good working knowledge in all components of QlikView and interaction on Server and Publisher.
• Experienced in working with project manager, development team, business analysts and end - users.
• Experienced in working as MS SQL Server 2012 (T-SQL, SSRS, and SSIS)/ 2008R 2//2008/2005/2000 developer in various industrial domains.
• Knowledge of Transact SQL (DDL and DML). Expert in creating tables, Indexes, joins, triggers, views, stored procedures, filtering user defined data types and functions.
• As part of the team, extensively involved through the software development life cycle (SDLC) involving business process analysis, requirement gathering and development.
• In depth in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package migration wizard and storage management.
• Highly experienced in creating and executing SSIS packages to extract transform and load data. Worked extensively on various data sources and different transformations in SSIS.
• Experience in error handling and event handling: Precedence constraints, break points, check points and logging towards SSIS package execution in SSIS 2012/208R 2/2008/2005.
• Great experience in Deploying SSIS packages, job scheduling, SQL mail agent.
• Created various reports like grouped reports, multilevel grouping, drilldown, multi-level drill down, cascading, parameterized and sub reports.
• Expert in using all types of report formats such as tables, matrix, pie, charts, gauge, maps, indicators.
• Extensive knowledge and experience in deploying reports and scheduling snapshots and managing snapshot history.
• Experienced in building OLAP cubes, fact and dimension tables with different architecture and data sources for business intelligence and populating/maintaining data marts in SSAS 2012/2008R 2/2008/2005.
• Used multi-dimensional expressions (MDX) queries for calculated members of OLAP cube, key performance indicators, aggregation, and measures in SSAS 2012/2008R2/2008.
• Strong knowledge on data ware house concepts and technologies, worked extensively on developing SSAS cubes, hierarchies, star and snow flake schema of data marts, cubes, data mining models, deploying and processing SSAS objects, ETL process, reporting tools.
• Good understanding of Relational Database Management Systems (RDBMS) complex Expertise in designing and modeling of QlikView Applications using QlikView (11.2/11.0/10.0/9.0 ) with multiple data sources (SQL, Oracle, Flat Files, Excel and Access) relational designs
• Experience with QlikView sheet objects including Pivot, List and Multi box, multiple chart types, Trends, KPI’s, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting.
• Strong knowledge of QlikView scripting, Set analysis, aggregation functions, multi-dimensional objects, layout and design including chart properties and formats.
• Strong understanding in creating Dashboards and scoreboards for the required KPI’s in QlikView.
• Experience in designing QlikView Document/User Setting Layouts to make consistent and professional optimized look to clients.
• Great skills in gathering requirements, understanding and analyzing the requirements.
• Worked in collaborative team environment with other developers, business analysts and with project management teams.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.

PROFESSIONAL EXPERIENCE

• MS SQL Server 2012/2008R 2/2008/2005/2000
• T-SQL
• MY SQL
• MSSQL Server Reporting Services (SSRS)
• DTS
• XML
• MSSQL Server Integration Services (SSIS)
• SQL Profiler
• SQL Query/Index Analyzer
• MSSQL Server Analysis Services (SSAS)
• Backup/Restore Server
• OLAP Services
• SQL Alerts
• SQL jobs
• ERwin
• Qlikview

PROFESSIONAL EXPERIENCE

Confidential, New York

MS SQL Server/SSIS/SSRS developer

Responsibilities:

• Worked with financial analyst, application developers, business stakeholders to gather requirements, analyze and build solutions with my team.
• Worked on SQL server profiler for improving the performance of present quires, created triggers, created and worked on existing Stored Procedures and Indexes.
• Created various ETL (SSIS) packages to load data from CSV files to the tables in SQL Server with using derived columns to specify the file path.
• Checked the health of the SQL Server.
• Created data mapping documents for ETL process (SSIS). Worked on writing the insert, update and delete quires joining multiple tables to make changes in the staging tables.
• Created a front end application for the finance and sales team with implementing the complex business logic of projected and actual amounts with coding in VB script using MS Access application
• Designed and created various forms for finance team, sales team and account managers with implementing the business logic. Worked with non-technical teams to help them to use the application.
• Designed the structure of history tables for the finance team
• Worked on creating various reports in SSRS (matrix, multi drilldown, parameterized) and scheduled the snapshots.

Environment: SQL Server 2012, SQL Server Data tools (SSIS, SSRS), MS Access 2013, Excel.

Confidential, BERKELEY HEIGHTS, NJ

MS SQL Server/SSIS/SSRS developer

Responsibilities:

• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Determined the SQL Server installation. Installed and configured SQL Server Management tools using SQL Server setup program.
• Implemented triggers for checking complex business conditions, providing security for tables.
• Physical implementation of database into SQL Server 2012 using T-SQL.
• Created views to facilitate easy and user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Created stored procedures and functions to support efficient data storage and manipulation. Created check constraints to maintain data integrity.
• Created various SSIS packages by extracting data from various sources according to the requirements.
• Load XML data in SQL Server table using SQL bulk copy.
• Worked with various containers in the control flow task such as For Loop, For EachLoop, Sequence.
• Worked with various sources in the data flow tasks and used various transformations. Some of the transformation are Row count, merge, merge join, union, Look up transformation, audit, aggregate.
• Worked extensively on bad data with configuring the error output, Conditional split, derived column, fuzzy lookup transformation.
• Deployed the packages in catalog method and worked on job scheduling and send mail task.
• Created tabular, drill down and parameterized reports using SSRS.
• Migrated ad-hoc reports from excel and crystal reports to SSRS.
• Gathered and documented QlikView application requirement from the users
• Designed, developed and implemented QlikView Business Intelligence reports
• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.
• Implemented security using QlikView section access that dynamically hides selected areas of the dashboards depending upon the user privileges.

Environment: SQL Server 2012, Excel, Access and Windows NT, MS SQL Integration Services (SSIS) and MS SQL Reporting Services (SSRS). QlikView 11.2/11.0

Confidential, Philadelphia PA

MS SQL Server/ SSRS Developer

Responsibilities:

• Designed, Developed and maintained Relational databases using agile scrum methodology, SME phase.
• Involved in normalization of the database and bringing it to 3NF.
• Created efficient stored procedures, triggers, user defined functions, tables, views, and other T-SQL join techniques for applications and improvement of database performance.
• Extensively involved with database space management, performance and writing SQL queries with Teradata.
• Generating XML from SQL server tables.
• Created various reports in SSRS according to the requirements. Some of the reports are grouping, multi-level grouping. drill down, multi-level drill down, Parameterized, cascading parameterized and sub reports
• Used various representations for the reports some of the representations are table, charts, pie, maps, gauge, matrix and indicators.
• Involved in configuring the report server.
• Deployed various reports to the report server and managed user permissions. Created different levels of security such as server level security, folder level security and report level security.
• Generated daily, weekly and monthly reports as per the customer requirements using subscriptions and maintained the snapshot history.
• Created ad-hoc reports using report builder.

Environment: MS SQL Server 2012/2008, SSRS, MS SQL Profiler, MS Access, MS Excel

Confidential, Salem, OR

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed new ETL packages using SSIS to validate extract, transform, and load data to data warehouse and data mart databases from excel spread sheets, flat files and OLEDB sources.
• Writing triggers, functions, views, indexes and developing T-SQL code as stored procedures and functions to be used directly in generating reports.
• Created different types of ad-hoc, cross-tab, sub-reports, tabular, parameterized, drill down and multi drill down reports.
• Deployed reports to the reports server and managed different levels of security.
• Managed subscriptions and snapshot history.
• Used MDX queries for the calculated measures and KPI's to design star schema using dimension tables and fact tables in SSAS.
• Created SSIS packages using slowly changing dimension, pivot transformation, derived columns, term extraction, execute SQL task and execute package task etc. to generate underlying data for the reports and to export cleaned data from XML files, excel spread sheets, text file, and CSV files to data warehouse / OltpDB.
• Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on daily basis using SQL server agent.
• Deploy SSAS OLAP cubes on development and production server for performance analysis.
• Created user defined data types and to model database to be deployed into production environment.
• Designed and developed BI Reporting solution, enabling users to effectively utilize the tool and create Analytical Reports, Dashboards, and Scorecards, align KPIs performance metrics to strategic drivers and priorities.
• Testing dashboards and data validation.

Environment: SQL Server 2008/ 2008R2, 2012 T-SQL, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), T-SQL, QlikView 9.0

Confidential, Schaumburg, Illinois

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Migration of data from different sources (text based files, excel spread sheets) to MSSQL.
• Implemented triggers, functions, stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up efficiency of queries and analysis in SQL server management studio.
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Worked on querying the data and creating on demand reports using report builder in SSRS reports and send the reports via email.
• Developed stored procedures and views to generate various drill down reports, parameterized reports using SSRS.
• Designed and created bar graphs, pie charts, power pivot tables and deployed them on to the web server for viewing.
• Capturing XML data from the server.
• Built efficient SSIS packages for processing fact and dimension tables. Defined the logging process for all the packages and populated it with entries like inserted record, update record and error record.
• Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development and ETL development.
• Created an ETL automated summary report which consists of the summary information for all the loading activities done each day and month.

Environment: MS SQL Server 2005/2008, Business Intelligence MS SQL Server Integration Services (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS), Teradata.

Confidential, Pleasanton, CA

SQL Server Developer

Responsibilities:

• Developed and deployed SSIS packages also upgrading DTS packages to SSIS
• Involved in extracting the data from OLTP to OLAP using SSIS.
• Used various transformations while mapping the data from source to destination using SSIS.
• Used SQL Server Agent to automate the SSIS package execution.
• Migrated 80+ DTS packages from SQL using SSIS designer.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS.
• Good understanding of data base connectivity mechanisms using ODBC, ADO and TCPIP and named pipes.
• Tested and managed the SSIS packages.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2005.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report for the insurance policies using SSRS.
• Created stylish Report Layouts and Deployed the Reports using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for writing complex stored procedures, triggers, views and queries.
• Created indexes, constraints and rules on database objects.
• Researching customer problems and filing bugs with SQL Server development team.
• Participated in implementation of new releases and code reviews.
• Performance testing on stored procedures, indexes, and triggers.
• Capacity planning and developing automation scripts for routine/redundant tasks.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Erwin, MS Excel, MS word, Visual Studio 2005