We provide IT Staff Augmentation Services!

Bi Consultant Resume

AtlantA

SUMMARY:

  • Over 7 plus years of IT Experience which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2012/2008r2/2005/2000) in production environments.
  • Worked in multiple projects as BI Developer in Designing ETL Packages in development and implementation stages of the Project according to client requirements.
  • Modified, maintained and developed the SQL codes to develop new enhancements.
  • Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, FTP Task and Data Flow Task in Designing packages.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert and SQL Server Integration Services (SSIS).
  • Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Union All, Merge Join, Kimball SCD and OLEDB. Command to load data into SQL Server destination.
  • Develop and maintain the documentation to support the team and business.
  • Developed Reports in the form of Matrix, Table, and Chart and linked Using SQL Server Reporting Services.
  • Modified, maintained and developed the reports using SQL Server Reporting Services.
  • Developed role based security for reports.
  • Proficient experience in Functionality Testing, SQL Database Testing.
  • Proficiency in System Integration Testing (SIT), Operational Readiness Testing (ORT), User Acceptance Testing (UAT), Regression Testing and other test levels.
  • Excellent knowledge and working experience in Test Planning, Test Preparation, Test Execution, Test Results analysis, Defect life cycle management, Debugging, Test Results Documentation and Release activities.
  • Good exposure to V - Model, Agile methodologies. Created Master Test Plan Document.
  • Uploading the scripts to MTM (Microsoft Test Manager) Tool and Creating Bugs in VSTF.
  • Verifying the code in packages and validating the report.
  • Good knowledge in SQL Server 2008.
  • Good knowledge on data warehousing concepts.
  • Good in designing, developing and maintaining data models.
  • Good communication, inter-personnel skills and good team player. Self motivated individual with strong analytical and problem solving abilities, Proactive, Dedicated, enjoy learning new technologies and willing to take on extra responsibilities to get work done.

TECHNICAL SKILLS:

Database: Oracle-10g, 11g, MS SQL Server 2008,2008R2,2012, MySQL

Programming Language: SQL, PL/SQL

ETL Tools: Microsoft Business Intelligence, Informatica Power Center 9.x,Informatica Data Quality

Operating System: MS-Windows Server2000,2008,2012, XP,7 Windows NT, UNIX and LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

BI Consultant

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, Visual Studio 2012, WINDOWS7

Responsibilities:

  • Extensively involved in interacting with the business users and gathering the requirements for the data warehouse.
  • Analyzed the requirements and provided best possible solutions.
  • Created project plan and a business requirement document and presented it to the client for their review.
  • Creating the complex stored procedures, user defined functions to meet the business rules.
  • Converted the data mart from Logical design to Physical design, defined data types, Constraints, and generated Schema in the Database.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Involved in Unit testing integrated testing and System testing.

Confidential, Florida

ETL Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, Visual Studio 2012, WINDOWS7 Oracle 10g, Windows Server 2008, Flat files

Responsibilities:

  • Understand the business model in moving data from legacy source to Siebel systems.
  • Implement logic to construct the staging area by analyzing business requirement and configuring Packages to load data into Siebel with precision.
  • Designing the staging area structure for capturing the extracted business data from the legacy system.
  • Involved in loading different entities into Siebel base tables (Group, Member, Invoice, Product, Agency, Contact, Address, Activity, Note, Attachment, LOV etc.)
  • Worked as business data analyst understanding the business need and actively participated in configuring the ETL using PowerCenter for data migration from legacy application to Siebel database.

Confidential

Senior Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, Visual Studio 2012, WINDOWS7

Responsibilities:

  • Interacting with the business users/stakeholders to clarify requirements.
  • Monitoring the jobs and troubleshooting them if the job fails.
  • Processing the files given by client on monthly basis and sending them the report.
  • Working on change requests raised by client.
  • Addition of new MCO’s as per client requirement.
  • Verifying the code in packages and developing reports.

Confidential

Senior Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, WINDOWS8

