We provide IT Staff Augmentation Services!

Technical Lead Resume

New, JerseY

SUMMARY:

  • 10+ years of professional experience as Business Intelligence Developer and Data Analyst.
  • Extensive experience in Installation, Configuration and Development of SQL Server 2008, 2012, 2014.
  • High proficiency over MSBI Technologies well versed with SSIS, SSRS and Power BI.
  • Experience in Development and Deployment of SSIS packages from Oracle, SQL Server 2005, 2008, 2012, AS400, Azure SQL Databases and XML’s.
  • Extensive knowledge and experience in developing scripts using T - SQL, Oracle, AS400 for querying against databases
  • Expertise in implementing business logic using stored procedures, using temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
  • Proficient at Performance Tuning with a solid knowledge of Optimizing Code
  • Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
  • Expertise in generating reports using SQL Server Reporting Services, Power BI
  • Designing and Deployment of Reports for the End-User requests using SSRS.
  • Build regular reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Drill through, Sub Reports, Cascading, Summarized, Matrix etc.
  • Experience in configuration and maintain Report Manager and Report server for SSRS, Deployed and Scheduled the Reports in Report Manager.
  • Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
  • Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
  • Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.
  • Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS and XML.
  • Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Developed the reuse components in SSIS like SSIS Framework and Transaction control for the project
  • Experience in Performance Tuning in SSIS packages
  • Proficient in application development with .Net technologies like .Net Framework 3.5, C#, ASP.Net, ADO.Net, AJAX, Web Services, SOAP requests, IIS Web Server and conceptual knowledge on SharePoint 2010.
  • Experience in creating various reports on Power BI and dashboards using SQL Server, Excel etc to make it more attractive.
  • Created DAX Measures in power BI to achieve business requirements.
  • Experienced in SDLC life cycle for Design, Development and Staging phases of the projects.
  • Experience in analyzing the requirements and mapping them as per the business use.
  • Experience in analyzing the root cause of data issues and fixing them.
  • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.
  • Provide 24/7 database maintenance and support.
  • Have knowledge on insurance domain.
  • Capable of handling the complete module alone throughout the requirement phase, development phase, testing phase and till the project moves to production.
  • Involved in Designing ETL Architecture.
  • Involved in all aspects of project/product development including Analysis, Design, Development, Training, Testing and Implementation.
  • Involved in providing Technical solution to different Verticals within the organization.
  • Ability to work under extreme pressure without compromising on quality and timely delivery, attention to details, and passion for work.

TECHNICAL SKILLS:

Development Skills: BI Stack

Cloud Technologies: T-SQL, PL/SQL, MSBI(SSIS/SSRS), Power BI, DAX Measures, .NET MSBI (SSIS, SSRS), Power BI, DAX measures Microsoft Azure

Languages: C#.NET

Web Technologies: ASP. Net, HTML, Ajax, Web Services, Restful Web Services

Databases Development Tools: Oracle 11g, SQL Server ( 2005, 2008, 2012,2014): BIDS, SSDT, SSMS, Visual Studio, Oracle SQL Developer

Source Controls: VSS, TFS

Other Tools: RPA

SOAPUI: UI Path

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Technical Lead

