We provide IT Staff Augmentation Services!

Developer & Data Architect Resume

DallaS

PROFESSIONAL SUMMARY:

  • 10+ Year of experience on Power BI, MSBI, SQL Server, Tableau, Big Data and Jasper Reports.
  • Having good experience in BI suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports using SQL query’s and analysis services (SSAS) for design and developing complex cubes and MDX query’s.
  • Expert in writing T-SQL, data migration for DTS 2000 (Data transformation services) packages to SQL Server 2005/2008 using ActiveX script task to support business logic in packages, data cleansing, data scrubbing.
  • Expert in understanding and querying complex Oracle databases (10g/11g) as well as an ability to understand the business rules that apply to the data.
  • Experienced in team mentoring, task planning and estimation, status tracking, Goal Setting and feedback discussion, trainings and recruiting technical resources etc.
  • Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment.
  • Extensive hands on experience on SQL Server 2005/08/R2/2012/2014 and IReports 5.6
  • Good understanding of RDBMS concepts and experience in writing joins, sub queries indexes, views, store procedures and function using SQL Server
  • Exposure to all phases of software development life cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
  • Skilled in developing Jasper Soft I reports, supporting and maintaining Jasper Report Server.
  • Strong report layout and presentation skills. Demonstrated skill in designing and developing complex reports
  • Solid understanding of T/SQL and ability to write scripts to automate and manage data, performance tuning, SQL Query optimization and Drive to automate process and procedures which are manual.
  • Ability to develop in fast moving, agile product development methodology. Strong data analytical skills for report validation and testing
  • Have extensive experience in configuring SSRS\I Report, Report Manager and Drill down report, Sub reports, creating subscription and scheduling reports.
  • Experience with open source Java technologies and APIs including Groovy.
  • Team player with good interpersonal skills and the ability to work in team.

TECHNICAL& DOMAIN EXPERTISE:

Reporting Tools: SSRS, Tableau, SSAS, OBIEE 10g, I Reports 5.6 (Jasper Reports), Power BI.

ETL Tools: SSIS, Informatica

ETL Testing Tools: Informatica Data Validation

RDBMS/DBMS: MS SQL Server 2008/R 2/2012/2014/2016

BIG DATA: HADOOP (SPARK.),Azure

Data Model Tools: ERWIN

NoSQL DB: Mongo DB

Languages: C#. Net and ASP.NET 2005/08, Java, J2EE

Framework: Grails, Spring

Database Connectivity: ADO.NET, OLEDB, and ODBC

Scripting/Markup: HTML, Java Scrip, JSON, XML

Operating Systems: Windows 10/8/7/XP/ 2000/2003/08 , UNIX, LINUX

Domain: Logistic/Supply Chain, Retail, HealthCare, ERP, Banking, Mortgage, Media, IM (Infrastructure Management).

PROFESSIONAL EXPERIENCE:

Confidential, Dallas

Developer & Data Architect

Responsibilities:

  • Create ETL SSIS packages and Invoke InRule (business rule management tool) through SSIS ETL package to evaluate data for cleansing.
  • Design the Physical and Business Model Diagram mapping and joins with Facts and Dimensions based on the Star and Snow Flake Schemas as per best practices.
  • Designed multiple KPI and partitioning of cube based on requirement.
  • Responsible for defect resolution and prioritize the local requirements from business.
  • Responsible for technical root cause analysis, providing solutions and work around.
  • Provide support during deployment of delivered requirements.
  • Create SSIS profiling package for data analysis and data profiling.
  • Create physical / logical data model design for ODHC Data warehouse project.
  • Create ETL Mapping document and Technical specification document for mapping data elements, data flow.
  • Create ETL for extracting data from source system to staging repository for business analysis and data cleansing work.
  • Translate data rules to complex SQL queries for data validation and cleaning.
  • Define Business Rules using InRule Engine.
  • Created and maintained proof of concepts for all the SSIS ETL packages.
  • Involve in OLTP and OLAP data modelling techniques and a demonstrated ability to interpret Entity Relationship Diagrams.
  • Create Power BI Dashboard reports and SSRS report type Parameterized reports, Linked reports, Snapshot reports, Cached reports, Ad hoc reports, Click through reports, Drill through reports, Sub reports.
  • Use Master Data Services for data steward review and decision.
  • Responsible for managing all the production deliverables (deployment document, Work Order, Change Order).
  • Maintain the best practices and RDMS best concept for writing the SQL queries and maintain the ETL tools.
  • Created C# .net tool for invoking InRule entities in SSIS component and pass the rules through inRule engine.
  • Create test Cases for business scenarios for validation and testing.
  • MS-SQL DBA experience with Migration & Up gradation.
  • Define and maintains database objects.
  • Involved in creating deployment document, Work Order, Change Order for production with DBA team.
  • Resolve the QA/Production Issues.
  • Interact with Onshore & off shore team on daily basis

