| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEMSBI/ PL-SQL Developer/SSIS/SSRSSummary: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 BIExpert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS, Tibco Spotfire.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 MDX SVN, GitHub.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).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.Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables.Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.Experienced in Data Masking and security of PII data (IBM OPTIM), Testing, Debugging, Validation and ReportingHaving strong experience in all Test Driven Development and Continuous Integration.Very good experience in writing expressions in SSRS.Review, validate and cleanse claims data towards preparation of the final data set for claims analysisExperience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling.Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.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.Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.Proven understanding of Hadoop SQL base tools such as Hive & Impala and Experienced in running query using Impala and used BI tools to run ad-hoc queries directly on Hadoop.Education:Bachelors in Computer Science, JNTUH, 2013Masters in computer science, Governors State university, 2017Technical Skills:Business Intelligence ToolsMicrosoft BI (SSAS, SSRS), SSAS Tabular, Self-service BI (Power Pivot, Power View, Power Map, Power Query), Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer), Qlikview Self Service BIETL ToolsSSIS, Informatica Power Center 7.x, Ascential Data Stage 7.5, SAP Business Warehouse, Power QueryDatabase SystemsMS-SQL Server 2000/2005/2008/R2/012, Oracle 10g/11g, DB2,MS Access, IBM Data StudioDatabase Management ToolsSQL Query Analyzer, SQL Profiler, DTA, SQL Server Activity Monitor, SQL Server Logs, Toad, HueProgramming LanguagesT-SQL, PL/SQL, .Net, MDX, DAX, HTMLOperating SystemsWindows 98/ME/2000/NT/XP/2003/7, MS DOS, Linux, IIS 5, 6, IBMProject ManagementMicrosoft Project/Office 2003,2007, 2010, 2013, Microsoft Visio, ErwinProfessional Experience:Delta Airlines Apr 2022 Till DateProject: Global Sales and Incentive System (GSIS)Role: Senior SQL DeveloperResponsibilities:Defining project scope, plans, and deliverables, including proposed implementation dates. Researching, analyzing, recommending, and implementing modern technologies, standard processes, tools, and techniques. Assisting in defining alternative solutions for business problems.Participating in standard business and technical information technology solution implementations, upgrades, enhancements, and conversions. Uses appropriate tools to analyze, identify, and resolve business and/or technical problems.Working on systems based on core technologies, Development (Niche) refers to niche technologies such as ecommerce systems and Specialty Development in Delta terminology refers to Mobility and TPF.Constructing, evaluating, and implementing portions of business and technical information technology solutions through application of appropriate software development life cycle methodology.Applying specialized knowledge in a single discipline such as assembly/integration, cross- discipline functions, knowledge engineering, industry expertise, or legacy evolution. Interacting with the customer to gain an understanding of the business environment and technical context.Writing SQL queries in updating tickets, coupons, and agreements data and works on quarterly processing for various countries and generates various kinds of share gap, Vol share reports using Hyperion tool.Analyzing and updating SSIS packages to meet the customer needs.Creating Linux scripts to automate ARC related processes and schedules the scripts to run on different schedules like weekly, daily, monthly etc. using Control M jobs.Involved in various EET regression processes to evaluate the exhibits creation automation process using LWC mode and updating the UFT scripts accordingly.Maintaining and running the SQL Agents jobs to refresh the agreements and build performance for various accounts and countries and works in regenerating and reprocessing the payments when needed for specific accounts.Updates the existing GSIS packages, procedures and tables based on customers requirements.Creates various reports using Salesforce for different countries like NAM, MX and Canada.Creating ETL packages (SSIS) helping in migrating data from different sources (Oracle, files, SQL) and updating the current servers/ tables in SSMS.Populating datasets using SQL queries involving joins, sub queries in Teradata environment on the customers data.Worked extensively with SSIS to import, export and transform the data from different data sources like XML, Text Tables, Oracle, SQL profilers.Worked with various SSIS control flow tasks and data transformation tasks like data conversion, derived column, look-up, and fuzzy look-up, conditional split etc. as part of ETL.Created checkpoints and configuration files in SSIS packages.Environment: SQL Server 2017, SQL Server Management Studio (SSMS), SQL Server Integration services (SSIS), Teradata, Linux Korn Shell Scripting, Hyperion Reporting Tool, UFT (Unified Functional Testing Scripts), Control M Jobs.Molina Health Care, Oakbrook, ILApr 2020 Mar 2022SQL BI AnalystResponsibilities:Develop ad-hoc reports using MS SQL Server, SQL Reporting Services, SQL Server Integration Services and Power BI.Solid understanding of relational database, modeling concepts and Power BI Dashboard Reporting.Understands how to prioritize reports according to business need, regulatory requirements, urgency and / or other key business factors.Coordinates data and analyses from MHI and / or Health Plans as needed.Modifies reports in response to error identification and / or approved change requests; understand the balance between responsiveness to business requests for enhancements versus department needs to complete work efficiently and timely.Analyzing, requirements gathering, documentations, coding like stored procedures and packages, Query optimizing, testing, bug fixing, designing reports using SSRS and SQL server 2005.Writing SQL server stored procedures and create / maintain SQL Server Development Database objects in the data warehousing environment.Conduct data mapping, design, develop, and implement extract / transform / load processes using custom ETL based on SSIS technology.Help Optimization of queries and performance tuning to make the queries run fast from tables with millions of records using PL/SQL codes.Creating adhoc reports and automate reports as and when needed using SSRS and Power BIParticipated in team meetings and got involved in technical design/ planning of middle ware database to combine data from various sources.Created various complex Map Chart, Cross tab Reports and Chart Reports.Developed multiple tabular and combination charts.Extracted, compiled and tracked data, and analyzed data to generate reports.Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.Established Database Connection and Created Dashboard file (DXP) in Spotfire Server.Responsible for developing business centric reports, dashboards, data requests, metrics, and other tools using the Microsoft Business Intelligence framework. Represent the department in fostering and developing relationships with other business units requesting business intelligence services. SSAS, SSIS and SSRSDevelop data extraction, write SQL queries, stored procedures, and packages, and manage data integrity for the data used in the reporting projects.Working on migrating SQL code to Data Lake Impala. Creating dynamic SQL parameters in SSRS when using Data Lake as a source.Working on importing data into data lake sandbox and Queried both Managed and External tables created by Hive using Impala.I have work experience in various kinds of data sources such as Teradata and Oracle. Successfully loaded files to HDFS from Teradata and loaded files from hdfs to hive and impala.Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server reporting services (SSRS), T-SQL and MDX, Power BI, Toad Workbook 5.2, Hue Editor.HCSC, Chicago ILFeb 2019 Mar 2020SQL Server BI DeveloperResponsibilities:Involved with business analysts in creating/reviewing business requirement documentsInvolved in creation/review of functional requirement specifications and supporting documents for business systems.Created tables for loading Provider and claim data in SQL server 2016Developed high performance views/ stored procedures for generating extracts for Provider and Claim data.Developed new ETL architecture for loading data using SSIS instead of Data StageDeveloped various SSIS packages for loading the Provider, Claims and Membership data into a data warehouse.Created complex Packages in SSIS 2016 as part of automating the extract Process.The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split and Data Conversion.Reviewed & Tested packages, fixing bugs (if any) using SSDT 2016.Generated different SSRS reports for different providers and provided subscriptions on daily, weekly, Bi-weekly, monthly, Quarterly and yearly basisEstablished connection between Spotfire and Tibco Data Virtualization to utilize AccelQ APIs.Integrated stored procedures with Spotfire to create a unique selection of columns for report.Used SQL Azure extensively for database needs in various applicationsLoading Data into different environments based upon the requests.Analyzed the data models to document the tables & their relationships.Worked on different data sources (xml source, excel, csv, flat file, web service) to pull, parse and load data into client servers.Optimized SQL queries and procedures for efficiency and to reduce time duration of data load.Created the store procedures and Data Modeling to back up the production data.Create database objects such as tables, views, stored procedures, Triggers, User Defined Functions, linked server queries for extracts from db2 and MySQL.Created the SSIS package to filter the physician data according to Vendors and Hospital Management requirement.Also created the SSRS package to generate the Reports for Financial team.Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), T-SQL and MDX, SVN. Continuous IntegrationFEDEX WHQ, Memphis, TNJuly 2017 Jan 2019MS SQL Server (SSIS/SSRS) DeveloperResponsibilities:Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.Created SQL Server Reports based on the requirements using SSRS 2012,2014Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.Experience in creating XML files by designing the SSIS packages and SQL server.Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).Troubleshooting performance issues and fine-tuning queries and stored proceduresWorked on OLAP Data warehouse, Model, Design, and Implementation.Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.Created multiple reports with drop down menu option having complex groupings within the report.Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).Experience in creating complex SSIS packages using proper control and data flow elements.Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centersQuerying and manipulating multidimensional cube data through MDX Scripting in SSAS.Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS)Scheduling the SSIS packages and Jobs.Worked very closely with Business Customers, End Users and resolved any business process related issues.Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse. Periodically developed a Report to be used by the Senior Management utilizing SSRS.Developed SAS Macros for data cleaning, reporting and to support routine.Develop and Debug T-SQL scripts in a complex relational database system (RDBMS).Worked on Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 by using MDX And generated the Reports using SSRS and Power BI tools for vendors.Built the whole new Data Base with tables, views, triggers, indexes and store procedures to avoid the use of Access Data Base. And created the SSIS package to send the data to vendors.Created the optimized SQL querys to get the data from DWHS to avoid the use of Adhocs.Worked on the optimization and performance tuning of SQL Server using ProfilerEnvironment: Windows server 2003, IIS 6.0, MS SQL Server-2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, GitHub and SVN and Continuous Integration.SYNTEL, Chennai, INDIAMar 2014 Dec 2015Projects: Solvency and Performance & AnalyticsOracle PL/SQL DeveloperResponsibilities:Developed, tested, debugged and documented Oracle PL/SQL packages and types in accordance with company policies, company standards and industry best practices.Assisted in the conversion of existing PowerBuilder code to PL/SQL and Java to support a new Flex application.Tested coding modifications and assisted with application and system testing to minimize errors and downtime.Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.Developed data model, PL/SQL Queries, SQL Query tuning process, and Schemas.Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.Formulated SQL queries, functions and processes as per requirement.Worked with developers to repair and enhance current base of PL/SQL packages to fix testing issues.Created and maintained PL/SQL scripts and stored procedures.Huge experience in developing Oracle PL/SQL packages and object typesSolid understanding of inheriting PL/SQL object types, casting PL/SQL object types into descendant types, converting PL/SQL object collections into a result set, bulk operations and pipelined functionsBuilt new functionality and improve processing time through code optimizations and indexes.Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.Experience working with Oracle CLOB, BLOB, Materialized Views, Ref Cursors, Index Organized Tables, Partitions, Objects/Collections, Execute Immediate etc.Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.Written packages, triggers, stored procedure and functions for Solvency project which involved retrieving data using FTP, scheduling through AUTOSYS, extracting and loading using ETL (Data Stage) and PL/SQL.Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.Worked on XML along with PL/SQL to develop and modify web forms.Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.Improved the performance of the application by rewriting the SQL queries.Used SQL*Loader as an ETL tool to load data into the staging tables.Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data ware housing. Extracted data from the XML file and loaded it into the database.Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.Defect tracking through JIRA and defect summary reporting.Proficiency with SCCS and Clear case version control systems.Worked on agile and test driven environment, participated on daily scrum meeting, and discussions.Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, SQL*Plus, PL/SQL, Oracle Designer 2000, Windows 2000, Toad. |
