Data Developer

Srikanth Sistla

Email: ********.****@*****.***

Phone: 781-***-****

PROFILE SUMMARY

SQL BI developer/ETL Developer with 10 plus Years of strong experience in Data Design and Development on Microsoft SQL Server 2016/2012/2008 R2/2008, advanced T-SQL, Oracle, Dynamic SQL, Microsoft BI Stack (SSIS, SSRS, SSAS), Power BI, Xml.

Expert in converting business requirements into real time project execution plan and provide a solution to achieve the goal.

Strong technical knowledge in SQL Server BI suite (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS and various 3rd party tools

Responsible for ETL operation using SQL Server Integration Services (SSIS) and have experience in Incremental data loading.

Experience in SQL programming and creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Functions, Triggers and Cursors. Hands on experience in troubleshooting database issues.

Experience in developing matrix and tabular reports including drilldown, sub reports and maintained Security and integrated with SharePoint and overall Reports Life cycle.

Experience in designing and implementing database logical and physical data models, schemas and document the testing and maintenance of system corrections.

Good Understanding in Waterfall as well as Agile projects with a solid foundation in Software Development Lifecycle (SDLC).

Excellent knowledge in Datawarehouse concepts.

Developed OLTP systems and involved in creating facts, dimensions and Star Schema representation for the data mart.

Experienced in dimensional design, data modeling, and data optimization.

Experience in development of reports and dashboards.

Experience working with Microsoft cloud’s Azure Data Lake and Azure Data Storage.

Experienced in Database Backup and Recovery procedures.

Experienced in writing complex T-SQL queries.

Researching, designing, and testing new stored procedures.

Working knowledge with Microsoft, Teradata, oracle databases.

Experienced in designing and implementing Data Warehouse architectures, OLAP technologies, Star-schema, Snowflake schema and Aggregation Techniques.

Ability working in fast-paced environment. Good problem solving and analytical skills.

Maintained physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL profiler.

Experienced in OLTP and OLAP databases.

Designed and generated OLAP cubes. Built reports, dashboards and scorecards on OLAP cubes.

Monitored Scheduled jobs and alerts.

Consolidating issues that needed to be escalated to engineering team along with additional data points such as exact error messages, retro steps, etc. that facilitate root cause identification.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Strong experience in setting up replication between a different node.

Experience in Performance Tuning and Query Optimization.

Monitored and modified jobs to improve performance using execution plans and Index tuning.

Identify database performance issues, database capacity issues and other distributed data issues and fix the same.

Monitoring SQL server performance using SQL profiler to find performance and dead locks and blockings. Rebuilding the indexes at regular intervals for better performance

Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.

Experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.

Create SSIS ETL packages which Includes tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.

Efficiently importing large volumes of data from multiple systems into a data warehouse environment.

Experience in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler

Excellent Knowledge in creating databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User Defined data types, Cursors, Triggers and Indexes using T-SQL.

Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.

Experience in creating and managing fragmentation of Indexes to achieve better query performance.

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2012, 2008/2008 R2, SQL Server 2005, Access, Oracle 8i/9i/10g, My SQL.

Database Tools: SQL Server Management Studio, Oracle SQL Developer, Performance Monitor, Query Analyzer, Query Optimizer, Query store, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS), SQL CMD.

Languages: T-SQL, Dynamic SQL, XML, C, C++, DAX,MDX,Python and R language (Beginner-getting better at it)

Reporting Tools: SQL Server Reporting Services (SSRS), Power BI, Crystal Reports 9.0/8.5, Tableau,

Jasper

Integration Tools: SSIS, Informatica, BCP

Data Modeling: ER-win, MS Visio,ER Studio

Development Tools: BIDS, SSDT, SSMS

Cloud: Azure, AWS

Version control: Visual Source Safe (VSS), Team Foundation Server (TFS), SQL builder

Operating Systems: Windows 12, Windows 7/8, Linux.

CERTIFICATIONS:

Microsoft Certified Solutions Associate (MCSA)

461-Querying Microsoft SQL Server 2012/2014

462-Administering Microsoft SQL Server 2012/2014 Databases

463-Implementing A Datawarehouse with Microsoft SQL Server 2012/2014 Databases

EDUCATION:

Bachelor’s in Computer Science

Andhra University

Master’s in Biotechnology

University of Norther Iowa

PROFESSIONAL EXPERIENCE:

Client: State of Arizona Eligibility and Enrollment Dept

Lead ETL Developer Dec 2014 –Present

