BI Developer & System Administrator Resume

SUMMARY:

5+ years of experience in the BI stack, Tableau and Proficient in Microsoft Excel pivot tables and VLOOKUP. An autonomous worker committed to providing high quality services. Directly worked with executive members, managers, and stakeholders. Seeking to leverage my technical and professional expertise to learn and grow in the role of BI Developer at your company.

TECHNICAL SKILLS:

MICROSOFT BI STACK: SSRS, SSIS, SSAS, SSMS

MICROSOFT OFFICE: Excel, Word, PowerPoint, Outlook

SOFTWARES: Hyphen Solution, New Star Enterprise, SAP, BuildPro, Tableau

OPERATING SYSTEMS: Windows 98/2000/2003/ XP/NT/Vista/7, Windows Server 2003/2003 R2/2008/2008 R2

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer & System Administrator

Responsibilities:

Created and maintained database objects
Created and implemented complex SSIS package to migrate data from various Heterogeneous data sources
Optimized SQL queries
Wrote complex stored procedures
Troubleshoot slow performing queries
Maintained data integrity by Creating checks and constraints
Developed various complex SSRS reports like Drill Down, Drill Through, Pie Chart, Bar Chart, parameterized, and Sub - Reports.
Deployed and configured the reports in the Report Server
Render reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions
Extracted data from different data sources such as Excel, OLTP, Flat files and XML
Analyzed source system data to determine the data model and ETL solution that will meet business requirements created complex SSIS packages using various data transformations like conditional split, for each loop, multi cast, data conversion
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to responsible parties
Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
Managed company wide outlook distribution list email accounts
Created and distributed monthly excel budget reports
Developed and launched the company’s performance management system ensuring a direct link with its Core Values, role clarity and goals at the individual, business unit and corporate levels.
Trained new hires
Served as Subject matter experts for NSE and BuildPro software

Confidential

SQL Server Database Administrator & Reporting Analyst

Responsibilities:

Supported in creation of user logins with appropriate roles, locking the logins, monitoring user accounts, and granting privileges to users.
Created and maintained database objects (tables, stored procedures, functions, and views)
Supported DBAs in activities related to database and log backups, restoration, backup strategies, and scheduling backups
Troubleshoot slow performing queries by using SQL Profiler
Created inbound and outbound inventory reports
Significantly reduced report processing time by implementing macros
Created process document

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship