SUMMARY

• Extensive exposure to all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance for various applications
• Extensively used T - SQL in constructing Stored Procedures, Table and Scalar Variables, Triggers, Tables, User Defined Functions, Views and Indexes
• Experience in creating and managing Clustered and Non-Clustered Indexes to improve database performance
• Expert in using SQL Server Agent to Schedule and monitor Jobs
• Advanced Access, Excel and SQL skills.
• High comfort level with consolidating and joining DB tables using Left, Right, Outer, Inner, Full and Cross Joins.

TECHNICAL SKILLS

RDBMS/DBMS: SQL Server, MS Access, and Oracle DB

Database Tools: SQL Server Data Tools, SQL Server Management Studio(SSMS), SQL Server Business Intelligence Development Studio, Visual Studio 2010

Reporting Tools: SQL Server Reporting Services(SSRS), MS Excel

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

SQL Server BI Developer/Analyst

Responsibilities:

• Integrate data from various sources using SSIS, validate data and create reports.
• Developed parameterized dashboards with SQL Server Reporting Services (SSRS).
• Responsible for developing and optimizing reporting solutions using SQL Server Reporting Services (SSRS) to author, manage, and deliver dynamic, interactive, drill-down web-based reports.
• Worked with internal or external business partners to recommend business intelligence solutions.
• Designed and implemented a variety of SSRS reports such as Parameterized reports, Drill Down, Drill Through, Ad-hoc and Sub-Reports using Report Designer
• Report Builder based on the business requirements using both Tabular, Charts and Matrix report formats.
• Responsible for scheduling the Subscription of the reports with the Subscription Report Wizard and creating Snapshots of the report as per requirement.
• Also, implemented Security to the reports using Report Manager.
• Review BRD documents and ensure all requirements are satisfied.
• Create database objects, complex queries, and stored procedures to support the ETL process of loading flat files
• Involved in performance improvement of created reports and deployed reports onto Report Server and SharePoint Server making those reports available for the end users.
• Extensively used SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance
• Migration of SSRS reports from SQL 2008R2 to SQL 2012

Confidential, Dallas, TX

SQL/BI ETL Developer

Responsibilities:

• Designed and developed SSIS packages to transform data from flat data files, DB2, Oracle, Excel, and SharePoint to SQL Server 2008 Data Warehouse.
• Worked actively on Data Quality Process to avoid data bypassing in the EDW (Enterprise Data Warehouse) and ETL (Extraction, Transformation and Loading) processes.
• Used SQL Server Integration Services (SSIS) to develop various complex packages load data into database, and archive data files from different DBMS using SSMS on SQL Server 2005 and 2008 environments.
• Added edit checkpoints to the packages for different purposes like sanity check of the extracts format like naming convention, file type, date formats etc. to process the file based on the date of recipient of the extracts
• Experienced in creating SSIS packages using different type of Tasks, with Error Handling in order to catch bad data that does not meet the specified requirements.
• I used logging to log the events and worked on package configuration to run the package on different servers.
• Created Ad Hoc reports with the report builder for the end users and was also involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the management
• Creating drilldown matrices and drill through reports that is details based on parameters like Yearly Sales and Monthly Sales.
• Extensive use of T-SQL in writing Stored Procedures, Tables, User Defined Functions, Views and Indexes.
• Used tools like Excel and SQL Server to analyze, query, sort and manipulate data according to defined business rules and procedures.

Confidential, Dallas, TX

SQL DEVELOPER

Responsibilities:

• Created weekly and monthly summary and detailed reporting for customer incidents by type for internal and investor analysis
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project
• Utilized variousSQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Unique keys and Check) to ensure data integrity
• Performed Data Manipulation, Mining/Extraction and Design and also conducted statistical analysis to evaluate risk using statistical and query tools
• Developed and configured reports using the data in data marts to be sent at regular intervals to the investors either through email or in shared folders
• Used Joins, sub-queries for complex business queries involving multiple tables from different databases.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler
• Created Jobs for scheduling SSIS packages in scheduler service and send alerts for successful and unsuccessful completion of Scheduled Jobs
• Created SSRS reports using Report Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts
• Prepared reports associated with the monthly loan activity, payoffs, short sales, and other events to investors

Confidential

JUNIOR BUSINESS ANALYST

Responsibilities:

• Created roles, role hierarchies and managed user registrations and approvals in Oracle User Management
• Monitored security by granting user access and defining application privileges
• Worked with the Business Process Owners, Compliance leads, Project team leads, Developers, and Database Administrators to ensure robust and permanent solutions
• Developed solutions to leverage Oracle user management functionality for the eBusiness Suite and suggest improvements
• Developed custom segregation of duties policies based on the company’s business process
• Conducted detailed conflict analysis and identified conflicts based on company’s segregation of duties policies
• Analyzed the segregation of duties reports by roles and users, showing top risks to the business process owners and recommended the best practice where applicable
• Developed solutions surrounding system administrator functions such as evaluating user access, segregation of duties analysis, profile option management, responsibility design, user function and menu design
• Recommended the best ways to remediate the segregation of duties conflicts identified
• Configured and modified the Application Configuration as required (includes system setups, flex-fields, workflow builder, custom library, profile options etc.)
• Assisted internal and external audit staff with problems and resolved issues independently
• Provided workshops and training for knowledge transfer