SQL/SSIS/SSRS Developer available for new projects
Name: Ramya
Skill: SQL/SSIS/SSRS Developer
Visa: CPT
Certifications:
· MCSA Querying Microsoft SQL Server 2012(70-461).
· MCSA Implementing a data warehouse using Microsoft SQL Server 2012(70-463).
· MCID: 13497359
PROFESSIONAL SUMMARY
· Extensive 8 years of experience in SQL/BI Development includes Business Intelligence applications design, development, and maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS) and Enterprise Data Warehouse.
· Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on SSIS/DTS, Data Cleansing and Data Migration.
· Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS the data into the Enterprise Data warehouse from Heterogeneous sources such as Oracle, Excel, and Flat files.
· Experience in migrating Crystal Reports 8.5 to SQL Server Reporting Services/Power BI
· High-skilled in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2016/2014/2012/2008 R2/2008 and Power BI.
· Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
· Highly experienced in database server performance tuning and optimization of Complex SQL queries.
· Highly proficient in using T-SQL for developing complex stored procedures, triggers, tables, views, user functions, and data integrity, SQL joins and query writing.
· Experience in creating Packages, scheduling Jobs, and sending Alerts using SQL Mail.
· Excellent communication and interpersonal skills, self-motivated, quick learner, and determination to learn new technologies, strong troubleshooting skill and good team player with excellent teamwork skills.
TECHNICAL SKILLS:
Databases
MS SQL SERVER 2012/2014/2016, MS Access 2013/2010
Database Tools
T-SQL, Query Analyzer, BCP, SQL, Agent, SQL Trace, Performance Monitor, Client Configuration Utility, Server Configuration Utility, SQL Server Integration Services (SSIS), SQL reporting Services (SSRS), SQL Analysis Services (SSAS), TFS.
Web Servers
IIS 6, Windows/UNIX Environment, TFS, SLA’s
Languages
T-SQL, VB.NET, ASP.NET, Visual Basic 6.0, C, C++
Certifications:
· MCSA Querying Microsoft SQL Server 2012(70-461).
· MCSA Implementing a data warehouse using Microsoft SQL Server 2012(70-463).
· MCID: 13497359
Education:
· Bachelor’s Degree in Computer Science Engineering, JNTU, Hyderabad, India (2010 - 2014)
· Master’s Degree in Information Technology, Lawrence Technological University, Southfield, Michigan, USA (2015 - 2014)
· Currently Pursuing my Double Master’s in Computer Science at Trine University Angola, Indiana, USA
PROFESSIONAL EXPERIENCE
Caliber Home loans – Irving, Tx
SQL/SSIS/SSRS Developer (March 2021 –Till Now)
Responsibilities:
· Served as the initial contact person for all SQL support queries.
· Collaborated with business support professionals to provide full system maintenance.
· Implementing SSIS packages related to the extraction, transformation and loading ETL process for database applications, in accordance with established standards.
· Supported code activations and updated business tool applications per company requirements. Utilized Visual Studio 2012 to develop dynamic reports
· Delivered database deployment through the whole system lifecycle.
· Manage end-to-end complex data migration, conversion, and data modeling.
· Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed, and built SSRS reports and dashboard reports in Power BI,
· Extensively worked on Data Integrator, Platform transforms and used lookup function to pull data from the various table form the data-store to the target table.
· Exposed to Data Warehousing Concepts including Star Schema and Snow-Flake Schema.
· Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions.
· Worked on Data Integrator which delivers enhanced data cleansing, data enhancement, and match / consolidate features. Skillful in developing different kinds of reports including Yearly, Quarterly and Monthly.
· Strong knowledge on creating shared directories for using flat files for each developer. Expert in developing SSIS packages.
· Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.
· Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
· Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
· Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
Environment: SQL Server 2005, SharePoint 2007, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services (SSRS), Integration Services (SSIS)
Livingston International – Civic center Dr, MI
SQL/SSIS/SSRS Developer (Jan 2019 – Feb 2021)
Responsibilities:
· Analyze, design, develop, and document the application software for the Classification Project.
· Designed and implemented ETL processes with SSIS packages using Heterogeneous data sources SQL Server, ORACLE, Flat Files, Excel source files, XML files, Text files, etc. and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
· Implementing SSIS packages related to the extraction, transformation and loading ETL process for database applications, in accordance with established standards.
· Creating T-SQL queries, complex stored procedures, and functions to perform database tasks such as inserts, updates, and deletes and performance tuning Views.
· Validating and looping through various file sources and loading dynamically into the database using SSIS tasks like Script Task, For Each Loop Container, For Loop Container,
· Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
· Involved in gathering Report Development Specifications (RDS) and SOWs for creating reports.
· Developed different type of reports including Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, billing report and other insurance/payroll reports by using SSRS and SQL Server 2008/2012.
· Documentation of proposed new batch jobs, programs, database table designs and /or reports.
· Developed browser-based management system, allowing various documents to be placed in Windows Explorer interface folders.
· Developed reports like Cross tab reports, Summary Reports, Sub Reports, Drill Down Reports, Drill Thru reports using Power BI/SSRS
· Worked on end-to-end testing of applications and migrated code to production environment.
· Performed Root Cause Analysis, Troubleshooting and resolved production issues.
· Performed UAT (User Acceptance testing) and performed data validation for end user reports.
· Published reports to Microsoft SharePoint for the review by executive team.
· Documentation of proposed new batch jobs, programs, database table designs and /or reports.
Environment: SQL Server 2005, SharePoint 2007, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services (SSRS), Integration Services (SSIS)
Great Expressions Dental center – Southfield, MI
SQL Developer/HRIS Analyst (Aug 2017 – Jan 2019)
Responsibilities:
· Strong understanding of HRIS database design, structure, and processes.
· Strong writing skills to translate system requirements into easy-to-use training documents.
· Created SSIS packages to extract data from different files according to the Business User Requirements.
· Designed SSIS Packages to transfer data from various sources like Flat files, XML files.
· Wrote T-SQL queries, Stored Procedures and used them to create Reports using SSRS/ Report Builder and Power BI.
· Involved in process improvements and proposes innovative solutions or alternative methods to meet data and reporting requirements within the department.
· Assisted in the review, testing and implementation of HRIS system upgrades or patches, and performs scheduled activities to keep system running proficiently.
· Extracted data from Database by writing SQL Queries according to the given requirement.
· Wrote SQL Stored Procedures to maintain and supports a variety of reports or queries utilizing appropriate reporting tools (SSRS/Power BI).
· Worked on Kronos Data according to the requirement and created reports by writing Stored Procedures.
· Optimizing and Performance Tuning SQL Scripts to make reports run smoothly and efficiently. Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
· Developed parameterized reports which were used for making current and future business decisions.
· Advise proper SSRS standards and created documentation on standard set forth for report formatting.
· Assisted in development of standardize reports for ongoing customer needs.
· Maintains data integrity in systems by running queries and analyzing data and coordinating appropriate training as needed.
· Develops user procedures, guidelines, and documentation.
· Wrote VBScript to get the required data in Excel.
Environment: SQL Server 2012/2014, SSIS, SSRS, VBScript, XML, MS SharePoint 2013
American IT Solutions – Farmington, MI
SQL Developer/Data Analyst (Jan 2016 – Aug 2017)
Responsibilities:
· Worked on Claims Data Migration and Claims Reporting Project.
· Designed SSIS Packages to transfer data from various sources like Flat files, XML files, and Excel to SQL Server using Business Intelligence Development Studio.
· Wrote T-SQL queries, Stored Procedures and used them to build packages.
· Designed, Developed and Deployed packages in SQL server environment using SSIS.
· Involved in tuning and configuration of SSIS.
· Deployed SSIS packages from Development to Testing Servers
· Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.
· Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)
· Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
· Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel, and other OLE DB providers achieved through Importing and Export Wizard in SSIS.
· Developed reports like Claims paid, claims unpaid, claims in-pending and overpaid.
· Worked with Claims Audit department and generated reports for end users.
· Developed reports like Cross tab reports, Summary Reports, Sub Reports, Drill Down Reports, Drill Thru reports using SSRS.
· Published reports to Microsoft SharePoint for the review by executive team.
Environment: SQL Server 2012/2014, SSIS, SSAS, SSRS, VBScript, XML, MS SharePoint 2013
Amazon, Hyderabad, India
SQL Developer (Jan 2014 – Dec 2014)
Responsibilities:
· Created database and database objects like tables, stored procedures, views, triggers, user defined data types and functions.
· ETL implementation using SQL Server Integration Services (SSIS), applying some business logic and data cleaning in staging server to maintain child and parent relationship.
· Created complex SSIS packages using proper control and data flow elements.
· Enhanced and deployed the SSIS Packages from development server to production server.
· Used SSRS creating well-formed reports and web-based reports for financial applications and transactions.
· Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
· Configured the report server and generated the report models for user interactions.
· Involved in the tuning of the existing Database Objects.
· Used Query Analyzer to optimize SQL queries.
Environment: SQL Server 2008, SSIS, SSAS, SSRS, T-SQL, MS SharePoint 2010
Thanks & Regards
Naveen
Team Lead- Sales
Tech Smart Global Inc.
666 Plainsboro Rd, Suite 1116, Plainsboro, NJ 08536.