Environment: SQL Server 2014, SQL, SSIS, C#.Net, InRule, SSRS, SSAS, Tableau, Groovy/Grails, JQuery

Confidential

Consultant/Team Lead

Responsibilities:

  • Interact with Onshore & off shore team on daily basis
  • Analyze source data and create SSIS packages based on USE cases
  • Discuss with BA & Team on gaps on the Data flow
  • Create SP & work closely with Database Architect
  • SSIS packages with Microsoft standers like dynamic package configuration and error log etc.
  • Maintaining the Log and Audit information in the SQL tab Experience in providing Logging,
  • Error handling by using Event Handler for SSIS Packages.
  • Administrate SSRS reports, SSIS packages and agent jobs.
  • Conduct KT session for new joiners in team
  • Deploy package from Development TFS to UAT on each sprint

Environment: ETL - SSIS, MS SQL Server 2012, SSRS

Confidential

Senior Developer

Responsibilities:

  • Interacting with Client and Users and gathering the requirement based on their business prospective.
  • Implemented the Caching for speeding up the reports and to improve the performance wise.
  • Interact with business unit/US counterpart to consolidate requirements.
  • Analyze the requirement and distribute work among the team.
  • Design & Develop complex SSRS reports
  • Create SSIS packages to data import and export
  • Create database objects - tables, stored procedures, functions, views
  • Deploy SSRS, SSIS objects into UAT/Production environments
  • Administrate SSRS reports, SSIS packages and agent jobs.
  • Conduct healthy weekly team meetings and technical sessions
  • Co-ordinating with on-site team .

Environment: ETL - SSIS, MS SQL Server 2008, SSAS, SSRS

Confidential

BI Analyst

Responsibilities:

  • Interacting with Client and Users and gathering the requirement based on their business prospective.
  • Daily Attending the Status meeting with Clients and Coordinating the On-Site Team to walk them to move further.
  • Preparing the Documents and Naming Specifications as per SQL Server Standards based on MSBI Best Practices.
  • Design the POC RPD for the future requirement purpose with Generic Standards.
  • Design the Physical and Business Model Diagram mapping and joins with Facts and Dimensions based on the Star and Snow Flake Schemas as per best practices.
  • Implemented the Caching for speeding up the reports and to improve the performance wise.
  • Created the reports and Store procedure as per the requirement.
  • We created the global Filters and Time Dimension prompts for all the Reports.
  • In Reports we have created the charts, tables, Pivot tables, Drill Down and Drill through and etc.
  • Worked Data load SSIS Packages to pull data from Source to staging table.
  • Configured Subscription and Scheduler for delivery options of a report and also scheduled FTP delivery options for a report.
  • Developed many T-SQL procedure & functions and used the same in mappings, pre and post sessions.
  • Performed Unit and Integration testing to validate report and mapping functionality.
  • Co-ordinating with on-site team

Environment: SQL Server 2008, SSRS, SSIS and SSAS

Hire Now