Software Engineer
Login Soft Technologies
Total years of experience :5 years, 1 Months
Organization Designation Duration
Login Soft Technologies Software Engineer 2011-2013
Career Profile
hiiiiii, iam sravan ihave work experience in msbi at 2 experience like msbi, ssis, ssrs, sqlserver
hiiiiiiiiiii, iam sravan kumar i have msbi 2 experience in msbi like ssis, ssrs, sqlserver
Login Soft Technologies Software Engineer 2011-2013
Career Profile
Query Language T-SQL
Data base Microsoft SQL Server 2008 R2
Team Size 8
Period December 2011 to November 2012
Operating System Windows 7.0
Description:
The Transfer Price Application (TP) developed for Dixon Retail Inc.provides users with better visibility of product pricing data and hence provides a better control over the business. Various reports have been designed in TP which projects useful information pertaining to product pricing data across the globe. The reports have been designed and can be viewed using ProClarity.
Environment:
Microsoft SQL Server 2008 R2, SSIS, SSRS.
My Responsibilities:
❖ Debugging the data issues.
❖ Creating SPs, Functions, Triggers, Temp tables etc.
❖ Monitoring SQL jobs and its performance.
❖ Development and Enhancements of Stored Procedures.
❖ Involved in Bug fixing in Stored Procedures.
❖ Implementing ETL logging and Configuration for Packages.
❖ Used Control Flow Tasks like For Each Loop Container, Execute SQL Task, Bulk Insert Task, Send mail Task, File system task and Data Flow Task.
❖ Extensively used Transformations like Derived Column, Data Conversion, Conditional Split, Audit, Aggregate, Lookup and Merge
❖ Developed the reports in the form of Matrix, Table and Chart using SQL Server 2008 Reporting Services as per the requirements.
❖ Different Types of reports are designed like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
❖ Scheduled Reports Daily, Weekly and Monthly basis as per the Client Requirements.
❖ Good knowledge in using report manager and Scheduling reports for sending as mail attachments and storing into File Server.
hiiiiiiiiiiiiii, iam sravan kumar i have 2 expeience in msbi like ssis, ssrs, sqlserver
Organization Designation Duration
Login Soft Technologies Software Engineer 2011-2013
Career Profile
Currently working with Login Soft Technologies at Hyderabad as Software Engineer from august 2011 to till date.
Technical Skills
RDBMS SQL Server 2008R2
Query language T_SQL
ETL TOOLS SSIS
BI Suite SSRS
Markup Languages HTML, XML
IDE Visual Studio 2008
Operating Systems Windows Family
Source control Tools Subversion
Project Thesis
The details of the various assignments that I have handled are listed here.
Project 1:
Name of project Reinsurance Schedule F reporting
Client Well care
Role Team Member (BI Developer)
Organization Techmetric Info Systems Pvt. Ltd, India
Project Location Login Soft Technologies (Hyderabad)
Tools SQL Server Business Intelligence Development Studio
Data base Microsoft SQL Server 2008
Team Size 8
Period December 2012 to Till date
Operating System Windows 7.
Development Tools Visual Studio 2008
Description: Well care client is the one of biggest client who provides the health insurance projects. The client will provide us the flat files which consists of claims information. We will load these files into our system by using SSIS. As part of the SSIS packages, we call multiple stored procedures which have the business logic. Once the data got loaded into the database, business users access this data using our UI application. Based on the schedule jobs will pick up the data from DB and generates advise files in the shared folder. These advice files will
be consumed by our clients again.
Environment:
MS SQL Server 2008 R2 Enterprise, MS SQL Server Integration Services 2008,
Currently working with Login Soft Technologies at Hyderabad as Software Engineer from august 2011 to till date.
Technical Skills
RDBMS SQL Server 2008R2
Query language T_SQL
ETL TOOLS SSIS
BI Suite SSRS
Markup Languages HTML, XML
IDE Visual Studio 2008
Operating Systems Windows Family
Source control Tools Subversion
Project Thesis
The details of the various assignments that I have handled are listed here.
Project 1:
Name of project Reinsurance Schedule F reporting
Client Well care
Role Team Member (BI Developer)
Organization Techmetric Info Systems Pvt. Ltd, India
Project Location Login Soft Technologies (Hyderabad)
Tools SQL Server Business Intelligence Development Studio
Data base Microsoft SQL Server 2008
Team Size 8
Period December 2012 to Till date
Operating System Windows 7.
Development Tools Visual Studio 2008
Description: Well care client is the one of biggest client who provides the health insurance projects. The client will provide us the flat files which consists of claims information. We will load these files into our system by using SSIS. As part of the SSIS packages, we call multiple stored procedures which have the business logic. Once the data got loaded into the database, business users access this data using our UI application. Based on the schedule jobs will pick up the data from DB and generates advise files in the shared folder. These advice files will
be consumed by our clients again.
Environment:
MS SQL Server 2008 R2 Enterprise, MS SQL Server Integration Services 2008,
T-SQL, MS SQL Server Reporting Services 2008, SQL Server Business Development
Studio Microsoft Visual Studio 2008.
My Responsibilities:
❖ Understanding the requirements and develop various packages in SSIS.
❖ Expert in Developing ETL packages to import data from various sources Using SSIS
❖ Hands on experience in using different transformations like Derived column, Conditional split, Multicast transformation etc using SSIS
❖ Scheduling the ETL Jobs and Batches
❖ Used various control Flow Tasks and transformations.
❖ Used different destinations like OLE DB Destination, Flat file Destination and different sources like Flat file and OLE DB Source.
❖ Scheduled the ETL Packages Using SQL Server Agent.
❖ Developing and enhancing the performance of the application.
❖ Understanding the business needs and providing the solutions accordingly.
❖ Attending priority meetings with the clients and understanding the upcoming business needs
❖ Coordinating with team members and ensure that we provide a high quality of service well within the time lines.
Project 2: Name of project Transfer Price
Client Dixon Retail Inc. U K
Role Team Member (BI Developer)
Organization Techmetric Info Systems Pvt. Ltd, India
Project Location Login soft technologies (Hyderabad)
Tools SQL Server Business Intelligence Development Studio
❖ B-Tech, passed in first class with an aggregate of 60.00% from Malineni Lakshmaiah Engg College, at Singarayakonda in 2011.
❖ Intermediate (M.P.C), passed in First class with an aggregate of 77.20% from Sri Chaitanya Junior College, at Ongole in 2007.
❖ S.S.C, passes in First class with an aggregate of 77.40% from Ganga High School, at East Gangavaram in 2005.