Responsibilities:

  • Developed Power BI models used for Reports.
  • Designed and documented the entire Architecture of Power bi project.
  • Used several DAX functions in Power BI and Power Pivot.
  • Used various sources to pull data into Power BI such as SQL Server, Flat File, Excel, SQL Azure etc.
  • Installed and configured Enterprise gateway in Power BI service.
  • Created Workspace and content packs for business users to view the developed reports.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.
  • Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
  • Weekly presentation to the business users about the reports and their changes as required.
  • Worked on all types of transformations that are available in Power bi query editor
  • Created stored procedures and SQL queries to pull data into power pivot model.
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined and Functions as required.
  • Created DAX Measures in power BI to achieve business requirements.
  • Developed Power BI dashboards for data analysis
  • Created various SSIS packages for the enhancements of the project to extract the data from the data sources like SQL SERVER and XML’s to the data warehouse.
  • Used SCD transformation to implement incremental loads.
  • Monitored runtime events for better troubleshooting, debugging of packages with Event Handlers and custom loggings.
  • Implemented Transactions in SSIS packages
  • Used SSIS optimization techniques to minimize the package execution time.
  • Configured packages with parameters and deployed packages to production servers utilizing package / project deployment model.
  • Involved in Designing ETL Architecture as per the requirements.
  • Daily Monitoring the Production Environment and analyzed the issues as per the daily load and fixing them.
  • Managed the Module by handling any change requirements and as well as enhancements to the project.
  • Helping team members to resolve any technical issue, Troubleshooting, Issue identification and management.
  • Interacting with Client and providing regular status update
  • A nalyz e Business/Functional requirements and provide a Design solution for software components to meet Business/Functional requirements.
  • Created few POC’s to automate the things using UI Path.

Tools and Environment: SQL Server 2012/2014, T-SQL, SSMS, SQL Profiler, MS Word, MS Excel, SSIS, SSRS, C#, XML, VSS, POWER BI, UI Path

Confidential, New Jersey, NJ

MSBI / SQL Server Senior Developer

Responsibilities:

  • Created various SSIS packages to extract the data from the data sources like SQL SERVER and XML’s to the data warehouse.
  • Used SCD transformation to implement incremental loads.
  • Monitored runtime events for better troubleshooting, debugging of packages with Event Handlers and custom loggings.
  • Implemented Transactions in SSIS packages
  • Used SSIS optimization techniques to minimize the package execution time.
  • Configured packages with parameters and deployed packages to production servers utilizing package / project deployment model.
  • Took Ownership to deploy and maintain SSIS package versioning on daily basis till the code moved to production.
  • Used .Net coding to accept data from web services and SOAP requests.
  • Created ETL Generic Framework in order to implement Error Handling and Rejection etc.
  • Involved in architecture at the ETL level in order to reprocess the data for the Dimensions and Facts.
  • Managing the ETL Team and Ensuring Complete Development.
  • Involved in Designing ETL Architecture as per the requirements.
  • Daily Monitoring the PreProd Environment and analyzed the issues as per the daily load and fixing them.
  • Managed the Module by handling any change requirements to the project.
  • Reconciled the data with the Old data model and various source systems and make changes to the present environment to match the data.
  • Created various SSIS jobs using SQL Agent and monitor them for any issues.
  • Created stored procedures using dynamic sql to extract data from XML to staging environment.
  • Designed and developed SQL structures utilizing temporary tables, table variables, CTEs, loops, and dynamic SQL to implement business logics.
  • Enabled package executions from the latest point of failure (for debugging) with checkpoints.
  • Build regular reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Drill through, Sub Reports, Cascading, Summarized, Matrix etc.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
  • Created few reports with Power BI and SSRS by extracting data from SQL SERVER tables, Excel etc.
  • Worked on Power BI and prepared various Reports, dashboards using SQL Server, Excel etc to make it more attractive.

Tools and Environment: SQL Server 2012, T-SQL, SSMS, MS Excel, SSIS, SSRS, C#, XML, VSS, POWER BI

Confidential, New Jersey, NJ

MSBI / SQL Server Senior Developer

Responsibilities:

  • Handled the complete module alone throughout the requirement phase, development phase, testing phase and till the project moves to production.
  • Direct interaction with client.
  • Collected the requirements by interacting with the business users.
  • Created various SSIS packages with heterogeneous sources like XML, AS400, Oracle and SQL.
  • Created the SSIS package which accepts xml from the web service.
  • Created the SSIS packages with get data from various sources, creates xml data and send to web services.
  • Also Created the SSIS packages to get the data from SQL Azure
  • Created web services using .net which accepts xml and call the SSIS package which is deployed in the SSMS.
  • Deployed various SSIS packages in the SSIS catalog.
  • Maintained package configurations using Environment variables with the new features of SSMS 2012 called environments.
  • Created and maintained Sql login groups to run the SQL jobs.
  • Created and scheduled the jobs for the deployed SSIS packages.
  • Create SSAS Tabular Model and SSAS Cube Model and support the existing database components
  • Create SSAS Tabular model and SSAS Cube using data from database and tables created by myself

