SUMMARY

• Over 8 Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL/Business Intelligence Developer with expertise in SQL Server Integration Services, Analytics, Reporting and Self Service BI
• Over 8 years of IT experience in database design and development in Microsoft SQL Server Suite of Products.
• Expert in working with the Business Intelligence Development Studio BIDS , which includes SSIS, SSAS and SSRS.
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.
• Experienced in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Extensive experience in Writing Transact SQL T-SQL Queries, Dynamic-queries and implementing SQL Server Indexing.
• Having strong experience in scheduling all the T-SQL jobs to run at particular times.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Integrity using all kinds of SQL Server Constraints Primary Keys, Foreign Keys, Defaults, Checks, and Unique .
• Good hands-on working experience in Writing Transact SQL T-SQL Queries, Dynamic-queries.
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP , Bulk Insert, Data Replication, Data Transformation Services DTS and SQL Server Integration Services SSIS .
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Proficient in OLTP, OLAP and Data warehousing Design concepts.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Generated reports using SSRS, Excel Pivot that could be used to send information to diverse group of users.
• Extensive experience in different type of reports including: Tabular forms, Matrix cross Tab report form, Conditional, List items, Charts and Sub reports.
• Strong experience in creating complex reports that use cascaded parameters.
• Very good experience in writing expressions in SSRS.
• Experience in Cube designing in Business Intelligence Development Studio SSAS to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Good Knowledge in OLAP Storage modes likes Rolap/Molap/Holap
• Experience in Relational, Multi-Dimensional Star and Snowflake logical modeling.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts MS SQL.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Developed reports using global variables, expressions and functions using SSRS.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts.
• Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression and Derived Column.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.

COMPUTER SKILLS

EXPERIENCE

Confidential

SAS developer

Responsibilities:

• Responsible for developing and implementing ETL process using SQL Server Integration Service SSIS to support Global Sales and Incentives project
• Assists with the development and testing of the Global Sales and Incentives reporting server data warehouse and related ETL process to support end user daily reporting needs.
• Design, develop, test and implement relational databases and procedural database code using Microsoft SQL Server T-SQL
• Designed, deployed and maintained various SSRS reports like parameterized reports, sub-reports, cross-tab, drill-down, drill-through reports using RDL. Created Linked servers to retrieve date from different databases.
• Document internal and external data sources and data integrations and provide operating support or data integration solutions.
• Create Power map solution based on the location, place name, crew size, number of customers to represent data for the higher level management at LGE
• Created power map solution which gives the geo spatial analytics of customer address using bing maps
• Developed 6 new reports by gathering requirement from business
• Changed dataset for the old reports in order to work on the new system
• Worked as SQL Developer developing complex oracle packages for the new ARM system for the new ssrs reports
• Configured Share Point 2013 for SSRS 2012 reports by installing add on in order to run the reports which provides secured data sets and shared security
• Moved the old code reports, packages from Visual source safe to Team Foundation Server
• Set Subscriptions on report server to deliver reports on daily weekly and monthly basis to email and shared folders.
• Involved in performance tuning, query optimization using SQL profiler
• Interact with end users to understand their needs and provide technical options and solutions

Environment: MS SQL Server 2005, Enterprise Manager, SQL profiler, Query Analyzer, Crystal Reports, Windows 2003/XP

Confidential

Sr. SQL Server BI/ETL Developer

Description:

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C and VB code as required
• Created ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Experienced in slowly changing dimension in SSIS packages.
• Performed incremental data load packages in SSIS
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports SSRS/Crystal/Impromptu from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC Rebuilding Indexes, Integrity Checks
• Created reports based on database usage and perform capacity planning.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Identified and Defined Fact relationships in SSAS.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Business Intelligence Development Studio BIDS , MS Excel, Windows XP.

Confidential

SQL BI Developer SSIS/SSRS/SSAS

Responsibilities:

• Involved in complete Software Development Life Cycle SDLC .
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression MDX .
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Developed a High level dashboard using SSRS 2008. .
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules using T-SQL
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio SSAS, SSIS, SSRS , .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003

Confidential

Role: SQL/ETL/SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. To generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Extracted data from XML to SQL server.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed ER diagrams and mapped the data into database objects
• Experience in developing and extending OLAP Cubes, dimensions and data source views.
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL
• Built reports for the analysis services using SQL Analysis services 2005 using different reporting tools
• Designed dimensions and using the MDX expressions for the various Optimizations like optimizing cube schema in SSAS
• Developed different types of tabular reports, matrix reports cross tab or pivot reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services
• Developed both the drill down and drill through reports
• Designed reports with grouping/sorting and parameters including multi-value parameters using SQL server reporting services
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Provided knowledge transfer to the company's SQL programmers.
• Created several materialized views and UDF's to be accessed by the new front end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Successfully tested all task in staging and stored all versions of data using team foundation server TFS .

Environment

SQL server 2008/2005. BIDS 2005, Reporting services 2005, Integration Services 2005, Analysis Services 2005, Windows Server 2003, HealthCare database, Oracle 9i, DB2,TFS,

Confidential

SQL Server/SSIS/SSRS/SSAS Developer

• The project is designed in two phase's data gathering and reporting, the data gathering part is done using SQL Server Integration Services SSIS and the reporting portion is built on SQL Server Reporting Services SSRS platforms
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data
• Built new SSIS Packages incrementally loading data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, and SSIS transformations
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE .
• Granted permissions to logins, groups to particular database or to a server depending on the requirement.
• Regularly monitored database sizes and disk space.
• Arranged meetings with the developers and other DBA's to discuss the current and new policies which can be established.
• Monitored SQL server performance using profiler to look for dead locks, blockings and captured long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing through Profiler.
• Created indexes to speed the execution of data retrieval queries, rebuilding them if necessary and often checked for any outdated statistics
• Scheduled the backups for Databases and performed restoration operations when needed.
• Used log shipping for synchronization of databases and documented every change.

• Created the dimensional relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration deployment of the Packages
• Designed developed the various SSIS packages for the daily, Hourly, Weekly Monthly Loads
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute sql flow task, data flow task to extract data from different databases and flat files
• Designed different type of reports tabular, matrix cross tab , conditional, list items, charts formerly in cognos reports and SAP BO
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• On the required reports, identified various data sources and established the connections using SSIS and constructed data source view

Environment: MS SQL Server 2005, DB2, Teradata, Microsoft Access, SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS , T-SQL, PL/SQL, MDX/DMX, Team Foundation Server, MS Visio, Agile Scrum Methodology, Microsoft Access, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS

Confidential

SQL Developer

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation missing values, formatting, transformations using SSIS.
• Handled migrations from DTS to SSIS 2005 and 2005 to 2008.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration import export BCP from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
• Written T-SQL queries for the retrieval of the data.
• Worked on error and event handling, break point and check points
• Worked on different methods of logging in SSIS
• Deployed the SSIS packages from development server to production server
• Moved packages on the cognos framework manger and created new models and published packages on to report studio
• Used framework manager to build models, packages and publish packages on to report studio server
• Built models containing with complex security requirements from imported metadata
• Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations
• Developing standard reports cross tab, chart , charts, drill through reports, master detail reports using report studio and ad hoc reports in query studio
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Created query prompts, calculations, conditions filters, prompt pages, using report studio Created Complex reports using custom prompts and Tabular Objects
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel, R, Tableau, SPSS

Confidential

SQL Developer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Involved in analyzing MS SQL server storage, memory, processing and their dependencies/performance bottlenecks.

Environment: SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, IIS 6, Visual Source Safe 2003, Crystal Report 10, Crystal Enterprise 10, Microsoft Visio 2000