Responsibilities:

  • Requirement analysis, understanding functional/technical specifications documents provided by business and attending calls with solution designers on the same.
  • Identified the KPI’s as per the business.
  • Created schema for the project.
  • Created SSIS packages to load the data into dimension and fact tables. Done Unit Testing.

Confidential

Senior Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, WINDOWS8

Responsibilities:

  • Requirement analysis, understanding functional/technical specifications documents provided by business and attending calls with solution designers on the same.
  • Verifying the reports available in Report Manager and validating them with backend.
  • Verifying the code in packages and validating the report.
  • Interacting with the business users/stakeholders to clarify requirements.
  • Creating Master Test Plan Document for users.
  • Creating SIT Test Scripts.
  • Uploading the scripts to MTM (Microsoft Test Manager) Tool.
  • Creating Bugs in VSTF.
  • Conducting daily sync up meetings on open defects with onsite issue resolution managers.

Confidential

Senior Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, WINDOWS8

Responsibilities:

  • Interacting with the business users/stakeholders to clarify requirements.
  • Creating Master Test Plan Document for users.
  • Creating SIT Test Scripts.
  • Uploading the scripts to MTM (Microsoft Test Manager) Tool.
  • Creating Bugs in VSTF.
  • Verifying the code in packages and validating the report.

Confidential

Senior Developer

Environment: SQL Server 2012/2008 R2/2008, SSIS, SSRS, WINDOWS8

Responsibilities:

  • Interacting with the business users/stakeholders to clarify requirements.
  • Closely worked with Microsoft IT team during critical Month Ends, Quarter Ends.
  • Providing access to users for the user interface as per the business justifications provided and restricted user access based on regions.
  • Monitoring the jobs on hourly basis on different servers and troubleshooting them if the job fails.
  • Publishing of dashboards on daily basis within the time limit.

Confidential

Senior Developer

Environment: WINDOWS XP, SQL SERVER, MSBI

Responsibilities:

  • Analyzing the Source Files and Existing system which is built by an application called BIZTALK.
  • Finalized the column names in the tables based on the Report Requirement.
  • Created Dimensional Data model for development stage.
  • Given a solution to deploy the reports in Share Point in PDF formats.

Confidential

Developer

Environment: WINDOWS XP, SQL SERVER, MSBI, XCELSIUS.

Responsibilities:

  • Created packages in SSIS Designer using Control Flow and Data Flow transformations to Implement business rules.
  • Extensively working in data Extraction, Transformation and Loading from source to Target system using SQL Server 2008 Integration Services.
  • Analyzing the Existing System and Understanding the business requirement.
  • Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2008 Integration services.
  • Created the mappings using Data Flow transformations such as the Derived Column, Conditional Split, Pivot, Lookup etc.
  • Used Control Flow elements like For Each loop and Sequence container, Execute SQL Task, Execute Process Task, Execute Package Task File System Task.
  • Scheduling reports using data driven subscriptions e-mail with an attachment in the desired format of reports to the respective management.
  • Deploying the reports into Report manager and creating cache and snapshot reports.
  • Managed the contents in the report server and published reports and linked reports to the report server.
  • Deployed Reports into SharePoint and given permissions to the respective management.
  • Developed cascading parameter reports.
  • Render formats like PDF, Excel, and Word issues are fixed while a report exports.
  • Developed alternate row color’s for matrix reports. Developed Shared data sources and dataset’s. Created Stored Procedure’s, user-defined functions.
  • Handled Unicode and Non-Unicode data formats by using Data Conversion task.
  • To develop audit process for each ETL package which stores all the package information like On Error, Execution date, Parent package, start date, end date

Confidential

Developer

Environment: WINDOWS XP, SQL SERVER, MSBI, XCELSIUS.

Responsibilities:

  • Analyzing the Existing System and Understanding the business requirement.
  • Created Data model for the Confidential data to load.
  • Created SSIS packages to load the data into dimension and fact tables.
  • Created Stored Procedures as per the requirement needed in SQL Server 2008 R2.

Hire Now