We provide IT Staff Augmentation Services!

Tech Lead Resume

PROFESSIONAL EXPERIENCE:

  • Having 10+ years of experience in Database Design, Development and business intelligence of MS - SQL Server 2005/2008/2012/2016 in various business domains like Financial, Healthcare, Retail and Pharmaceuticals using SSIS, SSRS,SSAS,Power BI.
  • Business oriented data analyst offering professional expertise in providing solutions for data analysis and coding.
  • Coordinate closely with Business users, IT experts, project engineers and subject matter experts in planning and developing analytical methods for data collection, data variables, storage, analysis, statistics and presentations.
  • Proficient in designing BI dimensional data models for Datawarehouse using different methodology.
  • Strong experience in all the phases of the Datawarehouse life cycle involving requirement gathering & analysis, Development, Design and Coding, Testing using ETL tools such as SSIS.
  • Proficient in designing and developing complex reports and dashboards using different reporting tools such as SSRS using MDX and T-SQL, Tableau, Power BI.
  • Worked Extensively on Creating and Calling Complex Stored Procedures, Views, Functions, Cursors, Triggers, Indexes using SQL Server 2005/2008/2012.
  • Building and writing MDX Queries, Calculated Members, and KPI’s using Confidential SQL Server 2005/2008/2012 Analysis Services Business Intelligence (SSAS). Involved in building Tabular Models for Power BI Reports.
  • Experience in Pharmaceutical, Finance, Travel, Retail, HR and IT Services domains.
  • Excellent communication, analytical and interpersonal skills, self-motivated, quick learner and an active team player and team leader. Very flexible and ready to take new challenges.
  • Have worked and successfully delivered many projects at onsite coordinating with stakeholders and developers, during various phases of delivery.
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Fuzzy Lookup, Multicast, Bulk Insert, Merge and union all.
  • Involved in Huge data migrations and transfers using utilities like DTS/SSIS, Import Export Wizard, and Bulk Insert
  • Experience in report in building Power BI and SQL Server Reporting Services (SSRS) and creating several types of reports like Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
  • Experience in Performance Tuning and Query Optimization.
  • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.

TECHNICAL SKILLS:

Databases: SQL SERVER 2005/2008/2012/2016

Programming: T-SQL, MDX,DAX.

Business Intelligence: SSIS, SSRS, SSAS & Power BI.

Tools: Backup Utility, SQL Profiler, Query analyzer.

Operating System: Windows 2003/2008 Advanced Server, NT & Windows 8.

Source Control: Visual Source Safe 6.0.

PROFESSIONAL EXPERIENCE:

Confidential

Tech Lead

Responsibilities:

  • involved in bringing all the data regarding Partners and P-Sellers into Cube and have built Power BI reports on top of this. These reports are used by Confidential internal team for analysis on the revenue, performance monitoring, Forecast of all the Partners worldwide.

Confidential

Tech Lead

Responsibilities:

  • The role involved in this project is to interact with document maintenance team who will provide us the documents or data that has to be loaded into the document repository for company’s reference.
  • Each data or document related to a particular Loan Number is uploaded to repository in a specific format using SSIS packages.
  • Involved in designing/development SSIS packages for many automated process.We are currently working on building the reports using data in repository for higher management team in the company to analyze and plan the strategy.

Confidential

Tech Lead

Responsibilities:

  • The source data is pushed into the staging area, transformed and delivered to the vendor solutions Tagetik, Risk Agility. This entire process was to be automated using SSIS as a tool.
  • The role involved in this project is Database design of Staging area, Analyzing different data sources, implemented parallel execution of multiple instances of SSIS package, invoking the web service through SSIS, processing of flat files with dynamic delimiters using SSIS tasks, custom logging of packages.
  • This package was developed to fully automate the process for Aegon Insurance. The package has to pick the files from the path that will passed to SSIS package as a parameter.
  • The package will first read the delimiter of the flat file and then processes the file to the required format. Once file is processed, SSIS has to invoke the web service of Tagetik system which in turn will pick these files for further processing.
  • This entire process should be executed in parallel for multiple files since there will be too many files that has to be processed.

Confidential

Tech Lead

Responsibilities:

  • To create a wow effect for the business users. Provide BI reporting as a value add to existing tenants. To package BI reporting to new tenants.
  • The role in this project was to design Dimension Modelling for the Data warehouse, Design SSIS packages to load data from Confidential transaction system to DW. Design and develop an SSAS cube using this DW.Finally develop the SSRS reports using this cube using MDX queries.

Confidential

Analyst Lead

Responsibilities:

  • The role involved in this project was requirement gathering, designing data warehouse, technical lead and also worked as a developer.
  • We have developed SSIS packages to load data into Date warehouse and have developed 35 reports using T-SQL.
  • The report layout and logic involved were of very high complexity.
  • The work was very well appreciated by Food World and Health & Glow, for the quality and turnaround time involved in this project.

Confidential

BI Developer

Responsibilities:

  • defined key performance indicators in Phase1 to measure its processes and get better insight into the key drivers in business.
  • These KPIs are represented as a dashboard and drill through reports. There were 7 main dashboards with key KPIs and 10 drill through reports which were developed using existing cube.
  • The project was successfully delivered in phase wise manner and we have got a very good feedback from Confidential .

Confidential

BI Developer

Responsibilities:

  • data of these products are stored in a Datamart using which cubes have been developed. The end users will have an ability to make decisions based on data that is available in the cube.

Confidential

BI Developer

Responsibilities:

  • The key objective of BI in CPSMS was to develop a BI Portal for CPSMS system for user interface.
  • We have developed ETL packages using Informatica to load CPSMS data into our data warehouse on a daily basis. We have developed 20 reports using Cognos for the end users to track funds.
  • The reports include dashboards, alerts, Chart reports, Gauge reports, Drill through/Drill Down reports.

Confidential

BI Developer

Responsibilities:

  • Through Collect Savvy we have provided more than 200 SSRS reports which are of very high importance for daily analysis of financial status.
  • The reports include both transactional as well as Cube reports. The Cube reports were developed using MDX queries.
  • The data was getting updated and processed in the cube using the SSIS packages for every 1 hour. I was also working on stabilizing process like Bug fixing in reports, packages and cube. Hence in this project I have hands on experience on SSRS, SSIS and SSAS tools.

Confidential

BI Developer

Responsibilities:

  • tried to provide important reports to the business and top management so that they can take important decisions.
  • Reports developed using SSRS are embedded within CRM product. Designed SSIS package for Data Migration.

Confidential

Development & Support

Responsibilities:

  • Analyze the data sent by the client and design the database according to the client requirement and upload the raw data into the database by developing SSIS packages.
  • Once approved by the client I need to design the custom reports using SSRS.I have designed 108 SSRS reports in this project.

Hire Now