Worked as Lead developer for Implementation and maintenance of all business intelligence module. Responsible for Working with client stakeholders, gathering requirements and implementing End to end Data solutions which includes designing Data models, ETL Pipelines, Report development and overall Datawarehouse Creation and Maintenance.

Responsibilities:

Acted as primary contact for the Defects raised by clients in the module.

Collaborated with stakeholders and business analysts to gather detailed requirements and specifications.

Created and maintaining the enterprise Data Warehouse structure to support the software development life cycle (SDLC) phases.

Implemented Dimensional Modeling by identifying facts, measures and dimensions and designed Star-schema and Snowflake schema.

Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using Server Integration Services (SSIS) into Datawarehouse.

Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.

Worked with T-SQL to create Tables, Views, and triggers and stored Procedures, cursors, common table expressions.

Built a Tabular Model cube from scratch data and Built Measures in tabular model using DAX queries and created partitions in tabular model.

Built KPIs in tabular based on the end user requirements, worked on Performance of SSAS tabular model cubes.

Designed SSAS cube objects such as KPIs, aggregations, perspectives, and translations.

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed ETL processes and built reports and dashboard, supported more than 6 clients.

Developing visual reports, dashboards and KPI scorecards using Power BI desktop and deployed reports to power BI server and service.

Develop monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.

Create and manage report subscriptions in the Report Server web portal

Used SSIS to implement the Slowly Changing Dimensions, to maintain Historical Data in Data warehouse

Implemented logical and physical modeling using ERWIN data modeler

Developed reports using Report Designer and maintained security and role-based security.

Developed matrix and tabular reports including drilldown, sub reports and maintained subscription.

Worked with Azure Data Lake and Azure Data Storage.

Optimize performance of queries with modifications in T-SQL queries, remove unnecessary cursors, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.

Implemented SSRS Business Intelligence Life cycle such as Configuration of Report server Configuration, Deployment of reports, creating report subscription.

Wrote stored procedures to generate Adhoc reports as per client system requests.

Worked with T-SQL to create Tables, Views, and triggers and stored Procedures, cursors, common table expressions

Monitored Scheduled jobs and alerts.

Deployed SSRS reports to the reporting server and assisted with deployment problem repairs.

Developed and maintained SSIS packages to transform and load data from primary databases to reporting databases.

Debugged SSIS packages with features such as breakpoints, event-handlers, data viewers, and custom loggings.

Worked on requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents.

Monitored SQL server performance using profiler to find performance and dead locks and blockings. Rebuilding the indexes at regular intervals for better performance

Involved in database administration to include installation, configuration, altering schemas, security management, performance tuning, SQL job creation/maintenance. Also installed many SQL 2012 failover clusters and Always On.

Coached and mentored team members on reporting tools, Analytics and performance tuning.

Installed table partitioning on several databases and tables.

Developed stored procedures and triggers to facilitate consistent data entry into the database

Imported the various files provide by the clients into the relational database systems.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Environment: SQL Server 2016/2014/2012, T-SQL, SQL Server Integration Services (SSIS), BCP, SQL Server Reporting Services, SSAS, Azure, TFS, Power BI, Agile, Visual studio, spotlight, SSDT.

Key Achievements and awards:

Developed stored procedures for most complicated dashboard for monitoring workers performance metrics which is the most used page in the system.

Implemented Dimensional modeling for reports database.

Client appreciation award for the month of January for successful completion of data loading of ALTCS data.

Above and Beyond award for second quarter of 2017 for successfully delivering and client satisfaction of ALTCS reports and workloads.

Client: State of California Eligibility and Enrollment Dept

Sr. SQL BI developer May 2013–Nov 2014

I was a part of Program operations with a team size of 3 responsible for ETL and Database development, Report Generation and performance monitoring.

Responsibilities:

Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance

Wrote stored procedures to generate Adhoc reports as per client system requests.

Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources (oracle, Teradata) into Company Format.

Created SSIS packages to download data from FTP sites and populating into different databases and tables.

Build data integration design and technical specifications, in alignment with DI technical architecture and framework, based on business functional and non-functional requirements

Created Drill down and drill through reports in SSRS.

Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.

Created various reports like parameterized, linked, snapshot, cached, clickthrough, drilldown and drill through, sub-reports, and graphs.

Expertise in scheduling reports to end-users and give access to the report server.

Created Subscriptions such as standard and data driven in Report Manager SSRS to generate email notifications.

Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.

Developed and scheduled the cached reports in SSRS

Created SSIS packages to import data from MS Access, Excel to SQL server.

Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data.

Effectively created and used views in SQL Server to prevent unauthorized access

Performed tuning of databases by normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Developed and created the new database objects including tables, views, indexes, stored procedures and functions, advanced queries and updated statistics using Query Analyzer

