BalaKrishna
Chicago, IL,***** 609-***-**** *********.*********@*****.***
Summary: -
●8+ Years of IT Experience in Microsoft Business Intelligence Technologies SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI (PBI).
●Excellent working experience in SDLC, RDBMS, Data Warehouse concepts.
●Better understanding of Normalization and De-Normalization techniques for both OLTP and OLAP systems.
●Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL Queries, Triggers, User-defined functions, Common Table Expressions (CTEs).
●Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered indexes and efficient coding standards.
●Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
●Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
●Expert in Extraction, Transforming and Loading (ETL) data using SSIS, Bulk Copy Program (BCP), Data Transformation Services (DTS).
●Creating Control flow/Dataflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
●Experience in creating jobs, SQL Mail Agent, Alerts, and schedule SSIS Packages.
●Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.
●Worked with continuous integration and deployment tools and procedures such as Jenkins, Git.
●Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS).
●Handful experience on Creating Multi Parameterized reports using SSRS.
●Exposure to SSRS roles (Browser, Content Manager, System Administrator, My Reports, Publisher) for various Business reports in Multi-User Environment.
●Expertise in Power BI, Power BI Pro, Power BI Mobile.
●Working Knowledge in creating and developing Power BI Dashboards in to rich look.
●Experience in developing Dashboard Report, Parameterized Reports, Linked Reports, Sub Reports using Power BI.
●Experience in working with Agile, Scrum Process in software development.
●Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
●Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
Skills & Abilities:-
RDBMS
SQL Server 2016/2014/2012/2008R2/2008, Azure, Oracle 11g/10g/9i, MS Access, DB2, Sybase, Teradata.
Analysis/Reporting Tools
SQL Server Analysis Service (SSAS), SQL Server Reporting Services (SSRS) 2012/2008R2/2008, Power BI.
ETL Tools
SQL Server Integration Services (SSIS) 2016/2014/2012/2008 R2.
Database Tools
MS SQL Server 2000/2005/2008/R2/12/14/16, SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager and Reporting Server.
Data Modeling Tools
Erwin 7.2/4.5, MS Visio.
Microsoft Tools
MS Word, MS Excel, MS PowerPoint, MS Outlook, TFS.
Operating Systems
Windows 10/7/Vista/XP, Linux.
Web technologies
HTML, XML, CSS.
Certifications: -
●Exam 70-761: Querying database with T-SQL.
●Exam 70-762: Developing SQL Databases.
Education: -
●Master of Science in Information and Communication Technology, University of Denver, 2014-2016.
Work Experience: -
BI DEVELOPER CARELON (AIM SPECIALTY HEALTH), CHICAGO, ILLINOIS NOV 19- CURRENT
Responsibilities:
●Involved in Working with business analysts to build tight technical specifications within a formal SLDC project environment assuring the business requirements are met by the coded solutions.
●Responsible for writing T-SQL (DDL/DML) Queries, Views, Functions and Triggers.
●Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
●Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
●Developed SQL Server Package Configuration technique to make Dynamic configurations.
●Used SSIS to create ETL packages to validate, extract, transform and load data into Data Warehouse and data marts.
●Developed Slowly Changing Dimensions (SCD) Packages using SSIS (ETL) to perform the Incremental Historical load from Source to Staging Environment and into the Enterprise Data Warehouse.
●Closely worked with production application teams to provide highly performing procedures to get back-end data.
●Configured SQL Mail Agent for sending automatic emails when SSIS packages fails or succeeds.
●Extracted Data from various Heterogeneous Databases such as Oracle and Access database, Sybase, flat files to SQL server 2016/14, Sybase using SSIS.
●Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
●Used Text Files/SQL Server Logging for all SSIS packages.
●Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
●Deployed and configured the reports in the Report Server.
●Developed various drill down, parameterized reports using Crystal Reports and SSRS.
●Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
●Developed Stored Procedures to generate various Drill-through reports, Parameterized Reports, sub-reports and linked reports using SSRS and integrated into the front end.
●Developed Power BI model used for Financial Reports.
●Handful experience on writing DAX functions in Power BI and Power Pivot.
●Wrote Calculated columns, Measure query’s in Power BI desktop to show good data analysis techniques.
●Exposer on all kind of transformation that are available in Power BI query editor.
●Designed and Developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
●Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
Environment: MS SQL Server 2016/14, MS SQL Server Reporting Services 2016, MS SQL Server Integration Services 2016, MS Visual Studio 2015, SSAS, Power BI, TFS, Service Now.
SQL, BI DEVELOPER ZELIS HEALTH CARE, BEDMINSTER, NEW JERSEY MAR 19- NOV 19
Responsibilities:
●Participated in daily agile scrum meetings to understand business logic and requirements of the company and provide optimal solutions to the users.
●Worked on SQL Server development including writing T-SQL Queries and creating SQL Server objects like Stored Procedures, User-defined Functions, Views, Triggers, implementing T-SQL relational database models and data integrity.
●Wrote complex TSQL queries to get data from different sources and test results with expected results.
●Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in a given period.
●Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
●Formatted reports for various Output formats as requested by the management using SSRS.
●Actively supported business users for changes in reports as and when required using SSRS.
●Analyzed reports and fixed bugs in stored procedures using SSRS.
●Used complex expressions to group data, filter and parameterize reports.
●Wrote Parameterized Queries for generating Tabular reports, Formatting report layout, creating reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and Datasets, calculating subtotals and grand totals for the reports using SSRS 2016.
●Used cascaded parameters to generate a report from two different Data Sets.
●Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
●Designed data intensive reports in Power BI utilizing various graph features such as Gauge, Funnel, Line better Business analysis.
●Installed and configured Enterprise gateway and Personal gateway in Power BI service.
●Supported Extract, Transfer, Load (ETL) efforts using Integration Services tools. Created, configured, modified and tuned SSIS packages.
●Created custom packages to load slowly changing dimension tables (for Type 2 and Type3 loads).
●Worked with SQL Server Job Agent to schedule packages, run and monitor them.
●Used Team Foundation Server to keep track of new created SSIS packages, and to modify and update existing packages when it is necessary.
Environment: MS SQL Server 2012/14/16, MS SQL Server Reporting Services 2012/14, MS SQL Server Integration Services 2012/14, MS Visual Studio 2013/15, SSAS, Power BI.
SSIS/POWER BI DEVELOPER VERIZON, HILLOARD, OHIO SEP 17- FEB 19
Responsibilities:
●Worked extensively with the end users in understanding the business rules and writing technical specifications and mapping documents from staging to data mart, cubes and reporting needs.
●Wrote T-SQL Queries, Dynamic Queries, Sub-Queries and complex joins for generating stored procedures, user-defined functions, views and cursors.
●Performance Tuning Database Queries, Stored Procedures, Views to improve performance and scalability.
●Designed processes for Extract, Transform and Load (ETL) of data from legacy system to SQL Server using SSIS.
●Importing Flat file (with different delimiters like comma, tab etc.) into the SQL Server 2008 Database tables using BIDS.
●Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, Data Validation Checks during staging, before loading the data into the data warehouse.
●Developed SSIS packages with various tasks like - FTP, file system, for each loop, execute package, data flow task, execute SQL task, custom script task, data mining task. Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.
●Experience in using SSIS tools like Import and Export wizard, package installation and SSIS package designer. Transformed data from one server to another server using Bulk Copy Program (BCP), and SQL Server Integration Service (SSIS) 2012/2014.
●Proficient and efficient with the Visual Studio 2015 team Foundation Server Tool (TFS).
●Detected bottlenecks, trouble shooting and tuning of mappings, queries, sessions for better performance and efficiency.
●Perform Unit tests, Integration testing and validated results with Functional lead and providing technical guidance to ETL team.
●Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
●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).
●Excellent experience in developing Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
●Experience providing accurate market, product and deal knowledge to potential new clients and existing investors.
Environment: MS SQL Server 2012/2014, Visual Studio 2012/13, SQL Server Integration Service 2012/, SSAS, SSRS, Power BI, T-SQL, Oracle 9i/10g, Erwin 7.2.
MSBI DEVELOPER MED REVIEW INC. NY June 2016 – AUG 2017
Responsibilities:
●Worked extensively with SSIS to import, export and transform the data between the linked servers.
●Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/Data Models, Requirement documents and ETL Specifications.
●Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL server 2012.
●Responsible for logical and physical data modelling, database design, star schema, data analysis, programming, documentation and implementation.
●Daily support, troubleshooting, monitoring, optimization, tuning and blocking of servers and SQL server environments across entire system.
●Involved in Unit Testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
●Generated Database SQL scripts and deployed databases including installation and configuration.
●Created DTS Packages for data import/export, scrubbing and scheduled jobs for backups for SQL and Oracle Databases.
●Written complex SQL statements using Joins, Sub Queries and Co-Related Sub Queries.
●Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
●Used SQL Profiler and Query Analyzer to optimize DTS Package queries and Stored Procedures.
●Migrated DTS objects to SQL Server Integration Services (SSIS) environment.
●Responsible for extracting and transforming data using DTS Import/Export, DTS Packages, MS SQL Server Integration Services (SSIS) Packages, Bulk Insert and Utilities like BCP.
●Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
●Developed various reports using SSRS, which included writing stored procedures for datasets.
●Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
●Developed various operational Drill-through and Drill-down reports using SSRS
●Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
Environment: MS SQL Server 2012/08/08 R2, Business Intelligence Development Studio 2008, SQL Profiler, SSIS, SSRS, Query Analyzer, Erwin.
sql DEVELOPER Iris info sol, Hyd, india NOV 2012 – July 2014
Responsibilities:
●Worked under the senior level guidance.
●Code Development as per the client requirements.
●Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
●Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, Functions, Packages, Cursors, Ref Cursor, and Triggers.
●Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
●Creating views and prepares the Business Reports.
●Resolved production issues by modifying backend code as and when required.
●Used different joins, sub queries and nested query in SQL query.
●Involved in creation of sequences for automatic generation of Product ID.
●Part of team for analyzing and implementing the physical design for database.
●Testing of code functionality using testing environment.
Environment: Microsoft SQL Server 2008, BIDS, Team Foundation Server (TFS), Windows server 2008.