Resume

Sign in

Sql Server Data

Location:
Hyderabad, Telangana, India
Posted:
January 11, 2018

Contact this candidate

Anil Kumar Lanka

Sr. MS SQL BI SSIS SSRS Developer

Professional Summary:

●8+ years of strong experience in the IT industry as a MSSQL BI Developer

●Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.

●Strong experience in MS SQL Server 2005/2008/2012 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analytical Services (SSAS)

●Experience in requirements gathering and analysis.

●Experience developing Stored Procedures, Functions, Views, Triggers, XML and Complex Queries with SQL Server 2012/2008R2/2008/2005/2000/7.0, and Oracle 10g and 11g.

●Experience with T-SQL Programming, query optimization and performance tuning.

●Experience with data warehousing methodologies, concepts and tools.

●Developing reports on SSRS on SQL Server (2000/2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.

●Hands on experience in Creating Star Schema and Snowflake Schemas.

●Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

●Excellent understanding of Relational Database Systems, Normalization, logical and Physical data modeling for OLTP and dimensional modeling for OLAP

●Highly proficient in design and development of SQL Server Integration Services (SSIS) packages, importing and exporting of data and using various control flow task and data flow transformation.

●Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using SQL Reporting Services (SSRS).

●Highly proficient in handling parameterized, drill down, drill through and chart reports using SSRS.

●Experience in Azure SQL Databases.

●Experience in various reporting tools like Report Builder, Report Designer and Performance point service designer and Power BI.

●Developed BI Report solutions in Power BI, SSRS and Tableau

●Excellent command in deploying analysis projects using SQL Server Integration services.

●Experienced in design and scheduling integration packages using SSIS

●DTS applications moving data between diverse types of databases and legacy systems.

●Exceptional versatility and adaptability, extremely diligent, dedicated team player with an ability to take new roles. Excellent communication and strong analytical skills.

●Strong soft skills utilizing Microsoft Outlook, PowerPoint, Word and Excel

●Effective in working independently and collaboratively in teams and also responsible for coordination between onsite and offshore teams in various projects.

Education and Certifications:

Bachelors in Information Technology(CSIT)

Skillset:

MS SQL Server 2016/2014/2012/2008R2, SSIS 2016/2014/2012/2008MS SQL Server Analysis and Reporting services,, MS Office, Oracle 8i/9i, C#, VB, T-SQL, ODBC, ADO, DTS, MS Access-XP2000/97, MS Visio 2003, HTML, XML, ER-Designer, QlikView, Tableau, Oracle SQL Developer, PL/SQL, MS Azure

Projects Summary:

Humana Inc., Louisville, KY November 2015- Present

MS SQL BI Developer

Responsibilities:

●Developed suites of applications for Humana’s Enterprise Measurable Messaging Ecosystem that gives insight on letters in progress, volume analysis between EMME and Control Point, time series analysis on process rate and highest and lowest messages received my members.

●Migrated some SSRS Reports of SQL Server 2008 to SQL Server 2012

●Created SSIS package to fulfill the SQL Server maintenance tasks including rebuilding index, backing up database and updating statistics.

● Identified and defined Fact relationships in SSAS for OLAP cubes.

● Built SSRS project to generate reports with desired formats (Word, PDF, Excel and etc) to present statistics information according to business requirement

● Managed the entire ETL process involving the access, analysis, and presentation of information from both internal and secondary data sources to customers.

●Identified and created Data Source Views for OLAP cubes.

●Developed complex SQL queries using Stored procedures, CTE, temporary tables to support Power BI and SSRS Reports

●Created, Configured and Managed OLAP Cubes (Star Schema and Snowflake Schema) using SQL Server Analysis Services (SSAS)

●Integrated custom visuals based on business requirement using Power BI

●Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports

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

●Experience in various reporting tools like Report Builder, Report Designer and Performance point service designer and Power BI.

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

●Created a SQL Server Reporting Services (SSRS) and SSIS Infrastructure that pulls data from various sources and provides a simple to use reporting environment.

●Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.

●Created SSIS Packages for Incremental Loading and slowly changing dimensions

●Created various Power BI Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.

●Mentored business power users to create reports/dashboards using Power BI.

● Coordinated with both Onshore and Offshore teams

Environment: SQL Server 2012, Oracle 11g, Access, .CSV Files. Microsoft SQL Server 2012/2008/2005 Enterprise Edition, OLAP, BIDS, Visual Studio, T-SQL, SSAS, SSIS, SSRS, Oracle SQL Developer, Tableau, QlikView.

Micron Technologies, Boise, ID December 2014 - October 2015

Business Intelligence Developer

Standup a Global Data Warehouse and combine data from multiple source systems with the necessary retention to support the product traceability, process effectiveness, supply chain enhancements and speedy product delivery.

Responsibilities:

●Worked with business analyst to identify and understand source systems.

●Map source system data to the data warehouse, data marts. MSSQL or Oracle to Avro, TSV or CSV file format for ingestion into Hadoop and Teradata.

●Tuned SQL queries using execution plans for better performance. (Both MSSQL and Oracle)

●Created stored procedures for the business logic using T-SQL.

●Developed custom SSIS script tasks using C#.

●Used Micron specific application AUTOETL to deploy and test SSIS packages.

●Developed, unit tested and performance tuned SSIS Packages.

●Documented Data Feeds from source to target using WIKI pages.

●Developed custom SSIS templates to source data from MSSQL or Oracle and target Avro, TSV or CSV files for ingestion into Hadoop or Teradata.

●Developed Active Batch jobs to schedule SSIS packages to drop Avro, TSV or CSV files for ingestion into Hadoop and Teradata.

●Extensive knowledge of ETL processes and procedures.

●Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

●Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.

●Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Cache Transform and Derived column while developing the packages.

●Responsible to monitor performance and optimize SQL queries for maximum efficiency.

●Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.

●Involved in performance tuning of SSIS Packages.

●Created Batch files to run the script in development, production environment.

●Created stored procedures for the business logic using T-SQL.

Hardware/Software:

MS SQL Server 2012, MS SQL Server Integration services 2012 (SSIS), XML, T-SQL, Windows 7, Oracle SQL Developer, Active Batch (Job Scheduler), AUTO ETL, SharePoint, DAT Manager, Enterprise Architect, Teradata Studio

FBL Insurance, West Des Moines, IA June 2013 – Sep 2014

MS SQL Server Developer/BI Developer

FBL Insurance holding company. FBL Financial Group is the parent of Farm Bureau Life. Through its subsidiary, the firm sells life insurance, annuities, and investment products to farmers, ranchers, and agricultural businesses. Farm Bureau Life sells its insurance and annuities through and exclusive network of some 2,000 agents in the Midwest and West. The company markets its products through affiliation with American Farm Bureau Federation.

Responsibilities:

●Map source system data to the data warehouse, data marts.

●Created complex SSIS packages to extract data and scheduled Jobs to call the packages using SQL server agent.

●Created Views for specific columns on a table to maintain privacy of a customer data.

●Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Cache Transform and Derived column while developing the packages.

●Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.

●Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.

●Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data.

●Extensively worked with OLAP cubes to generate drill through reports in SSRS.

●Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.

●Worked on SSIS to import the data from different format.

●Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data

●Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.

●Worked on Team Foundation Server for Version Control.

●Created various Tabular and Matrix Reports using SSRS.

●Proficiently created Reports based on the requirements using SSRS 2008.

●Configured the report viewing security for various users at various levels using Report Manager.

●Successfully worked with Report Server and configured into SQL Server 2008.

●Created Batch files to run the script in development, production environment.

Hardware/Software:

MS SQL Server 2012, MS SQL Server Integration services 2012 (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Analytical Reporting Services (SSAS), MS SQL Server, XML, T-SQL

HP, Cupertino, CA May2012 – May 2013

MS SQL Server Developer/SSIS Developer

Project was Designing ETL to populate data warehouse and importing data from excel sheets, cleaning and scrubbing of data, adding validations to the data using SSIS,loading data to staging and then to data warehouse.

Responsibilities:

●Worked on SSIS to import the data from Excel sheets.

●Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.

●Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

●Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

●Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, for each loop, multi cast, data conversion, Derived column, fuzzy grouping, script components

●Successfully deployed SSIS packages with defined security.

●Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.

●Scheduled database jobs for automation of DBA tasks using SQL Server Agent.

●Responsible to monitor performance and optimize SQL queries for maximum efficiency.

●Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.

●Tuned SQL queries using execution plans for better performance.

●Created stored procedures for the business logic using T-SQL.

●Performed coding of several database triggers and stored procedures and maintained integrity constraints.

●Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner.

●Involved in performance tuning of SSIS Packages.

Hardware/Software:

MS SQL Server 2012, MS SQL Server Integration services 2012 (SSIS), XML, T-SQL, Windows 7

Dow Jones and Company, South Brunswick, NJ June 2010 – April 2012

SQL BI Developer

Dow Jones & Company is an American publishing and financial information firm. Dow Jones offers business and financial information to the individual reader around the globe. Its publications and Web sites are some of the best known and most respected brands. The project was about importing data from different services like Wall Street Journal, Smart Money, and Market Watch etc. in the form of flat files and XML files, Data cleansing and Scrubbing, creating packages and storing the refined data into Data Ware House.

Responsibilities:

●Carried out a Developer’s role on MS SQL Server 2008 (using SSIS, T-SQL, Stored Procedures and Views).

●Imposed Referential Integrity of data by creating different constraints.

●Migration of the data from text files to SQL Server database and SSIS packages for the processing of different policies.

●Managed all indexing, debugging, optimization and performance tuning

●Created stored procedures, triggers and functions for the business logic using MS SQL.

●Successfully performed SSIS packages and scheduled them.

●Used advanced features of MS SQL in order to design and tune MS SQL to interface with the database and other applications in the most efficient manner.

●Effectively used views to prevent unauthorized access in database.

●Managed performance and tuning of SQL queries and fixed the slow running queries in production

●Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report.

●Developed various Charts and Graphs like bar charts, line charts, pie charts etc. by using chart experts for BI needs.

●Built and performed user acceptance testing on new and modified reports.

●Designed and Implemented the Stored Procedures and Triggers for automating tasks.

●Analyzed reports and fixed bugs in stored procedures

Hardware/Software:

MS SQL Server 2008, SSIS 2008, SSAS 2008, T-SQL

Aetna Inc., Hartford, CT Feb 2009- May 2010

MS SQL Server Developer/SSAS/SSIS

Aetna is a healthcare and medical Insurance company. Aetna offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, group life and disability plans, and medical management capabilities and health care management services for Medicaid plans. The project focused on to perform data conversion, migrating data from the Oracle database to MS SQL Server 2005 databases and designed OLAP data cubes to analyze the data.

Responsibilities:

●Designed a complex SSIS package for importing data from SQL Server 2005.

●Successfully deployed SSIS packages with defined security.

●Proficiently created Reports based on the requirements using SSRS 2008.

●Involved to write complex T-SQL queries and Stored Procedures for generating reports.

●Defined parameters for parameterized Reports using SSRS.

●Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008.

●Experience in the design, development and maintenance of different cubes using SSAS.

●Involved in the post deployment maintenance of canned reports and cubes.

●Successfully worked with Report Server and configured into SQL Server 2008.

●Created Batch files to run the script in development, production environment.

●Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data.

●Extensively worked with OLAP cubes to generate drill through reports in SSRS.

●Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.

●Responsible to monitor performance and optimize SQL queries for maximum efficiency.

●Proficiently scheduled the Subscription Reports with the Subscription Report wizard.

●Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system.

●Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.

Hardware/Software:

MS SQL Server 2008/2005, SSAS 2008, SSIS 2008, T-SQL, ORACLE



Contact this candidate