Worked on complex data loading (implemented the batch data cleansing and data loading

Meeting with Business Analyst and data modelling team to understand requirements and existing

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard

Data conversion from Text File into SQL Server Table and Database recovery and database maintenance plan

Assisted in designing and implementing database logical and physical schemas and document the testing and maintenance of system corrections

Environment: SQL Server 2012/2008 R2 Enterprise Edition, oracle, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SSDT, Visual studio

Key Achievements and awards:

Identified and performance tuned problematic stored procedures which were affecting the performance of the system.

Above and Beyond for the first quarter of 2013 for successful database Design and development for Des project

Client: The Commerce Insurance, MA

Sr. SQL BI developer May 2012–April 2013

I was a part of Solution Advancement team with a size of 6 responsible for ETL and Database development, Report Generation and performance monitoring.

Responsibilities:

Responsible for Documenting the Business Requirement and taking confirmation from Business users.

Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.

Responsible for analyzing, designing, implementing and maintaining complex components of Reporting / Business Intelligence information systems (business objects XI) that support critical business operations

Worked with ETL Development Team for extracting data from Data ware house, perform Transformations as per the requirement and Load the data into existing Oracle DB, and data integration for better performance.

Created Reports based on Views, Stored Procedures and Commands. Modified existing Report based on the User requirement and created running totals, sub-totals and used Crystal syntax to create complex formulas for the Reports

Involved in re-designing or customizing the existing Materialized Views and Stored Procedures to suit the Reporting needs and pull the records from multiple tables using JOIN’s.

Developed Parameterized Reports, Cross tab Reports and Sub Reports involving complex formulas.

Involved in redesigning of Existing Universe designs.

Involved in performance tuning of reports by eliminating filters at report level.

Responsible for showing all of your business intelligence (BI) content in one consolidated view using Dashboard builder.

Used prompts to make Reports confined to a case as per business requirement.

Generated sub Reports, linked and unlinked Reports, Reports on demand

Expertise in database Performance tuning

Implemented & managed database clustering, failover and load balance technologies as per client requirement.

Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers

Worked on complex data models and ERD diagrams to structure the data.

Environment: SQL Server 2000/2005 Enterprise Edition, T-SQL, SSIS 2005, VisualStudio.NET, Windows 2000 Advance Server, Windows 2003 Advance Server, MS Excel, MS Access

Client: Mattel, CA

Sr. SQL BI developer Sep 2011–April 2012

I was a part of SQL developer team with a size of 10 responsible for ETL and Database development, Report Generation and performance monitoring.

Responsibilities:

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts

Created ETL packages to load data from Oracle to SQL Server using various transformations in SSIS

Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)

SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL

Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

Analyzed the existing tool and participated in meetings with the business users to gather Requirements and design goals of data warehouse

Identified the dimension, fact tables and designed the data warehouse using star schema

Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS)

Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling

Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches

Developed Aggregations, partitions and calculated members for cube as per business requirements.

Defined appropriate measure groups and KPIs & deployed cubes

Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)

Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS

Created report snapshots to improve the performance of SSRS

Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups

Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers

Environment: SQL Server 2005/2008, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), MDX, SQL Profiler, MS Excel 2003, Visual Studio 2005,.NET Frame Work 1.0,SharePoint 2007.

Client: StubHub, KS

SQL server developer May 2009–Aug 2011

Small team consists of ten responsible for write complex logic using T-SQL queries for the front-end application, develop ETL solution like designing SSIS packages, data warehouse and build reports using SSRS

Responsibilities:

Performed all SDLC phases related to extraction, transform, and loading (ETL) processes by using SQL Server Integration Services (SSIS) and SQL Server stored procedures in MS SQL Server 2005 and 2008 environments

Install, configure and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases

Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects

Prepares users by conducting training; providing information; resolving problems

Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery

Developed complex canned reports using SQL Server 2012/2008 Reporting Services (SSRS)

Created and maintained data flow diagrams for existing and future ETL processes

Created and maintained detailed source-to-target ETL mapping specifications

Participated in on-call support rotation for nightly ETL batch cycles

Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency; and resolve other technical problems

Developed highly optimized stored procedures, functions, and database views

Translated business requirements into BI application designs and solutions

Involved in performance monitoring, tuning and capacity planning

Developed ETL audits and controls to ensure quality of data to meet or exceed defined standards and thresholds

Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.

Have written Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters, parameters, indicators, gauges, spark lines

Created stored procedures to be used as datasets for the Report Design

Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver Reports

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, SSRS.

Contact this candidate