Tools and Environment: SQL Server 2012, T-SQL, Oracle 10g, SQL Azure, AS400, SSMS, MS Excel, SSIS,SSAS,.Net 4.0, C#, XML, VSS, IIS

Confidential

Senior Software Developer

Responsibilities:

  • Handled the complete module alone throughout the requirement phase, development phase, and testing phase and till the project moves to production.
  • Involved in gathering the report specifications by interacting with the business users.
  • Identified the database tables and stored procedures for defining the queries for the reports.
  • Mentoring the fresher’s.
  • Created and deployed various kinds of SSRS Reports.
  • Created a multitude of reports with SSRS such as drill down, drill through, parameterized, cascading parameterized, and ad-hoc reports
  • Rendered reports to multiple formats per the business requirements utilizing standard and data driven subscriptions in native and SharePoint integrated mode as per business requirements.
  • Implemented TFS for BI application and SQL code source control.
  • Implemented role-based security for reports with report manager.
  • Created various kind of stored procedures, queries used in the SSRS reports using oracle11g
  • Creating Custom Data processing Extension using Oracle Data Provider to connect to SSRS Reports using .NET.
  • Successfully deployed two SSRS modules (ICS, ISMD and MRT) to production.
  • Direct interaction with client.
  • Ability to work in the cross vendor environment.

Tools and Environment: Oracle 11g, SQL Server 2008, SSRS, C#.NET, TFS

Confidential

Software Developer

Responsibilities:

  • Created SSIS packages to extract data from various heterogeneous sources like sql server, Text files, Excel Spread Sheets, XML, Oracle, clean and load data to various heterogeneous sources.
  • Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
  • Supported Presales POC by creating packages which transfers data from multiple Excel Spreadsheets to SQL Server DB
  • Created various SSIS packages for verticals according to the business requirements.
  • Supported the HMS team in the creation of packages & provided accurate solution as per their requirements and also provided guidance to their team members.
  • Created the Demo on SSIS for the Amex vertical, which extracts the data from flat file and inserts into the SQL server of 10 records at a time with validations, error handling, maintaining the corrupt records, rolling back the transaction if the package fails and also logging the errors.
  • Created a POC which connects to various databases like Informix, DB2, Sybase, Oracle, and MySQL and performs ETL operations.
  • Created SSRS reports and deployed on windows Azure.

Tools and Environment: Oracle 11g, SQL Server 2008, SSIS, SSRS, C#.NET, Asp.Net, Ado.Net, Ajax, Web S ervices, VSS

Confidential

Trainee

Responsibilities:

  • Created and deployed SQL Server 2008 SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Pivot, Union and Execute SQL Task to load data into Database.
  • Implemented logging, checkpoints and package configuration in SSIS 2008.
  • Created and deployed reports using SQL Server 2008 Reporting Services.
  • Created Stored Procedures in SQL Server 2008.
  • Used drill down functionality such as Drill Through and Drill Down to show the data at different Hierarchical levels.

Tools and Environment: SQL Server 2008, SSIS, SSRS

Confidential

Trainee

Responsibilities:

  • Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.
  • Developed application logic using C#.
  • Written stored procedures using SQL in SQL SERVER 2005.
  • Worked intensely on the User Interface.
  • Developed Web Forms using C# and ASP.NET.
  • Used AJAX in some webforms.

Tools and Environment: C#.Net, Asp.Net, Ado.Net, Sql Server 2005

Hire Now